MS VBA Access - Form Flickers or Crashes When it has Conditional Formatting, Totals and Only One Row is Returned

By His Royal Dryness, The Duke of Cork -

 An annoying problem in MS Access VBA sub forms which took some finding a solution for.

We had a form with a subform.  Every now and then the form would just hang (or freeze) but we couldn't work out why.

We eventually narrowed it down to the subform.  The subform was on a page/tab control and if we clicked a different tab (so the subform was no longer visible), everything was fine.

After much internet search and trialling of different approaches, we realised that if there was more than one row, everything worked fine.

Further investigate revealed that removing the totals from the form also meant it worked.

Finally we found that removing the conditional formatting meant that the form worked.

So we had to choose one of these things to drop

  • Conditional Formatting
  • Totals
  • Make the query return extra row(s)
In the end we dropped the conditional formatting and things worked fine.

Comments

Post a Comment

Popular posts from this blog

Morrisons Three Fish Roast

By -
At Christmas, we purchased a couple of Three Fish Roasts from Morrsions as an alternative to the usual turkey, which we also cooked.  We really liked the sound of the salmon, cod and smoked haddock combined into one roast. We cooked them as directed - 30 minutes at 180 degrees - and were delighted as they came out of the oven and the aroma wafted through the kitchen.  We left the turkey to rest and then carved it, so started to try to carve the three fish roast.  Sadly, it disintegrated at the slightest touch, so it became something of a plate of loose, random chunks of fish.  Not many people went for it! When we tasted it, though, it was very pleasant indeed. So, how to solve the problem of the collapsing roast? It was simple, in the end.  We had some puff pastry in the freezer.  We purchased another three fish roast and simply rolled the fish in the pastry, piercing a couple of holes for any steam to escape.  In the oven for 40 minutes at 180 degrees and it came out looking g
Read more

How to Stop the Annoying Nag Message in Outlook Asking to Take Outlook Anywhere

By -
Image
 I had an annoying message in Outlook 365 which appeared every day saying "Take Outlook Anywhere.  Stay connected to what matters.  Get Started (or Get it Now)"  There appears to be no way of stopping this appearing through the user interface, although you can just close it.  The reminder seems to appear every day  Even after a bit of searching online, I couldn't really see any obvious, clear solutions.  I even found some post suggesting that you need to complete on online form to opt out.  As far as I could tell this was just a data-harvesting scam.  This is what I pieced together to get rid of it. Open Regedit (Start --> Run --> Regedit) You then need to navigate to this node Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\TargetedMessagingService\MessageData\ Right-Click MessageData and choose "Find" Type 425141231 (I got this value by clicking get started and taking it from the URL) You should find a node ending in BizBar with sub node
Read more

Amazfit / Zepp App Needs to be Running for Alexa Shortcut to Work

By His Royal Dryness, The Duke of Cork -
Image
Got a new Amazfit GTS 2 mini.  Works fantastically well, and I think it's terrific value.  The battery life in particular I think is great. One issue I've faced, but can't find a solution to is that the Alexa link doesn't work.  I get the message "Phone not connected.  Cannot use Alexa." The problem appears to boil down to the fact that the Zepp app is not running in the background (I'm running Android, by the way).  If I leave the Zepp app alone, then Alexa works. Not sure if I've done something to prevent the app from working in the background or if the developers haven't done what's needed for the app to do its stuff, but maybe this will help someone...or maybe someone will help me!
Read more