copy / paste with form

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a form that asks around 15 questions. I want to
ultimately outpulse the results in a format that I can
copy and paste into as400. Here is my problem:

When I copy and paste, it shows the fields horizontally,
as it should, but I want it to show vertically.

Example:

Call back hours: 0800-1700
Call back Name: John Doe
Date of Call: 10/7/03

Here is what it outpulses if I send it to an excell doc /
copy and paste into an excell doc:

Call back hours: Call back Name: Date of Call:
0800-1700 John Doe 10/7/03

I want it to show:
Call back hours: 0800-1700
Call back Name: John Doe
Date of Call: 10/7/03

Any ideas?

Ultimate goal is when I click a command button, it will
outpulse it in a report type deal in access that I can
copy / paste into as400 in the format shown above.
..
 
I have a form that asks around 15 questions. I want to
ultimately outpulse the results in a format that I can
copy and paste into as400. Here is my problem:

When I copy and paste, it shows the fields horizontally,
as it should, but I want it to show vertically.
Click to expand...

Copy and paste - and even a basic Query - isn't going to do this for
you. I would suggest creating a Report with one textbox per line, with
labels for the fieldnames; you can then print this Report to a file
(.rtf format for instance) and read the file.

The alternative will probably be to write VBA code to open an external
text file and write your data out to it.
 
Back
Top