I would like to display a page that tells the user that there are no "bookings" for TODAY. It is a restaurant booking database which I have nearly completed. When there are bookings for TODAY, it shows a table with the customers booked for today (that's working ok), but if there aren't any for 'today' when I open that page, it just shows the headings of the table with no customers. I'd like to just display a message (and no table elements) when there aren't any bookings for today. Pretty confusing explanation? sorry bout that.
im making a system and part of that system is the booking of the library
2 classes can be in the library at once i want a way where if a 3rd teacher tries to book a slot then theyll be told its not available if only one class was allowed itd be easy, by using a compound key but cos 2 classes are allowed this is a bit hard for me lol trying to think of a way to allow 2 bookings but not more any ideas? thanks
I am trying to create a query that will count the number of bookings in january and a seperate count for the number of bookings in february from a table called booking order. im using the start date as the date to tell which month the booking was in. This is what i have come up with but it doesn't work and i am not to sure where to go from here. select count(jan.[booking no]), count(feb.[booking no]) from [booking order] jan, [booking order] feb where jan.[booking no].[start date] > 31/12/2006 and < 01/02/2007 and feb.[booking no].[start date] > 31/01/2007 and < 01/03/2007;
I am creating a repayment schedule (as a report) and I want to display a series of fields as a column which return (show) a date one month after the date in the field above.
The first repayment date field (Line 1) will show a date one month after the loan was paid out. the Next field below will show the date one month later.
I can't simply insert the "Date + 30" because that would get out of since over the year. If the loan was issued on say the 15th of January, I need the first field to display 15th February and the next would be .... 15th March.... Yes - You've got it!
Now I could do that in Excel, but I don't know how to get Access to do it.
Could someone check the following code. i've set up a form for creating regular bookings, and have a field, for which you type in the frequency in days you want the bookings for. (ie, 7 days for every week on that day, 14 for every two weeks etc...) and it seems to work, however it just alters the one record, instead of creating entirely new ones. Could someone please help:
Private Sub cmdCreate_Click() Dim date2 As Date Dim period As String Dim cost2 As Currency Dim frequency2 As Integer
Do While year = actual_year
date2 = Date_For period = Time_Period cost2 = Cost frequency2 = Frequency
Date_For = date2 + frequency2 Time_Period = period Cost = cost2 Frequency = frequency2
DoCmd.Close acTable, "tblRegularBookings" Loop
End Sub
Also, one of the other problems i'm trying to solve is for those who want to create a regular booking but on say every third monday of the month for example.
I have Trainee, Staff, Course, and Booking tables and forms. Everything is working fine but I want to limit the amount of bookings per course to 50, how would I go about doing this?
I want to create a calendar to show some bookings. I have a table [tblShootDates] with some fields, the most important being [ShootDate]. I also have a [ShootDateID] which is an Autonumber and is the Primary Key. I should add that it has a Prefix "Shoot ID" 000000.
I want the calendar to show each day that a booking has taken place and the text to show is the [ShootDateID]
I have a form which allows the user to book rooms.
On this form, there are the following fields:
BookingID: (Autonumber) RoomID: Text box Time:Text Box Date: Text Box Class: Text Box Teacher: Text Box
The form adds this information to the Booking table.
What I'm looking to do is prevent the user from double booking a room,like being able to check if the Room is already booked at that time and date, before the new information is added to the table and the room becomes double booked.
Basically this would be checking the RoomID, Time and Date fields, as everything else is irrelevant. What would be the best way to do this?
I work across a number of small venues which have art cases that can be booked for displays. I am trying to build a simple data base to report what space is available and also what art is currently being displayed. The art is usually booked by month, but sometime it can be booked for a week etc.
I have set up 3 tables
Art Inventory
Art Cases by Venue
Art Case Bookings
In the art case booking form, I have set up the start and end date but I cannot figure out how to avoid double bookings of a case? Once I have that worked out I believe I know how to build the required reports for my needs.
I am supposed to make a database for a hotel system, how I could prevent double bookings.
My Reservation Table has the following fields:
Reservation No. (PK) Room No. (FK) Customer ID (FK) Payment ID(FK) Reservation In Date Reservation Out Date
Together with preventing double bookings is there a way automatically that can mark in the Room Table, the status as "available" or "booked" automatically by looking at the date today?
I have just taken over an access database written by someone else. I am being asked to write some customized reports that will be extracted to excel and passed around to the team.
The database is used to track employee assignments and show us who is available and what percentage they are assigned to a task. The current report shows their percentage of assignments by month. The current column headers in the table are Month1, Month2, Month3, etc.
In the report I am creating, I would like to write it so that it pulls data based on criteria I give, but I want the columns to show Month1 as the current month, and Month2 as next month, etc. So instead of Month1, Month2, Month3... I will have September, October, November.
I cant seem to figure out how to calculate the "display as" part. When I put the formula Format(Now(),"mmmm"), the formula appears as the column name, not the expected value.
This used to be an easy one. . . but has anyone noticed that long date format no longer shows the day on the end? I have looked through the regional windows settings too and i cant find it anymore. What i would like is to group some results by date on a form with it displaying the day as like a diary style listing. Any help would be greatly appreciated....
is there a way about how to display date format inside on date field? (but if user want to type the data then the date format automatically be deleted)
currently i just put the date format label below of the date field like this picture:
Hello, I've searched the forums and all over the web, but I still can't figure out how to solve my problem.
I am creating a contact manager/scheduler. There are several tables in this database but the only ones that are involved with this problem are the following:
Contacts Table (main table stores all the contact info)
Meetings Table (stores all the meetings for all contacts)
The field relating the two tables is ContactID.
I have created a tabbed form allowing the user enter Contact Info, Meetings Info, Call History etc. Entering Meeting Info, is done on a subform and the subform will only display the meetings scheduled for the specific ContactID being modified. So everything works great.
What I am trying to accomplish now is to show the very next appointment for the specific ContactID being modified. Meaning if I'm editing/adding info for a specific ContactID, I would like to display above the subform (maybe in a textbox not sure) the very next meeting scheduled for that contact.
Currently the user can simply browse through the subform (meetings) for that Contact ID, and find the next meeting, but I think it would make it a lot more user friendly if the next meeting would be displayed automatically.
So what I am trying to figure out, is how to parse the Meetings table for the specific ContactId being modified and find a meeting date that is later then NOW() but is also the earliest date from now (hopefully this makes sense). If there is now such date, I would like to display "There is no scheduled meetings" (or something along the lines of that).
How can I accomplish this? Would be through a query?
Hopefully my explaination was clear, and I would appreciate any help, because I have really hit a road block...
I have a query that returns hours of vacation time taken for each specfic day of the year. But if no time is taken on for example Jan. 19th, that date do not show up in the query. I am wondering is it possible to return all 365 days and display a zero,if nothing is booked for that day. Attached is the db.
Hello, I'm attempting to create a report for a major school district in TX. I need to have the total number of records entered each month and a cumulative number of records entered for the year. Can anyone help me with this?
It's a small publishing business with a monthly newsletter. Access and database set-ups is not really my field but I'm going to give it a as much of my time as I can. I've gone through a number of tutorials and most of it is reasonably digestible but I think I have stumbled upon a hurdle.
The newsletter is a yearly paid-subscription and I need to be able to put up a sort of query/reminder of which subscribers need to renew. So that means I need to add 1 year to the subscribe date. After a bit of Googling I found a lot of DateAdd() function references for a similar problem but nothing really explaining how or where to implement it.
DateAdd("m", 12, [DateLastCalibrated])
I assume the [DateLastCalibrated] should be able to be replaced with my subscribed date but I get a number of invalid errors. Does it have to be implemented as a query? Should I create a calculate field? Do I even need to use this!?
hi, i have created a form and would like to display todays date and time in the following format
Mon 6 June 2005 24:00
this will literally be just on the form, no link to anything or any extra dynamic features. just there for the user's benefit
if anyone could tell me the steps that need to be taken, im guessing some formatting will need to be done, or some script will need to be placed in the form event code builder. i have only recently focused my attention on ms access so a descriptive but to the point explanation will be ideal thanks
i would like to display the date and week number on one of my forms but have no idea about dates and how to code this. can some one help? id appreciate it it beyond me :confused:
If I key in to the control source of a text box "=Date()-184" I will get the date 6 months ago but if I tried the same of 06/10/05 I will lose a day because of the 30/31 day months. Does anybody know another way around this?
