Recent content by Simon_C

The one thing I didn't think of earlier was to include some code in the Print events for the two header sections. Private Sub GroupHeader1_Print(Cancel As Integer, PrintCount As Integer) Cancel = IsNull(Me.ChildFirstName) End Sub Private Sub GroupHeader2_Print(Cancel As Integer, PrintCount...

I do see what you mean. At 100%, in Print Preview, I get the line between John and Luke but not between Frank and George and different zooms mostly get rid of it altogether. Printed to PDF I get both the John / Luke and Frank / George lines. I've tried a number of tweaks to the report but I...

I know it looks like it from the image, but are each of the text boxes that contain the names positioned at the very top of their section i.e. is the 'Top' property set to zero? And is each section the exact same height as the text box that it contains, and no larger? I ask because the 'Can...

It will depend very much on moi's circumstances but it may be that rather than try to synchronize two (or more?) databases via updates to specific records, the record updates need only be pushed in one direction (i.e. from site to main office) and that a copy of the whole newly-updated 'clean'...

I've realised why we were going round in circles a bit there: I was using "run-time" to mean any time the database was running (whether accdb, accde or whatever), and design time to mean when the objects were being created. I wasn't specifically thinking of "run-time" meaning an accde. To the...

I assumed I had, but that's why I was asking about design-time / run-time effects of the ANSI 92 option - because it wasn't checked in the database in which I was having problems so at first blush it doesn't seem as though that could have been the only cause of the problem.

I installed Office 365 on the Windows 11 PC last night. While I dare say there will be teething problems with the database which need to be ironed out under Office 365, the combo boxes are now working fine. Is the fact that the ANSI 92 option is in the Object Designers tab rather than the...

I did check that, and it's not set but the behaviour I'm seeing is pretty much exactly what's being complained about above - AutoExpand can work OK but only for the first 100 or so entries in the list and then it stops, though it works fine if you've dropped down the combo list. Some people have...

I've just started trying to convert an old Access Database system (using Office 2013) from 32-bit to 64-bit and have been hitting a few unexpected problems along the way. As it happens, the 64-bit version I'm using is running on a Windows 11 machine while the 32-bit has (most recently, anyway)...

Or even for digital comparison with a set of master versions (in text form) though obviously that would be more practical at a point where code wasn't changing frequently and significantly.

This, I think, was it. I mean I did get problems if I tried running the start-up code but I also had problems in design mode if I didn't, so I've gone back a fair way and using that older version seems to solved the more peculiar errors I was getting. I now might try picking a more recent backup...

Thank you, but I've tried a few of those!

The computer I'm running the 64-bit version of Office on has never had any other version installed.

Thanks for both replies. I haven't tried de-compiling it, I'll give that a go. I have already tried compacting it. When I first started messing with it, it did compile OK after I adjusted a couple of API calls which needed tweaking. It is ACCDB already. I also tried creating a new empty...

I have here an old Access Database system which has been running for the best part of 20 years, quite successfully. For the best part of the last ten years it's run on the 32-bit version of Access / Office 2013 running under either Windows 7, 8 or 10 without many problems at all. We'd stuck to...