Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
save new Access table
- Thread starter ELPorter
- Start date
TonyJollans
Programmer
Hi ELPorter,
To just create an empty table you can do it with SQL
Or some more long-winded VBA (which I think is correct) ..
Enjoy,
Tony
To just create an empty table you can do it with SQL
Code:
DoCmd.RunSQL "CREATE TABLE NewTableName (F1 Double, F2 Text)"Or some more long-winded VBA (which I think is correct) ..
Code:
Dim OldDatabase As DAO.DataBase
Dim NewTable As DAO.TableDef
Set OldDatabase = CurrentDb
Set NewTable = OldDatabase.CreateTableDef("NewTableName")
With NewTable
.Fields.Append .CreateField("F1", dbDouble)
.Fields.Append .CreateField("F2", dbText, 255)
End With
OldDatabase.TableDEFS.Append NewTableEnjoy,
Tony
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question