|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 30th, 2009, 01:26 AM
posted to microsoft.public.access.queries
|
|||
|
|||
I believe I have an AutoCorrect Issue with a field name?
I have 4 linked tables in Access 2007. At one point in time I was
having issues with what turned out to be an AutoCorrect associated file and whether or not AutoCorrect was turned on/off. Apparently as a fallout to that (just guessing), I have a field name that comes up 'notes/discrepancies' as the heading of all my queries, when in fact, the field name in the table (design view) is shown as 'Notes'] What is the best way to fix this issue? The table has thousands of records. Bob 
|
|
#2
December 30th, 2009, 02:02 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
I believe I have an AutoCorrect Issue with a field name?
BobC,
Try creating a new database making sure that, ummm, feature... is turned off. Then import your tables, queries, forms, etc. into it and see if that clears up the issue. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "BobC" wrote in message ... I have 4 linked tables in Access 2007. At one point in time I was having issues with what turned out to be an AutoCorrect associated file and whether or not AutoCorrect was turned on/off. Apparently as a fallout to that (just guessing), I have a field name that comes up 'notes/discrepancies' as the heading of all my queries, when in fact, the field name in the table (design view) is shown as 'Notes'] What is the best way to fix this issue? The table has thousands of records. Bob
|
|
#3
December 30th, 2009, 02:35 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
I believe I have an AutoCorrect Issue with a field name?
There is two check boxes associated with the autocorrect; do I uncheck
both? I have never decided it that whole thing is good or bad? Do you have an opinion? Thanks, Bob Gina Whipp wrote: BobC, Try creating a new database making sure that, ummm, feature... is turned off. Then import your tables, queries, forms, etc. into it and see if that clears up the issue.
|
|
#4
December 30th, 2009, 03:28 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
I believe I have an AutoCorrect Issue with a field name?
BobC,
Uncheck both... The majority of Access Developers I deal with consider that MIS-featrue to cause more harm then good. I myself turn it off... and when they do any work for me you MUST turn it off or my OCD kicks in and you have to listen to me rant until I run out of steam! -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "BobC" wrote in message ... There is two check boxes associated with the autocorrect; do I uncheck both? I have never decided it that whole thing is good or bad? Do you have an opinion? Thanks, Bob Gina Whipp wrote: BobC, Try creating a new database making sure that, ummm, feature... is turned off. Then import your tables, queries, forms, etc. into it and see if that clears up the issue.
|
|
#5
December 30th, 2009, 03:43 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
I believe I have an AutoCorrect Issue with a field name?
I think I got the message ;-)
Thanks much! Gina Whipp wrote: BobC, Uncheck both... The majority of Access Developers I deal with consider that MIS-featrue to cause more harm then good. I myself turn it off... and when they do any work for me you MUST turn it off or my OCD kicks in and you have to listen to me rant until I run out of steam!
|
|
#6
December 30th, 2009, 03:45 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
I believe I have an AutoCorrect Issue with a field name?
Hmmm, might have been a tad overkill...
You're Welcome! Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "BobC" wrote in message news  I think I got the message ;-) Thanks much! Gina Whipp wrote: BobC, Uncheck both... The majority of Access Developers I deal with consider that MIS-featrue to cause more harm then good. I myself turn it off... and when they do any work for me you MUST turn it off or my OCD kicks in and you have to listen to me rant until I run out of steam!
|
|
#7
December 30th, 2009, 03:40 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
I believe I have an AutoCorrect Issue with a field name?
Another possibility is that you have assigned a caption to the field and are
viewing the query in datasheet view. If that is the case, Access will show you the caption property of the field in datasheet view. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Gina Whipp wrote: Hmmm, might have been a tad overkill... You're Welcome! Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "BobC" wrote in message news I think I got the message ;-) Thanks much! Gina Whipp wrote: BobC, Uncheck both... The majority of Access Developers I deal with consider that MIS-featrue to cause more harm then good. I myself turn it off... and when they do any work for me you MUST turn it off or my OCD kicks in and you have to listen to me rant until I run out of steam!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
