SetWarnings macro command in Access 2010

In Access 2010, while building a macro in design view, the SetWarnings action command is not available in the "Add New Action" drop-down menu. I can import a macro from an earlier version of Access and copy/paste the SetWarnings into my new macro, Is there a different command in Access 2010 or am I missingsomething?

Sponsored Links:

Related Topics

Access 2010 Macro
I have an MS Access 2010 Database that will be run @ 6:00 AM Automatically. The Autoexec Macro has been created. the purpose of the Macro is to update a local table with data from SQL Server. In previous versions of Access I used setwarnings = off to accomplish this without user intervention. However in MS Access 2010 I don't find that option. Anybody know where it is or how I can accomplish this

Access 2007 macro RunCommand
I have a Macro that in the old version I had several things going on like SetWarnings, Open and Close 2 queries then OpenModule and its command is MailMod and next statement was RunCommand with a command of Run

When I run the macro it loops through 20 times and give me a error that a Macro can only call itself a maximum of 20 times.

If I run the Bat file I get a error that The command or action “Run” isn’t available now.

SetWarnings in 2007 Macro
I want to use the "SetWarnings" action in a macro but I received a message of "The text you entered isn't an item in the list. Select an item from the list, or enter text that matches one of the listed items".
Any idea of an alternative way to do the same functions like SetWarnings in X2007?

Sendkeys replacement
I am trying to find an alternative to the sendkeys macro command. I am using this command to invoke the tab key (sendkeys {tab}) to move focus to the next object in a form. The template I developed worked fine in Access 2003 and 2007, but when I started using Access 2010, this command turns off the numeric locks (on a periodic basis). In reading results of Google searches, it is recommended to avoid the sendkeys command since it has known issues, but I have not found a good alternative. I use this macro in several places in several forms, so I prefer to continue to use a macro or VBA code I can refer to in the form instead of using another command that would be control specific such as the GoToControl command

2 things - SetWarnings? and Running a saved Import
I'm using Access 2007 and two things I used to know how to do I have either forgotten or can no longer find.

From within a macro I used to "setwarnings" to off so I wouldnt keep having to click "yes" or "ok" - is there a different way of doing this from within a macro?

Secondly, I want to run a saved import from within the macro - any ideas?

Cant believe either of those is too hard

View Macro Result in subform
I have created a macro name "MonthwiseRep" to view select query result in pivottable view which works fine when I run the macro.
But problem occurs,
if I wish to populate subform on a click of a button that I have on the main form with the same macro results as "MonthwiseRep" in pivottable view.

I tried the following code for click event of the command button but it didn't work

DoCmd.SetWarnings False
Me.Child21.SourceObject = MonthwiseRep
DoCmd.SetWarnings True

2007 to 2010 macro won't work
I had this problem (below) previously which you guys helped me with - the solution was SetWarnings to No - at the beginning of the macro. It worked in 2007 but I'm now on 2010 and I'm back to getting the "can't find the database file". Can anyone help please?
I have a macro that imports a number of files from one source and places them in a single table. Not all the files come in at the same time but I need to start processing the ones that I do receive as soon as I get them. Currently, if a file has not yet been filed into the source the macro stops. What I need the macro to do is . if x file isn't there - then continue. As I say the files come in over a period of days

Loop in access 2010 macro
I am trying to create a macro to loop through all the records in a form and replace a number field until it hits a record with a specific entry.
I am unable to find the command in the macro drop-down box. The command I am looking for is Do Until.
I would prefer to work through macros rather than in VBA as I don't know how to program using VBA

Access 2010 - Creating a Data Macro
Office 2010 Developer Training Course > Access 2010 > Building Solutions with Access 2010 Lab using the Contacts Web Database template.

I'm at Exercise 4: Creating a Data Macro and for whatever reason my macro is not working at all.

I created the macro and confirmed it matched to the guide and I had no errors when I saved it, so that has to count for something.

The macro is suppose to be invoked when the 'Status' variable is "Offer Outstanding" more than once in the database.

Yet I can select it multiple times without any instances of the macro displaying any warning message as it should.

SetWarnings Macro Action
You can use the SetWarnings action to turn system messages on or off.

2010 MS Access 'RefreshAll' Automation
I have created a Form with a command button that moves the current record from one Table to another. The code behind the command button is provided below.
The problem is, after the code is executed, all that remains on the Form fields is "deleted". Is there something I can add to the end of the code that would RefreshAll?
I hit the RefreshAll button and it worked, but I am hoping to automate this step through VBA code.

Thanks, in advance, for your attention to my post!


Private Sub Command640_Click()

DoCmd.SetWarnings False
DoCmd.OpenQuery "TEST_QUERY_APPEND", acViewNormal, acEdit
DoCmd.SetWarnings False
DoCmd.OpenQuery "TEST_QUERY_DELETE", acViewNormal, acEdit

Access 2007 hates Access 2003 macros
I've made a database on access 2003 because I hate access 2007. I've put it onto our company server, and on an individual C:\drive on 1 pc to see if it s a server security message but it isnt.

Every time I run a macro, whether it be to move records or generate reports I get the message "RunMacro Action Was Cancelled". I've tried SetWarnings and obvioulsy I have a stop macro command built in, but I cant get rid of this message. Its more annoying than anything to be honest

Equivalent command to DoCmd.SetWarnings False for appexcel
I have an unattended database (triggered by scheduler) which imports excel files into access after checking the contents and format, but the process halts at "appExcel.Workbooks.Open" if it is unable to open the file - such as a zip file changed from .zip to .xls (I'm not joking!)
Is there an equivalent command to "DoCmd.SetWarnings False" for "appexcel" in access 2003. if I can avoid the error message, the rest of the code handles the problem

SetValue?? in 2010. What's the equivalent command in a macro?
In Access 2007, we used a "setvalue" function in a macro. What is the equivalent function to set the value of "onclick" for specific items on a form?

For example, I have a form that is used for multiple purposes. I use the onopen statement to change the button to do a different procedure based upon the paramater passed.

My 2007 macro looked like this:
Action: setvalue
Item: [Forms]![Results]![close].[onclick]
Expression: "=sendreports()"

I don't have a setvalue command in macros for 2010. What do I use now? I tried setparam, but it erred on my onclick item.

Executing Access macro
I execute an access macro from a batch file. I use this command:

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" file.mdb /x Import /nostartup

The macro is executed correctly but I see always that access window starts, even if I use /nostartup command. How is possible?

the second problem is about what happens when the macro gives an error.
I would like that in every case msaccess process is killed. This macro is scheduled in windows task, so every morning when I open task manager, I see a lot of msaccess.exe processes.

So I would like to know how to force the killing of access process when the work is ok but also when it's not ok. Now I use the "Quit" command inside macro. I see also a lot of other commands but I don't know which is better to use

last thing: is it possible to wite the result of the macro executed by access in a log file? If not how can I know if the macro is ok or not

Access 2010 now creates macros instead of VBA code
I have been using 2003 for a while but I have switched to 2010 recently.

I have just found out that if you use the wizards when creating a command button, Access now creates a macro instead of creating VBA code (for opening a form, for example)

I prefer code over macros, so is there a way to change this?

Also, what about the macros that have already been created? How can those be converted to VBA?.When I use the "Convert From's Macors to Visual Basic" option I get a "There was a problem opening the macro "[Embeded Macro]". Do you want to continue?" and the macro does not get converted

What Macro Command To Use to Close Query Results Screen
Am working with Access 2007. I have built a macro that opens several make table queries and exports the tables to excel spreadsheets. Macro functions properly, however the query results still show in the access database screen.

What macro command can I use to close these screens after the action is done? I use the CLOSE command for each query but the results still show in the Access window.

How to Edit the Macro that exists behind an existing Command Button
I have inherited the task of managing an Access 2007 application.

Within this application I have an Access 2007 form that has a Command Button. I'm not sure how this Command Button was created (Macro, Query, etc.) but I do know what it does. I would like to edit the Query/Macro this Command Button executes.

Can you pleae let me know how I can edit the Command Button's Query/Macro.

Macro to change the macro linked to a command button event?
I am using Access 2003. I have a form containing a command button that when clicked runs a macro that changes the form color and the caption for the command button. I also want the macro to change the macro linked to this command button.

My idea is that the button will function as a kind of “toggle button” between modes.

The original macro linked to the command button is named “record edit” and the macro I wish to link to the command button is named “on close”.

However, whenever I run the macro, though the caption and color changes take place, I receive the error:-

“The object doesn't’t contain the Automation object ‘on close’”

Here is the macro "record edit":-

Access 2010 Default Macro Behaviour
When I use a form wizard in Access 2010 and create a button, it defaults to creating a macro to perform that button's action. How can I change this so it never creates a macro but it builts VBA