D
dotcomsavant
I have been assigned to maintain an access application that uses macro
that call queries and invoke two forms. At this point I am onl
concerned with one form.
This one form uses the max() in this manner:
Next Claim#: "LH" & (Max(Mid([Claims-LH]![CLAIM #],3,8)))+1
The result is displayed on a form in order for the end-user to view th
current number after which is inserted/updated once the other require
data is sumbited. This works fine with one user but the are multipl
users who could be working with the "master" table at one time an
thats when the problem occurs.
Who ever developed the application created copies so that the copie
would link to the master and use the max() as mentioned above. Th
master copy use the max exactly as above and copy one and two use i
the concat string "LH0" and "LH1" respectively.
What then happens is that the forms seemingly appear to submit the dat
but when the form is refreshed the same CLAIM # appears. I hav
researched the web and have found no reason as to why this happens. An
direction would be good.
Thank yo
that call queries and invoke two forms. At this point I am onl
concerned with one form.
This one form uses the max() in this manner:
Next Claim#: "LH" & (Max(Mid([Claims-LH]![CLAIM #],3,8)))+1
The result is displayed on a form in order for the end-user to view th
current number after which is inserted/updated once the other require
data is sumbited. This works fine with one user but the are multipl
users who could be working with the "master" table at one time an
thats when the problem occurs.
Who ever developed the application created copies so that the copie
would link to the master and use the max() as mentioned above. Th
master copy use the max exactly as above and copy one and two use i
the concat string "LH0" and "LH1" respectively.
What then happens is that the forms seemingly appear to submit the dat
but when the form is refreshed the same CLAIM # appears. I hav
researched the web and have found no reason as to why this happens. An
direction would be good.
Thank yo