Code:
Private Sub Form_GotFocus() Update AutoTbl Set AutoTbl.AutoStatus = "Expired" WHERE AutoTbl.AutoStatus = "Not Compliant" Or AutoTbl.AutoStatus = "Approved"
Evelyn
Last Activity: Aug 31 '17, 07:01 PM
Joined: May 9 '17
Location:
-
Sub or Function not defined
Hi all! Maintaining a database that was created by someone else, and I tried running a compile to be sure the code is all good. However, I got a "Sub or Function not defined" error on the following, where "Update" is highlighted:
... -
You all are SO AWESOME!!! Thank you so very much for all the help!! I appreciate it so very much! -
Splitting a Database - Best method for distribution of FE
I am a contractor working with Access databases created by those who came before me. I have a shared database on the network, that is being simultaneously accessed by multiple users, which I would like to split.
I have split databases before with a few users, and have gone around the office pasting the FE to their desktops and updating the linked tables. However, in this case there are multiple users in various locations that access... -
Yeah, my thoughts have been the problem of a simple shared database, but the manager did not want to split the database. Meeting with him today and will take him your thoughts. Thank you!Leave a comment:
-
Losing some MS Access Data that has been entered using a form
I am a contractor working on several databases I have inherited. One database, that is shared from a network drive (not split), is being used by multiple users. One of those users has begun to notice that some data she has entered into form/subforms is "disappeari ng" when she returns to the form/subform. I have checked the tables, and the data does not appear to be in them. She is accessing the database from off-site through the companies...
No activity results to display
Leave a comment: