Returning query result in code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I return the query result in a function to a module code caller?
 
Charles Tam said:
How do I return the query result in a function to a module code
caller?
Click to expand...

If the query returns multiple records, you open a recordset on the
query. If there is only one value you are interested in, and it's a
stored query you are talking about, you can use DLookup to get it,
specifying the query name as the domain argument.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

display results of VBA SELECT Query 2
dynamic query using parameter function 2
Running action function from SELECT query 8
Add a line/row number in front of query results 1
Access Print Files from Query Results 0
Custom Function to return array 2
>> List of database queries 4
Query update fails 7

Back
Top