make table query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI there

I appreciate your reply. Sir when i try to use the alter table command, i
can only use in sql or i have to include ansi sql 92 libraries. If i do that
my other queries strop working. I am working in visual basic, is there any
specific command for that.

Thank you.
Taher.
 
HI there

I appreciate your reply. Sir when i try to use the alter table command, i
can only use in sql or i have to include ansi sql 92 libraries. If i do that
my other queries strop working. I am working in visual basic, is there any
specific command for that.

Thank you.
Taher.
Click to expand...

One question I would have is - why do you need to routinely run
MakeTable queries AT ALL? In my experience it's usually better to use
a Select Query as the recordsource for a form, report, export or
whatever; creating a new table is just added overhead.

But to answer the question - you can use the DAO methods CreateIndex
and CreateField to do this. See CreateIndex in the VBA online help.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top