Page 3 of 3 FirstFirst 123
Results 31 to 34 of 34

Data entry/edit in a junction table

  1. #31
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,064
    MTM Schedule Events Cancellstion-davegri-v03.zip
    Ed, see attached.
    This version addresses concerns except for associate members.
    User can enter cancellations first.


    Only IsActive=Yes members are processed.
    Report exists for scheduled but not attending
    Report exists for Not cancelled, not attending
    Report exists for cancelled, but attending anyway

    I see no easy way to mix associate and regular members as their requirements are opposite. It would probably be better to have separate forms and reports for the associate members.

  2. #32
    GrandpaEd is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Location
    Ft. Worth, TX
    Posts
    17
    Quote Originally Posted by davegri View Post
    MTM Schedule Events Cancellstion-davegri-v03.zip
    Ed, see attached.
    This version addresses concerns except for associate members.
    User can enter cancellations first.
    Only IsActive=Yes members are processed.
    Report exists for scheduled but not attending
    Report exists for Not cancelled, not attending
    Report exists for cancelled, but attending anyway

    I see no easy way to mix associate and regular members as their requirements are opposite. It would probably be better to have separate forms and reports for the associate members.
    Thanks Dave! I've got a fair bit of work to do to understand how forms work generally, work that back to your example, then relate it to my data. It will take me some time and I'll come back here if I get stuck to seek further help.

    I agree on the associate members. I'm going to have to create separate tables and analogous logic for them. I'll work on the active members first.

    Thanks again for your help!

    Ed

  3. #33
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,270
    If associate and regular members have same attributes, I expect could be managed in one table. As far as value of Yes/No or Status field for new record, do that with code when record is created instead of depending on DefaultValue property.

    Have as many status codes as needed to describe situation. Or stick with the 2 fields if that is more comfortable.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #34
    GrandpaEd is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Location
    Ft. Worth, TX
    Posts
    17
    As far as value of Yes/No or Status field for new record, do that with code when record is created
    D'oh! Why didn't I think of that? Thanks!

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. data entry/edit form
    By Jen0dorf in forum Access
    Replies: 5
    Last Post: 06-06-2016, 08:56 AM
  2. How to edit entry in table from VBA ?
    By fluppe in forum Programming
    Replies: 5
    Last Post: 07-14-2014, 08:32 AM
  3. Replies: 4
    Last Post: 02-04-2014, 10:41 AM
  4. Data entry form with three junction tables?
    By justgeig in forum Forms
    Replies: 5
    Last Post: 08-13-2013, 04:23 PM
  5. Replies: 4
    Last Post: 03-20-2013, 01:03 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums