Search results

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

The user that's running the report may not have any idea that someone else is editing or adding records. So they just get a duff result and rely on what's reported. Yes, there's a very short time window to insert/edit a record but wrong is wrong ... On balance I decided that because it sounds...

Dbuy, The user won't necessarily know that the result is wrong, unless they do add it up. They could run it again, but how do they know that the report is still flawed ? To take the most trivial example (Sorry you may already have got this): A new business is adding invoices continuously...

Yes I have a union query which unions the 3 select queries which feeds a tree view. I'm not running the select queries separately. Has it ever been an issue ? Well, no, not that I'm aware of. And I agree it's a really tight timescale for something to happen, maybe I shouldn't give it a...