There are many hypotheses in science which are wrong. That's perfectly all right: it's the aperture to finding out what's right. Science is a self-correcting process.
IS there a way to set a VBA code to input the current time in a text box when clicked instead of manually typing the time in the field? Id like to use the 24 hour format if possible.
Thanks
Adam Schwanz
@Reply 2 years ago
Ctrl+shift+semicolon enters current time.
You can also just set the value in the onclick event of the field
Fieldname=now()
For 24 hour just set the formatting. I think its short time that shows 24 hour, or make the format yourselfFormat
Chris LopezOP
@Reply 2 years ago
Thank you for that information, i thought thats what it was, but i put that VBA code in and i get the error "a problem occurred while microsoft access was communicating with the ole server". I thought that maybe i did something wrong in VBA.
Adam Schwanz
@Reply 2 years ago
Sounds like something else, Try to compile the database and put option explicit on CompileOption Explicit
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
