Search results

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

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