Recent content by ollyjolly

Ok so I would update the code you provided with the appropriate BE table and field names, and form field names. After doing that do I just place it in the VBA under the All load Click event so when the user clicks to add a new record it updates the table? Also, how do I change the form from...

BigHappyDaddy thank you! The form is bound form. I am not very familiar using unbound forms so I will do some research to determine how to pass the data to the BE table. I figure at this point it is worth a shot.

After checking the form properties the Record Locks is set to No Locks.

In attempt to resolve the issue I asked each user to let me know if anything out of the normal occurs. Shortly, afterwards one of the users contacted me with a run-time error. After filling in several fields on the form they selected a value from the drop down list in the Status field, and with...

Quick update. After providing each user their own FE the issue is still occuring. Shortly after the issue occurred I was able to isolate that around the time the #Deleted record was created in the table one of the users had very slow response on the network which leads me to believe the...

That is a good idea to allow each user to have their own FE. The deleted record issue was occurring prior to having the database split and hopefully it will cease or at least decrease once each person has their own FE. It is those types of issues that are so frustrating. :banghead::banghead:

Thanks David. Not sure what happen with that one quote. Probably happened when I copied it into a word document before posting to the forum. Not quite sure how to reload the form differently...Luckily users are not able to delete values from the form, and there is only one command button to add...

The form does have VBA. The user will first open a log-in form where they select their name from a drop down list and click an Ok button. Their name is assigned to a variable (CurrentEmployee) which is passed to another form (New Letters). Once the New Letters form is loaded some VBA runs to...

No each user accesses a single front end file on the network. Several of the users are on virtual computers which do not have local profiles that they can save the front end too. It was only recently that I split the database trying to resolve the issue of deleted records. So while I know having...

The issue does not happen specifically when the form is opened, but at somepoint during the day when users are entering records into the form.

That would make sense but the database opens a form in Add mode and the form does not allow deletions.

I have created a database that is stored on a network drive and accessed by about 15 users in many different locations across the network. Every day I get the error message 'Record is deleted', and appears to be caused from records in the table where the field values are #Deleted. The only way I...