Hello everyone,
Today's question:
What is the correct syntax for creating a table with VBA, using an YesNo field, and setting it's default value to NO/0/False?
This does not work, syntax error. IF I remove the default constraints, it runs. Using NO and FALSE also fail.
According to W3 Schools (W3), it should work...
Thanks!
Mike
Today's question:
What is the correct syntax for creating a table with VBA, using an YesNo field, and setting it's default value to NO/0/False?
Code:
sSQL = "CREATE TABLE TempSupercede (ItemID_FK INT, SupplierID_FK INT, PartNumber TEXT, DiscPart YesNo DEFAULT 0, Supercede YesNo DEFAULT 0)"
This does not work, syntax error. IF I remove the default constraints, it runs. Using NO and FALSE also fail.
According to W3 Schools (W3), it should work...
Thanks!
Mike