Run-time error 3033 (1 Viewer)

Caddie

Registered User.
Local time
Today, 01:47
Joined
Feb 16, 2010
Messages
75
Hi All -

I keep getting a Run-Time Error 3033 when I try to run the following code for a certain Group (DB has user permisssions) it works for me as I am admin. the error occurs on the bolded line. I checked the permissions for this group and they have "Open/Run" permissions for it.

Private Sub AddNewContract_Click()
DoCmd.OpenForm "Add New Contract"
DoCmd.Close acForm, "Main Menu"
Exit_Command1_Click:
Exit Sub
Err_Command1_Click:
MsgBox Err.Description
Resume Exit_Command1_Click
End Sub
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 08:47
Joined
Sep 12, 2006
Messages
15,614
you havent activated error handling in this code - so which error handler is reporting this.

what description is 3033 - normally you get a 2501 if the form doesnt open.

maybe the form is trying to do something on opening that needs more than open/run permisisons.
 

Caddie

Registered User.
Local time
Today, 01:47
Joined
Feb 16, 2010
Messages
75
Ya, I figured it out, the user group didn't have the proper permissions to the backend DB. Still trying to get my head around the permissions.

Thanks.
 

Users who are viewing this thread

Top Bottom