Hi Valerie,
Thanks for the info. Then pigeons would have been
fast enough :)
Have you added the DateSent field to the table and
modifed the query?
Knowing that you do it on a weekly basis, then you
could avoid adding the DateSent field and modify the
query to look for records created in the last seven
days. Originally I thought that you might be sending
updates more than once a day.
Do you use a CommandButton to initiate the creation
of the records to be sent and the sending of
the email?
Glad you liked the pigeons....
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "val9494@..." <angel9494@...> wrote:
>
> Hi Clive -
>
> I will be emailing the partial records for them to import into the existing database on a weekly basis.
>
> ...funny on the pigeon :)
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@> wrote:
> >
> > Hi Valerie,
> >
> > To select records that have not yet been sent,
> > you must be using a query to select the records.
> >
> > In that query you need to add the DateSent field
> > and in the QueryGrid for that column put Is Null
> > so you select only unsent records.
> >
> > When you have sent the records you will need to
> > update the 'DateSent' field so that they don't
> > get selected again when using the same query.
> >
> > How often are you sending the records? hourly, daily,
> > weekly?
> >
> > I saw your reply to Bill's post. How are you sending
> > the information?
> > By post on a CD, or paper documents, strapped to a pigeon,
> > or via a courier?
> >
> > Hope that helps.
> >
> > Regards, Clive.
> >
>
Tidak ada komentar:
Posting Komentar