Access looks for Confirmation (1 Viewer)

sathsaj · Sep 13, 2018

Hi All,

Access looks for confirmation to delete existing data before a query is run. This is a Maketable Query. the Action Queries under Client Setting is unchecked. But still why do we get this message ?

Is there a way were can get this away ?

JHB · Sep 13, 2018

If you run it from VBA code, look at the DoCmd.SetWarnings
https://docs.microsoft.com/en-us/office/vba/api/access.docmd.setwarnings
Or CurrentDB execute query.

isladogs · Sep 13, 2018

If you switch off SetWarnings there is a risk that errors will occur without your knowledge.

As JHB mentioned, the alternative approach is to use CurrentDB.Execute but you should include the argument dbFailOnError so a message appears if a problem occurs

sathsaj · Sep 13, 2018

unfortunately Iam not familiar with VBA

JHB · Sep 13, 2018

How do you run/open the query now?

sathsaj · Sep 13, 2018

I have a macro which is provided by access

Gasman · Sep 13, 2018

sathsaj said:
I have a macro which is provided by access

If it is really a macro you can add SetWarnings Off prior to the macro and On afterwards.?

sathsaj · Sep 13, 2018

Gasman said:
If it is really a macro you can add SetWarnings Off prior to the macro and On afterwards.?

that works

Access looks for Confirmation (1 Viewer)

sathsaj

Registered User.

JHB

Have been here a while

isladogs

MVP / VIP

sathsaj

Registered User.

JHB

Have been here a while

sathsaj

Registered User.

Gasman

Enthusiastic Amateur

sathsaj

Registered User.

Similar threads

Users who are viewing this thread