VB code help please

  • Thread starter Thread starter guitarfunk24
  • Start date Start date
G

guitarfunk24

I am trying to write a VB code for running a appending query then a
deleting query after they are run to close the form I am on. That
would be a submit button on this form. Then I need one that would
just run the deleting query and the close the form. If there is
anyone out there that knows the code for this that would be so much
help thank you.

I would also though when I do run the appending query and deleting
query it not to ask me if I am sure that I want to run the appending
or deleting message but are u sure you want to submit these parts.
 
I am trying to write a VB code for running a appending query then a
deleting query after they are run to close the form I am on. That
would be a submit button on this form. Then I need one that would
just run the deleting query and the close the form. If there is
anyone out there that knows the code for this that would be so much
help thank you.

I would also though when I do run the appending query and deleting
query it not to ask me if I am sure that I want to run the appending
or deleting message but are u sure you want to submit these parts.
Click to expand...

CurrentDB.Execute "QueryName", dbFailOnError
DoCmd.Close acForm, Me.Name
 
Back
Top