run access insert query with button from form

Question

hey is there a way to only run a saved insert query in access 2013 from a comandbutton and not show it? I alredy have a query that workes if i execute it from the query itselfe but i cant get i working from the form

i have tried it with the vba methode

dbs.Execute and than the sql statement as string

but that doesn't work and i tried the

OpenQuery "myqry"

but that does only show me a table with the values i want to insert but doesn't realy insert them.

i want to insert but doesn't realy insert - so, do you want to insert ot not? — Maciej Los
– Maciej Los, Commented Jan 5, 2015 at 8:17
the query should insert and it does if it is executed from the query itselfe but when i trie to run in from the form with the "OpenQuery" methode it only showes the values insted of inserting them — tjarko großmann
– tjarko großmann, Commented Jan 5, 2015 at 8:19

Shazu · Accepted Answer · 2015-01-05 10:44:33Z

1

DoCmd.OpenQuery ("myqry")

should be sufficient. Make sure that this code is assigned to the on-click event of your button. Another option is to assign a macro to the on-click event of your button for the same purpose. The macro can be selected from the dropdown list and is titled 'Open Query'. After selecting this macro, you need to select the query name and that's it.

answered Jan 5, 2015 at 10:44

Shazu

5874 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

run access insert query with button from form

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related