Topics Search

SetWarnings macro command in Access 2010

SetWarnings macro command in Access 2010
Views: 172
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:

Similar posts...

 

Access 2007 macro RunCommand

Access 2007 macro RunCommand Icon
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.
 

Sendkeys replacement

Sendkeys replacement Icon
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
 

Access 2010 - Creating a Data Macro

Access 2010 - Creating a Data Macro Icon
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

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

Access 2010 Default Macro Behaviour

Access 2010 Default Macro Behaviour Icon
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
 

SetValue?? in 2010. What's the equivalent command in a macro?

SetValue?? in 2010. What's the equivalent command in a macro? Icon
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.
 

What Macro Command To Use to Close Query Results Screen

What Macro Command To Use to Close Query Results Screen Icon
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.
 

Input date for a macro

Input date for a macro Icon
I have just upgraded from Access 2002 to 2010. I want to write a macro to set the default value for a field in a form, the value is a date. But I can't find the InputBox in the list of commands for a macro .

but have usually been able to write my own macro's before . I'm just having a bit of trouble working out macrosin Access 2010 are written!
 

How to Edit the Macro that exists behind an existing Command Button

How to Edit the Macro that exists behind an existing Command Button Icon
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?

Macro to change the macro linked to a command button event? Icon
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":-