Can more than one form be used as input to a table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to set up a database of invoices. I would ideally like to use
two forms to populate the table (database) i.e. on form for invoices, and
anther form for credit
notes. But I would like to ensure each shares the same sequence of automatic
numbers.
This database and forms are to be used by various users. Is there anyway
that the forms can be locked, so that other users can only enter to the input
fields without altering the basis of the form?
 
Yes, but you obviously cannot edit the same record, or in most cases, the
same page of records, at the same time. You can use 2 different forms and
permanently lock fields, or lock them based upon who is doing the editing.
If you want to use variable locks, have a look at the LockIt() code on my
website:

http://www.datastrat.com/Code/LockIt.txt

To get the username, you can use your own login form, or the CurrentUser()
function if using Access User-Level Security, or you can get the Windows
login username from:

http://www.mvps.org/access/api/api0008.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top