error 2950 - TGIF

[kroenc17]

(solved) error 2950 - TGIF

SOLVED: See link below
http://forums.techguy.org/business-applications/795546-solved-return-without-gosub.html

I've been working on an access database at work. I have a form, with a button on it, that opens another form with certain criteria. I have never gotten this message. I have worked on multiple databases in the same location. I have opened them from multiple computers. Yesterday this was working perfectly on two computers. The first thing I did after opening Access today was try to use this form. Here's what happened.

1. Click on the button. Get message: (attached: 1stError.jpg)

2. Click OK, then you see this message: (attached: error message.jpg)

3. ???? you say. Alright, go to google and type in the error #. Here's M$'s solution: http://support.microsoft.com/kb/931407

Method 1 refers to a non-existent message bar and options button, so we continue along to Method 2..

.. which didn't work. My trust center was already set to enable all macros. I added the path to my file, enabled sub-folders, tried making a copy and putting it on my desktop, nothing worked. Thanks, M$. Again - THIS WORKED YESTERDAY.

4. Delete that button. Create a new one, put the same WhereCondition "="[Assigned To]=" & [Employee ID]" on it. Save. IT WORKS!!!!!!!!!

5. After saving or reopening the file... see attached: GoSub.jpg.
After you click through that error message it takes you back to the 2950 error. I recreated this button on two computers, saved to multiple locations. I have no idea what is happening, please help!

 

[boblarson]

Which version of Access are you using? If 2007, are you sure you don't have one of the wrong selections on one of these two screens (the correct selections are shown)?

 

[kroenc17]

Bob- Thanks for the reply.

I have "Enable all macros" selected by default. I switched to the option you show selected, but that didn't cause any change. But wouldn't I want my macros enabled?

 

[boblarson]

Bob- Thanks for the reply.

I have "Enable all macros" selected by default. I switched to the option you show selected, but that didn't cause any change. But wouldn't I want my macros enabled?

You should put the database in a TRUSTED LOCATION or set the current location to be a trusted location instead of relying on that option.

 

[kroenc17]

The database is in a trusted location. There weren't any set until today, after this started happening. Like I said this wasn't a problem at all until this morning.. I've been working on this for several weeks. I've set the exact folder it's in on a network drive to a trusted location in Access, enabled subfolders, enable trust over network, I've made my entire C:/ drive (including subfolders) a trusted location and then copied my database to the desktop and tried from there, no dice.

 

[boblarson]

The database is in a trusted location. There weren't any set until today, after this started happening. Like I said this wasn't a problem at all until this morning.. I've been working on this for several weeks. I've set the exact folder it's in on a network drive to a trusted location in Access, enabled subfolders, enable trust over network, I've made my entire C:/ drive (including subfolders) a trusted location and then copied my database to the desktop and tried from there, no dice.

From what I know - your C drive root can not be a trusted location regardless of what it may say in the Trusted locations selection. You would have to set the trust to a specific folder below the root directory. So you could set

C:\Documents and Settings\YourName\Desktop

as the location but you can't just set C:\ with subfolders enabled.

 

[kroenc17]

I have absolutely no idea why this fixed it, but it did.

http://forums.techguy.org/business-applications/795546-solved-return-without-gosub.html