E-mailing data and receiving it back in

[Bill Brinkworth]

I need some advice. From an Access table (2003), I want to pull up certain
records, email them (could be 30 records with 20 fields) to salsemen. They
will receive the data and have the opportunity to enter data, check
checkboxes, select from combo boxes, and then e-mail the data (after its
changed) to the originating computer where it will go back into the Access
database. Can it be done with Access? What are some of the steps and
techniques I would have to incorporate?

Thanks for your guidance. I know it can be done, but i don't have a clue
how to accomplish it.

 

[Rick B]

answered in your OTHER post. Please post once per topic.

 

[MikeKloss]

What is the answer cannot find other post. -Mike

 

[Rick B]

I don't think you can email an interactive object. You can email a report
to them, but they can't update a report.

 

[Tom]

Since the records already exist in your table, you don't have to worry about
creating primary keys or conflicying data in any of the fields in the table.
Since the sales man will be entering data (presumably only in the records),
checking checkboxes and selecting from comboboxes, you don't have to worry
about conflicts in other tables. So all you need do is email the salesman a
small database that contains a table with the records, all the tables needed
for rowsource values for the comboboxes and a form for the salesman to do
data entry. With that, the salesman should be able to do all that you
describe he needs to do. When the salesman returns the database, you need to
create a temporary link to the database from your primary database. You then
need an update query in the primary database that updates all the records
that you sent to the salesman. If you need help setting this all up, contact
me at my email address below. I can help you for a resonable fee.