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?


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?


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


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:

XLAttendancePathways
XLAttendanceCasework
XLAttendees

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


Sign your own macros for stronger 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.
After completing this course you will be able to: 1) Digitally sign your own macros to prevent frequent security warnings. 2) Use the High macro security level and still run macros that you've written and signed without seeing security warnings. Create your own digital certificates by installing and running the SelfCert.exe file. 3) Add your self-signed certificate to the list of trusted publishers.
(Microsoft Access 2003)


Security: Sign your own macros for stronger 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.
After completing this course you will be able to:
1)Digitally sign your own macros to prevent frequent security warnings.
2)Run macros that you've written and signed without seeing security warnings.
3)Create and sign your own digital certificates and add them to the list of trusted publishers.


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.SetWarningsFalse
DoCmd.OpenQuery "qryAllAttendanceData", acViewNormal, acEdit
DoCmd.SetWarningsTrue
End Function

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


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


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


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?


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.