<div>
do you have error handling codes that goes with the codes above?<br />
<br />
or, is there an <br />
&nbsp; &nbsp; &nbsp; &nbsp;on error resume next &nbsp; &nbsp; &nbsp; &nbsp;line 
</div>


do you have error handling codes that goes with the codes above?

or, is there an
       on error resume next        line

<div>
comment this two lines, then test your codes again<br />
<br />
' DoCmd.SetWarnings False<br />
<br />
<br />
' &nbsp;DoCmd.SetWarnings True
</div>


comment this two lines, then test your codes again

' DoCmd.SetWarnings False


'  DoCmd.SetWarnings True

<div>
I commented those two lines out and the message box did not popup when only the first import existed.
</div>


I commented those two lines out and the message box did not popup when only the first import existed.

<div>
what about the first question?
</div>


<div>
<div class="content wysiwyg-content">
I have a strange thing happening with a message box. &nbsp;Here is the code of an onclick event of a command button:<br />
<br />
&nbsp; &nbsp; DoCmd.SetWarnings False<br />
<br />
&nbsp; &nbsp; DoCmd.RunSavedImportExport<wbr /> &quot;ImportEstimateWon&quot;<br />
&nbsp; &nbsp; DoCmd.RunSavedImportExport<wbr /> &quot;EstimateWonOutbuys&quot;<br />
<br />
&nbsp; &nbsp; DoCmd.SetWarnings True<br />
<br />
&nbsp; &nbsp; MsgBox &quot;Estimate imported. &nbsp;Proceed to job schedule. &nbsp;Be sure to check for outside purchase information.&quot;<br />
<br />
The problem is this... if there is no &quot;EstimateWonOutbuys&quot; import the message box does not appear. &nbsp;If both imports take place then the message box does appear. &nbsp;I need it to appear in either case. &nbsp;There are cases where there is no import to be done for &quot;EstimateWonOutbuys&quot;.<br />
<br />
--Steve<br />
<br />
<br />
&nbsp;
</div>
</div>


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 "ImportEstimateWon"
    DoCmd.RunSavedImportExport "EstimateWonOutbuys"

    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


 

Message box not working all of the time

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.