asked on Message box not working all of the time
I have a strange thing happening with a message box. Here is the code of an onclick event of a command button:
DoCmd.SetWarnings False
DoCmd.RunSavedImportExport
DoCmd.RunSavedImportExport
DoCmd.SetWarnings True
MsgBox "Estimate imported. Proceed to job schedule. Be sure to check for outside purchase information."
The problem is this... if there is no "EstimateWonOutbuys" import the message box does not appear. If both imports take place then the message box does appear. I need it to appear in either case. There are cases where there is no import to be done for "EstimateWonOutbuys".
--Steve
DoCmd.SetWarnings False
DoCmd.RunSavedImportExport
DoCmd.RunSavedImportExport
DoCmd.SetWarnings True
MsgBox "Estimate imported. Proceed to job schedule. Be sure to check for outside purchase information."
The problem is this... if there is no "EstimateWonOutbuys" import the message box does not appear. If both imports take place then the message box does appear. I need it to appear in either case. There are cases where there is no import to be done for "EstimateWonOutbuys".
--Steve
Microsoft Access
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
comment this two lines, then test your codes again
' DoCmd.SetWarnings False
' DoCmd.SetWarnings True
' DoCmd.SetWarnings False
' DoCmd.SetWarnings True
ASKER
I commented those two lines out and the message box did not popup when only the first import existed.
what about the first question?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
or, is there an
on error resume next line