Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Boston, Massachusetts, USA
    Thanked 0 Times in 0 Posts

    Am I asking for too much? See attachment (Access 97)

    Okay, there are several things I want to do and I am pretty sure it can be done. I just need the gurus to confirm it. This is the project I have been working on (and had several posts about) to allow multiusers access to only their updates. The users need to document their productive hours during the day. For the times they are working on other projects or leave early for personal time, not only do they have to adjust their "hours worked," but also need to fill out an additional form detailing why they were not "available" during that time and what they were doing.

    I want the user, when they open the form to only have access to their updates. Wendell and Charlotte, thanks for your help on this one through a previous post. I am still working on it.

    As soon as the user puts a number in one of the "less" boxes, I want the appropriate subform to open. Again, showing only their records and tying the record to the one in the main form. If they are separate, I won't know, other than by date (if they fill it out right) that the 2 records reference each other.

    Am I making this too complicated? Am I asking for too much? Am I looking for Santa Claus and the Tooth Fairy?

    Thanks so much!
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts

    Re: Am I asking for too much? See attachment (Access 97)

    I think you should be able to make it work correctly. Essentially what you need to do is to set the data source for the subform on the fly - you may want to do that by doing a late binding on the link to the subform. We use that approach on some applications where we want to different form to appear based on some choices on a main form. I guess I'm making an assumption that the special projects records are in a separate table, or are at least can be uniquely identified. Hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts