C
Chris
I need some help. I've created a database that has a form users fill out
that saves the data to a table. The application is such that everytime a
user finds a quality defect they open this form and fill out a rejection and
it autopopulates the main table as a new record. I have created a code for a
field in the form that gives each quality rejection form a unique number so I
can trace each unique problem. Here is the code:
Text5 = Nz(DMax("[QAR No]", "qry_QARNo_Value"), 0) + 1
This code gives the field, "QAR No" the next sequential number for each new
record that is opened or created. After I got this form to work and populate
my table correctly I made a copy of the database and created links to the
main tables. I then installed this "copy" to each users computer so they
could use it when they needed to fill out a rejection. The problem I'm
having is that the database will only allow one user at a time to access and
fill out this form. How do I fix this. I alread checked the security and it
has the "shared" box checked. All my tables are links to the main tables.
The only thing I can think of is that it must be this code. Any advice?
that saves the data to a table. The application is such that everytime a
user finds a quality defect they open this form and fill out a rejection and
it autopopulates the main table as a new record. I have created a code for a
field in the form that gives each quality rejection form a unique number so I
can trace each unique problem. Here is the code:
Text5 = Nz(DMax("[QAR No]", "qry_QARNo_Value"), 0) + 1
This code gives the field, "QAR No" the next sequential number for each new
record that is opened or created. After I got this form to work and populate
my table correctly I made a copy of the database and created links to the
main tables. I then installed this "copy" to each users computer so they
could use it when they needed to fill out a rejection. The problem I'm
having is that the database will only allow one user at a time to access and
fill out this form. How do I fix this. I alread checked the security and it
has the "shared" box checked. All my tables are links to the main tables.
The only thing I can think of is that it must be this code. Any advice?