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
|
|||
|
|||
Prompt for DB Field
Hi,
My problems goes like this - Table1 has field1. Form1 has VBA/SQL/DAO code that references field1. Field1 had its name changed to field2. The reference in Form1 was changed to field2. Now, Access prompts for field1 when the form is trying to come up - there is now zero reference to field1. If I put a field back into table1 with the name field1, the prompt goes away (of course, this is not acceptable) This is a complicated DB and forms. I'd really not like to scrap the form an start over to get rid of this prompt. All suggestions will be appreciated - Thanks, Dave H. |
#2
|
|||
|
|||
Dave
Sometimes when a field has been renamed in both table and form, an underlying query is overlooked. Is there a chance your form is based on a query, based on the table? If so, or if there is a combo box in the form that is based on the table, check there... -- Good luck Jeff Boyce Access MVP "dave h" wrote in message ... Hi, My problems goes like this - Table1 has field1. Form1 has VBA/SQL/DAO code that references field1. Field1 had its name changed to field2. The reference in Form1 was changed to field2. Now, Access prompts for field1 when the form is trying to come up - there is now zero reference to field1. If I put a field back into table1 with the name field1, the prompt goes away (of course, this is not acceptable) This is a complicated DB and forms. I'd really not like to scrap the form an start over to get rid of this prompt. All suggestions will be appreciated - Thanks, Dave H. |
#3
|
|||
|
|||
suggest you try turning *off* Name AutoCorrect, which can be found from the
menu bar: Tools, Options, General tab. then compact your database. if that doesn't work, try creating a new database. immediately turn *off* Name AutoCorrect while the database is "empty". then import all objects from your project database into the new one. then compact the new database. note: the Name AutoCorrect option is database-specific, NOT software-specific. each time you create a new database, you have to turn that option off manually if you want it off in that database. hth "dave h" wrote in message ... Hi, My problems goes like this - Table1 has field1. Form1 has VBA/SQL/DAO code that references field1. Field1 had its name changed to field2. The reference in Form1 was changed to field2. Now, Access prompts for field1 when the form is trying to come up - there is now zero reference to field1. If I put a field back into table1 with the name field1, the prompt goes away (of course, this is not acceptable) This is a complicated DB and forms. I'd really not like to scrap the form an start over to get rid of this prompt. All suggestions will be appreciated - Thanks, Dave H. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 08:39 AM |
Word template that automatically prompt users for field values... | Office Fan | General Discussion | 1 | November 5th, 2004 10:10 PM |
Prompt for input if another field is not blank | jh | Using Forms | 5 | September 10th, 2004 10:44 PM |
prompt for Subject field office 2003 | Lee | General Discussion | 3 | August 27th, 2004 12:34 PM |
field manipulation | Steve | Running & Setting Up Queries | 2 | May 28th, 2004 03:12 PM |