Re: How do I load data from a select query into an Array in VBA co
- From: "Tony Toews [MVP]" <ttoews@xxxxxxxxxxxxxxx>
- Date: Fri, 21 Dec 2007 18:12:49 -0700
BlueWolvering <BlueWolvering@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Ok, I suppose it's not NON Negotiable. My skill set is still a little
limited with VBA for access, though I'm pretty good with VBA for Excel. I
feel comfortable with VBA, but less so with the ACCESS specific stuff.
The differences between VBA for Excel and Access are negligible except
for the Excel/Access specific stuff. Which obviously can be
significant. But easily doable.
I am going to proceed with the method you suggest.
Here's what I need to do with data and you can tell me if there's a better
way.
I need to pull date's from the select query (3 fields) and compare them
against each other and today's date.
There might be ways of doing this in queries so that you can have just
one Update query doing the whole thing. Depending on the complexity
of the logic, etc, etc.
After that I have to extract the other
fields and insert them into a string that will be the text for an sql update
query. All this is done in VBA. Are arrays a good way to store this or is
there a better way?
For each record you are reading in are you then making a decision and
then updating a record? Nothing depends on data from multiple
incoming records?
If that's the case then just use variables inside the recordset
looping logic previously mentioned and update each record in the loop.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.
- References:
- Re: How do I load data from a select query into an Array in VBA code?
- From: Tony Toews [MVP]
- Re: How do I load data from a select query into an Array in VBA co
- From: BlueWolvering
- Re: How do I load data from a select query into an Array in VBA code?
- Prev by Date: Re: Access 2003 and Active Directory
- Next by Date: Re: Counting function
- Previous by thread: Re: How do I load data from a select query into an Array in VBA co
- Next by thread: RE: OnClick Command does not word with Vista
- Index(es):
Relevant Pages
|
