jwcolby
jwcolby at colbyconsulting.com
Thu Jul 2 07:19:45 CDT 2009
Son of a gun, so it does. I was operating on faulty memory apparently (more and more these days). > Any other thoughts? None that are immediately useful. If you must go through the clipboard there are functions to retrieve the clipboard and place things in the clipboard. You could pull it out into a text string, search for the first CRLF and delete that first line, then place it back in the clipboard. Kind of clunky. Or in a button click you could programmatically find the record(s) selected directly in the form, and copy that to the paste buffer. Or you could directly copy the data from Access to Excel using automation. I could make any of those solutions work but I don't have existing code that just does that. > Aren't you up early ? It is 0800 east coast time. John W. Colby www.ColbyConsulting.com Mark Breen 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 >>