Posts

Showing posts from December, 2022

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

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!

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

 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.