Results for:
Report

• Streamline reporting on recurring data imports

  26 Apr 2011

  Do you often have to summarize large data sets that have been extracted from your corporate database? Access can be very helpful when you need to work with a huge stream of data. We've published a new article that shows you how to make the data easier to import, analyze, and summarize in reports, even...
• Wrap text in Access

  15 Apr 2011

  How do you wrap text in Access? It's a question we hear quite frequently on Office.com. It may surprise you to learn that in most places where text is displayed in Access, text wrapping is on by default. The key is making sure there is enough room for the text to wrap. The process for doing that depends...
• Power Tip: Supercharge conditional formatting by using a bit of code

  6 Apr 2011

  Over the past few versions of Access, the product team has steadily added more conditional formatting functionality for forms and reports. For example, in Access 2010, you can add up to 50 conditional formatting rules for each object without having to write any Visual Basic for Applications (VBA) code...
• Back to the basics in Access: Reporting rapidly

  31 Mar 2011

  In the previous post , we gave many examples of how Access can really help you create a database fast and with ease. We mentioned data validation, querying, reporting, and viewing data in Excel as areas where Access is rapid and flexible. In this post I will focus on reporting. The last post mentioned...
• Power Tip: Add Sparkline-like graphs to Access reports

  10 Feb 2011

  Today's Power Tip is contributed by Philippe Bonnardell, an Access developer and contributor to the French Access forum Developpez.net . He was inspired by the new Sparkline feature of Microsoft Excel, which enables you to create tiny graphs that summarize data across many cells. Philippe worked up some...
• Mailings without the "merge"

  7 Dec 2010

  When you think of printing address labels in Office (as many of us do around this time of year), your first thought might be to set up a "mail merge" operation in which you store your data in Excel or Access, and then merge it into Word or Publisher for the final printing. However, you may not realize...
• Power Tip: Change the default behavior of controls

  25 Mar 2010

  Today’s guest blogger is Nadia Szucs, president of N-Soft , a provider of IT consulting services to businesses of various sizes in the Greater Toronto Area (Canada). N-Soft specializes in custom Microsoft Office product solutions centered around Microsoft Access implementations. I would like to share...
• Free report wizard offer from Gladstone

  6 Jul 2009

  Mike Hnatt has generously extended to the Access blog readers a FREE version of Gladstone’s Access Report Writer . Traditionally, he has sold the developer version of the wizard for $995. The offer includes unlimited computer licenses, ability to change report header and page footers, source code, and...
• Check out Gladstone's Report Writer for Microsoft Access

  27 May 2009

  Mike Hnatt at Gladstone Solutions has a nifty Report Writer utility, available at http://gladstonesolutions.com/default.aspx . The utility lets you create reports and mailing labels quickly and easily, just by stepping through a few wizard-like screens. What’s more, Mike is offering a 25% discount through...
• How to: Create a Shortcut Menu for a Form, Form Control, or Report

  21 May 2009

  Today’s guest blogger is Edwin Blancovitch. Edwin is president of Advanced Developers.net , creators of Easy Payroll , a software package to manage your human resources, payroll, scheduling, time and attendance needs. When you're designing a form or report, you may want to provide a method for...
• Roll-your-own “traffic light” icon set

  16 Apr 2009

  Posted by Chris Downs, writer, Access IW Content Team Here’s a great tip suggested by Clint Covington. Using an expression and a Rich Text text box, you can create a traffic light indicator in an Access form or report, as in the following illustrations: First, add a text box to the form or report, and...
• Video demo of conditional formatting in reports

  30 Oct 2008

  The video Watch this: Highlight values on a report by using conditional formatting is now live on Office Online. Enjoy! Edited: October 31, 2008--updated link with correct URL.
• Label saver utility

  18 Oct 2008

  Peter's Software has recently released a free utility for printing labels . Here is how they describe it: Label Saver is a freeware MS Access module that will allow your users to specify a label printing start position and a number of copies of each label to print. Using Label Saver means you don't have...
• Dot or Bang?

  30 May 2008

  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 a control - Control1, what are the differences...
• Code to make dates easier to read

  8 Feb 2008

  Today's author: Kerry Westphal, a program manager who works on the Access team. I like how many web 2.0 applications make it very easy to visualize complex data quickly. I found myself recently challenged with this task while working on a project where I wanted to display on a report an easy way to show...
• Four new video demos about reports

  17 Jan 2008

  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.
• Tips and tricks designing forms and reports

  11 Jan 2008

  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 AutoFormat based on the current form. This was...
• 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...
• Color Support in Access 2007

  7 Sep 2007

  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 feel right" - Alan Bean Figure 1: Access 2007 Color...
• Image Buttons

  4 Sep 2007

  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 buttons with text or a picture, but never both at...