disable clipboard pop up box???

[fishqqq]

Is there a way to disable the popup box that asks if i wish to copy
the data into the clipboard???
I have a macro that works perfectly but the popup box stops the
function from working completely.

Tks
Steve

 

[S.Clark]

There is a menu attached to it (Can't remember if it is a right-click or
pull-down.), but it is a function of Office and not Access. So, the user
will have to manually disable it prior to running your code.

 

[fishqqq]

There is a menu attached to it (Can't remember if it is a right-click or
pull-down.), but it is a function of Office and not Access.  So, the user
will have to manually disable it prior to running your code.

TKS but this doesn't work. i need to shut off the "prompt" - or window
bubble that comes up asking me if i wish to save the copied data.
any other suggestions???
tks

 

[S.Clark]

http://support.microsoft.com/kb/207438

TKS but this doesn't work. i need to shut off the "prompt" - or window
bubble that comes up asking me if i wish to save the copied data.
any other suggestions???
tks

 

[fishqqq]

http://support.microsoft.com/kb/207438

I am still having these prompt bubbles pop up. many in fact:

You are about to delete 1 record
You are about to run an update query that will modify your data table
You are about to update 1 row
You are about to delete 2 records
You are about to paste 1 record
You are about to run an update query that will modify your data table
You are about to update 1 row
You copied a large amount of data onto the clipboard

I have set up a macro to do all of the above and i don't want the user
to have to answer these questions.

Can anyone offer any suggestions on how to turn these prompts off?
Tks

 

[S.Clark]

Docmd.setwarnings False will take care of the Action Query messages.

Talk more about the large copy, maybe there's a better way.