Browse by Tags

• Attachment
• Engine
• Reference Code
• Ribbon
• SharePoint
• User Interface

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

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

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

Set SharePoint List Template for Access Table
16 August 07 07:32 PM

There was an interesting question in one of the other posts that I thought I'd answer here to reach the broader audience: Doug said : If I export Northwind 2007 to WSS 3.0, the tables, like Customer, that contain 'Contact' type information get exported Read More...

Postedby Zac Woodall | 27 Comments    

Filed under: Access 2007, SharePoint, Reference, Code

Customizing the New Access UI
13 July 06 10:58 AM

I described the new Access UI in this post and this post way back in March. Now I'll run through how you program the ribbon UI using VBA. In a future post (we're still working out the content) I'll do another post on how to do the same thing using macros Read More...

Postedby Erik Rucker | 56 Comments    

Filed under: Access 2007, Ribbon, User Interface, Reference, Code