Results 1 to 2 of 2
  1. #1
    Tenmakk is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    35

    Using a button, transfer only the current record on the form to Excel w/o a primary key?

    Hello, I currently have a database consisting of backup data. The form goes through that data, and I would like to transfer only the current record into Excel. Right now it transfers the whole table. I don't have a primary key, is there a way for me to do this?

    Thanks.

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Build a query using the current record as your parameter criteria. Export the query.

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

Similar Threads

  1. Copy value of primary key on current record
    By PPCEngineering in forum Programming
    Replies: 6
    Last Post: 07-20-2014, 04:31 AM
  2. Replies: 6
    Last Post: 05-18-2013, 12:48 AM
  3. Replies: 16
    Last Post: 02-06-2013, 03:06 PM
  4. Replies: 5
    Last Post: 08-24-2012, 10:32 AM
  5. Set Current Record based on Primary Key Input
    By andersonEE in forum Forms
    Replies: 2
    Last Post: 06-24-2011, 08:23 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