VBA HELP
From: JIMBO (anonymous_at_discussions.microsoft.com)
Date: 08/30/04
- Next message: Allen Browne: "Re: mysterious Type mismatch in WHERE clause"
- Previous message: Kendra: "Delete/append queries in macro firing late"
- Next in thread: Michel Walsh: "Re: VBA HELP"
- Reply: Michel Walsh: "Re: VBA HELP"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 30 Aug 2004 09:22:23 -0700
What if I have more than one query, say for example:
SqlStringA = Transform Query code
SqlStringB = Select Query Code
SqlStringC = Joins SqlStringA and SqlStringB
SqlStringD = Appends SqlStringC to a table
In this case I have four differnt querys, however if I
wanted to write this all in VBA how would I go about that.
I guess my ultimate question is if the case arises, how
would I execute a query in VBA and store the results in
memory to use in a later query also written in VBA?
- Next message: Allen Browne: "Re: mysterious Type mismatch in WHERE clause"
- Previous message: Kendra: "Delete/append queries in macro firing late"
- Next in thread: Michel Walsh: "Re: VBA HELP"
- Reply: Michel Walsh: "Re: VBA HELP"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
