CONFIRM MSGBOX after query run successfully

[ciel220]

Hi,

Could anyone one tell me how could I create a confirm dialog box to prompt user that a query has been run successfully?

I'm using, DoDmd Runquery "", to run a append query.
I wonder if there's a way to confirm after the append suceed.

THANKS SO MUCH!!

ciel

 

[danvlas]

Add:
SetWarnings True
before running your query.



Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[ciel220]

Is there a way that I could create a 'customize Msgbox' for confirmation?

Thanks a lot!
ciel

 

[gerard1979]

Public Sub BerichtWeergeven(strMessage As String)
MsgBox strMessage, vbExclamation, "Let op!"
End Sub
I often use this one.
but with acdialog and popupforms u can do the job completely customized. I think u can figure out by urself

Gerard

 

[ciel220]

But how you know if your query suceed?
There might be some 'run query error' and I don't want to prompt a success msg everytime.

Is there a way that I can
1. make sure query run success (ex. if (true) then...)
2. prompt msg

I am new to access VBA and I wonder how I could do that.

Thanks a bunch!

ciel