Is it possible to add, remove, and rename a column.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
It's possible - but needing to do so is usually a sign of a poorly designed
database.
 
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.
 
Back
Top