Delete Query Button on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a delete query and want to place a button on a form to run it. When I
create a button in design and run the wizard my delete query does not appear
in the queries window.

How would I create the button other than in the wizard.

Thanx
 
In design view, select the button, click on properties, select the Events
tab, put your cursor on the On Click event box. Click the button to the
right with three dots. Select code builder. Enter this code:

CurrentDb.Execute("Your query name goes here"), dbFailOnError
 
Thanx, But it does not work..



Klatuu said:
In design view, select the button, click on properties, select the Events
tab, put your cursor on the On Click event box. Click the button to the
right with three dots. Select code builder. Enter this code:

CurrentDb.Execute("Your query name goes here"), dbFailOnError
Click to expand...
 
Why not?
Post your code and what errors you are getting.
We can't help if we don't know what the problem is.
 
Got better advice on the query page, thanx.

Create a macro.... easy simple and effective, plus it works 1st time.

Accesscrazy
 
Glad you got your problem resolved. Maybe you got better advice because you
gave a better description of the problem.
 
What I originally sent does work, if you do it correctly.
Those of us who participate here do it voluntarily in an effort to help
others and, in turn, when we hit a problem, have a place to go for
assistance. If you choose to ask for help, give very little information on
the problem, and then be rude to the people trying to help, I think many of
use will remember your name and ignore your posts.
 
Back
Top