Copy Data without the header

[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?

 

[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