Access 2007 Issue

[Keypad]

Hello,

I'm getting a Runtime error: '2501' error when I try to open a form in
AC2007 which didn't happen in earlier Access versions. The error only
happens when the VB Editor is password protected. Once I open the VB Editor
with my password then the form will open, which is pretty strange. Has anyone
else experienced this and I don't know how to fix this.

I have a label which opens the form like below:

Private Sub lblQuickNotes_Click()
DoCmd.OpenForm "QuickNotes"
End Sub

-KP

 

[Jeanette Cunningham]

Hi Keypad,
error 2501 is the error for action cancelled.
This would happen for your code if there is a reason why the form called
"Quicknotes" won't open.

Try opening that form from the nav pane. Does it open OK?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Keypad]

Jeanette,

I didn't change anything at all and now it's working as it should. I have
no idea why it wouldn't open the form when I clicked on my label after
several attempts. I ended up closing out Access, ran a few other programs
then opened Access again and it worked. I have a feeling this might happen
again but I don't have a clue about why it occurred to begin with. Since the
form only loads a linked .gif which is 171KB (large by Access's standards) I
thought that might be the reason but as I stated before it works just fine
now.

Makes it pretty difficult to pinpoint the problem since I cannot reproduce
the error. Thank you though for you reply and interest in this post. Will
post back again if the problem occurs again.

BTW, when the problem first occurred I did open the form from the Nav bar
and it opened ok but when I tried clicking my label to open it I got the
error message. I think Access was having a senior moment somewhere in the
Twilight Zone. Seems to be fine for the moment


-KP