September 2007 - Posts

Ribbon Customization: Using a dynamicMenu to Show a List of Open Objects
27 September 07 10:06 PM
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...
Postedby robcooper | 3 Comments    
Filed under: , , ,
Prompt before committing record update
28 September 07 02:39 AM
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...
Postedby Zac Woodall | 5 Comments    
Filed under: ,
Ribbon Customization: Filling Dropdown Lists
25 September 07 05:35 PM
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...
Postedby robcooper | 5 Comments    
Filed under: , , ,
Ribbon Customization - Closing the Currently Open Object
24 September 07 09:45 AM
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...
Postedby robcooper | 7 Comments    
Filed under: , , ,
Writing a Count(Distinct) Query in Access
19 September 07 02:43 PM
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...
Postedby robcooper | 4 Comments    
Filed under: ,
Form Views and Subdatasheets
18 September 07 02:14 AM
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...
Postedby robcooper | 3 Comments    
Filed under:
Live Web Cast from the Access team
12 September 07 11:02 AM
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...
Postedby clintc | 9 Comments    
Filed under: , ,
Company meeting, and on to M2...
10 September 07 08:37 PM
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...
Postedby Zac Woodall | 18 Comments    
Color Support in Access 2007
07 September 07 07:50 PM
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...
Postedby Zac Woodall | 4 Comments    
Filed under: , , , ,
Image Buttons
04 September 07 09:38 PM
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...
Postedby Zac Woodall | 9 Comments    
Filed under: , , , ,
Page view tracker