• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Recent content by lwallis

  1. L

    Subform Only Showing Last Group Record

    JHB, Thank you so much for all your help. I'm not a programmer, just someone that had a tiny bit of DB knowledge from 15 years ago so I got elected! I would still be stuck on form creation without your help. Thank you again! Lynda
  2. L

    Subform Only Showing Last Group Record

    Here is a scaled back version of my DB
  3. L

    Hi JHB, I'm sorry I'm singling you out but you seem to be the reliable source that has always...

    Hi JHB, I'm sorry I'm singling you out but you seem to be the reliable source that has always given me a correct solution.. I'm on the home stretch of this project and I hope this is my last issue. Would you mind looking in the Reports Forum at a post I made titled: "Subform Only Showing...
  4. L

    Subform Only Showing Last Group Record

    I have one query that the main form is based on and another query the subform is based on. I linked the subform to the main form by a common field "Branch" My main form displays Grouped Employee overhead totals based on Branch Example: Branch 1 Employee overhead cost...........15,000.00...
  5. L

    Report field question

    Here it is! Thank you once again!!
  6. L

    Report field question

    I will post it as soon as I can... Thank you JHB you have saved me on this project before!
  7. L

    Report field question

    Maybe I'm going about this the wrong way.... I have created a query that incremintally adds the percent utilized for each employee. so the last line in the query for each employee has the total percent. Can I update a field in the employee table called "utilized" based on the last line for...
  8. L

    Report field question

    Is this even possible?
  9. L

    Syntax Error ( missing operator)

    Where would I insert the code to see the finished SQL? I apologize for this code. I have looked a videos and examples on the internet so it's a mix of things I have figured out over the last month. The is my one and only attempt at creating a database. Thanks for any help... Private Sub...
  10. L

    Report field question

    Add textbox to show Max subtotal??? See PDF example... How can I get Employee Billy Johnson to show on one line with a total of 1.25? (0.5 + 0.75 = 1.25) I need to merge the two lines and only show something like this: Division Manager Billy Johnson $44,174.60 1.25 I don't know if this...
  11. L

    Syntax Error ( missing operator)

    I uploaded it again, hopefully this works... I don't think I mentioned it but the problem occurs when I try to edit a record. Thank you Lynda
  12. L

    Syntax Error ( missing operator)

    Can anyone figure out why I am getting this error? I have attached a piece of my DB to this post. I compared it to other like forms but I am not experienced enough to figure this out.. Thank you for your help Lynda
  13. L

    Extra Space Between Detail and Subform(in footer)

    Thank you!!!! Once again you solved my issue!
  14. L

    Extra Space Between Detail and Subform(in footer)

    Here is a scaled back version of the db.. thank you for your help! L:)
  15. L

    Extra Space Between Detail and Subform(in footer)

    The first report example is what I get when I start on the main form and select an organization, run the report, opens report - BIG SPACE between the details and my footer section which holds a subform. The second report is what I need it to look like, what's strange to me is I get the report...
Top Bottom