Recently, I wrote an application to manage files between directories and needed a function to make sure that the directory structure was the same between the source and destination files. VBA provides a function called MkDir which is used to create a directory, but it requires that the parent directory already exists. Here's a function called MkTree that will walk a path and create all of the directories in the tree for a given file/directory path. ' ---------------------------------------------...

I was toolin' around the Internet the other day, and it occurred to me that there are really a bunch of different places that the Access community gathers to share and communicate online that people might not be familiar with. I think the most frequented venue for Access communications continues to be the NNTP servers. Check these out with any News reader (windows mail/outlook express is a free client you may already have). comp.databases.ms-access microsoft.public.access .* (I don't list them all...

I spent some time today updating the look and feel of the blog. We'd been running with Orange for quite a while, and it seemed like time for a change. We also decided it would be good to rename the blog to the Access Team Blog, because that name better reflects how we intend to use the blog (as an outlet for communications between you and the Access team). What do you think of the redesign? Comments are welcome!

We've finally gotten the runtime re-released and its available on the web at the location below. We've nailed the issues down and it will stay available at this point. My appologies I didn't get this posted over the weekend - I was away without net access for the weekend. Clint's blog got the word out earlier, and that's another good place to look for Access information. Here is the link for the 2007 Access Runtime: http://www.microsoft.com/downloads/details.aspx?FamilyId=D9AE78D9-9DC6-4B38-9FA6...

One of our Access MVPs, Oliver Stohr, has just released his new web site focusing on helping users make the switch from Access 2003 to Access 2007. Oli has some good tutorial content which should be useful for those of you who are just getting started with Access 2007, and also check out his blog. He’s been working with some members of the Access team producing content for Access Advisor Magazine. http://www.access-freak.com/

Someone asked about setting the formatting for rich text programmatically, and if there was an object model for the text formatting. There isn't, but the text is simply HTML, so it isn't hard to do through code. Here's a trick to see how our text is formatted and to update the HTML manually: Copy/Paste the text box that has Rich Text Select the text box Change the Text Format property on the Data tab to Plain Text Select a different property to commit the property change and click OK to the warning...