Prev: Attached sql tables and WIN 7
Next: IsNumeric() Bug?
From: Auntie Jack on 7 Jun 2010 15:10
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




From: Douglas J. Steele on 7 Jun 2010 15:35
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(a)gmail.com> wrote in message
news:57897762-4291-4a74-9fba-387b11452375(a)5g2000yqz.googlegroups.com...
> 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
>
>
>
>


 | 
Pages: 1
Prev: Attached sql tables and WIN 7
Next: IsNumeric() Bug?