Saturday, August 27, 2016

Rollover  Beethoven - Access Web Database Users Beware

Ok I know that there are less people in the world that use Access Web databases than there are people that know that Beethoven's ninth was the feature music in the cult R rated film, Clockwork Orange.

That ridiculous analogy aside, if you have an Access web database, then beware when Microsoft asks you politely if you mind changing servers. If you agree, you may find your  odbc 11 linked tables sending out weird readonly messages.  What has happened is you will still be connected to your old server and that server will be readonly. Meanwhile in the cloud, your new server is working ok and Office 365 cloud data is being stored there. This new data is not visible in your old links. That's the symptoms.

All I can suggest that you do is open up your Access Web Project file in design mode and find those Connection buried under the File menu.  Now reenter your new connections into your odbc 32 links and you will be on the way. I hope.

Meanwhile I feel like I have been done over by , the star of Clockwork trying to work this out. I thought adding a project to my Web database system tonight was only going to take a minute, little did I know. :(

Thursday, August 18, 2016

Combo Boxes in Access are really good but how do you do them in Excel ?

Sorry for a long absence, one of the companies that I work for was taken over and that used up all my gas in the last month or so.  So now I am back, here is a good article on Excel by Susan Harkins that sheds some light on the mysterious world of "Structured Excel programming".


Susan writes... Excel's basic validation is usually adequate, but sometimes you may need an on-the-fly solution. Here are the steps for using VBA to make it happen. Valid data is the cornerstone of any application. Thanks to Excel's Data Validation feature, input values can be tested and accepted or rejected based on criteria you specify. One of the easiest ways to validate data is to restrict users to a list. You can even update that list in one of two ways: You can manually add new items to the source list or you can allow users to enter new values using the data validation control itself. In this article, you'll learn how to update and alphabetize a data validation control's source list using VBA.  Read more on Excel Combo boxes here







Wednesday, August 17, 2016

Windows 10 Anniversary Edition

If you wondered what that giant upgrade to Windows 10 was that locked up your computer for 10-15 minutes, it was the anniversary edition of Windows 10. If you are a windows 7 user, your window for upgrading for free is closing fast. This story is very well told over at ZdNet and you can read about it here