Recent content by June7

Intellisense is popup tips VBA provides as you type. Also, in query designer and expression builder.

Brackets are not needed unless naming includes spaces or punctuation/special characters. Code is behind main form? Main form is named PatientAdmitance and subform container is named PatientNotesSF? Me.PatientNotesSF.Form.Pnote.Setfocus

Sorry, turns out it was not a Richard Rost page I landed on.

I have done lots of data entry, even into accounting programs (QuickBooks, Great Plains) and never seen a "math" textbox. Could you provide link to the Richard Rost tutorial? Only one I can find that seems relevant shows creating calculated field in table, not a "math" textbox for user to enter...

Did you fully read my previous post? I was able to fix your form by deleting and recreating the Nz() textboxes. I still don't understand need for the text fields. Why not just enter a value into number field? Why use Nz() at all? 0 does not show because of Format setting.

Why would you even need to use text fields with Eval() function to do calcs? I have never seen this. My point is, the Sum() calcs work with the Nz() textboxes visible and the text fields eliminated. I simply bound form to table instead of query. Made another attempt to replicate your original...

Why do you have txtDebit and txtCredit fields? These are text, not number type. What purpose do they serve? Both Sum() calcs reference Debit field. What do you mean by "remove"? I unbound the textboxes and removed fields from query and totals still don't work. I couldn't get your form to work...

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...