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.
--- In MS_Access_Professionals@yahoogroups.com, "Valerie B." <angel9494@...> wrote:
>
> Completely disconnected unfortunately.
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
> Sent: Thursday, August 02, 2012 1:35 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] Re: Exporting partial records
>
>
>
>
>
> Valerie
>
> Are these receivers on your network or are they completely disconnected from
> your office?
>
> Regards,
> Bill Mosca,
> Founder, MS_Access_Professionals
> That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
> MS Access MVP
>
> <https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-642707308
> 81E>
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-6427073088
> 1E
>
> My Nothing-to-do-with Access blog
>
> <http://wrmosca.wordpress.com> http://wrmosca.wordpress.com
>
> 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
> val9494@... <mailto:val9494%40att.net>
> Sent: Thursday, August 02, 2012 11:07 AM
> To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Re: Exporting partial records
>
> I apologize in advance, as I am quite new to this. Ok, I can add that field,
> but
> how do I only export the new records and attachments for them to import into
> their existing database?
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "Clive" <zctek@>
> wrote:
> >
> > Hi Valerie,
> >
> > Add another Field 'DateSent' to the table.
> > When you send the updates you need to enter the
> > date in the new field. You can then identify the
> > new entries by the absence of a 'DateSent' (null value).
> >
> > Regards, Clive.
> >
> > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "val9494@" <angel9494@>
> wrote:
> > >
> > > Hello! I have been having a hard time trying to figure out how to export
> partial records for a database.
> > >
> > > We are using the desktop call tracker database and are inputting
> customer
> leads in there with the attachments on the customer call details table. (I
> did
> add an additional 'date entered' field for when the lead is entered.) I sent
> the
> initial database to someone else to follow-up on all the leads. Meanwhile, I
> will be adding new customer leads in the database and they will be making
> call
> notes in the original database I have sent them. Once a week I want to send
> the
> new customer leads in there with their attachments that I have entered
> without
> re-sending the entire database (as that would overwrite their notes). I
> could
> use ID number or date as a way of knowing which records to send BUT how do I
> do
> only send new records and attachments?
> > >
> > > Sorry if that is too long or if I sounds confusing. Of course, it makes
> sense in my head... lol
> > >
> > > I appreciate your help!
> > > Valerie
> > >
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar