Date issue

[chipearly]

I have een searching through the forum, but I still have found no anser for this. I have created a table that includes dates on it, and have set to default to current date, but I have created a data acces page so that other users could access it easily. When I did this, the default date does not appear. Can anyone help?

 

[LonnieJohnson]

The default value property is only for new records. If you are looking at existing records and you want a text box or control to show the current date, then you will need to put it in the control source as

=Date()

or

=Now()

Date for Date only and Now for Date and Time.

If the control is a label then you will need to set the caption property of the label in the form's On Load or On Open even to one of the above functions.

Hope this helps...




ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[chipearly]

Thanks for the help, I was not entering the = , I do have one other question though, in this same access page I am trying to use the Autonumber, but it jsut doesn't happen, actually it will not let me enter anything into the block. Any suggestions?

 

[chipearly]

Actually I have a correction, the number does not appear until I save the file, why is this?

 

[LonnieJohnson]

That way it does not waste numbers and there will be no gaps in your sequence.



ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[chipearly]

I want to thank you for all of the help, I am sure that I will be coming to this forum more often