Darryl Collins
darryl at whittleconsulting.com.au
Wed Aug 29 21:46:14 CDT 2012
My understanding is using that method you will always get the headers. There are ways of doing it sans headers, but copy and paste like that isn't one of them AFAIK. Cheers Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Thursday, 30 August 2012 11:59 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Copy and paste records with no column names Forgive a dumb question, but why would you want to paste a whole table of records without anything to tell you which column is which? Charlotte On Wed, Aug 29, 2012 at 11:58 AM, Gustav Brock <gustav at cactus.dk> wrote: > Hi all > > I can run these commands: > > DoCmd.RunCommand acCmdSelectAllRecords > DoCmd.RunCommand acCmdCopy > > to select and copy all records from, say, an open query. > Then I can open a spreadsheet in Lotus Notes and paste in the records. > > However, the first row is the column names ... > How can I prevent these from being pasted? > > /gustav > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com