Kamis, 02 Agustus 2012

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-64270730881E>
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E

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@yahoogroups.com] On Behalf Of val9494@att.net
Sent: Thursday, August 02, 2012 11:07 AM
To: MS_Access_Professionals@yahoogroups.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> , "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> , "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]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar