Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2008
    Posts
    1

    Copying a single record from one table to another

    Hi, I'm desperately in need of some help here.



    I'm trying to retrieve a single record from a customer db to copy into a new service call record. From my log call form, I've created a button to open a customer table. From there I've created a button to update and close that form. I'm running an update query to try and do this. Not sure if that's the correct way to do it. Am I at least on the right track?

  2. #2
    Join Date
    Mar 2011
    Posts
    6
    Bump... I have the same issue

  3. #3
    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
    What are the tables in your database?
    I don't think you're trying to copy a customer record to a service table.
    Perhaps you are trying to add a Service record for a specific Customer -- is that correct?

  4. #4
    Join Date
    Mar 2011
    Posts
    6
    I have a table called All Leads
    I also have another table called qualified which is exactly the same but with 0 records in

    I have a form that lets me go through the records of All Leads.
    I also have a form that lets me go through all of the records from Qualified table

    When i get to a specific record I want to be able to press a button or check an option button that will move that record displayed (and only that 1 record) on the form to the Qualified table.

    Essentially i have a list of 15000 records that i need to filter between 4 catagories. I want to be able to scroll through each of these catagories on a seperate form...

    Help!

  5. #5
    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
    How do you determine which Category should be attached?
    If you have 15000 records, do you have any logic/process to do this assignment automatically?

    Have you considered as set up as per the attached?
    3 tables with relationships.

    The junction table PersCategory in this case would hold the identifiers from AllLeads and Category.

  6. #6
    Join Date
    Mar 2011
    Posts
    6
    I realise that the need for multiple tables is wrong.

    I have now set up a "catagory" field and have a dropdown box with 6 different headings. Leads, Hold, Qualified, Meeting, Account & Delete. The defualt value is Lead

    How can I set up different forms so that i can view each catagory independently?

    So far all i have managed to do is use a filter to view only, for example Hold.

    Ideally i want to be able from the switchboard go to different forms for each 6......

    How can i set a for to only display certain records... e.g. on Hold form, only to view records marked as hold?

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

Similar Threads

  1. Searching for a single word in all table
    By rielcas in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:28 AM
  2. Table related to multiple tables by single ID
    By MrTumnus in forum Access
    Replies: 1
    Last Post: 11-17-2009, 02:05 PM
  3. Checking a record in a table
    By widstje in forum Programming
    Replies: 4
    Last Post: 11-07-2007, 11:28 AM
  4. Adding a single record
    By kfoyil in forum Forms
    Replies: 2
    Last Post: 11-22-2006, 09:12 PM
  5. copying data from subform to mainform
    By wasim_sono in forum Forms
    Replies: 0
    Last Post: 03-10-2006, 04:35 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