Recent content by tif

Hi MajP, Sorry for the delay. This is perfect. Thank you!

Thanks MajP. That works in my continuous form! :D I embedded your code into my set form (rather than popup form) and it works great! The only thing that may be difficult with my user is that with this change when they click the edit button and then enter the details textbox which is...

Thanks Ridders and MaJP. I appreciate all of your help and efforts. It isn't that clicking on the specific box to see additional details is an issue. It is knowing which boxes require clicking on to see additional details without having to click in the box on every line. Unfortunately, I...

Hi Ridders, Thanks for your reply. If I understand correctly, you are saying that on load having all lines read with the details from the first record and only changing when you change focus would be the best case in a continuous form. If that is the case, then this solution actually doesn't...

Thanks Ridders. I made that change but now I am getting a variable not defined error. I can dim an rst varaiable as a recordset but I am not sure how to then define the variable so the lines return correctly. Attached is the full database (only data has been scrubbed) if it helps. Thanks...

Thanks Cronk. I've seen that method recommended many times but I want the user on a continuous form to be able to know which boxes have additional text (at a glance) and without requiring focus on the specific box.

Thanks Ridders. I made that change but I am still getting the same error. When they open the db, it opens to Dashboard form. From there they will click on Member List button, then the Member Log button for any of the Members. If I navigate in that method, when I click on Member Log button...

Thanks for your help Ridders. Sorry for the slow reply....your email was in my spam filter. I am trying to employ Ridders solution for a continous form with a label that goes visible/invisible based on the number of characters to show me that there is additional information in a long field...

I am trying to employ the exact same solution as ridder suggested for being able to see that a form field has more text without requiring focus. However, I keep getting an error. I have a continuous form called Members with a subform called MemberDetailsSubform which contains a Textbox...

Thank you JDraw. I have read the reference you linked. If I don't use a lookup, how do I point to the table and field (list) I want to choose from?

In my Access 2016 DB, I have 2 tables. Table Customers has an Account Number field. It is Primary Key, Long Integer, Increment, Format "CN1"000. When I enter customers into the table, this field is autogenerating CN1001, CN1002, etc. This is as desired. Table Customer Orders has a...

Thank you GinaWhipp for your reply. I will have to spend some time educating myself on Data Macros. Thank you for the link.

Hi. I have been trying to modify the Northwind2010Client Desktop database I got from the forum to allow $0.00 entries for list price and standard cost. In the previous posts for this thread, GinaWhipp instructed Larzee1 to remove the validation from the Products table in the field Design View...