Data Collection via Email

T

TREVOR

I have set up a table in ACCESS to track hours worked on a given project.
The table is updated using the "Collect Data Through Email Messages Wizard."
But I want the incoming data to add to, not over-write, the project hours
previously posted. Is there a way to do that? If so, what is the routine?

Thanks,

Trevor
(e-mail address removed)
 
N

NetworkTrade

make it 2 step; collect data to Table1 which is intented to be overwritten
each time; but make an append query of table1 to your permanent table that
runs each time....so that once the data is appended to the permanent, then it
is ok to overwrite Table1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting Email options when using Data Collection via Email 0
Linking data in MS Word into Excel 5
Data Collection Via Email -- error message that does not make sens 0
Collecting data via email problem 1
Access '07 Data Collection via Email 0
Data Collection via Email 0
Collect Data via Email won't provide existing information. 2
Collect Data via Email Question Length 3

Top