Search results

Because OpenArgs is evaluated only on first open, not on subsequent openings and the params may be different. Just composing reply to DBguy...

Thanks for the quick response. Sort of. I found an old thread on here that said TempVars are only of use in SQL queries so I've avoided them. So far I haven't used TempVars or Global Variables. Plus, how would the different instance of the called form know which of the variables were the...

Is there a method for an open form to get the name of the calling form, so that it can read some parameters from the calling form ? I can't use OpenArgs as the form is already open. The open form may be called from different 'hosts' There may be an additional complication. Although I...

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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