Fix Access Macro Single Step Errors

Whether you are a newbie or an experienced Access database user; with the improvements of enhanced Access database versions it’s common to encounter Access Database glitches.  Today we will discuss about one very frequently occurring Access database issue i.e Macro Single Step Error.  Well this specific error comes with several error codes like macro single step error 2950, Macro Single Step Error Number 3021, Macro Single Step Error 2103, Macro Single Step Error 3270 etc.

In this blog we will discuss about all Access Macro Single Step Error one by one and best ways to resolve them. Apart from this, the tutorial also covers information on SingleStep Macro Action and also learns how to test a macro by using Single Step mode.

What’s The Use Of Macros In MS Access ?

MS accesses macros are slightly different from excel macros. Basically a macro is a set of actions which can automatically and on demand.  It is used to automate repetitive tasks to save time and effort.

  • It is built from a set of pre-defined actions which allows you to automate common tasks and add functionality on the controls or objects.
  • Macros are mainly used to run whenever particular event occurs. That’s the reason why it’s necessary to specify about the event at the time of creation of macro.
  • User can use macros for any task or any set of tasks. Best thing about Access macros is that it can run many tasks one by one all at the click of buttons. This automatically starts running as soon as the database is opened.
  • All in all macros provide an easy way to run commands without writing any VBA code. Thus you can achieve a lot of things with the macros.

 HAVE A LOOK:

5 Instant Fixes To Repair Damaged Access Macros And Modules

What Is Access Macro Single Steps Error Code?

What Is Access Macro Single Steps Error Code

Just like other database applications MS Access also catches several errors and issues. But the most vulnerable point of MS Access, where most errors occurs is Macros. MS Access macros introduce a level of automation within access, scripts which make the execution of Macros possible has an easy chances to get corrupt. Thus this leads to occurrence of several unexpected MS Access Macro Single Steps errors.

Here are some commonly rendered Access macro single step errors discussed below. So let’s discuss them one by one.

1#Macro Single Step Error 2950

Macro Single Step Error 2950- “Action Failed” Error is one of the most commonly occurring Macro errors.

Generally this error occurs when a macro calling VBA (Visual Basic for Applications) function is executed. Well the basic reason is that the macro is not trusted by access. By default, MS Access opens the database which is not trusted in disabled mode. In this disabled mode, executable content is disabled.

2#Macro Single Step Error 2103

Error code: Error 2103

Name: Microsoft Access Error 2103

Error Description:   The report name ‘|’ you entered in either the property sheet or macro is misspelled or refers to a report that doesn’t exist.@If the invalid report name is in a macro, an Action Failed dialog box will display the macro name and the macro’s arguments after

3#Macro Single Step Error 3270

 Practical scenario:

Even though I’m new to access, things were progressing well, but I’ve hit the wall with a few issues.  I’ve inherited a split database with four pieces, a backend version, frontend version and two user versions in accde form.  The users wanted some changes, so I needed to add a few forms, modify a few forms, add a table and come up with the queries for the changes.  That work is complete and I was able to convert the new frontend accdb version to the user accde versions.   Some of the users are able to open the database, but some of the users are getting a Macro Single Step message with the following information;

Macro Name:  AutoExec

Action Name:  RunCode

Error Number:  3270 

There’s also a message about the backend location not being a valid path, but of course it is.

I’m wondering what the differences  would be between the users who are able to get in and those that aren’t.  I’ve added the location to their trusted sites and I’ve changed their macro settings with no success.

Any thoughts would be appreciated, thanks, Bill

https://social.msdn.microsoft.com/Forums/en-US/7c3bd795-97f9-4bf8-91bd-0f95073c9782/macro-single-step-error-3270?forum=accessdev

4#Macro Single Step Error 2001

Practical scenario:

I have a Autoexec macro setup on a Access 2016 database to determine which form to open based on Environ(“USERNAME”).

When I open the database I get a macro Error 2001. If I click Stop All Macros, I can continue using the database without issue, until I change the filename, then the issue happens again.

Are there any options to prevent this error from occurring?

SOURCE:

https://stackoverflow.com/questions/47457648/macro-error-2001-autoexec-access-macro

5#Macro Single Step Error 32002

This Access Runtime Error 32002 is also known as Cannot open or run macro ‘|’, because it is not valid

Error Information

Error code: Error 32002

Name: Cannot open or run macro ‘|’, because it is not valid
Description: Cannot open or run macro ‘|’, because it is not valid.@@@1@@@1.

6#Macro Single Step – Error Number 3021

Error Code: Error 3021

Error Name: No Current Record

Practical Scenario:

Hi,

I am noticing this error while attempting to search for an record from two tables. Initially it worked with one table alone which just returns no records, But now I am looking for 2 tables where the 2nd Table gets returned in a label value. When I debug the error, it stops at the below line. I have attached the code as well. pls assist.

varReturnValue = CurrentDb.OpenRecordset(Query)(0)

 source:

http://www.utteraccess.com/forum/index.php?showtopic=2048865

Way To Fix Access Macro Single Step Error:

Way To Fix Access Macro Single Step Error

Solution 1#SingleStep Macro Action

In MS Access SingleStep macro action is used to pause macro execution and open Macro Single Step dialog box. So, you can use this method to check if there is any issue with Access Macros.

Remarks
  • Make use of the SingleStep action in order to fix Macros not working issues. Well you can add SingleStep action to a macro, before an action on which you have doubt that may be it is causing the issue. This Action pauses the macros and opens the macro single step dialog box.

 In this dialog box information about current macro action is present like its macro name, applied conditions, action name, arguments and error number if applicable.

 In the dialog box, you can tap to the Step option to advance the next macro action. Or press the Stop All option to stop the all currently or previously running macros. Press the Continue option to stop single stepping and executing normal macros operations.

  • Effect of SingleSteps action is much similar to click Single Step in Tools group which is on the Design Tab of macro windows.
  • Well there is a difference between performing this operation and running the SingleStep The difference is that by the execution of the action, you can put the action in the macros exactly to the location where you want single stepping to get started. You don’t need to step through all previous actions to approach for the one you want to check.

Whereas on the other hand, click Single Step in the macro window, before running the macro. In such case, single step starts at first action in the macro.

YOU MAY ALSO LIKE:

How To Fix Microsoft Access 3615 – “Type Mismatch In Expression” Error

Note:

Suppose if you are using single-step all way to end of macro without tapping on the continue option then single stepping will work also when macro ends. Subsequent macro which you run starts in the single step.  In order to turn off single steeping, click to continue option in macro single step dialogue box. Macro that is open in design view from design tab, in tools group, tap to the single step option. This will de-select all the previously selected macro.

Solution 2#Test a macro by using Single Step mode

Test a macro by using Single Step mode

By single stepping into the macro, you can take a look over the flow of macro and its result on each action. Other than this you can also isolate over the causes of error or fix unwanted results.

  1. Make a right click on the macro in the Navigation Pane, after then tap to the Design View.
  2. Now go to the Design tab, in the Tools group, hit the Single Step option.
  3. Tap to the Run button. If your macro is new or edited one, then you are prompted to save macro before running it.

If the macro is a new or edited one, then you will be prompted to save before running it.

After then Macro Single Step dialog box appears to your screen.  In this box information about macro, its action and error number is mentioned. If the error number is zero then it means no error is occurred.

  1. Try one of the following:
  • In order to perform the action shown in the Macro Single Step dialog box, tap to the Step option.
  • For stopping off the macro, close the dialog box and tap to the Stop All Macros option.
  • In case of closing off the single stepping process, run the remainder of the macro and tap to the Continue option.
Remarks
  • To start the single stepping at the time of execution of macro, press the CTRL+BREAK button.
  • If you need to start single stepping at some specific point in the macro. Then add the SingleStep macro action in your macro exactly where you want the single stepping to startup.

Here are the following procedures to use the SingleStep macro action right into your macro:

  1. In action catalog, on the right side of macro design window search for the SingleStep. If in case the action catalog is not displayed then you need to turn it on from Design tab, go to the Show/Hide group, and select the Action Catalog.
  2. Now drag the SingleStep macro action from the Action Catalog right onto your design window. After then drop the action above or below where you want single steeping to start.  The action contains no arguments.
  3. Save macro by tapping to the save option on Quick Access Toolbar.

Sometime we assume that single stepping is turned off when you click on the Run option. Execution will continue from where you have inserted the SingleStep macro action. After then macro will start single stepping. If you want to add multiple SingleStep actions to your macro then also you have the option to do it. For this you need to click on the continue option in Macro Single Step dialog box. This will switch single stepping off until next SingleStep action is encountered.

Recommended Solution

ACCESS REPAIR

If in case you are unable to perform above mentioned fixes or problem still persists then the chances can also be the corruption of your Access database files. Here you need to try Access Database Repair n Recovery tool to solve corruption or data loss issues. This software tool not only has the capability to fix several of the MS Access Macro Single Step Errors but also deal great with the corrupt access database.

This tool is proficiently repair corrupt MDB/ACCDB database files to restore tables, queries, relationships, indexes. Moreover the software also supports calculated data type and linked tables to retrieve password-protected forms and modules.

Final Thoughts

Every problem has solution, but for the right solution you need proper guidance. Though MS Access database related issues are quiet tricky or too technical to solve at the user’s end.  In such cases, choosing the right, secure and reliable Access database repair and recovery software tool may be purposeful. So, now it’s up to you whether you go with the manual fixes or approach for the software solution.

How To Fix Access Macro Single Step Errors (2950, 2001, 3270, 2103, 3021, 32002)