Sorry all. After reading Jim's reply, I realized I'd not read the original request carefully enough. My suggestion would do nothing more than move the user to a new, empty record. I was too quick on the draw!
Try adding this code to the code that runs when the F9 key is hit:<br>
<br>
DoCmd.GoToRecord acDataForm, "frmTest", acNewRec<br>
<br>
Substitute the name of your form where I have "frmTest" (the quotes are mandatory). This should move you to a new record. This should work...
I don't know what your skill level is, but you could try writing a Pro*C app that could be run as a scheduled job on your NT server at the required time interval. Pro*C can be a little tricky, but if you are knowledgeable of C and understand the concept of cursors in Oracle, it should be pretty...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.