Access 2010 returning error code when trying to subform "On Load" event
To create this error: with a tab control, on one of the tabs is a sub-form. When I select the “On Load” event for the subform I get the above error.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have created a function that checks the server for latest FE version and updates it if needed. The code is located in the form's "On Open" event.
I have some problems with some users with the FE client getting corrupted while updated. It think it might have something to do with my code running a bit slow and the form tries to load while the code is attempting to delete and copy over new files.
Is there a better way of relocating my update code? Should I put it in the "On Load" event? I am thining of creating a macro with my update code. Will this be better?
Database opens -> runs Macro -> if update needed delete and copy over new db -> if no update then continue to load login form
Private Sub Form_Load()
Const dbg = False
2007 displays the following error:-
"the expression On Load you entered as the event property setting produced the following error: Object or class does not support the set of events"
In the subform's Exit event I have the following code:-
Me.Answerssubform.Enabled = False
When I exit the subform and go to the control "answertype" (or any other control other than "cboBenchmarks"), it naturally goes to "cboBenchmarks". How can I modify\add code that will detect that I have gone to "answertype" control and get it to go there naturally after it went to "cboBenchmarks"?
The expression On Load you entered as the event property setting produced the following error: A problem occurred while was communicating with the OLE server or ActiveX Control.
* The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro.
in addition, the "Show Help" button on this error message gives the following information:
This error occurs when an event has failed to run because Microsoft Office Access cannot evaluate the location of the logic for the event. For example, if the OnOpen property of a form is set to =[Field], this error occurs because Access expects a macro or event name to run when the event is fired.
I don't really understand what this means, to be honest. the same code/macro combo worked perfectly fine on another form I created (and subsequently lost, which is why I'm recreating it).
Ive created a form (customer) with a subform (product) in access.
The question is how can I make the form automatically navigate to customer that still didnt have any product, considering all the customer info has been filled?
I have made a query that shows all the customer that still doesnt have any product. Then I made a code at "on load event". This is the code
DoCmd.GoToRecord acDataQuery, "no product", acFirst
But when I try to run it, I get Runtime error 2046, gotorecord isn't available now
One of the problem is that there is thrown error when referencing sub report in its Open event.
I have a report called Main and it contains subreport control called sbrLine. In sbrLine sub report control I have placed report Line.
Open event of Line report contains following code:
It was working in Access XP, but it fails with error in Access 2010.
The error is #2455 "You entered an expression that has an invalid reference to the property Form/Report."
Is this a bug in Access 2010?
Since upgrading to Access 2010 I have been getting a "Property not found" error upon using the existing Save button on multiple forms. The error occurs only when data in the record has changed. Converting the old .mdb file to .accdb format hasn't solved the issue.
The Save buttons have "On Click" event procedures associated with them.
The first one is as follows:
The other one I am having issues with is this, on a different form:
I have no idea where to even start with figuring it out as the error doesn't even try to take me into Debug mode - it's a very unhelpful error with an "OK" button and nothing more!
I have done Compact/Repair. Also when I compiled the code I get a "File Not Found" error.
I don't know what I did - things were working just fine then of a sudden this issue - I was not modifying/adding any code.
Anyway. I keep getting an error message that says "The expression On Error you entered as the event property setting produced the following error: A problem occurred while Microsoft Access was communication with the OLE server or Active X control"
This is just with a button opening a form - nothing fancy. I am able to click through it - but I can;'t get rid of it. have tried all the old favourites ( compact and repair, open and close, reinstall) but to no avail. When I look at the on click event it is an embedded macro not an Event procedure. I just did with the wizard - why is it coming up like this - Access 2007 used to come up as an event procedure
Private Sub Form_Load() DoCmd.ApplyFilter "filterviewer", "[day]='" & [Forms]![frmfilterrecordset]![TXTDATE] & "' And [site]=" & [Forms]![frmfilterrecordset]![COMBOLOC] & "" End Sub
It has been working fine for a couple weeks now, and now it gives this error
Runtime Error 3011: Microsoft Databse Engine could not find object "filterviewer".
It's true that there is no "filterviewer", but this has been working fine up until now. It still works on my computer, but now anytime I load the database onto another computer, it doesn't work.
Why might this be happening