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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running Apend,Delete and Make queries with VB 1
Open form if conditions are met 1
Clear form after append query 1
Form Code to append results from query to table 2
Query prompts for StartDt and EndDt? 4
Capture number of records updated? 1
Need VBA Help to Append! 12
Add current record to table 3

Back
Top