March 2009 - Posts
Someone sent us a question the other day about one of my favorite dark corners in Access and we thought it might be interesting to dive into this area a little. Microsoft Access SQL supports two uses of the IN keyword. The most commonly used case is as
Read More...
Access MVP Garry Robinson and editor of vb123.com recently wrote a nice review article on IBDE Ribbon Creator . You all should find it enlightening. http://www.databasejournal.com/features/msaccess/article.php/3803996/Making-Your-Own-Access-2007-Ribbon.ht
Read More...
There is a new article on MSDN that has some useful code samples. This was based off a post by Kerry Westphal on the Access blog a while back. Here is the intro: Many Web 2.0 applications are designed to make it easy to visualize complex data. I found
Read More...
I got this request from a customer who is trying to analyze their environment as it pertains to Access and Excel files: Can we use WSH and VBScript to get this type of basic information out of files in an automated fashion? Both MS Access and Excel
Read More...
The team recently eclipsed 10 million downloads of Access 2007 templates. Quite frequently I hear from template users about the need to change the application to match their business process. Additionally, I hear from people about the need to build
Read More...
There is a pretty good directory available with links to team blogs at Microsoft. Enjoy!
Read More...
in mid December an Excel security fix (MS08-074) broke paste from Excel inside Access. Users would get the following error message: The data on the Clipboard is damaged, so Microsoft Office Access can't paste it. There may be an error in the Clipboard,
Read More...
Luke Chung from FMS recently talked on Channel 9 about his view of Access solutions -- where they fit well, what challenges users and developers often face in creating and maintaining them, and how they have evolved from standalone desktop solutions to
Read More...
Mike Alexander (Excel MVP) recently sent me a very cool trick that I hadn’t seen before. He uses some simple hackery and trickery to get data bars in a query. This is the first installment of a long series about how Access can be used to create cool dashboards.
Read More...
There is an interesting article on about Office 14 on Cnet. It doesn’t have anything specific about Access but there is a good interview with Antoine Leblond, who leads the Office client engineering efforts.
Read More...
