I currently have a macro set up in the "Close Form" button that will run an Append Query. Is there a way to shut off the Warning message about updating records if there are no records to update? I'm trying to make sure my users won't be confused by this as they will only have read-only access to this database. -- Madelyn
Turning off warning message when running query
2 posts
• Page 1 of 1
- c++ moderated
- Windows XP
- FLASH
- Win32 Programming
- IBM PS2
- MS SQL SERVER
- Windows XP
- MS Office Access
- ms windows
- IBM PC
Jump to:
- 1. Attachments to a Macro
Is there the possibility of buiding a Macro to automatically send an email to a user when the command button is clicked but have a report attached to it without the user knowing??? - 2. Reverse Order of Letters
Greetings. I asked for and received help regarding this issue some time ago, but my computer crashed and I appear to have lost the data. I am using MS ACCESS 2002 and MS Windows XP (Home). I need a macro to reverse the order of all the words (Hebrew) in a certain column (named HEBREW). So, using English instead of Hebrew as an example, the word "house" would become "esuoh," the word "flower" would become "rewolf," and so on. Could someone please help me with this, and please explain the various steps in very easy English? Thanks. - 3. Check box size
How i can increase the size of a check box in a form ? From properties i change the width and heigh but the checkbox remains the same......... - 4. HELP--WITH A FORM
I made a search form and after I search for something it pulls up a list in a form another form. the list it pulls up you might have to scroll through it to see all the information. When I click print or make a macro for print it only prints what you see on the screen it does not show you all the information on the screen. How can I print all the information??? If I can not, can the Search form that I made be pulled into a report. Thank you reading and hopefully responding Adam A. Armoudian XXXX@XXXXX.COM 580.819.1188
Next
Turning off warning message when running query
by U2Vla2VyRmFu » Thu, 02 Jul 2009 03:43:01 GMT
RE: Turning off warning message when running query
by S0FSTCBERVdFWQ » Thu, 02 Jul 2009 06:02:01 GMT
Use the macro action SetWarnings to turn it off and then again to turn it on.
Similar Threads:
1.turn off warning message in mde
Hi I hope someone can tell me how to do this. I have an append query that runs when I open a form. While working with the full version of Access (ver 2002) I have turned off the warnings for action queries - but when I create the mde I get the warning using the Access Viewer. Also, is there a way for the MDE to retain the login information so the user doesn't have to type it? My report is linking to my accounting tables vie obdc so I have to type a user id (no password) to login in - can this be automated? Thanks for your help
2.Turn off default warning messages
I have a command button on my form that runs a macro. The macro opens an update query, then a report. I know how to create my own messages. Such as; "Please insert account number" but how do I turn off the default mess. When I run the macro I get a message: "You are about to update 36 records" "Are you sure" etc. I dont need this, plus this requires the user to click on extra buttons. Thanks for the help. Randy
3.Turning off warning message when form closes
Access 2000
I have a form which displays sub forms (Query results) and a chart. When
closing the form it always pops up with a warning message saying
"The object is locked so any changes you make will be discarded when the
form is closed
Cick Save As/Export on the file menu and save the object under another name"
The you click ok to continue
I never make changes to data in this form and it always displays this. I
have tried to turn it off using a set warnings macro ("off" on open) yet that
doesn't work.
I'm missing something really obvious aren't i...
How do you turn off that warning message that pops up everytime the database is opened which says "Thses scripts could be harmful are you sure you want to open this?" , or words to that effect. Access 2003 Thanks Jack
I am using macro to output a file to a folder. I have tried Setwarning/NO before the action. Why the warning message still come up "Do you want to replace existing files?" Can anyone show me how to turn off the warning message? Thanks
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 81 guest