Create a table in access 2002 using VBA

Computing.Net > Forums > Programming > Create a table in access 2002 using VBA

Create a table in access 2002 using VBA

Original Message

Name: Willems
Date: July 29, 2002 at 07:21:39 Pacific
Subject: Create a table in access 2002 using VBA

Comment:

I'm looking for a way to create a table in my MS Access database. This table should be dynamic so i would like to create and modify it using VBA. But I don't seem to find one good way to do this. I'm using access 2002.

Report Offensive Message For Removal

Response Number 1

Name: Conrad miller
Date: July 29, 2002 at 13:17:24 Pacific

Reply: (edit)

You can use a macro then select run sql or
The sql ="SELECT [pram1] AS Feild1, [pram2] AS Feild2, [pram3] AS Feild3 INTO Test;"
take a command button with this code
docmd.runsql "SELECT [pram1] AS Feild1, [pram2] AS Feild2, [pram3] AS Feild3 INTO Test;"

Report Offensive Follow Up For Removal

Response Number 2

Name: mark
Date: July 30, 2002 at 06:53:51 Pacific

Reply: (edit)

it tells you on the microsoft site, under automation i think

Report Offensive Follow Up For Removal

Response Number 3

Name: kris
Date: July 30, 2002 at 20:29:49 Pacific

Reply: (edit)

Why using access ???
you could use php + mysql and do everything web based (even on lan). You will notice it's faster if you use linux and open source.

Report Offensive Follow Up For Removal


can we send mails from a table in access Help to create a function in Access Date question in access divert the mails in outlook into a table VBA in Access with Win XP	Linking forms in Access 2002 vb6 making tables in a web page visual basic and access...date/time Displaying Checkbox in email msg? delete a record in vb

JAVA- adding window to a ...

VB, C, Java or all?

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Create a table in access 2002 using VBA

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Have you ever used OpenOffice?

Poll Finishes In 5 Days.
Discuss in The Lounge

Play Backed Up Games

Nvidia Nforce networking controller

.dll files NOT found in Google ??

Old (~P1) Case LED Screen - setting

Better Motherboard

All Posts Awaiting Replies