Topics Search

Access Error 2950!

Access Error 2950!
Views: 48
I have an access .accb file with one form.
On the sub:
Public Sub Form_Load()
combobox1.SetFocus
End Sub

When the form loads, it sets focus to combobox1. EASY RIGHT?!?!?!?!?!?

It works perfectly fine using Access 2007 on Windows XP.

When I open it on Access 2010 on Windows 7, I get Run-Time Error '2950'! Tried 4 different computers all with the same error!
Sponsored Links:

Similar posts...

 

Access 2950 error

Access 2950 error Icon
I am getting a 2950 error. I looked it up on MS support but the solution did not work. So let me explain. I have an Access program that is a Macro calling a VBA program via scheduler on a server. The program is run with AC2007 runtime.
It loads data to a back end database. The program is getting this message.
Action failed
Macro Name: ImportCounts
Condition: True
Action Name: RunCode
Arguments: LoadCounts()
Error Number: 2950
I have checked the Trusted locations and added the program location in the program. I was told this is a local setting and can not be set on the server because we are using AC2007 runtime. Anyway changing the settings did not effect the message. Is that true? How do I get the program to run
 

Errors: 2950 AND 2109

Errors: 2950 AND 2109 Icon
I have created a macro to go to a control on a form on click of a button. The control is definitely on the form, visible and enabled and referring to a field within the table but I sometimes get an error.

The error number comes up 2950 which generates a run time error 2109 stating no field named in current record.

As the field is in the table that the form is bound to I have no idea what the problem is and it only comes up with the error occasionally. How can I prevent the error from ever coming up?
 

Error 2950 In Access 2007 Runtime From Trusted Location

Error 2950 In Access 2007 Runtime From Trusted Location Icon
I am deploying an Access 2003 database in a network environment using the 2007 Runtime to run the DB. The front end runs off of the local computer and the backend off of a network location.

I have both databases in trusted locations that I have added through the registry. I have enabled network locations. I do not get a prompt indicating that they are not trusted, which shows me that they really are in trusted locations.

I have the full version of 2007 on my laptop and get no errors, however, on the client machine I get a 2950 error in the Autoexec macro.

I tried moving the function call in the macro into a form that would launch on startup instead of the macro and still get the runtime error, however, when I get the error in this fashion I do not get the error dialog like with the macro, I just get a runtime msgbox.
 

Error 2950: using combo box on form

Error 2950: using combo box on form Icon
I have a combo box on my form that I use to search my records. We use it to select a client and have that client show up on the form. For some reason, the original combo box we had stopped working, so I tried to put another on using the wizard and deleted the original that had stopped working.

Now when I try to use the combo box I get an error. The drop down shows my clients and it allows me to start typing their name and have it show up, but when I select a name I get the error"procedure declaration does not match description of event or procedure having the same name" When I select "OK" on that message box an "action failed" box pops up with the following.

[CODE]
Error Number: 2950

I did a search for error 2950 and nothing that helped came up. I have enabled macros and selected to trust the source.
 

Error 2950 In A2007 in AutoExec Macro From Trusted Location

Error 2950 In A2007 in AutoExec Macro From Trusted Location Icon
I'm running Access 2007 on a Win XP box. I have a make table query to create a local table from linked Oracle tables. I have been running this successfully for a couple months in a trusted location from an AutoExec macro via a scheduled overnight job.

I recently started receiving a 2950 error when running the query from the macro, but when I run it manually itcompletes successfully.
 

Problem With SetValue, but Only On Certain Forms

Problem With SetValue, but Only On Certain Forms Icon
Basically, my database is for HR and uses a series of forms to enter a new hire, and to export this new hire to excel for a data upload. The weird thing is that it worked before, then all of a sudden, it gave me error 2950 while trying to run a macro which had a few SetValue functions.

I went to another form to see if that one worked w/ SetValue (because the database is trusted in my system), and it did. So my problem is that I'm receiving error 2950 (trust issues) inone form, but not receiving the same error, from the same function, on another form.
 

Error 2950 - Permissions? Exclusivity? WHAT???

Error 2950 - Permissions? Exclusivity? WHAT??? Icon
So I deal with around 12 Access databases at my job - 1 back end and 11 front end.

I've just built the 11th front-end (if you ask why so many, it's because its a multi-disciplinary team at at hospital and each sub-specialty needs their own db). I went down to their office to show them how to use it.

The basic setup is open the database and theres a splash screen. Click OK on the splash, and a macro runs which updates a couple tables in the back-end before opening the main menu.

The problem is, she is getting an Access Error 2950 when clicking OK to run the macro. It basically says she either doesn't have the permission to read/write to the tables (which she does)or someone else has the database opened exclusively (which we don't - we routinely have 4-5 people writing to the backend)

I've disabled all security, enabled all macros. I'm completely at a loss. My IT department is really only for networking issues and hardware faults, and the informatics team moved onto SQL Server so they don't support Access
 

Error message 2950 when attempting to save a record

Error message 2950 when attempting to save a record Icon
I created a form populated by a query ("update form query") The reason for the form is to update records when needed. I added a button ("SAVE RECORD") with an embeded macro whose action is "save" with an argument of "query, update form query". When I change a value on the form and click "SAVE RECORD" I get an error message (error number 2950) saying that the "update form query" is not open. When I check, however, the query and table are both updated.
 

Dlookup in Macro Error 2950

Dlookup in Macro Error 2950 Icon
Everytime I run the following Macro in a form field after update I receive the Error 2950 message box.

Item [EmployeeID]
Expression DLookUp("[Employee ID]","Contacts Extended","[File As]=" & [FULLNAME])

I am trying to update the EmployeeID field with the Employee ID from the Contacts Extended Query when the FULLNAME field is updated - FULLNAME from the form equals File As in the Contacts Extended query
 

Error 2950 when checking total time

Error 2950 when checking total time Icon
I am having a problem with a form and a query. When I open the form (called Paper), it runs a query that adds a row to a table called Time. If Paper is open and I try to run a query to see my total time on the form, I get a 2950 error. If I close the Paper form, then I have no problem calling the total time query. I tried doing an explicit close of the Time table in the macro that sends the row to the Time table, but that did not solve the problem.