Valerie
Thanks for letting me know. It seems to be okay today.
Bill
--- In MS_Access_Professionals@yahoogroups.com, "Valerie B." <angel9494@...> wrote:
>
> Good morning!
>
>
>
> I was able to download the link today from this link:
>
> http://www.thatlldoit.com/Pages/AccessBasics.aspx
>
>
>
> but just wanted to let you know this is the link from this pages that still
> isn't working:
>
> http://www.thatlldoit.com/Pages/default.aspx
>
>
>
> Thank you again!!
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
> Sent: Friday, August 03, 2012 1:37 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Exporting partial records
>
>
>
>
>
> Valerie
>
> Please try the link to the eBook again. It needed to be repaired.
>
> Bill Mosca
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.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%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Clive
> > Sent: Friday, August 03, 2012 12:16 PM
> > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.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>
> > <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%40yahoogroups.com>
> > > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.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>
> > <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>
> > > <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>
> > > <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]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar