Пошаговое исполнение макроса ошибка 2001

10.07.2012, 02:11. Показов 4337. Ответов 3

---

0

Microsoft Access users may encounter the ‘Macro Single Step error 2001’, when trying to make a directory by running a VBA script or using the Autoexec macro in MS Access. Sometimes, due to this error, the Microsoft Access application crashes with the runtime error AutoExec 2001.

This error may also appear when using the single step command in debugging mode in MS Access to execute a macro. When each action completes, a dialog box appears with information, such as Macro Name, Action Name, Arguments, and error code.

There are several reasons that may lead to such an error. Let’s discuss the reasons for this error and the solutions to resolve it.

Reasons for Macro Single Step Error 2001

Here are some possible reasons behind the macro single step error 2001:

• The database is stored at an untrusted location.
• The MS Access database is corrupt.
• The location of the database is incorrect.
• Missing references.

Methods to Fix Macro Single Step Error 2001

Here are some methods to fix macro single step error 2001.

Setup a New Trusted Location

The macro single step error may occur when you open an untrusted database or access the database from an untrusted location. In such a case, you can try moving the database file to a trusted location – a folder that can be considered safe to execute the code. Here are the steps to set up a new trusted location:

• Open Microsoft Access.
• Go to File > Options.
• In the Access Options dialog box, click Trust Center.

• Click Trust Center Settings under Microsoft Office Access Trust Center.
• Click on the Locations option in the left pane of the Trust Center wizard. The Trusted locations dialog box is displayed.
• Click on the Allow Trusted Locations on my network checkbox to add a network location.

• Click Add New location.
• Use one of the following options in the Microsoft Office Trusted Location dialog box:
  • In the Path field, write the path of the location you need to add.
  • Use the Browse button to browse to the location.
• Select Subfolders of this location are also trusted, if you want to specify the subfolders.
• After adding the location, click OK.

Use SingleStep Macro Action

The SingleStep macro action in MS Access is used to pause macro execution and display the Macro Single Step dialog box. The dialog box displays information about the current action of the macros. It includes the macro name, action names, error number, arguments, etc. You can add a SingleStep action to a macro to check and troubleshoot the issue with macros. The steps are as follows:

• Open Microsoft Access.
• Go to File > Create.
• Right-click on the macro in left pane and choose Design View.

• In the Design View search bar, find SingleStep. 
• Drag the SingleStep macro action and drop it on the design window where you want to start single step action.
• Click Step to go to the next macro action.

• Click Stop All Macros to stop the current macros or continue to stop single step action and resume the normal macro execution.

Delete the Missing References

If your document contains a Visual Basic function or database has missing objects or broken references, you may receive the “macro single step error 2001”. In such a case, you can remove the missing references.

To remove the missing references, follow these steps:

• Open your Access database.
• Press the ALT + F11 keys. It will display the Microsoft Visual Basic for Applications window.
• Click Tools > References.

• On References window, uncheck the checkboxes for the type library.

You can also restore the reference file to a specified path. If the reference file is at a new location, unselect the checkbox for the Missing: <referencename> and then create a new folder to create a new reference.

Repair the Database

You may also experience the macro single-step error if the database is corrupt. In such a case, you can run the Compact and Repair utility to repair the damaged or corrupt database files. Follow these steps:

• Open Microsoft Access.
• Go to File > Info > Compact & Repair Database.
• Choose the corrupt Access database file and then click OK.

After repairing the database, check if the error is resolved.

If Microsoft’s built-in ‘Compact & Repair Database’ utility fails to repair the database, you can use Stellar Repair for Access to repair the database file. This tool can easily repair corrupted Access database file (ACCDB/MDB) and recover all the components, such as forms, modules, reports, etc. The software is compatible with all Microsoft Access versions.

 Closure

The macro single step error 2001 can occur due to various reasons. This blog outlined the reasons behind the Access error ‘macro single step error 2001’. It also discussed the workarounds to help you troubleshoot the issue. If the error has occurred due to corruption in the database, you can use the Compact and Repair utility. If it fails, you can use Stellar Repair for Access to repair and restore all objects from the database file.

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 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 all Access Macro Single Step Error one by one and the best ways to resolve them. Apart from this, the tutorial also covers information on SingleStep Macro Action and methods to check a macro by making use of Single Step mode.

What’s The Use Of Macros In MS Access?

MS Access macros are slightly different from Excel macros. Basically a macro is a set of actions that 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 that allows you to automate common tasks and add functionality to the controls or objects.
• Macros are mainly used to run whenever a particular event occurs. That’s the reason why it’s necessary to specify the event at the time of the creation of a macro.
• Users can use macros for any task or any set of tasks. The 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 macros.

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 occur is Macros. MS Access macros introduce a level of automation within access, scripts that make the execution of Macros possible has an easy chance to get corrupt. Thus this leads to the 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: Macro Single Step Error 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

SOURCE:

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 Single Step 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 the macro ‘|’ because it is not valid

Error Information

Error code: Error 32002

Name: Cannot open or run the macro ‘|’, because it is not valid
Description: Cannot open or run the 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

Solution 1#SingleStep Macro Action

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

Remarks

• Make use of the SingleStep action in order to fix Macros, not working issues. You are free to add SingleStep action to a macro right before performing any action on which you have doubt that maybe it is causing the issue. This Action stops the macros and opens up the dialog box of macro single step.

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

In this dialog box,  just tap to the Step option to advance the further macro action. Or press the Stop All option to prevent all currently or previously running macros. Press the Continue option for ending up the single-stepping and executing normal macros operations.

• Effect of SingleSteps action is much similar to click Single Step in Tools group which is present on Macro Windows’s Design Tab.
• Well, there is a difference between performing this operation and executing the SingleStep The difference is that, the execution of the active user can put the action in the macros. Exactly to the location from where you want to start your single-stepping. You don’t need to go through all the previous actions for approaching the one you want to check.

Alternatively, just tap to the Single Step option in the opened Macro Window, just before executing the Macro. In such a case, a single step starts its 1st action within the macro.

Note:

Suppose if you are using a single-step all way to end of the macro without tapping on the continue option then single stepping also works when macro ends. A subsequent macro that you run starts in a single step.  In order to close the single steeping, click to continue option in the macro single step dialogue box. A macro that gets open in the design view from the design tab present in the tools group, tap to the single-step option. This will de-select all the previously selected macro.

Solution 2#Check A Macro By making Use Of Single Step mode

Using the Single Stepping into the macro, any user can take a look over the execution process of macro and its result on each action. Other than this you can also isolate the causes of error or fix unwanted results.

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

If the currently using macro is edited or a new one, then you are asked to save before running it.

After then the dialog box of Macro Single Step will appear on your screen.  In this box information about macro, its action and error number is mentioned. If the showing error number is zero then this means there is no error that occurred.

1. Try any of the following:

• In order to perform the action displayed in the dialog box of Macro Single Step, tap to the Step option.
• For stopping off the macro, cut the opened dialog box and tap to the Stop All Macros option.
• In case of closing off the single-stepping process, execute the remainder of your Access macro and tap to the Continue option.

Remarks

• To start the single stepping during the time of execution of the macro, press the CTRL+BREAK button.
• If you need to start single-stepping at some exact point within the macro. Then put off this SingleStep macro action in your macro exactly from wherever you want to startup the single-stepping.

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

1. In the action catalog which is present on the right side of Macro design Window, browse for the SingleStep. If in case the action catalog doesn’t appear then you need it. Then turn on this by following this step: Design tab> Show/Hide group>Action Catalog.
2. from the action catalog just drag down the SingleStep macro action within your Design Window. After then drop the Action either below or above in the place from where you desire to start your single-stepping.  Well, the action doesn’t have any arguments.
3. Save macro by tapping to the save option on Quick Access Toolbar.

Suppose a single-stepping option is been closed when you hit on the Run option. Execution will continue from where you have put down your SingleStep macro action. After this, the macro will start single-stepping. If you want to insert multiple SingleStep actions into your macro then also you have the option to do it. For this, you need to tap to continue option present within the dialog box of Macro Single Step. This will close the single-stepping till further next SingleStep action occurs.

Recommended Solution:

If in case you are unable to perform the 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 the 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 deals greatly with the corrupt access database.

This tool proficiently repairs 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 a solution, but for the right solution, you need proper guidance. Though MS Access database related issues are quite 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.