Previous Thread

6/30/2006 4:22:02 AM    Is it possible to add, remove, and rename a column.
Is it possible to add, remove, and rename a column in a Table using a Form, 
 
if yes them how? 
 
For example, there is a Table by name tblSales, which carries Field1, Field2 
 
and Filed 3, can there be a user Form which takes the input from user and 
 
creates another column in table tblSales. 
 
Thanks.



6/30/2006 6:05:16 AM    Re: Is it possible to add, remove, and rename a column.
Some thoughts. 
 
1) If you had developed ANY forms/queries/reports etc using those names 
 
then they are now broken when you do that. Also, if you remove the 
 
column you lose the data. 
 
2) It is the title/literal/label that goes with the field that you want 
 
to change when it appears on a form/report. 
 
- with forms it can be done with a conversion table used when you load 
 
the form. Not fun and a lot of work but it can be done. 
 
- I have never attempted it with reports. 
 
Ron.

6/30/2006 12:39:18 PM    Re: Is it possible to add, remove, and rename a column.
It's possible - but needing to do so is usually a sign of a poorly designed 
 
database. 
 
"Kevin" <Kevin@discussions.microsoft.com> wrote in message 
 
news:68A279A8-1BB4-46F7-8D8B-36423C7046FD@microsoft.com...

6/30/2006 1:15:28 PM    Re: Is it possible to add, remove, and rename a column.
Yes, it is possible.  Check this thread: 
 
http://www.xtremevbtalk.com/showthread.php?threadid=16324 
 
And this: 
 
http://support.microsoft.com/?kbid=210405 
 
And this: 
 
http://www.utteraccess.com/forums/showflat.php?Cat=&Number=702770&Main=702437 
 
More important than adding a new field is the ability to use a search 
 
engine properly.  ;o)