Browse by Tags

• Access 2003
• Attachment
• Engine
• Form
• Navigation Pane
• Reference
• Reference Code
• Report
• Ribbon
• SharePoint
• Table
• User Interface

New Access 2007 Technical Article
20 August 08 10:03 AM

Aleksandar Jakšić, who is one of the testers on our team, has written an article that shows you how you can use the Access Database Engine from native applications written in C/C++. The article shows you how to to the Access Database Engine using Read More...

Postedby robcooper | 10 Comments    

Filed under: Access 2007, Engine, Code

Adding multiple attachments from a folder
31 July 08 02:55 PM

Rob Cooper recently made a post, Adding Attachments from a Folder, which shows how to add a single attachment file per row. But what if you wanted to add more than one file? One (highly contrived) scenario would be to add all of the files in a folder to one row, and do so recursively if requested, similar to Rob's example. What follows is some VBA code to do this, which borrows a bit from Rob's post and a bit from one of my earlier posts. However, I should point out this (again, highly contrived scenario) is meant only as an example and not something I would recommend doing, because if you are adding more than just a few files you can (ok, WILL) bloat your database very quickly, and in doing so can negatively impact performance and potentially hit the two gigabyte file size limit very quickly (see Access 2007 Specifications for details on database file size and object limitations). Read More...

Postedby James K. Rivera | 10 Comments    

Filed under: Access 2007, Engine, Reference, Attachment, Code, Reference Code

Adding Attachments from a Folder
25 July 08 07:40 PM

Someone asked us yesterday how to add all of the .jpg files from a folder into an Attachment field in a table. In this case, the individual wanted to add one attachment into a new record in the table. This could be pretty useful, so we thought we would Read More...

Postedby robcooper | 7 Comments    

Filed under: Access 2007, Table, Attachment, Code

Dot or Bang?
30 May 08 05:39 PM

Here's a question that comes up from time to time. The other day, someone internally asked about the difference between using a dot "." vs. a bang "!" for control references in a form in VBA. In other words, given a form - Form1, with Read More...

Postedby robcooper | 0 Comments    

Filed under: Access 2007, Report, Form, Code, Access 2003

Interactive chart/form filtering code sample
13 January 08 10:38 PM

Here is another repost from my blog... Enjoy--Clint ----- One of the most enjoyable design challenges I have had over the last couple of years was redesigning how users can filter inside Access and Excel. The new filter dropdown menu and context menus Read More...

Postedby clintc | 0 Comments    

Filed under: Access 2007, User Interface, Code

Ribbon Customization - Repurposing Commands
10 October 07 03:45 PM

Sue and I were talking the other day about Ribbon customizations with regard to some training materials that she is preparing for our support engineers. Along the way I mentioned command repurposing and how you could do some pretty cool stuff with it Read More...

Postedby robcooper | 9 Comments    

Filed under: Access 2007, Ribbon, Code

Sorting Nav Pane Objects by Description
03 October 07 06:35 PM

I've recently had some questions from users who used to sort their DBC by the description field and wanted to be able to do the same thing in the 2007 navigation pane. If you use this scenario, and you've tried in 2007, you'll know that the navigation Read More...

Postedby Zac Woodall | 6 Comments    

Filed under: Access 2007, Navigation Pane, User Interface, Code, Query

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: Access 2007, Ribbon, User Interface, Code

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: Access 2007, Code

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: Access 2007, Ribbon, User Interface, Code

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: Access 2007, Ribbon, User Interface, Code

Using VBA code to open a file stored in the new Access 2007 Attachment field
30 August 07 10:30 AM

Someone asked me about using the Attachment data type in Access 2007 for a specific task. They wanted to use it as a simple data type where it would only be used to hold 1 file per record, and they wanted to be able to open the file in an external application Read More...

Postedby James K. Rivera | 4 Comments    

Filed under: Access 2007, Reference, Code

Integrating Access Contacts with SharePoint and Outlook
28 August 07 05:10 PM

There was a question on our post about getting Access to recognize tables as specific WSS table templates around what else you need to do to get the new Add From Outlook feature to work on a custom contacts table. This feature uses the same mechanism Read More...

Postedby Zac Woodall | 10 Comments    

Filed under: Access 2007, SharePoint, Code

Adding, removing, and saving files from the new Attachment field in Access 2007
24 August 07 01:41 PM

One of the coolest new features in Access 2007 is the new Attachments data type. There are some very helpful dialogs for working with this data type, but there are also some useful additions to DAO to make automating the process of adding and saving attachments Read More...

Postedby James K. Rivera | 7 Comments    

Filed under: Access 2007, Code

Creating item templates for Ribbon customizations to use in Visual Studio
23 August 07 01:47 AM

Despite my passion for all things related to code, I've always had a soft spot for UI that is exciting both in its "coolness" factor and visual appeal. Along those lines, one of my favorite new features in Access 2007 is Ribbon Extensibility . Writing Read More...

Postedby robcooper | 5 Comments    

Filed under: Access 2007, Ribbon, Reference, Code