Mark Breen
marklbreen at gmail.com
Thu Jul 2 07:01:00 CDT 2009
Hiya John, If I select the row selector and then do a copy (Edit and Copy, or CTRL + C, or right click and copy), Access actually put the headers and the row in question onto the clipboard. then when you paste into Excel, you convienently get the headers, which is great when you want them, but not when you do not want them. Any other throughts? Aren't you up early ? Mark 2009/7/2 jwcolby <jwcolby at colbyconsulting.com> > 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 > >> > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >