Search results

  1. A

    Auto pop textbox on 2nd form with same value as 1st form

    OUCH ! ! ! ...thank you for tip ..I just backed it up and ran the compact and repair utility
  2. A

    Auto pop textbox on 2nd form with same value as 1st form

    :) ...Done and done
  3. A

    Auto pop textbox on 2nd form with same value as 1st form

    Done ! :) Here it is ..please advise if this is what you meant ...
  4. A

    Auto pop textbox on 2nd form with same value as 1st form

    As requested .... here it is Also, in regards to the "referential integrity" i did enforce it ... and as for the other 2 options are concerned ...i don't think I require them.
  5. A

    Auto pop textbox on 2nd form with same value as 1st form

    thats what i started to think after i wrote that .... I will go ahead and ceate the relationships ... and will leave the "manager reporting" out of it for now... sound a upload the revised db once I'm done?
  6. A

    Auto pop textbox on 2nd form with same value as 1st form

    I forgot to mention ..that the managers will report that they have completed their weekly reviews with thier employees....
  7. A

    Auto pop textbox on 2nd form with same value as 1st form

    Managers = yes, why ...to update/add new employee tasks Directors = No, the directors will use this to view reports and activies ....
  8. A

    Auto pop textbox on 2nd form with same value as 1st form

    Right ...also .... I meant that the Hours tbl will populate the drop down boxes for Plannedhrs and Actualhrs fields .....
  9. A

    Auto pop textbox on 2nd form with same value as 1st form

    Hello, sorry for the delay ... No, the Hours table will not contain any records per employee.... the hours table is only used to populate the Plannedhrs and Actualhrs fields .... Arv
  10. A

    Auto pop textbox on 2nd form with same value as 1st form

    Aighty ..... Here it is :)
  11. A

    Auto pop textbox on 2nd form with same value as 1st form

    Wow ... okay ... I have removed the "Users" Table I have created the "Users" Table field in the "Employees" Table I have changed all fks to "number" I do to but that is the only way I could think of setting it up .... I think it looks good ...and I noticed the change in the...
  12. A

    Auto pop textbox on 2nd form with same value as 1st form

    Ahhh shit! ...sorry ... I guess the DLookup funtion would do that .....
  13. A

    Auto pop textbox on 2nd form with same value as 1st form

    Ahhhhh ...i see ..... So... if I understand this ..then the Roles table would replace the use of having password to access the application? but ... I would I prevent User1 (employee level) from accessing User2s (employee level) information ....
  14. A

    Auto pop textbox on 2nd form with same value as 1st form

    Well .... that was my understanding of what vbaInet had mentioned .... I'm sorry :confused:... I can change it though ... no biggie for me :) Pls advise and thank you
  15. A

    Auto pop textbox on 2nd form with same value as 1st form

    Okay .... This is what I have done so far .... does this table layout/design seem better?... Side note .... doing this exercise has already helped me more in understanding "normalization" Thank you in advance Arv
  16. A

    Auto pop textbox on 2nd form with same value as 1st form

    Good morning ...... I've starting to work on this already this morning :) ..... and I will add that...also .... I'm guessing that I would add the "Password" field to the "Users" table? .....
  17. A

    Form

    This kinda sounds similar to what the ol'famous Northwinds sample db has ....
  18. A

    Auto pop textbox on 2nd form with same value as 1st form

    LMAO!!!! :) You guys are funny! :) K ...first ...I am a male...and no hard feelings at all .... overall, my knowledge of access is limited ... I've been using access for 2 yrs and I have created simple apps ....and I will admit ..I go off track and start add pic's and changing fonts before I...
  19. A

    Auto pop textbox on 2nd form with same value as 1st form

    sounds like a plan ... I will start on that now ...
  20. A

    Auto pop textbox on 2nd form with same value as 1st form

    hmmm......I would like to keep them as is please .... I guess i will have to create a Password field in the Director table and Mgr table also in order to give them access to the app ...
Back
Top Bottom