Recent content by Simon_C

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

Of course tracks exist independently of records - compilation albums consist of (almost) nothing but tracks plucked out of their original home. Tracks on albums may be released as singles etc. If it is important to keep track (sorry) of multiple appearances of the same track then that's really...

Thanks.

I guess the simplest way to describe this is that I want a message box to be displayed (and to hold up proceedings until the user responds) when the user clicks on the Form's [X] but not when they click on the Application's [X]. The user's response could - but will not always - prevent the form...