Recent content by June7

Don't need to programmatically open the Access Options dialog to accomplish the actions you describe.

Yes, I always forget that one. And still need link on tank number as well. However, INNER JOIN will result in dropping last record. I tested LEFT and RIGHT joins with non-standard join and nested subquery - all fail. So if don't care about last record, either is option. Caution: don't try to...

Cross-post https://forum.allaboutcircuits.com/threads/what-is-a-weak-reference-and-where-am-i-using-it.200578/ Review https://www.geeksforgeeks.org/weak-references-in-python/

Correlated subqueries can perform slowly with large dataset. Alternative that might be faster would be to build a query that calculates a date field that subtracts 1 from InventoryDate. Then join that query to table with compound linking on date and tank number. Otherwise, might have to...

An alternative query would require there be a record every day for every tank, no gaps. Can you rely on that?

You are not recording transactions documenting in and out movement of inventory. You are recording a daily balance. Calculating the difference between sequential records is not simple in Access. Review this tutorial http://allenbrowne.com/subquery-01.html#AnotherRecord. In your case, query...

Possibly use RunningSum property of textbox on report as well as report Sorting & Grouping. Could you provide db for analysis? Follow instructions at bottom of my post.

What result do you want - 16 or 13? If you want 13 then you need to build a query that returns DISTINCT something. Then you would do DCount() on that query. Provide sample data and desired output. You can build tables in post (click the 3 dots on toolbar to see more options) or copy/paste from...

"That filed became too lengthy." - exactly how is this field "too lengthy"? Each data element is in its own record. This is how it should be. What other fields are in source table - ID, Date, etc? How many possible Desc elements are there? Could there be repetitions? WHY would you want to...

My db is set for Overlapping Windows, not Tabbed Documents. Popup Yes would be required for form to open over other objects for Tabbed Documents. For Overlapping Windows, even Modal alone opens over other objects.

I tested a form set as Popup No and Modal Yes. Form opens over other form and cannot click on other form.

Setting as popup allows form to sit above the application window. Without popup form can be moved but it will be within the window. Do some experimenting. Keep in mind that popup and modal can be a bit annoying when developing and debugging database. Suggest not setting until ready to distribute...

Did you try? Popup makes sure form or report is above other objects. Modal is above and prevents clicking onto other open objects.

If you want to pursue this, could you provide db for analysis?

Are your other forms all Navigation Form type?