General option? (1 Viewer)

[Johny]

I got an MS Access 2003 db which I think has an general option disbabled or so dnno, here's the case:

When I create a query, and choose to close the query (just be clicking the "X" button at the top), Access doesn't ask me to save the query or not.. it directly displays the box to fill in the name of the query

When I execute an action query, Access just executes it when I click "!" button, without asking me if I want to "deleting, updating, adding xx records"

I've been searching ages to find an option to enable but I can't seem to find anything

Can anybody help me?

 

[Johny]

ok now I had the briljant idea to just ask him and it works now.

I had to execute the following line again:

DoCmd.SetWarnings true

 

[Ron_dK]

You might also check :
tools > options > edit/find > action queries. Once the latter is checked, access will give a confirmation message when you run an action query .

ok now I had the briljant idea to just ask him and it works now.

Who is him ?

 

[Johny]

The person who made the access tool