Re: Access 2007 Object Model Issue.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try a decompile, followed by a compact.

This sequence would be worth trying in order:

1. Uncheck the boxes under:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Office Button | Manage | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by entering something like this at the command prompt while Access is not running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code), and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

7. Still in the code window, choose Options on the Tools menu. On the General tab, make sure Error Trapping is set to:
Break on Unhandled Errors
and the Compile on Demand is unchecked.

At this point, you should have a database where the name-autocorrect errors are gone, the indexes are repaired, inconsistencies between the text- and compiled-versions of the code are fixed, reference ambiguities are resolved, the code syntax is compilable, and the VBA options are set to show errors and avoid this kind of corruption.

If the error still occurs after this, take note of:
a) when it occurs, and
b) which line generates the error
and post back.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"jpollock" <jpollock@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:713974B3-91C8-4E61-9973-EF663608607E@xxxxxxxxxxxxxxxx
Thanks Paul.
I took a look over there and didn't find anything pertaining to my error. I
also check
Microsoft's list of bugs.
Thanks again.
"Paul Shapiro" wrote:

Access 2007 has some new bugs with form and control expressions. Review the
list of known bugs on Allen Browne's website and see if anything applies:
http://allenbrowne.com/Access2007.html

"jpollock" <jpollock@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E33A7098-131A-4E45-B85C-A0F366A5CC10@xxxxxxxxxxxxxxxx
> Hello,
>
> The application has 1 main form with 3 tabs on it. The 3rd tab is used > to
> search and find users records (can have multiple records). To view each
> record’s details from the 3rd tab, double click on the record to view > and
> the
> values should appear in the correct controls on tab 2. The problem is > that
> the first time you double click on the record from tab 3, the > application
> changes focus too tab 2 (this is correct) but fails to fill in the
> controls
> with the data. Now, if you return back to the 3rd tab without searching
> and
> double click the same record, you will find that the controls on tab 2 > are
> now filled in with correct data. The error that I receive is: “You > entered
> an
> expression that has an invalid reference to the property Form/ > Report.”
> There is no issue within Access 2003. The controls on tab 2 are filled > in
> from the original double click on tab 3. This application was built
> originally in Access 2000 and then modified in Access 2003. We are now
> running Access 2007 environment.



.

Relevant Pages

  • Re: Erroe when executing command (requery)
    ... Then compact and compile again. ... Compact the database to get rid of this junk: ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.forms)
  • Re: error 3709
    ... Compact the database to get rid of this junk: ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access 2000 - unexpected shut down
    ... Compact the database to get rid of this junk: ... Open Access, and compact again. ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.forms)
  • Re: Object does not support this function????????
    ... have you added your database folder as a trusted location under: ... Compact the database to get rid of this junk: ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.reports)
  • Re: Object does not support this function????????
    ... have you added your database folder as a trusted location under: ... Open Access, and compact again. ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.reports)