Select Query in VBA

[3239]

I'm new at writing queries in VBA. I Just wanted to know if it is possible to write select queries in VBA and if so, how?

Thanks.

 

[PHV]

Use a Recordset.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[genomon]

An easy way to start is to develop a query in query design view, then change views to SQL view. This will give you an idea of the SQL you will need to SELECT from your recordset.

If quizzes are quizzical, what are tests?

 

[lameid]

The answer is yes. The real question is what do you want to do?

A Recordset will allow you to programmatically manipulate or read the records. You can create a DAO Querydef object (query) and set it's Sql property and you have a query. You might set the recordsource property of a form or report to an SQL string in VBA. You may also mean you want to build a select statment based on selections of things on a form.

So what is it you are REALLY trying to do?

 

[jedraw]

As others have said, it depends on what you want to do.
Here's a link with various Access pointers

http://www.fontstuff.com/access

 

[kjv1611]

3239,

Did you ever made any sort of decision on this? Where are you at with your project or whatever?

--

"If to err is human, then I must be some kind of human!" -Me