Search results

  1. G

    Question about Recordsets and Transactions

    Well this has been going round in my head for days (and nights). I've found the solution (subject to looking at code but I think it will work). The big issue is: summing up and saving child values in the parent record. First let's just have another look at another normalisation issue...
  2. G

    Question about Recordsets and Transactions

    Thank you again it's all helpful. One of my main startup forms is a tabbed form with various lists. I changed the queries to fetch the detail lines and sum them on demand instead of taking the saved balance in the invoice header, or the customer record, etc. etc. From opening the form to it...
  3. G

    Question about Recordsets and Transactions

    OK. Quick question: When you talk SQL workspaces, does that include the recordset operations? I think it does. My recordset is initialised by a SQL select, but the changes to the fields are done by vba commands on the recordset (.edit and .update) Well, I'm certainly talking about...
  4. G

    Question about Recordsets and Transactions

    I've coded a big update routine which involves 6 tables all wrapped up in a DAO transaction workspace. Typically in normal use, it could run for some minutes where a batch of transactions updates various control accounts, supplier and nominal account balances, history tables, that sort of...
  5. G

    Calculated Fields and Breaking the Rules

    Yes, thank you, I'm kind of wishing I had saved the net total in the invoice lines. I'm a bit annoyed with myself for not anticipating what I was letting myself in for. I think I'll add the field and just work through simplifying the queries and data sources. Obviously the existing...
  6. G

    Calculated Fields and Breaking the Rules

    3 fields plus one for the unit quantity. It's not a sum, it's a calculation. It crops up in a lot of places, for example a ledger, where I need to show the net value for each record. So it's not the column totals, it's the record value. Of course I use SUM to get the total of many records...
  7. G

    Calculated Fields and Breaking the Rules

    Just reached a milestone in my replacement accounting application. Imported about 50k records and after a few false starts I now have matching debtors, creditors and trial balance. I had to code a 'conversion' routine to deal with differing conceptual design but my project seems to have come...
  8. G

    Listbox from array

    OK the array was a red herring I think. I know what my question is in my head but getting the answer in Access speak is more difficult. So far: dropped any thought of using an array. Figured it out by doing the calculation in the query. Figured out the SQL with the Select, Sum on two...
  9. G

    Listbox from array

    Thank you, I'll code it on that basis, I'm fairly sure I can achieve what I want, I just wanted to be sure about the listbox being held in memory.
  10. G

    Listbox from array

    The 'static table' is tblVatRates. It rarely changes. So yes it's an actual table (a small one) When I create and save an invoice, I want to create a 'result matrix' and display it on frmInvoice. It will look like this (on the form), all nicely presented: (sorry tabs don't work in here)...
  11. G

    Listbox from array

    If I populate a listbox with an array, does Access save the rows to disk ? I want to populate a listbox with a small static table, and add two columns to it which are calculated on the fly. I can create my array from the static table (say 12 rows x 6 columns) I can create the two columns by...
  12. G

    Requery List Boxes

    In the host form, the form that shows the list: At the beginning of the code module: Private WithEvents ChildForm As Access.Form ' invoice or paymentIn the cmdAddNewRecord procedure (the press of the button): DoCmd.OpenForm Me.txtFrmName, _ DataMode:=acFormAdd...
  13. G

    Requery List Boxes

    I've done something very similar with my current (only) Access project. In the form that displays the list, I have a WithEvents on the child (add/edit) form. The WithEvents is defined and set to fire on the AfterInsert event of the child form. So, when the child form has inserted the new...
  14. G

    Option Frame: Get Name and Tag text

    Yes you're right MajP's solution does work and does what I want. I should have followed it up properly, and I like it better than the multiple case statements. That's why I didn't try it out I thought it couldn't be done Thanks MajP
  15. G

    Option Frame: Get Name and Tag text

    Yes, that's the thread. If it can't be done I'll just stick with the Case Select, it's just a single assignment in each case this time. Thanks again
  16. G

    Option Frame: Get Name and Tag text

    I've called the buttons optPINV, optPPAY, optSINV, and optSRCT So if I could get the name of the button I could parse what I need from there But I see there is a 'tag' property for the button so if I just put PINV in the tag for the button I wouldn't need the Case Select The case select...
  17. G

    User Defined Function in SQL Select

    YES ! That did it. I can sort of see what's going on with the SQL select. It's beyond my current skill level, I do have SQL selects and updates but I can see it can do some very powerful stuff that I should learn. Thanks for spending the time on this, really pleased with the result
  18. G

    Option Frame: Get Name and Tag text

    I've been using a Case Select like this: Select Case fraPurchIndexOptions.value Case 1 txtDocType = "PINV" Case 2 txtDocType = "PPAY" Case 3 txtDocType = "SINV" Case 4 txtDocType = "SRCT" End SelectBut I had a similar situation with a tab control...
  19. G

    User Defined Function in SQL Select

    OK I posted a payment of £500 for a supplier where bCredit = true I posted a receipt of £500 for a customer where bCredit = false (the same form) I've checked the table values and tlSalePrice is £500 in each case, two records in the table On sfrmPaymentLineDsheet, txtSalePrice was bound to...
  20. G

    User Defined Function in SQL Select

    OK I put your code in the record source and it works (I think) I get the same records that I expect to show in the bottom datasheet I need to check some stuff out as I've done quite a bit today Should the values show reversed ? Does this mean it's going to tblDocTypes for *every* datasheet...
Back
Top Bottom