disable clipboard pop up box???

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

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
 
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.
 
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.
Click to expand...

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
 
http://support.microsoft.com/kb/207438
Click to expand...


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
 
Docmd.setwarnings False will take care of the Action Query messages.

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