Re: How to use a VBA query results in non-VBA query?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It sounds like a design problem, but you problem can normally be solved by a
temper table which it built via vba then queries are run against the temp
table. If you go down that route consider multi-user problems with the temp
table.

I urge you to review the structure of your data as there maybe a much
simpler/faster solution.


--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"ats" <ats@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1116326292.489459.89290@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I need the results of a query in several other queries. The problem is
> that the first query cannot be constructed using SQL, but can be in
> VBA. How can I refenence the VBA query results in other queries?
>
> The problem all steams from not being able to use another query or
> function results for the "IN" of a query which references direct path
> of the external database.
>
>


.

Relevant Pages

  • Re: Data Changing Issue
    ... In the query, on the field line, I added the above expression. ... *if* you are in VBA. ... the data of your table from a recordset. ... I am running some queries using a form I created and for some ...
    (microsoft.public.access.queries)
  • Re: Data Changing Issue
    ... "Michel Walsh" wrote: ... In the query, on the field line, I added the above expression. ... *if* you are in VBA. ... I am running some queries using a form I created and for some ...
    (microsoft.public.access.queries)
  • Re: Inserting data from 2 tables into 1
    ... been busy with Access and VBA for about 6 ... I would make all the queries and then use a set of macros to ... > Do you perhaps mean look for duplicates in tbResultsTemp? ... > The first is easier and lets you use all the nice interfaces like query ...
    (microsoft.public.access.modulesdaovba)
  • Re: Cant Explain This In Few Words
    ... The initial query I ... In this case here Day01 has the precip value for day one, ... Unit for Temp Data is either C or F. For precip it's Inches. ... >>thing I did was build queries to pull a specific element. ...
    (microsoft.public.access.queries)
  • Re: Data Changing Issue
    ... *if* you are in VBA. ... think you were using either VBA code, either a query.) ... is very unlikely to print some value of myid present in table1... ... I am running some queries using a form I created and for some strange ...
    (microsoft.public.access.queries)