Running an append query

[Guest]

Hi all,

I have a button that's supposed to run an appen query,but when i click on
this button nothing happens,when i double-click theb query ,it works
well,what's the reason of this problem and how can i solve it ?
Here's the code i'm using:
DoCmd.Openquery "qname"
I tried also to open it through a macroo but it does not work

 

[Graham R Seach]

Pietro,

Try using this construct:
On Error Resume Next
CurrentDb.Execute "qname", dbFailOnError
If (Err <> 0) Then
MsgBox Err.Number & vbCrLf & Err.Description
End If

....and see what (if any) error is reported. Fix the error.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia