Adding a field in a table

  • Thread starter Thread starter ReidarT
  • Start date Start date
R

ReidarT

I try to add a yes/no field into a table, but get an error.
dbs.Execute "ALTER TABLE tblFirmaopplysninger Add column TurIDSynlig
dbBoolean ;"
if I use 'text 255' instead of dbBoolean it works OK, but this shall be a
yes/no field

regards
reidarT
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Data Type from Integer to Boolean 9
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Make Table in Back End using VBA code is not creating the table 3
Error 2465; Can't Find Field 5
Boolean property - "Yes/No" 5
Adding field to existing table 2
Add New Combobox to table useing code 1
Creating Checkbox Fields For Every Record 0

Back
Top