Recent content by GK in the UK

I'm not sure if you mean don't enter any negative values or don't save any negative values. I see several examples of tables with a dr and cr column. What's the point of that? I agree that users should normally enter positive values. But surely it matters not one jot how the computer system...

Well, yes, perhaps I should have made it clear that there's a table for supplier accounts. But the transaction values are recorded in the item lines table only. So we have the Accounts table (suppliers), Transaction table (Invoices, payments, journal entries), Item Lines table (item line...

What is this 'self-referencing' table for? When you say debit one account and credit the other, are you talking about a journal entry to the nominal ledger or are you talking about an expense receipt, a bill or something like that? Does your application have sales ledger and purchase ledger with...

in 2012 (just checked my records and I also found the eBay listing photo!) I e-bayed a boxed and unused multiple floppy disk Windows v1.0 for an Olivetti M24. I netted £133 from an italian buyer.

It may work if you click in a different place along the node. Try changing the multiplicands in Private Sub mTVW_MouseUp in the class module. It may depend on your monitor. I changed y=y*15 to y=y*12 but I still occasionally get the wrong menu appearing. More info...

Context menu is right-click menu. My tree is for financial accounting. I build the node totals into the node text and each item node is summed into all it's parent (group) nodes. There is a lot going on which is outside the scope of the tree view, but as a result of the summing up which all...

It's not the width of the nodes, it's how much of the depth of the treeview is displayed in the control. It doesn't auto-scroll so if your target is out of reach you can't do it, you end up faffing about trying to make both nodes visible. I see that FMS have some code that enables...

Additional feature suggestion: Drag and drop is a pain if the target node is out of the tree view control window. You might want to consider doing what I did which is to allow a selection of items on checks, across any level, then drop them on a single highlighted target node from the context...

Thank you, that's at least confirmation I'm on the right lines. I already group up deliveries to create invoices then give them a batch number when they're posted. But because I have a header table what I do is give the invoice header record FKs to the delivery note lines and the Delivery Note...

You're describing the method, I think, for sales. I have that all covered, more or less, but the conundrum arises when you consider purchases. Where do you store the purchase VAT? I have a place to save it, the header record which I think would be the right place for purchases but you don't...

I do have an invoice header table but no values are stored in it. I realised long ago that Sage and possibly others don't bother, they just sum an invoice based on some grouped reference field. When I started with Access I'd never heard of an aggregate query (didn't actually know about any...

Q. In general, what is the preferred approach, setting the recordset or recordsource? As you have discovered you can open a Recordset from a QueryDef with the parameters passed in. But if you apply filters Access asks for the arguments so it doesn't really work. Q. Is it possible to set...

Can't we just test it with a Hex Editor on the Access file and find out? I tried it with XVI32 on a new monolithic Access DB, and changing the value of a 3-character string in a table resulted in the old value not getting a hit at all, and the new value appearing in the file in the identical...

Yes, sorry, by unqualified I mean with no criteria or parameter, just returns all the records. But in Form_Load, criteria is applied and I'm suggesting it's too late, isn't it?

I open form instances with a somewhat clunky way of getting a single record PK into the recordsource query, so I was interested to see how it's done in Northwind2. To my surprise one of the two forms that are opened as instances has an unqualified query as recordsource. In Form_Load, there's a...