Browse by Tags

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

New Access 2007 Technical Article
20 August 08 10:03

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

Message box replacement sample code
05 August 08 10:30

Renaud has released a cool replacement for message box. Here is how he describes the code sample: This project provides a custom and enhanced message box replacement for the default MsgBox found in Access. A Test database for Access 2007 is available Read More...

Postedby clintc | 5 Comments    

Filed under: 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

Follow up to Transparency Forms
05 May 08 05:47 PM

Renaud posted some comments to the previous post about transparency forms and made some really cool enhancements to the code, along with a note about using a class module to make it easier to use. This is how I use transparency forms in my own implementations Read More...

Postedby robcooper | 23 Comments    

Filed under: User Interface, Form, Code

Modal Dialogs with Transparent Backgrounds
28 April 08 05:20 PM

If you've taken a look at some web sites recently, you may have noticed an effect where items (usually images or videos) are brought to the foreground using an effect called a lightbox . The effect is used to dim (or sometimes lighten) the background Read More...

Postedby robcooper | 21 Comments    

Filed under: User Interface, Form, Code

Kiosk Forms
27 April 08 09:23 PM

One of my favorite tricks with forms in Access has always been what I call a kiosk form. A kiosk form is a form that takes up the entire screen and is one that you might find in a store or shopping center displaying information. For example, a real estate Read More...

Postedby robcooper | 4 Comments    

Filed under: Macro, User Interface, Form, Code

Data Points: Web Services & Country Codes
14 April 08 06:13 PM

“In the clouds” ~ Using Microsoft Access to query and update Web sites Garry Robinson shows off integrating web 2.0 into Access through REST and VBA. Tip: How to create automatic input masks for Us/Canada Postal Codes Doug Klippert posted Read More...

Postedby Ryan McMinn | 0 Comments    

Filed under: Code

Code to make dates easier to read
08 February 08 08:19 PM

Today's author: Kerry Westphal, a program manager who works on the Access team. I like how many web 2.0 applications make it very easy to visualize complex data quickly. I found myself recently challenged with this task while working on a project where Read More...

Postedby clintc | 6 Comments    

Filed under: Report, User Interface, Code, Query

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

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