Browse by Tags

• Access 14
• Access 2003
• Code
• Filter
• Graphic
• Layout View
• Macro
• Navigation Pane
• Reference
• Report
• Style
• Template
• User Interface

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

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: Access 2007, Form

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: Access 2007, Report, Form

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: Access 2007, Report, Reference, Form

Color Support in Access 2007
07 September 07 07:50 PM

This is the next installment in a series of posts about Access 2007 originally made by one of our developers on the Access team on his own blog that I'm moving here for the broader audience to enjoy. "I find color schemes that I just like and that just Read More...

Postedby Zac Woodall | 4 Comments    

Filed under: Access 2007, Report, User Interface, Form, Style

Image Buttons
04 September 07 09:38 PM

This is the first installment in a series of posts about Access 2007 originally made by one of our developers on the Access team on his own blog that I'm moving here for the broader audience to enjoy. Up until this point, Access has supported command Read More...

Postedby Zac Woodall | 9 Comments    

Filed under: Access 2007, Report, User Interface, Form, Graphic

New Access 2007 Articles on Office Online
13 August 07 06:33 PM

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 Read More...

Postedby Zac Woodall | 5 Comments    

Filed under: Access 2007, Report, Macro, Navigation Pane, Template, User Interface, Reference, Form, Layout View

Sorting and Filtering in Forms
11 May 06 04:53 PM

One of the key things databases provide is the ability to sort, filter, and group data. Of course Access provides this today but Access 2007 makes it quicker and easier to sort, filter, and group data in forms, reports, and tables. Today we'll look at Read More...

Postedby Erik Rucker | 18 Comments    

Filed under: Access 2007, Form, Layout View, Filter

Better Looking Forms & Reports, Faster
25 April 06 02:53 PM

Building modern looking data forms & reports in Access 2003 can be difficult. Doing the heavy lifting is easy - there are great tools for building the data-bound portions of the form - but making the interface look great can be a challenge and can Read More...

Postedby Erik Rucker | 25 Comments    

Filed under: Access 2007, Report, Form, Style, Graphic, Access 14

WYSIWYG Form Authoring
14 April 06 01:34 PM

Last week we looked at the WYSIWYG report authoring tools , this week we'll take a look at the similar forms designer. Since forms generally don't repeat like reports do this designer looks more like the old form authoring tools than the report designer Read More...

Postedby Erik Rucker | 16 Comments    

Filed under: Access 2007, User Interface, Form

Starting from Scratch
28 February 06 04:21 PM

Sorry for the extra time since the last post, I got run over with some other work when I got back and am just getting through that. Last time, we talked about modifying the issues tracking app . This time, we'll look at starting from scratch, but again Read More...

Postedby Erik Rucker | 13 Comments    

Filed under: Access 2007, Report, User Interface, Form

Customizing the Issues Template
13 February 06 11:14 AM

Last time, we looked at the Issues tracking application that will ship with Access 12 and provide a simple place for users to get started with Access. This time, we'll look at some of the new tools available to modify that application. Each of these toolsets Read More...

Postedby Erik Rucker | 17 Comments    

Filed under: Access 2007, Report, Template, User Interface, Form, Layout View