Re: How to Direct Query Output ?
- From: Marshall Barton <marshbarton@xxxxxxxxxx>
- Date: Sat, 30 Apr 2005 14:05:44 -0500
IAN BURDON wrote:
>I am have a problem redirection a Query out to a named TABLE or to Visual
>Basic Macro object set using DAO. Does anybody know if this is possible and
>if so how.
Sorry, but your question as stated doesn't make much sense.
Ultimately, a Select query only retrieves records from one
or more tables. It's the context that's used to run the
query that determines how those records are used.
For example, a query used in a form's record source allows
the form to display/modify the values in the records.
Another example is opening a recordset on the query so that
you can use DAO or ADO operations on the records/fields in
the query's dataset. If this is what you're asking about,
then see Help on the DAO Recordset onject.
Perhaps if you explained what you are trying to accomplish,
someone might be able to provide a more specific answer.
--
Marsh
MVP [MS Access]
.
- References:
- How to Direct Query Output ?
- From: IAN BURDON
- How to Direct Query Output ?
- Prev by Date: Re: pulling a report from 3 tables
- Next by Date: Re: Query Problem
- Previous by thread: How to Direct Query Output ?
- Next by thread: Re: What is the T-SQL equivalent for ANSI-SQL substr?
- Index(es):
Relevant Pages
|
|
