To Add Yes/No Field using SQL

[sajedaslam]

Hi Guys

I want to add a field Status123 of Datatype Yes/No in MS Access using SQL.
I am using SQL as

Alter Table Labor Add Status123 YesNo.

It creates a field but its data type is not Yes/No.

Please guide.

Sajed Aslam

 

[SamDeMan]

explain what you are trying to do.

sam

 

[RV]

Run your statement in MS Access.

RV

 

[raskew]

Try this:

Public Sub AddField2(ptbl As String, pfld As String, ptype As Integer, Optional psize As Integer)
'from debug window
'Call AddField2("Labor", "Status123", dbBoolean)
Dim db As Database
Dim td As TableDef
   
   Set db = CurrentDb
   Set td = db.TableDefs(ptbl)
   With td
   .Fields.Append .CreateField(pfld, ptype)
   End With
   db.Close
   Set db = Nothing
End Sub

HTH - Bob