Re: E-mailing data and receiving it back in

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.

--
PC Data***
Your Resource For Help With Access, Excel And Word Applications
resource@xxxxxxxxxxxxxxx
www.pcdata***.com


"Bill Brinkworth" <BillBrinkworth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:993F4B1F-B49D-4AFB-8ECA-E405548E2B31@xxxxxxxxxxxxxxxx
> 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.
>


.