adding field to record using command_click

  • Thread starter Thread starter susan
  • Start date Start date
S

susan

Hi,

How can I add a Yes/No-field to a record using a Command_click() ?
Is it also possible to check if the field already excists before adding it?

Thanks,

Susan
 
Susan, you really should switch your table to design view to add new fields.

Access 2007 does actually allow you to add new fields while the table is
open in datasheet view (shudder!!!), but no one who knows what they are
doing would ever use this misguided 'feature'.

If you have a table with lots of yes/no fields, there's a very high probably
that you have created a spreadsheet design in Access, i.e. you have not
built it the way a database should be designed. For details, see:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html
 
Back
Top