Created a query.. How do i get a button to run it? (1 Viewer)

[test123123help]

Title says it all. How do i get this button on my form to run the query?

 

[theprez]

Try This


DoCmd.OpenQuery "queryname"


This command will be put on the On Click event of the Button on the form

 

[a.sinatra]

Dim strOpenQuery As String
strOpenQuery = "qryQueryName"
DoCmd.OpenQuery strOpenQuery, acNormal, acEdit

________
Toyota Wish Specifications

 

[test123123help]

quick response - where do i type that info in?

 

[a.sinatra]

On click event for the button.
________
VAPIR NO2 VAPORIZER

 

[neileg]

The Access button wizard will do this for you.

 

[DALIEN51]

One Thing To Remember!!!!!

If ya dont want a warning to appear that this will alter your data blah blah blah...then insert:

docmd.setwarnings false

before you call the query!

Regards,

DALIEN51

 

[RaWiKe]

In Access 2010 when you add a button the wizard will open. then go to misc and Run Query. you can also show it as a report if you have made a report from your query you would use the Report Operations and Run Report this will show you your query as a report that you could print or email.

 

[salgergawi]

Great idea
on the button and chose from proparities - even onclick
and write the need code