Mark Breen
marklbreen at gmail.com
Thu Jul 2 06:37:04 CDT 2009
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 >