add a yes/no field to a table in code

[Mcgrco]

Does anyone know who to do this.

Thanks

 

[norman]

Function tbalter()

Dim mysql
mysql = "ALTER TABLE yourtablename ADD yournewfieldname yesno;"
DoCmd.RunSQL mysql

End Function

Note that this code has no error trapping and is very basic
Search help for alter table command for more info

HTH

Norman

 

[Mcgrco]

Thanks,

That worked fine