Related Topics

Set Warnings On / Off in macro

Set Warnings Off
Just upgraded to Access 2007. There used to be a feature in Macros to Set Warnings to off - so when your macro was running update or append queries you didn't get a message.

How to you turn those off in Access

Set warnings in Access 2007
I have update and make table queries in Access 2007 and I want to disable the warning messages that appear when the macro runs. In previous Access versions it was easy to add 'Set Warnings off" in the macro, but that does not appear to be an option in 2007.

I have searched on line and done all of the fixes for trusted directories, etc. I can not select the 'message bar' in database tools, as it is greyed out.

Also greyed out is the 'convert macros to Visual Basic', as well as many other options. Why?

Warnings off, but still get pop-up
I have a simple Output macro that exports a table to Excel. My warnings are off, but I still get asked if I want to replace the existing file. How do I eliminate this

WHY isn't setwarnings *working*!?
I normally set the warnings equal to false, run some recordset loops that throw down some maketables, and then set my warnings to true. For some reason it isn't working in this particular database and it is driving me crazy. Under what circumstances would setting warnings to false NOT suppress the "you're about to delete this table / run a maketable / etc" warnings?

Linking Macros/Modules to a form Control (?)
I would really appreciate any help you can give - I am not very good with the modules side of things in Access so laymans terms would be useful

I have multiple make table queries that are being linked to excel. The only problem is that the macro that intiates these queries has 3 message box/warnings per report (and Set Warnings can't be turned off in the macro in MSA2007).

I was told that you can create a module to run on "click" on a form say, and turn off warnings and turn them back on after the module has executed. My problem is I don't know how to do this!

For example my Make Table query names are:


Could anyone share the required code and explain how I would link this to a button control

Access 03 Autoexec
I know this has been beaten to death but I still need help. I need an Autoexec macro to turn off warnings for action queries.

I've create the macro, named it Autoexec, chose the SetWarnings action, set it to False. When I run queries I still get the pop up asking if I'm sure I wanna.blah blah I've also set the macro security setting to low.

Errors but not warnings ?
I have created a script (VBA program) which runs a chain of queries to do some simple processing. The queries will run either using currentdb.execute (with SQL) and/or docmd.openquery (with the SQL written to the appropriate query).

As it is, I have opted for docmd.openquery because this gives me the option to switch warnings on (docmd.setwarnings true) in order to check the work of the queries.

However, what I would really like to be able to do is to switch warnings off but tell the system to report errors if they occur.

So my question is whether this is possible? Can I tell the queries to report errors but not warnings

Make Table on Start up - Autoexec?
I have a 2007 database that on startup needs to replace a table of student attendance as this makes is easier to report on.

I can easily set up an autoexec macro to do this but get the warnings messages. I tried to get around it by converting the Macro to a Module and editing is so:

Function autoexec()
DoCmd.OpenQuery "qryAllAttendanceData", acViewNormal, acEdit
End Function

I don't think it's working - can an autoexec function be a module rather than a macro?

Microsoft Access 2007 - Managing Macro Security
Learn why signing your own macros will reduce the number of security warnings you see while still maintaining a high security level, and find out how to sign a macro by using self-certification.

Append query runs on its own but not in a macro
A database I created for a client some years ago has a macro which contains an append query. This macro repeats itself until a condition is met and has run thousands of times without any problem.

The client has asked that I make the database work for multiple factories. Without going into too much detail the same macro and append query are needed in the spin-off databases (one for each factory).

The problem is that the append query will not run in any of the spin-off databases as part of the macro although the macro itself is unchanged, but will run in isolation when it performs correctly and gives no error messages. I have run the macro with SetWarnings ON, but only get the warnings that you would normally expect.

I have pasted over the macro, the append query and the underlying select queries from the original database, but to no effect.

prevent warnings
I have a form that is updating records using docmd.runsql(update.)

when it updates it brings up a warning that it is going to up date the records, is there a way to turn off these warnings and how can I do this

Records deleted with NO warning message.
I have a form that will delete records with no warnings. I have looked everywhere and can't find whatever setting it is that is disabling warnings for this form only. I have checked my code everywhere for a possible instance of "docmd.setwarnings false".. without out a "docmd.setwarnings true" immediately following - but there is no place in my code that disables the warnings and doesn't turn them back on.

Hyperlinks: warnings, special characters, errors
Function to replace FollowHyperlink() in VBA. Handles security warnings, special characters in file name, return value.

OpenArgs not working
I have a subform (SubFrm_Warnings) which I need to appear according to which company record is open on the form. I have used OpenArgs on the DoCmd.OpenForm to set the companyref / ID number - this is working fine. I have now realised that although the correct company ID is now being set, the actually text box which contains any warnings is not linking to that company ID?

I know I must have to link this somehow. The forms involved are Frm_Search (where the DoCmd.OpenForm is); Frm_Company (which is the main form which includes all the company info) and SubFrm_Warnings (which is to appear on open of the Company form should there be any warnings for that particular company.

I have attached the database and posted the relevant code below...

How do I override the Drop Changes Msgbox
I created a Tabular Form where each row has a check-box which the user can check if he wants to view the record in detail. I also have two Command Buttons which run Update Queries. One query checks all of the boxes and the other query clears all of the boxes. I also turned off the Warnings for these queries so the user is not prompted with any MsgBoxes when he runs them. The problem I am having however, is that if the user checks one of the boxes and then tries to run one of the Update Queries a Drop Changes/Save Changes MsgBox appears (even though I set the Warnings to No). So my question is, can I override this Drop Changes Msgbox so it does not appear

Prompt a user in a Macro
I have set up a Macro that automates the file import process for my users. As part of this Macro, it deletes the old file and replaces it with the new imported file. I would like to set something up that warns them before proceeding, such as "Clicking 'Yes' will delete the existing file." I have been able to set up this warning but am unable to figure out how to prompt the user to select 'Yes' or 'No'. Is there a way to do this in a Macro?

Use VBA in Access to stop Outlook warnings 2003
Need to disable Outlook 2003 warnings when sending auto Email using Access 2003 using VBA, I have yet found a way

Macro to Sort Specific field
I have a command button linked to a macro set up to do a filter, but I also want the button to do a sort with another macro. How do you set up a sort Macro

Query for Warnings
I was looking to create query in MS Access that uses 4 fields.

IssuedFor Text
IssuedAt | Date/Time
WarningType Text
IsSales Yes/No

I'm to get the query to display only IssuedFor, IssuedAt and WarningType.

IssuedFor = displays the PersonsID
IssuedAt = displays time and date of warning
WarningType = one of the many diff warnings
IsSales = Only selects Sales staff from DB (Hidden)

Example Outcome:

IssuedFor IssuedAt WarningType

12454 12:12:2012 14:00:00 Incorrect Sale
12454 12:12:2012 16:00:00 Incorrect Sale
12454 12:12:2012 18:00:00 Incorrect Sale

12454 17:12:2012 09:00:00 Incorrect Transfer
12454 17:12:2012 10:00:00 Incorrect Transfer
12454 17:12:2012 11:00:00 Incorrect Transfer

This shows only when the WarningType is the same for 3 times or more and will filter out all the instances where there are 1 or 2 warnings. I'm trying to show this query for the full weekand the warnings would be grouped by date.

I tried building this with a duplicate query but couldn't get the expressions correct.

Switchboard to run code
I'm having problems getting my switchboard button to run a function I created. I'm guessing its something in the way my code is written, the name or something I'm leaving out, but I'm not seeing it. If you have any idea please help me.

I went through the switchboard manager and set the item I want to run code and copy and pasted the function name from the code to the manager so I dont think the problem is there. Now here is what my function looks like:

Public Function ClearContestants()

DoCmd.SetWarnings False
DoCmd.OpenQuery "qryContestantClear"
DoCmd.OpenQuery "qryAirflowClear"
DoCmd.OpenQuery "qryBrazingClear"
DoCmd.OpenQuery "qryCoolingClear"
DoCmd.OpenQuery "qryHeatingClear"
DoCmd.OpenQuery "qryTestClear"
DoCmd.SetWarnings True

End Function

Side note, I would do this through a macro but I dont want the warnings popping up and I didnt know how, if possible, to turn them off in a macro