How to implement DoCmd.TransferText

[BradCustom]

I'd like to use the DoCmd.TransferText to export a table as a fixed width text file but I'm not sure how to implement the code.
Do I link it to a macro or to a button click?

Thanks for the help!

 

[PHV]

Use a SpecificationName you've created doing the job manually.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BradCustom]

Thanks for responding,

I've tried that but the part I'm not sure about is how to use the VBA code. Should I create a module or place the code in the switchboard linking it to one of the command buttons or somehow use the code in a macro.

Below is the code:

Private Sub Command0_Click()
    DoCmd.TransferText acExportFixed, "Export-Weekly Payroll Template", "Weekly Payroll Template", "M:\PTO\Weekly Payroll Hours\Weekly Payroll Template.txt", True

End Sub

Thanks for your help!

 

[combo]

If you plan to add this code to switchboard:
- add module and paste the code,
- make the procedure public, i.e. remove 'Private' from the procedure declaration (first line: [tt]Sub Command0_Click()[/tt]). It does not matter, but the procedure name could be more descriptive,
- in the switchboard wizard, add item, with 'run code' action and procedure name from the code.

combo