Adding a date field with code

N

Nigel

I am trying to add a field using code, it is a date field
but I just cannot get this to work, any suggestions

dbs.Execute "ALTER TABLE orders ADD COLUMN
emaildate date/time"

Nigel
 
R

Roger Carlson

The datatype is "DATE" and not "DATE/TIME" Therefore:

dbs.Execute "ALTER TABLE orders ADD COLUMN emaildate date"

should work.
 

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

Add New Combobox to table useing code 1
Add Column 4
error on update table WHERE date comparison 0
Updating a field using 'on click' event procedure (access 2000) 6
Calender Control on a Form 2
Setting DefaultValue property with VBA 4
modify field type of existing field in table 1
want to change field size by using alter table 1

Top