Edit Existing Code


just fix it

We would like to add an additional field to our txt reports. In looking at
the code I have made what I thought was the correct change but only see the
change in the export delim report not the export fixed report. The current
code is as follows:

Option Compare Database

Private Sub FindButton_Click()
On Error GoTo Err_FindButton_Click

DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit Sub

MsgBox Err.Description
Resume Exit_FindButton_Click

End Sub

Private Sub Form_AfterUpdate()
DoCmd.TransferText acExportDelim, , "qu-Active Cad", "n:\public\actv-cad.txt"
DoCmd.TransferText acExportDelim, , "qu-Stored Cad", "n:\public\stor-cad.txt"
DoCmd.TransferText acExportDelim, , "qu-Current Job List",
DoCmd.TransferText acExportDelim, , "qu-Master Job List",
DoCmd.TransferText acExportFixed, "standard-active", "qu-Active Cad",
DoCmd.TransferText acExportFixed, "standard-stored", "qu-Stored Cad",

End Sub

The correct information is showing up in the first line for "qu-active Cad"
"C:\public\active-cad.txt", but it does not reflect correctly under line 5
for the r-list portion.

I am a basic access user and the person that created this program has not
worked here in years. I do not know what the portion "standard-active" is.
Have looked at all the qu's and do not see any reference to this nor is their
a file on the network called this. We are attempting to add an additional
field to the txt report. This is not a new table that the data is pulling
from, but rather a new field on the report.

What do I need to do to get the data to reflect on the ExportFixed
"Standard-Active", "qu-active Cad", "N:\store\file\r-list.txt.

Any assistance would be greatly appreciated.

Jeanette Cunningham

you need to make some change to the width of the fields in the export
specifications used in the export with fixed width fields.

Do a manual export using the fixed width specification and the appropriate
query. Use the advanced button, choose standard-active.
The details of standard-active will open.
Check the data in each field - you will need to adjust the field length so
that the data in all fields can be seen.
When you have finished adjusting standard-active, save it.
Do the same process for standard-stored

Jeanette Cunningham -- Melbourne Victoria Australia

Jeanette Cunningham

I have filed this extra info for future answers.

Jeanette Cunningham -- Melbourne Victoria Australia

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question