Copy Data without the header (1 Viewer)

[Gismo]

Hi All,

I have the below code to copy data from a query

The data copied I would like to exclude the header of the query

Id this possible in any way?

DoCmd.SetWarnings False
DoCmd.RunMacro "Run Files - IW73"
DoCmd.OpenQuery "Orders List", acViewNormal, acEdit
DoCmd.SelectObject acQuery, "Orders List"

DoCmd.RunCommand acCmdSelectAllRecords

RunCommand acCmdCopy
DoCmd.Close acQuery, "Orders List", acSaveNo
MsgBox "Data copied to Clipboard"
DoCmd.SetWarnings True

 

[June7]

I would have to say no. What do you want to do with data?

 

[Pat Hartman]

If you want to send the data from the query someplace, there is no need to go via the clipboard. You probably want to use TransferText or TransferSpreadsheet. Both are well documented.

 

[Isaac]

As Pat said, don't use that Menu command approach ... use a method 'made' for your situation, like Transfer_

 

[Gismo]

I would have to say no. What do you want to do with data?

Hi,

I copy the order number then past into SAP to run stock queries

I also have a similar process where I copy all the orders for Access and past into SAP order generation

I only want to copy to clipboard

 

[Pat Hartman]

Copying a single field and pasting it is no problem. However, you are copying a recordset. I'm not even sure this would work if you could get rid of the header which you can't.

Try pasting into Excel and then copying from Excel where you can avoid copying the header.