Creating a tab delimted file from 3 different tables(macro preferred) 
Author Message
 Creating a tab delimted file from 3 different tables(macro preferred)

I need to be able to create a tab delimted file created
from 3 access tables, but it needs to be almost totally
automated as I have 12 salesmen that are not totally
computer literate.  They will need to be able to do this
and send the tab file via e-mail.  Please advise.

Mike



Tue, 15 Jun 2004 10:39:53 GMT  
 Creating a tab delimted file from 3 different tables(macro preferred)
You'll want to create a stored query that joins the tables appropriately and
includes the fields you want from each query.  You'll then want to go
manually through the export process once, but click the Advanced... button
before the end and save the export specification under a name you can refer
to later.  Now you can build either a true macro that uses the TransferText
action to export that query using the named export specification, or
(better) write a subroutine in a standard module to do it using the
TransferText method of the DoCmd object.  Your subroutine could even use the
SendObject method to send the exported file via e-mail to wherever it's
supposed to go.  You can run the macro or call the subroutine from a button
that you can place on the toolbar or on a form.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(to reply via e-mail, remove NOSPAM from address)


Quote:
> I need to be able to create a tab delimted file created
> from 3 access tables, but it needs to be almost totally
> automated as I have 12 salesmen that are not totally
> computer literate.  They will need to be able to do this
> and send the tab file via e-mail.  Please advise.

> Mike



Tue, 15 Jun 2004 14:04:09 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Tab Controls: Using Different Tables on Different Tabs

2. excel to tab delimted text file

3. Tab delimted txt file

4. Tab Control97 - Different Tables for Each Tab?

5. tab delimted ascii database to access

6. Creating macro for to open different excel files

7. Access Macro to create a tab-delimited file

8. Merging Multiple Text Delimted files into One .XLS file

9. What do you prefer - tabs or scrolling?

10. Reading comma delimted file using VBA


 
Powered by phpBB® Forum Software © phpBB Group