Access Find the previous checkout record and add a return time

5 pts.
Tags:
Microsoft Access 2007
Microsoft Access database
I am setting up a database in Access 2007 to track equipment that is checked out and returned everyday several times a day. I have the checkout and return times working, but I need the Returns form which only has a text (to enter the equipment ID) to look up the last matching equipment ID record with no return time and insert the NOW() in that record. The object here is to quickly allow a clerk to simply scan in and out equipment without any clicking. It works presently with auto tab and input masks but there is a new record for every checkout and return. So I have to use a report to compile the associateID, checkout and return time instead of having a table that shows the User ID, Equipment ID, the checkout time, and return time in a single record. <img]http://i39.tinypic.com/f54txx.jpg[/IMG]
<img]http://i39.tinypic.com/205fkl.jpg[/IMG]
<img]http://i41.tinypic.com/4vid0j.jpg[/IMG]
I am new to access and I cannot figure out which command in visual basic I would use to have the returns form look up the last entry for the Equipment ID when it is entered and insert the return time in the return feild.


Software/Hardware used:
Access 2007 VB
ASKED: January 12, 2012  7:44 PM
UPDATED: November 8, 2012  4:51 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following