End user complaints

[benwah]

Hi

I have a database and all that is required is the user to fill in a simple form. The form has required fields that need to be completed before they can navigate, quit, add new record etc. A message will pop up telling them why they cant do any of the before mentioned commands if they try.

The problem is the users claim that when two or more of them are adding a new record at the same time one record will be missing when they go back at a later date. They tell me that after adding a record and exiting the db they get no error messages appearing and as far as they are concerned they have completed all that is required on the form.

Also the db has been operational and in constant use for a few months now and there are 10 users but this is only the second time this problem has occured.

Anyone else with a similar experince or recommendations? Need to get them off my back!

wah

 

[Lozere]

How isimplemented the validation for the contents of the forms, i.e. the presence of valid data is the required fields?
Do you perform it with some VB code or macro or do you rely on the validation rule of the database?

Some problem may arise when user exit the forms or the application by closing it (closing the window with the X button at the upper right) in lieu of clicking the appropriate button.

In this case, be sure to catch such exit with the Form_Unload event procedure.

 

[benwah]

The field in the backend table has its Required value set to True.

and if they try to quit by using the Xs then an error message will occur if a required field isnt complete. If they are complete it will quit with no errors msgs but the record is saved from what i can tell testing it...

I have tried everything i can think of so I think someone has 'accidently' quit via a few error messages, no doubt murphy will prove me wrong though!

thanks
wah

 

[MichaelRed]

look into you record locking setting (and action). In particular, if you use an autonumber in a multiuser situation, some problems can / will arise.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over