Results for:
Reference

• UtterAccess Wiki adds libraries for class modules and APIs

  27 May 2011

  The folks at UtterAccess have added two new libraries to their Wiki Main Page : The Class Library has sample class modules and demonstration applications that illustrate how to use the classes. The Class Library is a good place to start if you are just beginning to program Visual Basic for Applications...
• Using Hyperlinks in Access: Display As Hyperlink and Is Hyperlink

  9 Jan 2008

  Those of you transitioning to Access 2010 or 2007 from earlier versions of the product may notice the addition of a new property on the TextBox and ComboBox controls: Display As Hyperlink . You may wonder how this new property interacts with the existing Is Hyperlink property. I asked that question myself...
• Office Online Community Submitted Database Templates

  7 Jan 2008

  Community submitted templates are now live on Office Online!!  "Er?"  You say, "what has this to do with me?"  I'm so glad you asked!! For the first time ever, there is now a Microsoft hosted service through which you can publish and share database applications with...
• New Ribbon Reference: RibbonX for Dummies

  5 Jan 2008

  Those of you out there building custom Ribbon UI for Access/Office might be interested to know that the Dummies folks have recently released a guide for building Ribbon UI titled (as you might expect) " RibbonX for Dummies ".  The book is a general guide to building Ribbon XML, and it...
• Teaching users to fish--an online intro to queries

  4 Dec 2007

  Does this sound familiar? Smart Access user builds a cool database to help co-workers do their jobs more efficiently. Co-workers sing praises and advocate a raise for the smart Access hero. A few weeks later, end users ask hero to help create a couple queries and reports to answer more complex business...
• AccessJunkie's updated 2007 content

  29 Nov 2007

  Our very own Access Junkie, Jeff Conrad, has updated his 2007 Help links and FAQ. These are great resources for 2007 info. Jeff is an engineer on our test team who is very active in the newsgroups, and he's tried to capture answers to the questions that he sees asked most commonly by the community at...
• Access 2003 --> Access 2007 UI Guide

  4 Oct 2007

  The Access help team has just finished up our new interactive guide for users moving from 2003 to 2007. The guide is a flash based tutorial which allows you to select a command from the 2003 Access UI, and then see where it has moved to in the 2007 ribbon.
• Using VBA code to open a file stored in the new Access 2007 Attachment field

  30 Aug 2007

  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 using a button on a form instead of using...
• Access 2007 Reports Demo

  23 Aug 2007

  I can't resist doing a quick post to let you all know about the new report demo that just got published to OfficeOnline. This is a quick little video, just a few minutes long, which gives a great overview of some of our new reporting features in 2007. Big thanks to my engineers, Steve Lesser, Abigail...
• Creating item templates for Ribbon customizations to use in Visual Studio

  22 Aug 2007

  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 the XML for a customization can be a bit of a bear...
• Set SharePoint List Template for Access Table

  16 Aug 2007

  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 to an WSS 'Contact' content type. Very cool! Now...
• New Access 2007 Articles on Office Online

  13 Aug 2007

  Thanks to Jeff Conrad on the Access test team for this: Office Online now has published four articles with material pulled from the Microsoft Office Access 2007 Inside Out book. This enormous book, published by Microsoft Press, is co-authored by Access MVP John L. Viescas and recent Microsoft hire Jeff...
• Formatting numbers into hexadecimal

  8 Aug 2007

  Even though class modules in VBA are not as powerful as their brethren in C++, C#, or VB.NET, I'm still a fan. Some time ago, I wrote an application which contained a class called ISearch and then subclasses which implemented this class using the Implements keyword. For debugging, I thought it would...
• MkTree Function - Make sure that directories exist

  31 Jul 2007

  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...
• Easing the transition from Access 2003 to 2007

  12 Jul 2007

  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...
• Setting Rich Text Formatting Programmatically

  2 Jul 2007

  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...
• Automated front-end management and publishing

  28 Jun 2007

  One of the Access MVPs from Canada has a great tool for helping to manage and publish Front End database apps. For those of you who are familiar with the process of front-ending, this is a real time saver, and he makes it available for free (thanks Tony!). You can pick up Auto FE Updater from here: http...
• Running Access 2007 in Runtime Mode

  26 Mar 2007

  Even though we haven't gotten the runtime re-distributable shipped yet, you can run apps in Access 2007 in runtime mode. This will let you test solutions while waiting for the re-dist. In addition, it is a simple way to keep users from changing your applications even when they have the full app. You...
• Access 2007 Books List

  28 Feb 2007

  I did a quick search out on Amazon to get the list of current and upcoming titles for Access 2007. There are really a ton of great titles out there from lots of different publishers. Content ranges from a complete Access reference like Microsoft® Office Access 2007 Inside Out to more targeted scenarios...
• Improvements to assistance features and content in 2007

  4 Dec 2006

  The following is a post from Marci Billow, the UA manager for Access (and other teams in Office). The UA team has done a tremendous amount of work in improving help, and wanted to spread the word. __________________________________________________ During the past few years, you shared a number of concerns...