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

jwcolby jwcolby at colbyconsulting.com
Thu Jul 2 06:54:12 CDT 2009


Mark,

Have you tried simply selecting the row using the row selector on the left, copying to the paste 
buffer, and then pasting that to Excel.  AFAIK that works.

John W. Colby
www.ColbyConsulting.com


Mark Breen wrote:
> Hello All,
> I wonder do you know of a convienent way to catch the contents of a row in
> an Access Grid, and put that data on the clipboard, without the headers.
> 
> IOW, my user wanted to copy and paste the data from the grid to an Excel
> sheet, but she does not want to include the row headers in her sheet.  I
> would prefer to avoid the two step approach of a) paste to a blank Excel
> Sheet, and b) copy again from within Excel.
> 
> To summarise, I want the user to be able to copy a row from Access 2003, and
> the data that is placed on the clipboard should contain just the 15 columns
> of data, with no header information.
> 
> I can imagine two possible solutions
> Solution A
> A neat class that someone has already written that uses VBA to catch the
> columns and programatically places the data on the clipboard, seperating
> each values with tabs:  this should be a good solution I suppose
> 
> Solution B
> Someone knows a secret trick, something like CTRL + 'SOMEKEY' + C, and this
> trick only places the values and ignores the headers.
> 
> Thanks in advance for you assistance,
> 
> 
> As it is my wedding anniversary on Saturday, can I wish you all a great day
> if you celebrate it also for independance.
> 
> Mark Breen
> 
> 
> 
> 2009/7/2 Dale Kalsow <dkalsow at yahoo.com>
> 
>> Good Morning,
>>
>> Does anyone have a database with a nice splash screen and/or menu system in
>> access 2007 that they are willing to share.  Several years ago I did a lot
>> of programming in the previous version of Access and when on to other
>> projects.  Now I changed jobs and am again being asked to write Access
>> applications.  It looks like M$ is encouraging a new look in 2007.  I could
>> create them myself but I thought if someone was willing to share there was
>> no reason to recreate it.
>>
>> Thanks!
>>
>> Dale
>>
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>



More information about the AccessD mailing list