MS Visual Basic Runtime Error 2494

Asked By patty white 10 points N/A Posted on - 05/31/2012

I have encountered this error while trying to use MS Visual Basic program. The following programming codes below are the codes that I am dealing with to fully continue to access it. Please provide some guides on how to resolve this issue.

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
The issue is the DoCmd line where I get a message
Run-time error '2494':
The action or method requires a Form Name argument

• Status: Open
• Question Views: 2150
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Visual basic

Best Answer by Amanda Morson

Go To Solution

Best Answer

Best Answer

Answered By Amanda Morson 0 points N/A #150087

MS Visual Basic Runtime Error 2494

Try to open form as below

Syntax

<Form Name>.Show

Example

Myfrom.Show  

Try to solve your problem as below 

 

Assuming you are going to open Activities_Menu  form

Private Sub Open_Activities_Menu_Click()

If InputBox("Enter password") = "111111" Then

Activities_Menu.Show

Else

MsgBox  "You are not authorized!", vbOKOnly

End  If
End  Sub

I am sure you can solve  your problem using the above code

About Amanda Morson

Questions
0

Answers
50

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 06/10/2012
• Question Category: Visual basic

Answered By Wangwe Amos 0 points N/A #150088

MS Visual Basic Runtime Error 2494

If the code doesn't work when it should, a possible cause is corruption of the database. To check if that is the actual cause, first create a temporary database and export this section of the code you posted into it and check to see if the error is still there. If the error does not appear again, then you will have to recreate a new database by exporting all objects from your original database into the new one due to corruption.

About Wangwe Amos

Questions
0

Answers
250

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 05/13/2014
• Question Category: Visual basic