Re: Tips on domain aggregate replacements

Tech-Archive recommends: Fix windows errors by optimizing your registry

Brian, if you just want a single value in VBA, just go for it.

If you need multiple values, or values in a loop, you are probably better to
build a recordset to get those values. It will be based on a totals query,
or possibly a query with a subquery.

If subqueries are new, see:
How to Create and Use Subqueries
at:
http://support.microsoft.com/?id=209066

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Brian" <Brian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5022F742-E256-45EC-8DEA-2A0F6A5FA230@xxxxxxxxxxxxxxxx
> Everything I am reading tells me I should minimize my use of domain
> aggregate
> functions, so I am in the process of going through several apps to replace
> these. In many cases, I can use a join in a query, but there are times
> when I
> need to run the statement from VBA. I need a tip on how to accomplish
> this.
>
> I know how to run action queries using RunSQL, but (how) can I run select
> queries to return Max, Sum, etc. results to a variable or array in VBA?


.

Relevant Pages

  • Re: Merging content from access
    ... My hunch at the moment is that this is a problem in my access query. ... I agree with you that Word VBA is a more elegent solution. ... The other field-based technique requires you to have a "parent" table as ... the mail merge data source and a child table inserted using a DATABASE ...
    (microsoft.public.word.docmanagement)
  • Re: Merging content from access
    ... that could well be the case - I guess you'd see if you ran the same query in Access. ... I have an expression that calls a vba function to collate records from all of the notes resulting in a long field. ... Historically, there have been character-count limit problems when Word gets data from Access memo fields (e.g. the limit for ODBC connections was increased many years ago, I haven't researched the Access limitations" problem anything like as much as the equivalent problem in Excel. ... The other field-based technique requires you to have a "parent" table as the mail merge data source and a child table inserted using a DATABASE field. ...
    (microsoft.public.word.docmanagement)
  • Re: Form Advice Relating to Queries
    ... books, Mastering Access 2002 Premium Edition, Access InsideOut 2002 by Helen ... For more complex queries, use vba programming..... ... I haven't quite worked out how to use the Query Builder via ... ... The form's RecordSource property is a string. ...
    (microsoft.public.access.forms)
  • RE: Macro
    ... The macro can be found by type Alt F11 to get to VBA and clicking on Module1 ... Then post the query results. ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ...
    (microsoft.public.excel.programming)
  • Re: Form in macro to not open if query result is empty recordset
    ... basically a redisign of a previous tool that was written solely in vba. ... macro means that one will not run until the previous query has completed. ... If not all the vendors will be in your vendor list and you have RI ...
    (microsoft.public.access.forms)