John
Well, that makes sense seeing how Perform Name AutoCorrect is the feature that does the cascading name changes, but why leave the Track Name AutoCorrect on if you aren't going to be using it? That's just negative overhead.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Sunday, April 01, 2012 10:11 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Allow AutoCorrect Field Properties
Bill & Hendra-
You can leave Track Name AutoCorrect on, but you must turn of Perform Name AutoCorrect.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
------------------------
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
Sent: Sunday, April 01, 2012 6:53 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] Allow AutoCorrect Field Properties
Hendra
You don't have to turn it off on all textboxes. That is another feature that corrects spelling mistakes.
The AutoCorrect you should turn off is under Options>Current database>Name AutoCorrect Options. Uncheck "Track name AutoCorrect info".
You only have to turn it off in this place.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Agestha Hendra
Sent: Sunday, April 01, 2012 9:45 AM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Bls: [MS_AccessPros] Allow AutoCorrect Field Properties
Bill -
I have used it for my application,,,really great codes..thanx Bill..
Would you give me vba codes to Turn Off "Allow AutoCorrect" all of text boxes property in our FE..?
Hendra
________________________________
Dari: Bill Mosca <wrmosca@comcast.net <mailto:wrmosca%40comcast.net> <mailto:wrmosca%40comcast.net> >
Kepada: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
Dikirim: Minggu, 1 April 2012 23:35
Judul: RE: [MS_AccessPros] Allow AutoCorrect Field Properties
Open each table? Use the code I wrote (TurnOffSubDataSheets) at
http://thatlldoit.com/codesamples.aspx#anchor4
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP
<https://mvp.support.microsoft.com/profile/Bill.Mosca>
https://mvp.support.microsoft.com/profile/Bill.Mosca
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of John Viescas
Sent: Sunday, April 01, 2012 9:16 AM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] Allow AutoCorrect Field Properties
Hendra-
Those of us "in the know" humorously refer to that "feature" as AutoCorrupt. It
has been known to cause damage - sometimes irreversible - in you database. You
should ALWAYS turn that off. And yes, it will improve performance. While
you're at it, open each of your tables in Design View, display the Properties
window, and set Subform Datasheet to [None]. You have to turn off AutoCorrect
first, or the change won't "stick." Turning that off greatly improves opening
tables because it turns off opening a sub-dataset on the related table(s).
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
--------------------------------
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of
agesthahendra@ymail.com <mailto:agesthahendra%40ymail.com> <mailto:agesthahendra%40ymail.com> <mailto:agesthahendra%40ymail.com>
Sent: Sunday, April 01, 2012 5:41 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] Allow AutoCorrect Field Properties
Hi All,,, :)
Do we have to set "Allow AutoCorrect" text box property to "No" if we
don't need it..? can it increase the performance ?(If it be setted to
"No")
Regards
Hendra
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar