Recent content by AccessAllAreas

  1. A

    How do I create a report to output to a specific layout for records going back a number of years?

    Hello Everyone I hope you are as well as possible during these turbulent times. I was wondering whether anyone may be able to help me with this issue. Here is the requirement again: Goal: To be able to report for each "publisher" their monthly "activity", with calculated fields in the...
  2. A

    Using a check box on a bound form to control the NotinList combo box event to take 2 controls from form, inserting into 2 fields in another table

    Just to letmall know, I ended up removing the cancel event from the Select Case statement, with a message box being vbOKOnly! Then, if anyone doesn't want to follow through with selecting that person to be a Group Overseer, then they can simply click the box again, which will remove the name...
  3. A

    Using a check box on a bound form to control the NotinList combo box event to take 2 controls from form, inserting into 2 fields in another table

    Many thanks for that explanation. I will work on this over the next week with the various solutions offered and see what works with the least loss in functionality or adding too much complexity to the end user.
  4. A

    Using a check box on a bound form to control the NotinList combo box event to take 2 controls from form, inserting into 2 fields in another table

    Wow! That looks, umm, interesting. So, I am guessing that I need to recreate a separate table with just the GOs listed in it and reference that as my table in the sSQL statement and the Set rs = statement? Hope I understand that correctly. On the previous (currently implemented) solution...
  5. A

    Using a check box on a bound form to control the NotinList combo box event to take 2 controls from form, inserting into 2 fields in another table

    Many thanks for your thoughts, Minty. Thank you for teaching me about record level validation. That will be useful for ongoing planning. I agree with you this is slightly unusual requirement. This is one reason why I decided to create a separate table called Tab_Group_Overseers to house all...
  6. A

    How do I create a report to output to a specific layout for records going back a number of years?

    Hi Arnel Just wondered whether you are able to educate me in what you did to implement this solution. it looks very complex and I wish to know how to port those changes into my full DB. Many thanks again.
  7. A

    Using a check box on a bound form to control the NotinList combo box event to take 2 controls from form, inserting into 2 fields in another table

    Hi All Just wondering if anyone has a thought on what I am doing wrong. To re-cap, the outstanding issue is described in this paragraph: So, I have implemented that clarification you outlined. Unfortunately, the cancel (pressing No) event does not stop the update of the combo box entries...
  8. A

    Solved Avoid Duplicated Records by dates - but by a range, not exact date match

    Hello Bob, Darnel, Gasman and Pat Hartman Many thanks for the solutions. I put together a couple of the solutions and found one that I believe works pretty well for me! Only thing left to do is get rid of the automated error message box "The value violates the validation rule for the field or...
  9. A

    Solved Avoid Duplicated Records by dates - but by a range, not exact date match

    Wow! Four suggestions so quickly! Thank you all. I will try to implement these options and see what works! I will get back to you! Once again, thank you.
  10. A

    Solved Avoid Duplicated Records by dates - but by a range, not exact date match

    Hello Access Experts I hope you are well during these strange times! I have a pop-up form for entering data. This data includes a "date" component and a type of "event" component. Almost every week, there will be two "events". There will be one "event" held midweek, there will be another...
  11. A

    How do I create a report to output to a specific layout for records going back a number of years?

    Sorry for my lack of clarity. If a publisher has been with the organisation for a while, they will have built up legacy records, going back, potentially, years. One each publisher's report, their name should appear once on the top of the page. The grid that we kindly now have should appear...
  12. A

    How do I create a report to output to a specific layout for records going back a number of years?

    Wow! You did a lot of backend work here. Thank you! I have no idea what functions most of the changes have, but, ultimately, it has got me much closer! I have adjusted the report to group on ServiceYear (like a financial year), rather than the calendar year field (y). That now shows all...
  13. A

    Using a check box on a bound form to control the NotinList combo box event to take 2 controls from form, inserting into 2 fields in another table

    Hi Minty Many thanks for your further input. I totally understand the idea of cutting down on the typing and using shortcuts instead. Years of configuring Cisco IOS devices caused me to take a similar approach. But I knew all the necessary shortcuts then and could figure out suggested code...
  14. A

    Using a check box on a bound form to control the NotinList combo box event to take 2 controls from form, inserting into 2 fields in another table

    Sorry.Spoke too soon. The addition and removal of the new entries to the combo box works fine. However, when I wish to cancel the update (controlled by a message box with a vbYesNo, then it doesn't cancel the operation requested. it either still adds or still removes the entry from the combo...
  15. A

    Using a check box on a bound form to control the NotinList combo box event to take 2 controls from form, inserting into 2 fields in another table

    That worked! I didn't really understand the first line fully (as everything I read about IF statements says following a Then would be another action (which I recognise in the second line fine). But hey, it works, so I'm not complaining. Only one thing missing to complete this - how on earth...
See more
Top Bottom