var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: create tables in access with vba
I need to gather lots of info from a bunch of tables and shove it into another bunch of tables.
My question is: how do I use vba in access to automate the query creation and how to avoid massive warnings that access gives out for me to click on once I dare create a new table.
To create a table via VBA use
Dim tbl As TableDef, fld As Field
Set tbl = dbs.CreateTableDef("yourTAbleName")
' Creating the fields
Set fld = tbl.CreateField("yourFieldName", "yourFieldType", yourFieldsize)
if you mean, that you are reorganising existing table data in new tables, in that case i have done that by using an array.
i read one table in the array (or in case you have a large table record per record)
and add to the array (elementlist, row) an destination table (recordset)
with for next edit and update.
to supress the warning use this in your code