Is it possible to add a time field to a form and until you save the record it stops? I'd also like that time to be locked in so it can't be changed.
Advanced Beginner
Windows 7 32bit 
Access 2010 32bit
Is it possible to add a time field to a form and until you save the record it stops? I'd also like that time to be locked in so it can't be changed.
VIP
Windows 7 64bit Access 2010 32bit
AFAIK, this requires VBA code and Timer event. Why do you need this?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Advanced Beginner
Windows 7 32bit Access 2010 32bit
My boss is requesting it for our database. I wish I didn't have to do this...I don't even get paid enough to be doing work like this. I know you have solved quite a few of my problems already with this database and hope you can fix this one too.
VIP
Windows 7 64bit Access 2010 32bit
I've never coded any timer event. It's my understanding that timer hogs processing power.
Check out the form OnTimer event and its associated TimerInterval property. http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Data saved via form disappears in form view
My form saves the data into the table, but once saved I can't see it in form view??
Posting Permissions
Reply With Quote