var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to manipulate a table thru VB
I have a table and I want to add/Delete a column/field to it using VB..is that possible?
If yes how can I do that.
Any help would b greatly appreciated.
Sure, you need to use the Alter Table statement.
Ex. (from Access Help):
Dim dbs As Database
' Modify this line to include the path to Northwind
' on your computer.
Set dbs = OpenDatabase("Northwind.mdb")
' Delete the Salary field from the Employees table.
dbs.Execute "ALTER TABLE Employees " _
& "DROP COLUMN Salary;"
Hope this helps,