creating a table

  • Thread starter Thread starter david white
  • Start date Start date
D

david white

dynamically - on-the-fly I want to push a button that
creates a table with 2 fields (field1 field2). How can I
do it? Thanks.
 
Put code similar to this in the Click event of your button:

DoCmd.RunSQL "CREATE TABLE MyTable (Field1 Number, Field2 Text)"
 
Back
Top