[AccessD] How to copy from Access Grid form, without getting the column headers

Excel would still paste the values including the header in this case.  "Values Only" means don't paste any formulae or formatting, just the values that the formulae return sans formatting...

cheers
Darryl

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, 2 July 2009 11:11 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to copy from Access Grid form, without getting the column headers

I don't know if it'll work or not, but have you tried using Excel's Paste 
Special -- I know there's a Values option, but in this case, Excel would 
probably consider the header information values, but can't hurt to try.

Susan H.


> Solution B
> Someone knows a secret trick, something like CTRL + 'SOMEKEY' + C, and 
> this
> trick only places the values and ignores the headers.
>

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.