Macro Help Please................

[NEEDHELP123]

I have created a form and in the form users can run a macro to update their queries with their new entries which ultimately updates their reports. When I click the button to run the macro it opens each queries for me to run them. How do I make the macro run automatically without opening the queries. I want it to be invisible to the users.

Access 2003

 

[Liv Manto]

put a code "On click" event - docmd.runsql "Update blah"

check this site for samples

or ask the CLIP.

 

[NEEDHELP123]

Can someone help with how to write the codes so that the macro runs invisible to the users. Right now it opens all the queries for me to run each one individually.

Below are the codes. How should I modify it? Liv, when I added the code you suggested I get as syntax Update Statement message.

Private Sub cmdMacroRerunQueries_Click()
On Error GoTo Err_cmdMacroRerunQueries_Click

Dim stDocName As String

stDocName = "Update Queries"
DoCmd.RunMacro stDocName

Exit_cmdMacroRerunQueries_Click:
Exit Sub

Err_cmdMacroRerunQueries_Click:
MsgBox Err.Description
Resume Exit_cmdMacroRerunQueries_Click

End Sub

Can anyone help?

 

[Liv Manto]

Give me more details, or better send me a copy of the database with sample recordsets/tables. Livmanto@hotmail.com
What is the command behind the macro? Is the form a free form, meaning no recordset is behind it, its just used to hold textboxes? The command button then inserts the records?

 

[tkoh78]

Just put Echo and SetWarning action, respectively before taking any other action. The Echo will take care of hiding anything background action and SetWarning will take care of warning pop-ups.

 

[NEEDHELP123]

tkoh78, it worked perfectly. Thank you!