dbTalk Databases Forums  

Track Name Autocorrect error when running mdb in 2007

comp.databases.ms-access comp.databases.ms-access


Discuss Track Name Autocorrect error when running mdb in 2007 in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Auntie Jack
 
Posts: n/a

Default Track Name Autocorrect error when running mdb in 2007 - 06-07-2010 , 02:10 PM






For your information:

Private Sub Form_Open(Cancel As Integer)
On Error Resume Next
Application.SetOption "Track Name AutoCorrect Info", 0
End Sub

If you do this in 2003, no problem. The form you are opening will
display correctly, and the option will be turned off.

If you run this same .mdb in 2007, the form will not open. An error
31556 occurs:
"To view object dependencies or change the Track Name autocorrect
option, Microsoft Office Access must close all objects and update
dependency information."
Using Resume Next doesn't help here, just makes it harder to find out
why the form didn't appear.

Jack

Reply With Quote
  #2  
Old   
Douglas J. Steele
 
Posts: n/a

Default Re: Track Name Autocorrect error when running mdb in 2007 - 06-07-2010 , 02:35 PM






Why would you want to include that code in your application?

That's something you turn off once, not each time you open a form!

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

"Auntie Jack" <raycorbin1 (AT) gmail (DOT) com> wrote

Quote:
For your information:

Private Sub Form_Open(Cancel As Integer)
On Error Resume Next
Application.SetOption "Track Name AutoCorrect Info", 0
End Sub

If you do this in 2003, no problem. The form you are opening will
display correctly, and the option will be turned off.

If you run this same .mdb in 2007, the form will not open. An error
31556 occurs:
"To view object dependencies or change the Track Name autocorrect
option, Microsoft Office Access must close all objects and update
dependency information."
Using Resume Next doesn't help here, just makes it harder to find out
why the form didn't appear.

Jack




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.