Recent content by temacc

I'm not so much concerned with record locks, rather with locking a field! These are new records being entered so the data is fine, however when the user clicks a picklist to approve a license, code is triggered to get the max number in the database and add to it to produce a new license number...

Hi, I need to lock a field while I'm generating the next sequential number. Does anyone have any code examples or the function you would use to lock a field. Does the .locked lock the field in the table or only on the form?? Thanks

would you have any code examples of the pessimistic locking for a field?

Hi, I have a database being used by multiple users which was working fine. Recently two users entered new records into the database at the same time, the data saved however the code generates a license # and both users happened to get the same license number. Is there a way to lock a...

Help, I have this code and when it triggers a box prompts me for a value to be entered in... when I debug the program, ls_client has a value in it but it doesn't seem to want to take. strSQL = "INSERT INTO Client_numbers (Client_num) VALUES (ls_client);" DoCmd.RunSQL strSQL

Hi, I'm new at vb scripting and am trying to set a field value in access. I think you use the setvalue function but haven't been able to find the syntax on how to use it even in the help. Any examples would be great. Thanks,