Calendar driving me crazy

[Smiles]

Good day

I am redoing a bad flat file (one large 100 record) single table
database into one with 6-8 proposed tables

because the old one had 11 tabs in one form I used the ajbCalendar bound
to a text box and copy and pasted into on record which was fine
because I had the time

with the new database I have too many forms to open and close to waste
time copy and pasting dates

I can not seam to bind my text box from the calendar to a record
"WorkDate" by either using a form bound to a table or query with out
getting an error

Any advise from anyone
thanks
Smiles

 

[Arvin Meyer [MVP]]

Try using the calendar at:

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

A version of this calendar has worked in every version of Access for the
last 15 years.

 

[Smiles]

Try using the calendar at:

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

A version of this calendar has worked in every version of Access for the
last 15 years.

Thank you

your calendar comes from this site and I am using its sister calendar a
pop up http://allenbrowne.com/ser-51.html

when I have a table with two text boxes plus date
I can save record containing my text input but the date field is always
blank. or I have a ?error displayed in form

in past I have had to copy and paste from a unbound box to the date
field. It seams you I could not create a micro to copy data from one
field to another, update after clicking on the calender

thanks again

 

[Arvin Meyer [MVP]]

Using the calendar I suggested, you only need to import the module and the
calendar form. Then each textbox you want to use the calendar in, you add
the expression:

=popCalendar()

to the double-click event, and the calendar is automatically called.
Clicking on any date, puts that date in the calling textbox.