Search results

The actual button functionality is ok without the caption change, so I may just dump the stuff to recaption it. I cannot figure out how the sub form can respond to one event, but not another. It is clearly 'receptive' to repeated KeyDown events but ignores KeyUp events even though it's clearly...

OK I've been working on it and it's not the Locked status of the field. I just set it explicitly unlocked to check. Same behaviour. 06/07/2021 21:59:10 TabCtlDetail_Change - Screen.ActiveControl.Name = txtPickQty 06/07/2021 21:59:10 TabCtlDetail_Change - Me.ActiveControl.Name = OrderLines...

Well, it's fancy functionality that has turned out to be a lot more complex that I expected. To reduce the number of buttons on my form, two of them are dual-function. A main function, and a related subsidiary function when Control is pressed. The functionality has worked perfectly and...

So ... just to be sure, the list of Macros, which seems to be an arbitrary list of Public subs, isn't an issue ? It's just I can't see why some of those subs are in there when others aren't. I've never written a Macro to my knowledge. I've only ever used Access 2016. I have a module called...

It says F5 Run Sub/User Form so I must be having a senior moment, I must have used F8 before. Question about the Macros still stands though.

Ah that works. I could have sworn I used F5 before. Thanks. The forward arrow 'Step Through F5' brings up the Macro dialog but I'll just use F8. Part 2, why do I have this Macro list ? I don't know how to design a Macro. How did the Public subs get in there ? I'm trying to be sure that I...

Oh yes, sorry, I have set a breakpoint. Still trying to debug my other issue. So I open the form where I have the breakpoint, the code window opens with the line highlighted yellow, I press F5, the Macro window opens. I want to keep stepping through.

Trying to step through some code using F5 and it brings up a Macros window. This didn't use to happen. There's a list of procedures, all Public. Just 3 of them are from my own code, but the list seems arbitrary. For example, one of my code modules has 3 Public subs but just 2 of them appear...

Disabled the toolbar with DoCmd.ShowToolbar "Ribbon", acToolbarNo. I'm getting the same issue. Focus apparently is in the right field on the right sub-form but it's not ready to receive input. Sub-form KeyDown fires, KeyUp doesn't. Any ideas why this is happening ?

OK I've recovered and got back to where I was. Fixed a name ambiguity which wouldn't have helped. Done some more testing, my SetFocus commands are ok. I had a feeling this was going to be one of those "how did I miss that ..." and I think it is. When I bind the tab for the first time, using...

Unfortunately I can't post it. I discovered that just minimising Access and restoring it enabled the focus and the key events. Then it crashed and wouldn't open again so I've had to revert to a recent backup. I'm going to have another look in a couple of days.

Per the title. In my TabCtlDetail_Change sub, I try to set focus to the sub form, then the sub form control. It doesn't work. Despite, Access reporting that that is where focus is. TabCtlDetail_Change calls a sub to bind the page, then attempts to set focus as the last two lines. I put a...

OK thanks all. Looks like I'll go with Double. An early design decision that wasn't the best but it can be fixed.

Billion pound turnover, ha ha I wish It's not the integer part that's the problem. You'd think it absurd that I have invoices priced to one-thousandth of one penny but that's how the utility companies price my electricity and gas. I've been having to tweak my input because I can enter prices...

A long time ago as a total novice I made my price fields as Currency which gives me prices to 4 decimal places of one UK pound. How can I increase the decimal places stored ? I need up to 5 for prices, and possibly more for another function, with total precision. Looking at the table design...

Well it did turn out to be the sub form and it was a coding error. Who knew that setting the SourceObject in code closes the sub form then immediately opens it again ? Not me. I was setting the SourceObject early on in the detail form. Probably not even necessary. Other things going on...

I *may* have tracked it down. I explained I have two similar main forms each with their own similar detail forms. The tree view control is common so the spotlight was on it. It occurred to me there's another common component, the sub form of the two detail forms. On step through, the sub form...

MajP, yes it is your tree view. Although I just said I didn't copy and paste any controls into my new form I DID copy and paste the actual tree view control. It IS looking a little suspect. I wondered if it only happened when I double-click the node from 'empty space' but I just tried...

I have two main forms, functionally similar but sufficiently different to justify separate forms. Each form opens a detail form on a double click event in a tree view control. The detail forms are also functionally similar. So, two main forms, each of which displays a tree view control, and two...

Doc_Man, it's my explanation that's lacking I think. I should have made clear, OTHER users could edit and update the records between the 3 selects of the union query. When I said 'saved in the same records', I meant, we get the net value grouped by expense category in query 1, we get the vat...