1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access help

Discussion in 'Business Applications' started by karlhaywood, Dec 22, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. karlhaywood

    karlhaywood Account Closed Thread Starter

    Joined:
    Jan 17, 2010
    Messages:
    680
    i need to create a database to check what tasks we have to complete and who they have been assigned to. Can somebody advise what is the best way to go.

    Thanks
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Karl, are the people involved in this project in one of your other databases?
     
  3. karlhaywood

    karlhaywood Account Closed Thread Starter

    Joined:
    Jan 17, 2010
    Messages:
    680
    No, im trying to help my brother with a project he is doing.
     
  4. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    A people table, a tasks table and a PeopleTasks table.
     
  5. karlhaywood

    karlhaywood Account Closed Thread Starter

    Joined:
    Jan 17, 2010
    Messages:
    680
    in the people tasks table do i need the ID's from the other two table? Where off to Wales tomorrow.
     
  6. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Yes you will need them.
    Your timing is good, it is thawing here.
     
  7. karlhaywood

    karlhaywood Account Closed Thread Starter

    Joined:
    Jan 17, 2010
    Messages:
    680
    whick table do i create the form from?
     
  8. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Mainform from People and Subform from PeopleTasks, use a combo to select the Tasks.
     
  9. karlhaywood

    karlhaywood Account Closed Thread Starter

    Joined:
    Jan 17, 2010
    Messages:
    680
    I was actually going to use a memo field for the tasks, because they will be different everytime. Everytime i try and use a subform i have an error, i must be doing it wrong!
     
  10. karlhaywood

    karlhaywood Account Closed Thread Starter

    Joined:
    Jan 17, 2010
    Messages:
    680
    I will do it your way OBP. Can you check my relationships please on the attached file?
     

    Attached Files:

  11. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    They look fine, will you need any dates in the PeoplesTasks or tasks tables?
    Do you create a form based on a query to use as the Subform?
     
  12. karlhaywood

    karlhaywood Account Closed Thread Starter

    Joined:
    Jan 17, 2010
    Messages:
    680
    I have added "expected completion date" to the peopletasks table. Shall i create a query based on that table and then a form based on the new query? I was worried that the relationships were wrong because i enforced "referential integrity" on each side, is that correct?
     
  13. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Yes that is correct. I would create the form as you have suggested.
     
  14. karlhaywood

    karlhaywood Account Closed Thread Starter

    Joined:
    Jan 17, 2010
    Messages:
    680
    OBP i have a problem, i have created a form based on the new query, but the PeopleID and TaskID are showing as text boxes with a number in, instead of combo boxes. Why is this? Take a look at the attached screenshot.
     

    Attached Files:

  15. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Are you using Lookup combos in the table?
    If so remove them.
    Did you create a peoples Form?
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/970033

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice