I need hep Adding a boolean field using CREATE TABLE in VBA

G

GitarJake

dbs.Execute "CREATE TABLE [" & Me.txtSongbookName & "] " _
& "(SongTitle CHAR (50), SongOrder INTEGER, SongLyrics MEMO, " _
& "SongChords_A MEMO, ASelect Yes/No)"


Hello all,

Where it says "Yes/No" above I have tried "Boolean", "True/False", "On/Off"
and even "MakeADernedYes/NoFieldYouSnippityTwitOfAProgram"!

How do I add a yes/no field to a table using CREATE TABLE in VBA?

TIA

Jake
 
D

Dirk Goldgar

GitarJake said:
dbs.Execute "CREATE TABLE [" & Me.txtSongbookName & "] " _
& "(SongTitle CHAR (50), SongOrder INTEGER, SongLyrics MEMO,
" _ & "SongChords_A MEMO, ASelect Yes/No)"


Hello all,

Where it says "Yes/No" above I have tried "Boolean", "True/False",
"On/Off" and even "MakeADernedYes/NoFieldYouSnippityTwitOfAProgram"!
LOL

How do I add a yes/no field to a table using CREATE TABLE in VBA?
Click to expand...

Use BIT or YESNO as the field type.
 
Top