Originally Posted by
ItsMe
Why do you believe the references are to the MDA file? What is the name of the MDA file?...
What I would do is use the Access 2003 wizard to import one or more of the objects from a copy (a Right Click Paste copy) of the original file. In the wizard, I would use the advanced options to "Import Saved Procedures"...
Thanks! The MDA file (jdate8HOS.mda) was clearly shown in the references; importing the procedures from this file definitely helped.
There were several other issues I fixed - security, syntax errors, converting macros to VBA, etc.
So, now it works perfectly in Access 2007. However, when I try to open it in Access 2013, I get "error 2467, The expression you entered refers to an object that is closed or doesn't exist."
The error occurs on this line of code:
Code:
SH = Me.Subform0.Height / Me.Subform0.Form.Section(0).Height
Right below that is this line:
Code:
SW = Me.Subform0.Width / Me.Subform0.Form.Width
When I mouse over 'Me.Subform0.Width' (after the error), it shows 'Me.Subform0.Width = 8206'
Going back to Access 2007 (same database file, same directory), adding a breakpoint shows the same value for 'Me.Subform0.Width', and values for the other 3 properties:
Me.Subform0.Height = 5276, Me.Subform0.Form.Section(0).Height = 4755, and Me.Subform0.Form.Width = 10860.
So Access 2013 is doing something different in processing these lines, which causes the error. Any ideas how to fix?