Need Help with Calendar on Form

  • Thread starter Thread starter ju
  • Start date Start date
J

ju

Experts!

I have a form that is going to track issues. For each issue, there are
fields that resemble the following:

Submitted By Submitted Date (Command Box to the right)

Referred To Referred Date (Command box to the right)

Resolved By Resolved Date (Command box to the right)

For each date field I want to add a command box (noted in above
diagram) that will pull up a seperate calendar for each. On the
calendar, I would like to select the date, and the date be applied to
the date field on the Form. Once the date is selected, I would like
for the calendar to disappear.

I must forewarn, that I have very little programming knowledge, and the
only experiences I have are from seeing what other people have posted.


If there is anyone that can help me with this it would be greatly
appreciated!!!!

ju
 
There is a very simple little Access form that behaves as a popup calendar
in this link:
http://members.iinet.net.au/~allenbrowne/ser-51.html

Download the sample database in the article.
Import the calendar and code into your database.
No code changes are needed.
In the On Click property of your each button, you include the field that is
to be updated, so it can work with 3 fields on the one form.
 
Well this looks great. I imported the form and code, but when I try to
open the calendar it gave me a compile error in the following section:

Private Sub Form_Open(Cancel As Integer)
On Error GoTo Form_Open_Err

'Initialize to the existing date, or today if null.
****If IsDate(gtxtCalTarget) Then****
Me.txtDate = gtxtCalTarget.Value

The line preceeded and followed by asterisks was the line giving me the
problem, and more specifically, I think it has to do with the
(gtxtCalTarget). Let me know if there is something I should change, or
if there is something I am doing wrong.
 
Did you import the module "ajbCalendar" into your database as well (part of
step 1)?

If you view the module, you should be able to see the line near the top
where this variable is declared, like this:
Public gtxtCalTarget As TextBox
 
Back
Top