Need help coding KeyDown Event

[RJ45]

I need that Date and Time to be stored separately, But the problem I have, is I don’t want the user to have any control over the input of the Date and Time.


BUT When the user starts typing in the “notes” field, that I when I want the time and date to be automatically populated.
I've been trying to find example on this topic, but i came up empty. I need help coding this.


Any help will be Appreciated.

thank you.

 

[Prince]

Hello..
I understod that u want the time and date to appear automaticlly.
To get the system time automatically do the following:
1- right click in the time field.
2-go to data
3-in the defult value write =Time()
4- to spcify the time formate go to the formate which is before data.
5-in the formate write the time formate HH for hours MM for minutes and SS for seconds in the order u want.
6- to lucjk the fileds(remove the user control) goto data and in the lock preporty set it to Yes.

about the date do the same but instead of =Time() write =date()
and instead of HH MM SS use MM for months DD for days and YYYY for years.

It is better to set the memo inpox as the first in the tab order
as follows
1- goto the design view
2- right clik anywhere in the form
3-choose tab order
4- set the meno inpox as the first one.

I hope this answer your question.

 

[RJ45]

Thanks for the help But, I need the fields to be populated when the user starts enter data in the ‘Notes” field.

I know that “Notes” needs to Have an “On Key Down” Event. I tried writing the code but it’s not working.

Your help would be appreciated

 

[Pat Hartman]

Please stop spamming the board with multiple posts on the same topic.

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=225955#post225955

 

[RJ45]

I'm not spamming the board with my topic.

My problem is contains both a Forms and Modules- VBA question.

 

[Pat Hartman]

There is no need to post it multiple times. Just pick a forum that seems appropriate. Stick with a single thread until your issue is resolved.