DoCmd line Issue: Occurs a Run-time error ‘2494’

Asked By athan haas 20 points N/A Posted on - 05/24/2012

I have a problem with my MS Access. I’m trying to use a method of password protecting a command button that I found here. But it doesn’t work properly. The errors are shown below:

If InputBox("password") = "thepassword" then

Docmd.OpenForm formname
Else
MsgBox "You are not authorized!",vbOKOnly
End if

Private Sub Open_Activities_Menu_Click()
If InputBox("Enter password") = "111111" Then
DoCmd.OpenForm Activities_Menu
Else
MsgBox "You are not authorized!", vbOKOnly
End If
End Sub

I think the issue is about the DoCmd line, and here I get a message.

Run-time error '2494':
 The action or method requires a Form Name argument

Thanks in advance.

• Status: Open
• Question Views: 3298
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Benter Adede 0 points N/A #151374

DoCmd line Issue: Occurs a Run-time error ‘2494’

 

Run-time error '2494' is normally occurs when either a DDL file is not registered on the computer or when it is missing.  This is a common problem experienced by most Microsoft Windows users and more often than not, their computers crash now and then if the problem is not solved. To fix the problem,

You can download the missing DLL files from the internet and use it to re-register the registry list on your computer.

1.       Click on start>run

2.       Then type in regsvr32 c:windowssystem32dllfile (use the file downloaded from the internet) 

3.       Finally, re-start the computer

Alternatively, you can run a free registry scan for your computer. This will not only fix the Runtime error 2494 but will also help in avoiding other runtime errors. You can find various registry repair tools from the internet which you can download and use. These tools will scan, analyse and fix errors on your computer. 

About Benter Adede

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/26/2012
• Question Category: MS Access