Calander help

[Guest]

Hi, i have a database that is based around a bookings system, and on the form
where a a new bookings is created, i want a callender that when a user enters
a date, the callender goes to that date and some how displays any bookings
already made on that date.

During the week there can be three bookings a day, Morning, Afternoon, and
Evening.
is there anyway i can do this?

 

[Arvin Meyer [MVP]]

First you need a calendar. You can get one based on an Access form from:

http://www.datastrat.com/Download/Calendar2K.zip

Now build a form, and use the Double-Click event of a date field text box to
fill a date or a range of dates. Base your Bookings form on a query that
uses the Dates form as a criteria:

Select * From tblBookings Where Booking Date Between
Forms!frmDateDialog!txtStartDate And Forms!frmDateDialog!txtEndDate;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

thanks, but thats not what i meant, i have a calander on the form (one of the
active x things in access. what i want is a message box to pop up when i
click on a specific date on the calender.

 

[Arvin Meyer [MVP]]

Sub txtDate_Click()
If Me,txtDate = #1/1/07# Then
MsgBox "Happy New Year", vbOKOnly, "Greetings"
End If
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access