Valerie
Please try the link to the eBook again. It needed to be repaired.
Bill Mosca
--- In MS_Access_Professionals@yahoogroups.com, "Valerie B." <angel9494@...> wrote:
>
> Thank you for the link to the ebook, but unfortunately an error comes up
> once you click on the ebook link saying "404 not found".
>
>
>
> That is my problem - I haven't sent a weekly email yet, because I don't know
> how to export just certain records. I have only sent the 1st database that
> had the initial contacts and attachments in it. I haven't figured out a way
> yet to send my weekly email w/ the new information for them to import into
> the database.
>
>
>
> I appreciate the valuable information that has been provided by Bill Mosca
> and all the posts within the group.
>
>
>
> Valerie
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Clive
> Sent: Friday, August 03, 2012 12:16 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Exporting partial records
>
>
>
>
>
> Hi Valerie,
>
> In the meantime, while you are waiting for your book,
> you can download an eBook to learn the basics of Access.
> It was prepared by Crystal, a Microsoft MVP.
>
> You will find it on Bill Mosca's website at,
> http://www.thatlldoit.com/Pages/AccessBasics.aspx
>
> Will you describe your current method for creating the
> data for the weekly email step by step?
>
> By the way, Bill Mosca is the founder of this website
> which has had just over 100,000 messages posted since
> it was started in 2002.
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "Valerie B."
> <angel9494@> wrote:
> >
> > 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%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Clive
> > Sent: Friday, August 03, 2012 3:57 AM
> > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.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>
> > <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>
> > <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]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar