create query

[Doina]

Hi all,

Is there a way to create a query in ms-access using a command like:

create myquery(custID, custName)
as
select custID, custName
from customers;

I need to update an existing ms-access database and I would rather create a VB program to execute this commnad along with other updates.

Thanks,
Doina

 

[LittleSmudge]

I think you've just spent twice as long coding as it would take to do it by hand !

If you are going through the queries and replacing an existing table name with another (New ) table name then that's a different matter. Use the QueryDef object and cycle through looking for the text string and replace it in all cases.


G LS

 

[Guest_imported]

hi I don't know if you can help me but I need an info

 

[Guest_imported]

I want to know if you know how to create a calculated field with the expression TrueFalse. My program doesn't accept that kind of format, it only take the numeric on like true is -1 and false is 0. I really need your help ASAP.

Thanks a lot.

 

[Doina]

Hi,

You should post your question in a new thread since this is a different subject.

Doina