Everything you wrote in your email is foreign to me. I haven't a clue how
to initiate the partial send of records or use CommandButton. I have
ordered an Access 2010 book, but it won't be here till next week. I will
google CommandButton. I really appreciate the help!
Valerie
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Clive
Sent: Friday, August 03, 2012 3:57 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Exporting partial records
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
<mailto:MS_Access_Professionals%40yahoogroups.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
<mailto:MS_Access_Professionals%40yahoogroups.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.
> >
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar