|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 9th, 2009, 03:26 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Can I create a query using the results of a Macro?
If so, how?
|
|
#2
December 9th, 2009, 10:08 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Can I create a query using the results of a Macro?
On Dec 8, 9:26*pm, hshepardjr
wrote: If so, how? Never tried. What's the macro do? If it's just data manipulation, then probably...
|
|
#3
December 9th, 2009, 02:45 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Can I create a query using the results of a Macro?
The web interface cuts off the Subject line after about 50 characters so your
question looked like: Can I create a query using the results of .... Please keep the subject very short and expound upon it in the message area. The big question is: What are the results of a macro? It almost has to be something like a query running inside the macro to have results. Please explain what those results are and how they became results. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "hshepardjr" wrote: If so, how?
|
|
#4
December 9th, 2009, 04:52 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Can I create a query using the results of a Macro?
The Macro displays query results based on selected criteria in a form. The
query results displayed are one of three queries. For example: Macro criteria: If [Forms]![Pick]![Segment] = WIS, OpenQuery: "WIS Query" If [Forms]![Pick]![Segment] = Count, OpenQuery: "Count Query" If [Forms]![Pick]![Segment] = Summer, OpenQuery: "Summer Query" I believe this can also be done through an If else statement in VBA but I'm not sure how to create a query to call the recordsource in VBA. Any help you can provide would be appreciated. Thanks, "Jerry Whittle" wrote: The web interface cuts off the Subject line after about 50 characters so your question looked like: Can I create a query using the results of .... Please keep the subject very short and expound upon it in the message area. The big question is: What are the results of a macro? It almost has to be something like a query running inside the macro to have results. Please explain what those results are and how they became results. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "hshepardjr" wrote: If so, how?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
