Deleting a table's field with VBA

  • Thread starter Thread starter Guest
  • Start date Start date
To delete the contents of a field, leaving the definition ...

UPDATE tblTest SET tblTest.TestText = Null

To remove the definition of the field from the table ...

ALTER TABLE tblTest DROP COLUMN TestText

You can execute these SQL statements from VBA code using either
CurrentDB.Execute (in an MDB) or CurrentProject.Connection.Execute (in an
MDB or an ADP).
 
You must log in or register to reply here.

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

ReNaming a table's field name with VBA 1
delete autonumber memory 2
Finding a special characterlike + 1
programmcatically create a relationship between tables 2
Find/Replace with code 3
Error 3211 delete table with multi-valued lookup field 7
creating a table of file names 3
Open report from multivalue fields 1

Back
Top