A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Prompt for DB Field



 
 
Thread Tools Display Modes
  #1  
Old March 13th, 2005, 10:34 PM
dave h
external usenet poster
 
Posts: n/a
Default 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  
Old March 14th, 2005, 12:16 AM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default

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  
Old March 14th, 2005, 12:22 AM
tina
external usenet poster
 
Posts: n/a
Default

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

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 Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Syntax needed to get needed reports Frank Lueder New Users 15 January 6th, 2005 09:39 AM
Word template that automatically prompt users for field values... Office Fan General Discussion 1 November 5th, 2004 11: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


All times are GMT +1. The time now is 02:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.