• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 628
  • Last Modified:

Error 2467 if subform's Load event an/or error 2424 in open event

I have a subform control xDetail on a main form frmMain.
xDetail can be loaded with a variety of forms (selected according to user actions in another subform) and may also have it's recordsource adjusted to display a subset of records.
The lines of code I have to do this are:

 
Public Sub LoadLinkedForm(pstrFormName As String, pstrSQL As String)

2260     On Error GoTo PROC_ERR
     
2270     Forms.frmmain!xDetail.SourceObject = pstrFormName
2280     Forms.frmmain!xDetail.Form.RecordSource = pstrSQL
     
PROC_EXIT:
2300     Exit Sub
     
PROC_ERR:
2310     Select Case Err.Number
             Case Else
2320             LogError
2330     End Select
2340     Resume PROC_EXIT
2350     Resume
     
     End Sub

Open in new window


Often, but not always, when this code is run, I get either an error 2467 in the load event of the form being loaded or an error 2424 in the current event when the sourceobject is being set. In both cases, the code is referencing a control on the form (not the same control in the two events).

When the errors happen:

frms.frmmain.xdetail.visible = true
frms.frmmain.xdetail.form.visible = true
frms.frmmain.xdetail.sourceobject = "frmSource" 'This is an examle; it happens with a variety of forms.
frms.frmmain.xdetail.form.name = "frmSource"
frms.frmmain.xdetail.form.recordsource = "SELECT qrySource.* FROM qrySource WHERE qrySourceID = 39;"

If I run a query based on the recordsource, it returns a single record (as expected).

When the error 2467 occurs, if I examine "Me" in the Locals window, everything is showing "<>".
When the error 2424 occurs, "Me" in the locals window looks as I would expect, except that all of the controls have the value: The expression you entered has a field, control or property name that Access can't find.

The 2424 error also happens in the Current event sometimes when the recordsource is being changed.

The same forms can also be loaded into another subform on frmMain but I haven't *yet* seen them fail if they're loaded there?

I'm bemused as how how to proceed with this one.

0
colevalleygirl
Asked:
colevalleygirl
  • 7
  • 5
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
A sample DB would probably make this much easier for most experts here to understand.

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Compile the code. (From the VBA code window, click: Debug-->Compile)
10. Run the compact/Repair utility.
11. Remove any Passwords and/or security.
12. If a form is involved in the issue, set the Modal and Popup properties to: No
    (Again, unless these properties are associated with the issue)
13. Post the explicit steps to replicate the issue.
14. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.

JeffCoachman
0
 
colevalleygirlAuthor Commented:
OK, I've followed your guidance and the problem DB is attached. You will also need to install the 3rd party OCX attached (for which I have distribution rights) into Windows\System32 or Windows\SysWOW64. It's a reputable 3rd party OCX from SoftelVDM; I don't believe it's implicated in the problem but the application navigation depends upon it. The forms are set to Pop-up because they are opened sometimes in that state.

To replicate the 2467 problem:

In the top left pane of the mainform, Expand Repositories and Click on New Repository.
In the bottom left pane, click on Sources.

You should get an error 2467.

Correction: I'm not being allowed to upload the ocx or a zipped version of it! So this isn't going to help....
ProblemDB.accdb
0
 
colevalleygirlAuthor Commented:
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
colevalleygirlAuthor Commented:
I shall be offline for some time now -- time differences and other commitments. I'll be back 1000 GMT.
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK

I'll look at this around 10PM New York time
0
 
colevalleygirlAuthor Commented:
Just to add a little more info, I've modified the code a little to set the recordsource at Open (passed via a global variable). It seems on first testing to have reduced the occurence of the error but not eliminated it totally.
0
 
Jeffrey CoachmanMIS LiasonCommented:

OK, I'll let you know in a few...
0
 
Jeffrey CoachmanMIS LiasonCommented:
Could not load the control
encountered errors
0
 
colevalleygirlAuthor Commented:
Rats.
I'd be on very shaky ground making the developer copy of the ocx available.
I may have to continue working on this on my own.
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK,

I tried...

But the error may have to do with naming.

So make sure to double check your spelling on all associated objects.

Also make sure you are using a solid naming convention and not leaving the default names...

Make sure you have all your service Packs in place for Office *And* Windows.
Finally make sure you compact and Repair the database regularly and compile the code.

JeffCoachman
0
 
colevalleygirlAuthor Commented:
Checking all the naming hasn't shown anything. I've gone back to do a complete redesign.
0
 
colevalleygirlAuthor Commented:
The experts tried hard to help, but the database is so complex it needs a redeign.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now