Results 1 to 5 of 5
  1. #1
    ClawGee is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2012
    Posts
    8

    Active Records Vs Inactive Records

    Hi,



    I am creating a database with our client's records. I initally imported the data using two different tables "ActiveClients" and "Inactive Clients" I have created a form to add clients to the Database however, I am wondering if I have added the "Active" and Inactive" fields which contain dates, will Access move the one client from the Active table to the Inactive table?
    Should I just have a single client table containing active clients and inactive clients? If so, how do I keep the inactive clients hidden when i "flip through" the Form pages?

    I'm very new to Access and desperately trying to get this to work for my boss.

    Thank you

  2. #2
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I would have one table, "Clients", with an additional field "Active" and/or a date field when they went inactive.
    The query for the would select only the "active' records.

  3. #3
    ClawGee is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2012
    Posts
    8
    Quote Originally Posted by ssanfu View Post
    I would have one table, "Clients", with an additional field "Active" and/or a date field when they went inactive.
    The query for the would select only the "active' records.
    Thank you so much! So I did do this with a test file but I cannot get my form to display the Activation and Deactivation dates. I tried using a combo box and instead it provides me with a drop down menu of all activation dates. How do I tie the activation date to the client ID, so it only shows the clients' activation date?

    Do I need to create a separate table with the Clients ID (Primary Key) and their activation and deactivation dates?

  4. #4
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    What is the form record source?

  5. #5
    JeroenMioch's Avatar
    JeroenMioch is offline Competent Performer
    Windows Vista Access 2003
    Join Date
    May 2012
    Location
    Den Haag, Netherlands
    Posts
    368
    You can do this Ssanfu mentions, And use a filter on Active or deactive records.

    I have a db that has seperate tables. In my case this is for storing deleted records.
    It works like this :

    I have two radio buttons, One is for the active table and one is for the history database
    When one clicks the history radio button it fires this code :

    Me.Form.RecordSource = "YourTableHere"

    So a user wanting to browse the history of deleted records then he clicks the radio button.
    When he wants to return he clicks the other one (referring to the active table)

    If you want help with either ways to go, just give a shout.

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

Similar Threads

  1. Tabs for Active Records on a Form
    By drewsmama in forum Programming
    Replies: 3
    Last Post: 07-30-2011, 02:17 PM
  2. Query to seperate active/inactive clients
    By csnyder1582 in forum Queries
    Replies: 5
    Last Post: 05-05-2011, 12:01 PM
  3. Inactive or active
    By Bruzer in forum Access
    Replies: 4
    Last Post: 04-08-2010, 04:20 PM
  4. Active/Inactive Option
    By mikel in forum Database Design
    Replies: 6
    Last Post: 10-09-2009, 07:47 AM
  5. Replies: 1
    Last Post: 12-06-2006, 05:32 PM

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