Search results

  1. June7

    Solved Deleting Records Warning

    Nothing ready made. Yes, use a form to display related records that will be deleted.
  2. June7

    Solved Sum / Dsum

    Have you read post 2? I have edited it so might review again.
  3. June7

    Solved Sum / Dsum

    Gasman, the error is #Error showing in textbox.
  4. June7

    Solved Sum / Dsum

    Aggregate functions must reference field, not control, and must be on form with the field. So if field is named Total, simply in textbox in subform footer section (it will not show with Datasheet View): =Sum([Total]). Then textbox on main form references subform control: =[Expenses...
  5. June7

    Variables changing to fields

    TempVars can be referenced in ControlSource and queries and macros and they retain values even when unhandled runtime error is triggered (globals do not). Does require code (macro or VBA) to establish and populate.
  6. June7

    Query return max value

    LeoM, why no output shown for OMBIRD 02? If UNION gets too slow, use expression in query or VBA function called by query. Here is non-UNION workaround. Assumes only 9 frequency fields as shown in sample. Query: SELECT Table1.TASK_LIST_GRP, Table1.TASK_LIST_COUNTER, Switch(Not...
  7. June7

    Hyperlinks not working in printed report

    Should work. Review https://www.accessforums.net/showthread.php?t=89532&page=2&highlight=hyperlink
  8. June7

    Solved Is there another way?

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

    Solved Is there another way?

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

    Solved footer totals in subform

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

    Solved footer totals in subform

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

    Solved footer totals in subform

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

    Solved footer totals in subform

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

    Solved footer totals in subform

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

    How to open the "Access Option" from a button

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

    Access query question

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

    What is a Weak Reference and Where am I using it?

    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/
  18. June7

    Access query question

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

    Access query question

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

    Access query question

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