Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-15-2007, 01:03 AM   #1
ukmale65000
Newly Registered User
 
Join Date: Nov 2007
Location: Doncaster UK
Posts: 52
Thanks: 2
Thanked 0 Times in 0 Posts
ukmale65000 is on a distinguished road
Macro Deleteobject trouble

I currently run a macro which deletes a temp table using the delete object command.
Users are then presented with a warning box that says "You are about to modify data etc" which I dont want them to see I just want the macro to run and make any modifications automatically.
I have looked in the help menu and it says go to Tools/Options/ Edit/Find and untick the confirm record change box, that is where my trouble starts as this box is not ticked in the first place.
Any ideas???
TIA

ukmale65000 is offline   Reply With Quote
Old 12-15-2007, 01:08 AM   #2
Ron_dK
Cool bop aficionado
 
Ron_dK's Avatar
 
Join Date: Sep 2002
Location: France
Posts: 2,141
Thanks: 0
Thanked 4 Times in 3 Posts
Ron_dK is on a distinguished road
Go to your macro in design mode and delete the action line MsgBox.


Hth
__________________
.
I recognise Quality when I hear it
Ron_dK is offline   Reply With Quote
Old 12-15-2007, 01:40 AM   #3
ukmale65000
Newly Registered User
 
Join Date: Nov 2007
Location: Doncaster UK
Posts: 52
Thanks: 2
Thanked 0 Times in 0 Posts
ukmale65000 is on a distinguished road
Would love to say there was a line Msgbox but there isnt ????

ukmale65000 is offline   Reply With Quote
Old 12-16-2007, 01:19 AM   #4
Ron_dK
Cool bop aficionado
 
Ron_dK's Avatar
 
Join Date: Sep 2002
Location: France
Posts: 2,141
Thanks: 0
Thanked 4 Times in 3 Posts
Ron_dK is on a distinguished road
OK, then you might try :
Setwarnings to no


Hth

__________________
.
I recognise Quality when I hear it
Ron_dK is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
need macro to run every 5min? teeitup Macros 13 02-20-2009 12:36 AM
Error - "The object doesn't contain the Automation object "ExperationDialog" molnerr Reports 6 09-13-2007 01:39 PM
Why my macro cant close the Access amator Macros 3 07-04-2007 09:24 AM
Trouble Building Expression in Macro Robin Evans Macros 4 02-14-2002 03:48 PM




All times are GMT -8. The time now is 06:15 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World