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  

Data Fields Changing



 
 
Thread Tools Display Modes
  #1  
Old January 13th, 2010, 01:28 AM posted to microsoft.public.access.tablesdbdesign
Steve Stad
external usenet poster
 
Posts: 89
Default Data Fields Changing

I have a Master Table in a Master DB linked to a few sub databases. The
input forms (to update Master table) are in the sub databases based on
queries also in the sub db's. The field names in the Master table change
names occasionally. Is there an efficient way to update code in modules,
forms, and control/fields in the form(s) when the fields change in the Master
table. I can update the control source/fields in the form for the new fld
names - but I noticed the old/previous field names still in the dropdown
window (at top left of Font window). Also do I have to update all field
names in the code/modules and re-insert new fields on form? Am I doing
un-necessary/extra work when the field names change or is there a more
efficient way to update or plan for field name changes?
  #2  
Old January 13th, 2010, 01:37 AM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Data Fields Changing

Steve,

Though I am slightly confused by your meaning of *sub databases* I think
this will work for you... http://www.rickworld.com/products.html (Sorry
don't know of a free one that actually works).

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve Stad" wrote in message
...
I have a Master Table in a Master DB linked to a few sub databases. The
input forms (to update Master table) are in the sub databases based on
queries also in the sub db's. The field names in the Master table change
names occasionally. Is there an efficient way to update code in modules,
forms, and control/fields in the form(s) when the fields change in the
Master
table. I can update the control source/fields in the form for the new fld
names - but I noticed the old/previous field names still in the dropdown
window (at top left of Font window). Also do I have to update all field
names in the code/modules and re-insert new fields on form? Am I doing
un-necessary/extra work when the field names change or is there a more
efficient way to update or plan for field name changes?



  #3  
Old January 13th, 2010, 02:01 AM posted to microsoft.public.access.tablesdbdesign
Clifford Bass via AccessMonster.com
external usenet poster
 
Posts: 150
Default Data Fields Changing

Hi Steve,

If the names of the table columns change, but that is all, then you
could simply hide the problem behind a query. Make sure you have a backup of
the front end. We are talking a front end here aren't we? Create a new link
to the table and give it a new name. Create a query that uses the new table
and aliases (renames) any columns as needed. When you save it, save it as
the current table name. Delete the old table link. All should work as
before. In the future when column names change, all you have to do is fix
the query.

So if your original table link is "tblData" and its fields are Col1,
Col2 and Col3, you would create a new table link to it called something like
"tblTheData". Then you would create a query named "tblData" that simple does
"select Col1, Col2, Col3 from tblTheData". Then delete "tblData". When the
back end "tblData" column names change to Fld1, Fld2 and Fld3, you update the
link to "tblTheData" and and then change the "tblData" query to be "select
Fld1 as Col1, Fld2 as Col2, Fld3 as Col3 from tblTheData". And you are done.
Make sure you document that you are naming a query to look like a table. Or
name the query "qryData" and then go through all of your code and queries and
forms and do a one-time replacement of "tblData" with "qryData".

Hope that helps,

Clifford Bass

Steve Stad wrote:
I have a Master Table in a Master DB linked to a few sub databases. The
input forms (to update Master table) are in the sub databases based on
queries also in the sub db's. The field names in the Master table change
names occasionally. Is there an efficient way to update code in modules,
forms, and control/fields in the form(s) when the fields change in the Master
table. I can update the control source/fields in the form for the new fld
names - but I noticed the old/previous field names still in the dropdown
window (at top left of Font window). Also do I have to update all field
names in the code/modules and re-insert new fields on form? Am I doing
un-necessary/extra work when the field names change or is there a more
efficient way to update or plan for field name changes?


--
Message posted via http://www.accessmonster.com

 




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


All times are GMT +1. The time now is 05:47 AM.


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