• ** 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/

Search results

  1. L

    Vertical Scroll bar disappears when in "modal" view

    Wow, so sorry. So many things in my head, not sure how I missed that. I did try that before, must have done something wrong. My bad. Thanks for all your help.
  2. L

    Vertical Scroll bar disappears when in "modal" view

    I do appreciate all the feedback on this topic. I found a simple fix. I set the resize value on the form to "No". When the form popped up, I resized it to the dimensions I needed and when I closed it and reopened it, the form kept the size. Yeah!
  3. L

    Vertical Scroll bar disappears when in "modal" view

    I tried the code and it didn't work. I did repeat for all the other subforms. The height of the detailed section will not change. The subforms need to be this height or all the actions won't appear. I somehow need to shrink the detailed section while keeping the subforms in the detailed...
  4. L

    Vertical Scroll bar disappears when in "modal" view

    Thanks for all the input. I found that the subforms were not big enough to show all the records, hence the scroll bars weren't showing. The scroll bars appear now, but my problem now is that the form is not big enough to show all the data and the footer. Is there a way I can make the Detail...
  5. L

    Vertical Scroll bar disappears when in "modal" view

    It's not off to the side at all, the form centers when opened. I tried reducing the form width and still no scroll bar. I did change the resolution and the scroll bar appeared. How can I fix that problem? I am sure that many screens will be at this resolution (1920 X 1080).
  6. L

    Vertical Scroll bar disappears when in "modal" view

    Hello, you might remember me when you see the program. I posted this a while back and didn't hear back from you, so I sent it again in a direct reply. I am redesigning this application the way it should have been done in the first place. I have a friend that is helping me through this, but...
  7. L

    Vertical Scroll bar disappears when in "modal" view

    Hello, you might remember me when you see the program. I am redesigning this application the way it should have been done in the first place. I have a friend that is helping me through this, but even he is stuck on this. When you open the database, it will open to the “Main Menu” and from...
  8. L

    Vertical Scroll bar disappears when in "modal" view

    Hi, I have a form that has several subforms on it and when I open it in a modal view, the vertical scroll bar disappears. It is there if I take it out of modal, but I really want to be able to use the modal feature. I hoping to have the program act as an app that the user doesn't see any of the...
  9. L

    Trouble displaying date with no year.

    I thought so too, but it still put the year on. This solution is working well. Thanks for the help.
  10. L

    Trouble displaying date with no year.

    I figured it out. =Format(DateAdd("d",7,[TempVars]![TmpStartDate]),"(mm/dd)")
  11. L

    Trouble displaying date with no year.

    I'm getting an #Type! in the text box instead of the date. I tried the (mm/dd) and took of the parenthesis in the control source and it is ignoring the format. It's putting it with the year.
  12. L

    Trouble displaying date with no year.

    I am positive. I am using the Start Date on the form I'm working with and it shows up in that field.
  13. L

    Trouble displaying date with no year.

    Hello, I am having trouble getting a date formatted correctly. I just want the mm/dd to show in parenthesis. ie: (3/9) It was working when I created the text boxes, but when I went to display the forms it didn't work. In the control source, I am using a temp variable "TmpStartDate" and...
  14. L

    How to select certain records in a query to print

    MajP, You Are The Man! This solution works great, it took me a little time to get it all straight and looking professional, but I got it. Thanks to you.
  15. L

    How to select certain records in a query to print

    My apologies MajP, it does work for the one action that is showing. My hopes were to pull up the list of actions and select which ones I would like to print. I would think that there will be times when more than one, but not all, will need to be printed. Just trying to accommodate all...
  16. L

    How to select certain records in a query to print

    I do realize that this database has a lot of issues, but believe it or not, it does work well. There are many reasons why things are the way they are and when the next version of this comes out, all of these issues will be addressed. The needs of this project were not given all at once, but...
  17. L

    How to select certain records in a query to print

    I have a cut down version of my database that focuses on only the problem at hand. Still too big to attach, but I have a google drive link to download the database. https://drive.google.com/file/d/1a_HL1137PP5ChK_A4izQNOWPy_4UCemK/view?usp=sharing If you open the AchmntProgress form and...
  18. L

    Creating a chart in Access form

    I just tried adding the field to the two tables but seeing that it has run through two other queries the field is not updateable. If I can add a boolean field to just the ActionQuery, I think i can get this to work.
  19. L

    Creating a chart in Access form

    The ActionsQuery is actually the result of two other queries. Instead of adding a field to the two tables that were used to create those queries, I need to add a boolean field to the ActionsQuery. Not sure how to define it in the query. Can you help with that? I was also thinking that the...
  20. L

    Creating a chart in Access form

    I was thinking about trying to add a checkbox field to the ActionsQuery. That way I can use a form to check which actions I want and then use the criteria to sort which records I want to print. I just don't know how to add a column to a query.
Top Bottom