Search results

Hi @GPGeorge the issue i have is that 2 different PCs running same versions of Access 1 can compact the other can't same database front end i am on the latest version and i have backed out the updates to many different previous versions and it still occurs so i think its something up with my...

@CJ_London so done all that and still no joy, still unable to compact on my computer

@CJ_London i have tried the reboot option and that didn't resolve. how do i go about compiling the VBA or decompile/recompile as you say. its just weird the database compacts on other machines not mine. actually i just realised in the main post i didn't state The database is split as well, the...

Hi All I thought i'd hit an issue with the latest update whereby i get the following error: But i have tried the following: Multiple database files Different folders on my local machine Confirming that the folders being used are in my trusted locations configuration Reverted to earlier...

@Pat Hartman thank you for the info, i did try that earlier and got the following error: but i have just realised the mistake i have been doing, the call to the module routine did not include "Call" in front of it. When i add that it works, although it does act weird with lots of rendering...

@Pat Hartman it was literally just header and footer colours on forms that have them, and it was more just to see how to do it and leave a few easter eggs for certain users than anything particular or practical. colour would have been logged against username in database and if usable retrieved...

looks interesting i'm going to add it to a backup of my project and see what fun i can have with it thanks @arnelgp

@arnelgp i'd be interested in seeing how it does it but again this was more just a bit of fun to break the monotony and didn't want to go full on with it so i'd just be happy to understand why its failing

@sonic8 thank you but its the finding of the form part that fails not the header/footer bits, i tried using the section property and it does the same thing

Hi All On a number of my forms there are header and footer sections which are set to a specific colour but I wanted to make it a little more user configurable by allowing a user to select a colour theme/scheme that will apply to all headers and footers. I already do a couple of things as a...

If you add the folder which the front end resides into the Access Trusted Locations: File->Options->Trust Center->Trust Center Settings->Trusted Locations this (for me anyway) fixes an issue that came about as part of the update in that when you shut down Access a process remains running in...

@Gasman thank you, it still looks like it shouldn't be affecting my version but i can see the issue on others who have updated to the version specified. i'll look out for an new update and hope it fixes my issue as well as the other users

@GPGeorge so does that mean it affects the current version i am on and the version you mentioned?

I have noticed a few people in the office who are having issues with shutting down Access in that when they do it doesn't shut properly and they are on the version you mention 14827.20158

i'm currently running Version 2112 (Build 14729.20260) it does say there are updates available

@GPGeorge oh, grrr, ok, i'll take a look at the versioning information and see what i can find, thank you for your update.

Apologies, the title is not the correct error. its "Cannot open any more databases" if i ignore the error the 4th query returns 0 results even though if i run the query on its own it returns the values i expect I've updated the title with the correct wording of the error. sorry @Gasman

Hi All So i am trying to generate a complex excel sheet from data from my database. I have currently 4 complex queries (but the need for at least 2 more) some of which use the results of 1 to generate total lines for the sheet. Also as part of some of the queries i am doing currency...

@Minty was looking for code to replace a set of certain characters that can't appear in a Excel sheet name and found this and it worked brilliantly so just wanted to thank you for posting

@arnelgp yep a second query and sorting that solved the issue thank you