Re: Need help creating temporary table from filter

you're very welcome :)


"Darhl Thomason" <darhlt@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OAe4NiKMGHA.1676@xxxxxxxxxxxxxxxxxxxxxxx
OK, so I've played with both and I agree that doing it with a new select
query is the way to go.

So, now that I have the data for the email messages, I'm planning on using
For Each/Next to parse through the records to create/send the messages.

Thanks a lot for your advice! It's highly appreciated.

Darhl


"tina" <nospam@xxxxxxxxxxx> wrote in message
news:ZMWHf.386323$qk4.206050@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
using a query to pull a subset of existing table data usually makes a
lot
more sense than either 1) repeatedly creating/deleting a temp table,
inside
or outside the database, or 2) adding/deleting records to an existing
"holding" table.

if your process didn't use For Each/Next loops on tblTemp, why should
you
need to do that when you substitute a SELECT query? as i said before,
and
as
Marsh said elsewhere in this thread, you can probably use the query
*exactly
the same way as you were using tblTemp*. "At least give it a try before
launching off into all this
temp table stuff." <from Marsh's post>

hth


"Darhl Thomason" <darhlt@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uqtfhwEMGHA.208@xxxxxxxxxxxxxxxxxxxxxxx
Would that be more efficient than putting it in a temp table?

I'm currently reading up on For Each/Next loops to parse through the
dataset
(I'll use that because it should work instead of an extra table or a
new
recordset). Is that the best way? I'm also thinking of Do While not
dataset.EOF to parse through.

Thanks again,

Darhl

<snip>
a SELECT query returns a specific dataset, which is what you get when
you
work with a table. have you tried using the SELECT query in your
"form
letter email" process, *instead of * tblTemp?
</snip>








.

Relevant Pages

  • Re: Need help creating temporary table from filter
    ... For Each/Next to parse through the records to create/send the messages. ... need to do that when you substitute a SELECT query? ... the same way as you were using tblTemp*. ... I'm currently reading up on For Each/Next loops to parse through the ...
    (microsoft.public.access.formscoding)
  • Re: Need help creating temporary table from filter
    ... more sense than either 1) repeatedly creating/deleting a temp table, ... need to do that when you substitute a SELECT query? ... the same way as you were using tblTemp*. ... I'm currently reading up on For Each/Next loops to parse through the ...
    (microsoft.public.access.formscoding)
  • Re: Library Cache
    ... procedures that determines the SQL to be submitted based on the ... query string to parse, whereas: ... it's HOW and WHEN that replacement occurs. ...
    (comp.databases.oracle.server)
  • Re: help pulling data from a query
    ... our scanners will only scan the data not hit return so i was ... that the query just returns the scanned units. ... if the battery should be replaced again or not. ... then parse that string to find each serial number. ...
    (microsoft.public.access.forms)
  • Re: Need help with query linked to form.
    ... Format() is guaranteed to create a Text field. ... You generally do need to parse the dates so Access knows how to interpret them. ... I have never used the CVDate() function though. ... do you use a Make Table query? ...
    (microsoft.public.access.queries)