Max Wanadoo
max.wanadoo at gmail.com
Thu Jul 2 07:20:29 CDT 2009
Hi Mark, In excel if you create a Macro you can then use that. I have just tried it and it works fine. In Excel, click on Tools/Macro/Record New Macro. Give it a name and then invoke it with something easy like Ctl-Z. Then when it start recording, click on Edit/Delete then click on Stop Recording. Now when the person inserts the grid data with Ctl-V, tell her to click on the row with the header information and press Ctl-z and it is gone. max On Thu, Jul 2, 2009 at 1:01 PM, Mark Breen <marklbreen at gmail.com> wrote: > 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 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >