September 2007 - Posts
This is the third post in my short three-part series on ribbon customizations in Access. In the previous post, I showed how you could fill a dropdown with a list of the open forms in the database. This time, we'll fill a dynamicMenu control in a ribbon
Read More...
I just ran across this little video from a how-to on MSDN in which Joel Krist shows how to get Access 2007 to prompt before committing a record update using VBA.
Read More...
In the previous post, I showed you how to create a simple customization to close the currently open object. Continuing along the lines of adding object helpers to an application, we'll add two dropdown lists to a customization to work with forms. The
Read More...
In a previous post, I talked about how much I enjoy developing solutions that use the new Office Fluent Ribbon UI. Along those lines, this post is the first of three upcoming posts on some specific customizations I've used in some applications recently.
Read More...
We received a question from a reader named Eric week before last about how to write a Count(Distinct) query in Access. In other database applications such as SQL Server, Oracle, and MySQL, the Count(Distinct) aggregate is used to count the number of unique
Read More...
Subdatasheets were added to Access 2000 but here's a tip to both add functionality to them and make them look pretty cool. This works in Access 2000 as well but can be a little hard to find. (Read: I just found out you could do this.) A subdatasheet is
Read More...
Mor Hezi, the Access product manager, is giving a web cast targeted an at new users Thursday September 13, @ 9:00 AM pacific time. This is a great opportunity to introduce Access to co-workers that want to learn more about how to track information. Microsoft
Read More...
We're headed into our second coding milestone for the next release of Office (v.14). The stuff we're building is really amazing, and I can't wait until I'll be able to talk with you all about it in detail. For now though, as we ramp up for our next coding
Read More...
This is the next installment in a series of posts about Access 2007 originally made by one of our developers on the Access team on his own blog that I'm moving here for the broader audience to enjoy. "I find color schemes that I just like and that just
Read More...
This is the first installment in a series of posts about Access 2007 originally made by one of our developers on the Access team on his own blog that I'm moving here for the broader audience to enjoy. Up until this point, Access has supported command
Read More...