Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert a date from an on_click event

Status
Not open for further replies.

ADW

Programmer
Jun 21, 2001
50
GB
Hi, I'm working in Access 2000 and what I want to do is give the user the option of inserting the current date into a textbox by simply clicking on it. I can get this function to work in normal VB but it does not want to know in Access. Nothing is happening when I click, no error messages. Can anybody help?

Date.Text = Date
 
works fine over here.. when in the immediate window you put
?date, does that work?

CPU-burn
 
It doesn't answer your question, but maybe Access is confused because you have named your textbox using the reserved word DATE. Strongly suggest that you rename it to something else... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top