RE: append and update without confirmation message

Tech-Archive recommends: Speed Up your PC by fixing your registry

Here's what I did


Private Sub Command49_Click()
On Error GoTo Err_Command49_Click

With DoCmd
.Execute "qrystyleappendstyle", dbFailOnError
.Execute "qrystylegary", dbFailOnError
End With

Exit_Command49_Click:
Exit Sub

Err_Command49_Click:
MsgBox Err.Description
Resume Exit_Command49_Click

End Sub


When I try to run I get and error message
"Complie Error" "Method or data member not found"
With "Execute" highlighted

Klatuu wrote:
That would work just fine.
Where would I put the method? The "on click" event of a command button?

[quoted text clipped - 24 lines]
Is it possible to have one command to run both and without any confirmation
messages

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200706/1

.

Quantcast