Hello everyone,
I am using the DoCmd.FindRecor d to search a table and pull up a record. The way it is working right now, if it doesn't find the record, it still pulls of the form.
What I would like to do is put the DoCmd.FindRecor d into an If statement and if it doesn't find a record, display a error message telling them to try again.
I have tried to put the Find Record into an If statement but it just...
KirkT
Last Activity: Sep 5 '17, 06:37 PM
Joined: Jun 14 '17
Location: Lawton, OK USA
-
What if DoCmd.FindRecord can't find a record?
-
Phil,
That worked awesome. I do have another question for you, I am backing the databases up to a Backup folder and overwriting the existing databases. Do you know how make so the Replace confirmation screen doesn't show up and it just automatically replaces the old backup?
Once again, thank you.
Kirk -
Phil,
That works great up until the following line:
It gives me an error at that point. I get a runtime error '438'. Object doesn't support this property or method.Code:AppAccess.Forms.DoCmd.Close AcForm, Me.Name
I really do appreciate your help.
KirkLeave a comment:
-
Phil,
Thank you for your response. My module does have Option Compare Database and Option Explicit in the header. Also, the sub is set to public.
I need to run the code that are in the databases that I am backing up because of path issues.
I would appreciate anyone's help on this issue. Once again, thanks Phil.
KirkLeave a comment:
-
Trying to click a button on one form from another
Hello all. I am creating a access database that goes out to all of our databases, open them and select the backup button.
I can open the database and get to the right form but I haven't been able to figure out the button.
I receive a run-time error '438':
Object doesn't support this property or method
I appreciate everything that anyone can do for me.
KirkT
This is...
No activity results to display
Leave a comment: