Query To String Converter

[BerkshireGuy]

I thought I remember a utility that lets you cut a Select statement
from a query and it converts it to be used in VB. Takes the work out
of making sure the syntax is correct.

Anyone know of such a utility?

[Lyle Fairfield]

"BerkshireGuy" <be*************************@yahoo.comwrote in
news:11*********************@h40g2000cwb.googlegro ups.com:

I thought I remember a utility that lets you cut a Select statement
from a query and it converts it to be used in VB. Takes the work out
of making sure the syntax is correct.

Anyone know of such a utility?

The SQL created by the Query Wizard? in Access is convoluted, verbose,
inefficient, ugly and bad. (For the young: It sucks!)

One might consider going from the String to to the Stored Definition as a
more productive route. After one has learned to write SQL, many previously
puzzling tasks may seem simple.

In any case the QueryDef's SQL (string property) holds the SQL string.

--
lyle fairfield

[BerkshireGuy]

Thanks Lyle:

I don't think it's clear. I know how to write SQL, but sometimes I
want to take a query and use the same logic (select statement) in VB
(perhaps in a recordset or whatever). I usually just copy and paste -
but then you need to fix all the syntax - single quote instead of
double, etc. I was wondering if there was a program that formatted a
querys SQL for VBA use.

-=B

Lyle Fairfield wrote:

"BerkshireGuy" <be*************************@yahoo.comwrote in
news:11*********************@h40g2000cwb.googlegro ups.com:

I thought I remember a utility that lets you cut a Select statement
from a query and it converts it to be used in VB. Takes the work out
of making sure the syntax is correct.

Anyone know of such a utility?

The SQL created by the Query Wizard? in Access is convoluted, verbose,
inefficient, ugly and bad. (For the young: It sucks!)

One might consider going from the String to to the Stored Definition as a
more productive route. After one has learned to write SQL, many previously
puzzling tasks may seem simple.

In any case the QueryDef's SQL (string property) holds the SQL string.

--
lyle fairfield

[raskew via AccessMonster.com]

Hi -
You might be thinking of SQL Grabber. It's freeware available at Applecore.
http://www.applecore99.com/dld/dld001.asp

HTH - Bob

BerkshireGuy wrote:

>Thanks Lyle:

I don't think it's clear. I know how to write SQL, but sometimes I
want to take a query and use the same logic (select statement) in VB
(perhaps in a recordset or whatever). I usually just copy and paste -
but then you need to fix all the syntax - single quote instead of
double, etc. I was wondering if there was a program that formatted a
querys SQL for VBA use.

-=B

I thought I remember a utility that lets you cut a Select statement
from a query and it converts it to be used in VB. Takes the work out

[quoted text clipped - 10 lines]

>>
In any case the QueryDef's SQL (string property) holds the SQL string.

--
Message posted via http://www.accessmonster.com