Search results

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

Before Update will fire regardless of how the record gets saved. If a record is dirty, you simply cannot stop it from firing other than pulling the plug or killing Access. It’s the last thing that happens before the record actually gets updated to the disk, and it’s where you should have...

I think there is confusion about NewSaleID and what it is. It isn't your new invoice number, it's the Access auto-generated ID of the new parent record. Access provides it automatically when you .Update the parent record. At that point, you can put that new ID into your child record. It has...

Thank goodness it's not just me that's been puzzled by this thread. MajP's demo works as he says it does, but it's not the behaviour I see. My listbox properties are: Control Source: empty, RowSource, empty, RowSourceType: Table/Query. RowSource is set in code, list populates, and when I...

Have you tried setting the format of your field to a custom format? You say you set it to 0.0000 but did you define the format correctly? Like this: #,###.0000 So: entry of 1 shows 1.0000 entry of 1.27 shows 1.2700 entry of 1.2345 shows 1.2345 Works for me where the table field data type...

I have a sub form in a tab control which is a datasheet. The column filters are all available. By default there are some hidden columns but they can be unhidden which is ok. But on close of the main form, using the X, Access asks if I want to save the changes. How do I stop this message...

I'm kind of wishing I hadn't linked the article, yes it's old but it's something I discovered as an Access beginner and it seemed to fit the bill. The dbDenyRead was a kind of 'ah-ha' moment. Does no-one use this? The issue of duplicated Autonumbers mentioned in the article is really a red...

I may have misunderstood your original question. Almost all of my tables have meaningless autonumbers. as keys. Some have natural keys. But I don't use autonumbers for any business purpose. Just as an aside, I have a table with a natural key which turned out to be a mistake, not because I...

I adapted this code. You can code it to have any kind of prefix/suffix you like. You need a table to maintain the last picked number for each document type. Built for multiple users but my implementation doesn't test that. What it doesn't do, is recover the number for a deleted record. In...

My first submission. To be honest I'm always amazed by how the experts here can get so much done with so little code. This might be an example of how little is done with a ton of code, not really sure. If this makes the grade tell me if it should go in Code Repository or Sample Databases...