Calendar linked to form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having trouble with a calendar linked to a form. I have a main form with
three calendar buttons. When clicked a small form with a calendar and a
close button comes up. The main form is NOT closed when the calendar form
opens. I select the date using the calendar and click the Close command
button on the calendar form. The main form should then have the date filled
in to the correct field. What I'm getting is the first record on the main
form changed, not matter what record I'm working on. Is there a way to link
the calendar to the active record? Thanks!

floprock
 
how are you opening the calendar form?
how are you putting the date into the control on the main form?

-Dorian
 
I'm opening the calendar with a macro (openform), and then there is a command
button on the calendar's form to close it (macro - close form).

I just have the text box on the main form with a data source of the query
for the main form. The calendar is also pointed to this same field.

floprock
 
What calendar form are you using.
I use Datepicker that does what you want and doesn't use the unreliable
ActiveX calendar available in Access.
You can find Datepicker here:
http://www.glump.net/dokuwiki/software/microsoft_access_date_picker
Good luck.
floprock said:
I'm opening the calendar with a macro (openform), and then there is a command
button on the calendar's form to close it (macro - close form).

I just have the text box on the main form with a data source of the query
for the main form. The calendar is also pointed to this same field.

floprock
how are you opening the calendar form?
how are you putting the date into the control on the main form?
Click to expand...
[quoted text clipped - 11 lines]
Click to expand...
 
I found a site that had a nice little pop-up calendar exampled. Here's the
link: http://www.fontstuff.com/access/acctut09.htm. Thanks for your help!

Bob M via AccessMonster.com said:
What calendar form are you using.
I use Datepicker that does what you want and doesn't use the unreliable
ActiveX calendar available in Access.
You can find Datepicker here:
http://www.glump.net/dokuwiki/software/microsoft_access_date_picker
Good luck.
floprock said:
I'm opening the calendar with a macro (openform), and then there is a command
button on the calendar's form to close it (macro - close form).

I just have the text box on the main form with a data source of the query
for the main form. The calendar is also pointed to this same field.

floprock
how are you opening the calendar form?
how are you putting the date into the control on the main form?
Click to expand...
[quoted text clipped - 11 lines]
floprock
Click to expand...
Click to expand...
Click to expand...
 
Back
Top