January 2008 - Posts

modScaleForm to Scale for different Screen Resolutions
30 January 08 09:04 PM
You can find modScaleForm here on SourceForge.  It is an open source utility for scaling Access forms to fit different display resolutions.  As we've seen in a prior post, anchoring provides this kind of support in 2007 automatically.  Read More...
Postedby Zac Woodall | 4 Comments    
Video demo: Bring your business data together in an Access database
26 January 08 09:57 PM
We just released a polished video geared towards explaining the why someone should use Access. Here is the introduction: Tired of juggling your business contact data among an address book, lists of orders, file folders, and ledgers? An Access database Read More...
Postedby clintc | 3 Comments    
Filed under:
Updating the spotlight control inside Getting Started
23 January 08 09:24 PM
As you know, the Access Getting Started experience went through some dramatic changes in 2007. This redesign has contributed significantly to the uptake on templates. What most people don't know is the screen also has dynamic content that is updated regularly Read More...
Postedby clintc | 1 Comments    
Filed under:
Video demo: collect data into Access 2007 using email
22 January 08 09:12 PM
There is a new video demo that shows off the new data collection feature. This one is a more formal and polished than the other demos. Enjoy! Read More...
Postedby clintc | 4 Comments    
Filed under: ,
Video demo: make controls grow and shrink
22 January 08 06:15 PM
Chris Downs from the Access user assistance team has just finished a nice video demo about making controls grow and shrink as the form is resized. Read More...
Postedby clintc | 6 Comments    
Filed under: ,
Microsoft Access Downloads in Silverlight
21 January 08 05:45 PM
I ran across this new Silverlight version of the Microsoft download center this morning.  If you haven't seen Silverlight yet, it is pretty cool stuff. It is Microsoft's engine for doing rich graphics composition in the web.  Here are all the Read More...
Postedby Zac Woodall | 1 Comments    
Filed under: , ,
Seven strategies for resolving conflict
21 January 08 08:25 AM
Recently, I was asked the following question: All of my Access work has always been my sole responsibility and I have been accustomed to making all the design and development decisions, and doing all the work myself. I am now attempting to work on a project Read More...
Postedby clintc | 3 Comments    
VBA in Office 14
17 January 08 12:27 PM
A few readers have recently expressed concern and anxiety about an article published by The Register . Particularly, “VBA will disappear completely when Office 2007 for Windows is replaced, sometime around 2009.” As someone who is working everyday on Read More...
Postedby clintc | 12 Comments    
Filed under:
Four new video demos about reports
16 January 08 10:40 PM
The Office Online writers for Access have recently produced four cool video demos about designing reports. The effort should help the topic Modify a report become much easier for people to understand. Read More...
Postedby clintc | 2 Comments    
Filed under:
Rich formatted text that includes data from fields
16 January 08 12:45 PM
The other day I was working on a report where I wanted to build a sentence that included multiple fields from a record but I wanted to use rich text formatting to provide contrast . My scenario was pretty simple in that I wanted a bold title with a date Read More...
Postedby clintc | 6 Comments    
Easy Drill Through with Macros
14 January 08 11:18 PM
This tip comes from Tim Getsch - from www.checkoutmycards.com . He wrote to me after seeing my recent post about Display As Hyperlink : There is the trick that I use for creating hyperlink navigation. Create an Access (not VBA) macro with a short name Read More...
Postedby Steven Greenberg | 17 Comments    
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: , ,
Interesting article on SharePoint adoption
11 January 08 09:57 PM
There is an interesting article on cmswire about SharePoint adoption and applications. Choice quotes include: "The number of organizations that employ SharePoint for mission-critical applications is less than 20 percent, a figure expected to double over Read More...
Postedby clintc | 0 Comments    
Filed under:
UI Builder for Access v.3.0 Released
11 January 08 08:27 PM
Brandon Smith-Daigle has recently released the 3.0 update for his UI Builder tool that helps Access developers to build customized user experiences in Forms without coding the VBA themselves.  This tool is compatible with older versions of Access Read More...
Postedby Zac Woodall | 0 Comments    
Filed under: , ,
Access Dev @ Office DevCon
11 January 08 06:03 PM
Abigail Short, one of the developers on the Access team who helped me to create Layout View and other new reporting features in Access 2007 is going to be presenting at the upcoming Office Developers Conference.  Here's are a few words she wanted Read More...
Postedby Zac Woodall | 0 Comments    
Filed under:
Goldsoft tools for Access Developers
11 January 08 05:27 PM
Ken Hockley has recently released his Goldsoft suite.  These tools aim to increase Access developer productivity by helping to reduce the amount of time spent building necessary application plumbing so that developers can focus their effort on producing Read More...
Postedby Zac Woodall | 1 Comments    
Filed under: , , ,
Tips and tricks designing forms and reports
11 January 08 01:02 AM
This is the final post of a three part series on Access Tips and Tricks provided by members of the Access team. It was originally posted on my blog but I'm reposting here for the benefit of the broader audience. Custom AutoFormats You can create a custom Read More...
Postedby clintc | 1 Comments    
Filed under: , ,
My favorite keyboard commands
10 January 08 10:28 AM
A while back I published this article on my personal blog . I'm republishing it hear for the benefit of the broader audience. _________ I have a confession to make… I started hacking around in computers with Windows 3.1—never learned how to Read More...
Postedby clintc | 3 Comments    
Filed under: ,
New Vehicle Maintenance and Expense Reports database available
09 January 08 09:15 PM
We just published two new Access 2007 templates that are now available on Office Online. Expense Reports Create an expense reporting database for your business to track and approve expenses in addition to printing reports. Vehicle Maintenance Create a Read More...
Postedby clintc | 0 Comments    
Filed under: ,
Using Hyperlinks in Access: Display As Hyperlink and Is Hyperlink
09 January 08 08:47 PM
Those of you transitioning to Access 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 Read More...
Postedby Steven Greenberg | 1 Comments    
Filed under: , , ,
Charitable Contributions Templated
08 January 08 11:32 PM
For three months this fall we were fortunate to have Anshul Tandon working on our PM team as an intern.  Anshul has now gone back to Louisiana State University where he's a member of the senior class. During his time with us one of his tasks was Read More...
Postedby Zac Woodall | 0 Comments    
Filed under: ,
Runtime Update in Progress
08 January 08 06:10 PM
I've had a bunch of questions come in about this so I want to post here to give you all a quick update on the status of the Runtime issues for RTM. We're currently working on an update to the Runtime intended to address all the known issues which cause Read More...
Postedby Zac Woodall | 26 Comments    
Filed under: ,
Office Online Community Submitted Database Templates
07 January 08 10:43 PM
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 Read More...
Postedby Zac Woodall | 7 Comments    
Filed under: , , ,
New Ribbon Reference: RibbonX for Dummies
06 January 08 02:12 AM
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 Read More...
Postedby Zac Woodall | 5 Comments    
Filed under: , ,
Page view tracker