Results 1 to 5 of 5
  1. #1
    mademen is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2011
    Posts
    10

    Talking Search employees backup database


    Hi All

    Attached i have a Database with 3 Tables.
    -Table MA's. is the just a table were you can select if an Analyst is at the office or not. so if the check box is selected the analyst is available.
    -Table Backups. We have Alias which is a reference code to a supplier the 1 Analyst and then Backup 1 and backup 2
    -Table suppliers are just de supplier details.

    what i whould need is when in the MA's table an Analyst is not selected a macro or query should search for backup 1 and replace it. when the backup 1 is not available as wel than backup 2 should be put in place.
    When no backups are availeble then a message can put in the cell like"No Backup Available'.

    This result can be put in a new table named. Decksplit with then the Supplier Alias, Supplier Name, Analyst

    could anybody help me with this?

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    when in the MA's table an Analyst is not selected a macro or query should search for backup 1 and replace it. when the backup 1 is not available as wel than backup 2 should be put in place.
    So . . . when I opened your MA's_tbl, none of the check boxes were checked.
    Then I look at the Backups_tbl . . . and . . .
    How do you pick a replacement from Backup1 . . . or Backup2?

    What is there in the Backups_tbl to tell me if the backups are 'available'?

  3. #3
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Also, if there are more than 1 person assoicated with a supplier (key person, and 2 backups), that is a one-to-many relationship which would warrant that the people be listed in 3 records in a related table. Something like this:

    tblEmployees (all of your employees listed here)
    -pkEmpID primary key, autonumber
    -txtFName
    -txtLName

    tblSuppliers
    -pkSupplierID primary key, autonumber
    -txtSupplierName

    This table is where you would define the key person and the backups
    tblSupplierKeyPeople
    -pkSupplierKeyPeopleID primary key, autonumber
    -fkSupplierID foreign key to tblSuppliers
    -fkEmpID foreign key to tblEmployees
    -longRank (this would just be a number field, 1= you key person, 2 would be the first backup and 3 would be the second backup)

    You will still have to address the questions Robeen posed.

  4. #4
    mademen is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2011
    Posts
    10
    Hi Robeen

    Thank you for the reply.
    Can a link be made that if a checkbox is unchecked that person gets lets say "eliminated" and it looks for that specific supplier a backup 1, if backup one is checked it takes that person into a table, when that person is unchecked as well it goes for backup 3. the final table should give than the available people divided between the suppliers.

    i'm a really nooby when it comes to this. if you guys would have another, better idea please just shoot. i think you guys understand the idea behind it and could help me with a easier solution?

  5. #5
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    In addition to the tables I proposed earlier, I think you need some sort of sign in/out table for your employees. That way you can use a query to check who is in on any given date/time and who is not.

    tblEmployeeAttendance
    -pkEmpAttendID primary key, autonumber
    -fkEmpID foreign key to tblEmployees
    -dteAttend (a date/time field)
    -another field to say In or Out

    If the most recent record for an employee in this table on a particular date is Out then you know they are not in the office, so you would exclude them from the list of employees available to help with the supplier.

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

Similar Threads

  1. Creating Backup of Tables/Database
    By ETCallHome in forum Access
    Replies: 2
    Last Post: 08-15-2011, 10:57 AM
  2. access database backup...
    By alex_raju in forum Access
    Replies: 5
    Last Post: 07-17-2011, 09:00 AM
  3. Replies: 2
    Last Post: 03-02-2011, 06:50 AM
  4. Database backup automation
    By aat in forum Access
    Replies: 2
    Last Post: 09-17-2010, 07:24 PM
  5. Making a backup copy of table or database
    By wasim_sono in forum Access
    Replies: 0
    Last Post: 03-09-2006, 05:44 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