Advanced Excel / Access for Transfers tracking

[jcchs2]

I need some help please. I have researched and researched, but I cannot find what I am looking for. I have read almost every thread about this.

I need an excel document (or Access) that can help keep track of Transferred Items. I have 5 “Coordinators” that will be using this form to track Transfers from 130 establishments.

* I want the document to be locked anytime information is entered (they input data and then when saving it locks the row and cannot be changed).
* Which means the last row without data should have a “new” or “add” button that opens the row for them to use.
* I want to automatically assign a transfer number based off of the last number used.


If it is in Access, I would like them to be able to pick their name when they first open the file. So that we can see which Coordinator is inputting the information.

PLEASE HELP ME WITH WHATEVER MACRO OR OTHER INFORMATION I NEED TO MAKE THIS WORK

[zbor]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/access-tab...-tracking.html

Thread Closed.