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)"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 options based on result 4
updated field 3
Different fields "Required" 1
Error message - unique index created on two different fields 3
Create and Open Word Document From Access & asociate with 2 Fields 3
Report layout problem 2
Referencing table objects 2
Maximum value from table 9

Back
Top