N
Nick X
I have two databases. We will call them Alpha and Bravo. Alpha and Bravo
are basically the same database. Bravo is used for data entry of job
tracking by one entity and Alpha is used by another entity to track and do
quarterly billing on those jobs. To prevent duplication of work I would like
to do the following:
1) On database Bravo I would like to place a button with some code that
exports a comma delimited text file based on a query.
2) That code will then attach the text file to an e-mail and send it to
the recipient Alpha.
3) On the recipient Alpha's computer I will designate the default download
folder so the recipient only has to click "Save to Disk"
4) On database Alpha I would like to place a button with some code that
imports a comma delimited text file.
5) That code will then run some Update and Append queries to get the
information into the proper table.
I think I have #'s 4&5 covered, but I don't know where to start on the
export and e-mail part. I have control over database Alpha. Database Bravo
will be totally out my hands though once it is deployed, so I would like to
keep it as basic as possible.
Thanks
Nick X
are basically the same database. Bravo is used for data entry of job
tracking by one entity and Alpha is used by another entity to track and do
quarterly billing on those jobs. To prevent duplication of work I would like
to do the following:
1) On database Bravo I would like to place a button with some code that
exports a comma delimited text file based on a query.
2) That code will then attach the text file to an e-mail and send it to
the recipient Alpha.
3) On the recipient Alpha's computer I will designate the default download
folder so the recipient only has to click "Save to Disk"
4) On database Alpha I would like to place a button with some code that
imports a comma delimited text file.
5) That code will then run some Update and Append queries to get the
information into the proper table.
I think I have #'s 4&5 covered, but I don't know where to start on the
export and e-mail part. I have control over database Alpha. Database Bravo
will be totally out my hands though once it is deployed, so I would like to
keep it as basic as possible.
Thanks
Nick X