Mark records as "sent"

[hullstorage]

Hi all,

I have a customer who has a copy of my database with identical tables etc..

On a daily basis he enters numerous delivery address's.

I am trying to do this with his database:

When he has entered the address's and he prints/emails the list of address to us the records that he has sent will be marked as "sent", so the next batch of address's will not be sent again i.e. avoiding him sending me duplicated records and a large table file size.

Any thoughts

Oh i will at some stage try and import his records into my database from email sent ??

many thanks

simon

 

[HiTechCoach]

Hi all,

I have a customer who has a copy of my database with identical tables etc..

On a daily basis he enters numerous delivery address's.

I am trying to do this with his database:

When he has entered the address's and he prints/emails the list of address to us the records that he has sent will be marked as "sent", so the next batch of address's will not be sent again i.e. avoiding him sending me duplicated records and a large table file size.

Any thoughts

Oh i will at some stage try and import his records into my database from email sent ??

many thanks

simon

It is possible to do what you want. What you are wanting is also called replication.

without seeing your database, it will be almost impossible to give you any specific advice for your database.

You could use the build in Access replication or create your own.

To get you started, see:
Synchronization without Replication

Database Replication in MS Access


I have a link for how to do it manually with VBA code and not the built in replications. I will see if I can find it.

 

[dfenton]

A more complete Jet Replication source is the Jet Replication Wiki:

http://dfenton.com/Replication/

There are a number of things that much of the documentation for Jet replication fails to caution about. The Jet Replication Wiki makes it clear what works and what doesn't.

 

[CEH]

Sounds like replication was an after thought....... your first question was on only sending new records........
I do this with a few DB's on "orders" a simple Yes/No field in the table... "Sent" perhaps. In the onclick event of the sendobject button run code to mark "Sent = True". Then with your query only pulling in records with "Sent = False" it won't send twice.