Copy without field names?

[Guest]

is there any way to copy the results of an access query without including
field names? i am trying to copy and then paste in another program but one
of my fields is a date field, so i cannot paste because the name of the field
is not a date. anybody have any ideas on how to get around this?

 

[Guest]

You did not say what the other program was that you were using.

If you are pasting into Word then copy the fields (not the records) and
Paste Special - Unformated Text.

If it is Excel then copy the fields (not the records) and Paste Special - Text

 

[Guest]

It's not an MS office program.
it is an obscure little program for printing CPR certification cards.
i cannot paste special in this program

 

[Guest]

You could create a form with textbox where you concatenate the fields with
spacing between them as required. It will take a little more if you are
pasting more than one record at a time.

 

[Guest]

i am pasting more than one record at a time

You could create a form with textbox where you concatenate the fields with
spacing between them as required. It will take a little more if you are
pasting more than one record at a time.

 

[Guest]

Do not click in the lefthand gray area of the record row.
Move your cursor to the left corner of the first field until the cursor
changes to an open cross and then drag to highlight the rest of the fields
and number of records you want.
This copies individual fields (cells in Excell).

If you were pasting into Access you have to highlight the cells that you are
pasting into.

 

[Guest]

when i do this it still copies field names too.
also i am looking for a way to do this whole copy-and-paste operation in one
step, with a command button.
i guess i will just give up, have it paste into excel instead of directly
into the program i'm using, and people will have to manually select and copy
the cells (not including field names) to paste into the third program
I just wish there was a simpler way