DoCmd.RunSql syntax problem

[BarryMK]

Helo folks
I'm just trying to run a make table query from a toggle button on a form (simple enough eh?) and have tried all sorts of syntax from examples in the forum. The Access wizard gives "DoCmd.OpenQuery stDocName, acNormal, acEdit" but this doesn't work, I understand it's because it's an action query.


I've been through many posts on the subject of this command and still can't nail it. This is my best! effort but when I debug I'm getting the message "variable not defined" and tblTrans2 highlighted.

Private Sub tglClear_Click()
On Error GoTo Err_tglClear_Click

DoCmd.SetWarnings False
DoCmd.OpenQuery "qryAppendToTrans2", acNormal, acEdit

DoCmd.RunSQL ("SELECT tblTrans1.* INTO TBL_" & tblTrans2 & " FROM tblTrans1; GROUP BY tblTrans1.*;")

DoCmd.SetWarnings True
Exit_tglClear_Click:
Exit Sub

Err_tglClear_Click:
MsgBox Err.Description
Resume Exit_tglClear_Click

End Sub

 

[Mile-O]

DoCmd.OpenQuery "MyQuery"

This works for me.

 

[BarryMK]

DoCmd.OpenQuery "MyQuery"

This works for me.

Thanks Mile I'll give it a go. Have a good weekend

 

[sparx]

You are implying that tblTrans2 is a variable. Declare your variables and what value is tblTrans2 holding?

 

[BarryMK]

Thanks for the response sparx but events have overtaken this problem, the users decided there was no advantage in replacing their paper system with a database - after most of the development had taken place. Oh well.

 

[Rich]

Thanks for the response sparx but events have overtaken this problem, the users decided there was no advantage in replacing their paper system with a database - after most of the development had taken place. Oh well.

Luddites!

 

[BarryMK]

Luddites!

If only they were that sophisticated