Results 1 to 15 of 15
  1. #1
    julioot is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    11

    Copying fields includes column name

    Like the title sais,



    If you copy a field from a table or query without highlighting the information. It automatically copy's the column name aswell.

    This has proven to be very annoying for some of my co workers. So I was wondering if there is a way for access to stop copying the column name aswell.

    So, Is there a way for us to copy field information, just by selecting the field it self. Without copying the column name?


    thnx for ur time
    Julian

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Please show us the code/technique you are currently using so we understand exactly what the problem is.

  3. #3
    julioot is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    11
    Hi organe,

    It dont think it is a matter of code or technique.

    Im simply trying to copy a field out of my table into a word document. I'll select a field in my table and I copy it by pressing crtl-c. If I paste this information in my word document. It shows the content of the field AND the name of the column.

    It is possible to copy just the content of the field without the name of the column by highlighting/selecting the text in the field. But I want to be able to simply select the field and without having to copy my column name aswell. Exactually like you would copy fields from excel.

    This website describes my problem, yets gives no solution. http://support.microsoft.com/kb/168219

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Did you try this based on the link you gave

    If you want to use your keyboard to select all the data in a cell without selecting the column name, click anywhere inside the cell and press F2.

  5. #5
    julioot is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    11
    Yeah I did. But working like this, does not fit the purpose

    We really need to be able to select the field and directly copy the data containing the field. Without any steps inbetween.

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    So you want an automated solution? I haven't done anything with Access and Word for 5 years and even then it was minimal.
    What exactly are you doing -- in plain English?

    Are you putting Access values into a Word document that has been set up to receive these data?
    I'm sure others have more experience and will offer suggestions, if they can understand what you are trying to do. There may be more options than copy/paste.

  7. #7
    julioot is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    11
    No I do not want a automated solution

    I'm not putting values into a word document that has been set up to receive data.

    I'm simply copying the value's from my database. And paste them over a range of documents.
    Having to select the actual data, rather than just the cell that contains the data is a time consuming proces.

  8. #8
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    If you put the cursor in the cell and hit F2 does it not copy just the data? And can't you paste (and repeatedly paste) that data?
    I must be missing a piece of what you are saying.

  9. #9
    julioot is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    11
    No it simply selects the data.

  10. #10
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Yes, I agree I just tested using Access 2003.
    If I put the cursor in the cell and press F2 it only selects the data.
    If I
    -put the cursor in the cell and
    -drag my Mousepointer thru the cell to highlight the data,
    -right click will save to buffer
    -then move to Word and do cntrl V or RightClick Paste to paste
    seems that the answer.

    How is your Word set up to receive the data?

  11. #11
    julioot is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    11
    yeah... Ive been trying to explain the last 5 posts that I know that works, but I dont want to have to drag my mousepointer thru the cell to highlight the data.
    I just want to be able to slect the cell, copy it. And past it without copying the columns name aswell.

  12. #12
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    You are trying to do something that Access cannot do. Just clicking on a cell or table field moves the cursor to that location, yes, but it does not select any text. Maybe you are thinking of MS Excel? It does behave that way.

    What you can do is to set MS Access to select the entire field when you enter it with tab or the arrow keys (in A2003 it is in Tools - Options; I don't know about A2007). But entering with a mouse-click does not do that. Using Copy-Paste when a field is selected this way does not include the field name.

    That should make life a bit easier for you, rather than having to mouse drag all the time.

  13. #13
    julioot is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    11
    Thnx John_G,

    I sort of allready knew access wasnt able to behave in that "excel-like" way. I was just hoping one of you knew a trick to enable the excel way.

    Anyhow, thanx for taking your time to explain. The way you are suggesting to use it still isnt ideal. But it does make life a bit easier

  14. #14
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Instead of dragging to highlight the data, have you tried double clicking on the data to highlight it? Then ctrl-C to copy it....???

    Unless it is more that one word.....

  15. #15
    julioot is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    11
    lol yeah it's more than one word

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 11-04-2011, 06:52 AM
  2. Copying and Rename of Files based on fields
    By desk4tbc in forum Programming
    Replies: 2
    Last Post: 06-28-2011, 11:00 AM
  3. Replies: 0
    Last Post: 01-22-2011, 08:08 AM
  4. Copying selected fields to a new record
    By Lyle Bitikofer in forum Forms
    Replies: 0
    Last Post: 12-13-2009, 04:01 PM
  5. Copying into empty fields until...
    By cochi30 in forum Programming
    Replies: 8
    Last Post: 06-07-2009, 07:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums