Oh, Fooey (F U I)

"One of the most exciting new developer features that Microsoft Office Access 2007 provides is the ability to customize the Office Fluent User Interface (UI) in your application.

The Office Fluent UI provides a new user model for exposing commands, and application navigation that is more discoverable and easier for users of the application.

You create XML to change the Ribbon, a component of the new Microsoft Office Fluent user interface (UI). You can create customization files in any text editor.

All applications that include the Office Fluent Ribbon use the same extensibility model, so you can reuse the same Office Fluent UI extensibility XML with a minimum of adjustments.

For example, you can reuse the custom XML you create for Access 2007 in Microsoft Office Excel 2007, Microsoft Office Word 2007, Microsoft Office PowerPoint 2007, or Microsoft Office Outlook 2007."

Labels: Customize, Ribbon, Tips, Tutorials

No cost tool

"The Access Developer Extensions include the following components:

• Save As Template
  Enables you to create database templates (ACCDTs) that can be featured in the Access 2007 Getting Started screen.
  
  
• Package Solution Wizard
  A wizard that creates a Windows Installer Package (MSI) to install your database and any supporting files and optionally includes the Access 2007 Runtime, or prompts the user to download the Access 2007 Runtime.
  
  
  
• Source Code Control
  Integration with Microsoft Visual SourceSafe or other source code control systems to allow check-in/check-out of queries, forms, reports, macros, modules, and data. You can also see the differences that have been made to your checked out objects."

Labels: Add-in, Customize, General, Tips

It can make life easier

Labels: Tips, Tutorials

Reformat reports

Access is not the most versatile instrument for complex formatting.

If you wish to share your findings, Access does have the ability to re-format Reports into Word documents.

Open the Report in Access and go to Tools>Office Links.
One of the choices is to "Publish It with Microsoft Word."
Here's the command in 2007-10:



When the data is sent to Word, you will be asked to confirm that you wish to convert the file to "Rich Text Format (RTF)" Click OK.

(RTF is a "universal" format. The Report can be re-saved as a Word "DOC" or "DOCX" file.)

Microsoft KB:
How to send the current record to Word 2000 with automation

Teachers on the web: Aussie SchoolHouse:
Merging Access Data with Word Documents

Use a table or query as a mail-merge data source (2007-10)


See all Topics access

Labels: General, Tips, Tutorials

Just a keystroke away

[Ctrl][Alt][Spacebar]

Labels: Entries, Forms, General, Tables, Tips

Geek fame

"You probably have a document you use over and over again, something you created to solve a particular problem. You may even find yourself occasionally sending the document to others in e-mail because it's so useful. Now you can share your clever solution with everyone who uses the 2007 Microsoft Office system!

People like you all over the world are allowing others to download and use their document templates on Office Online. Some of these templates have tens of thousands of downloads. They were submitted by people who either wanted to help others or show their great solutions. You can, too.

Labels: Customize, General, Samples, Templates

From reports and forms

Sometimes, you may not want to go to the effort of creating a report; you just need a quick hardcopy of data.

In such cases, you can simply print the Form view of your data. However, doing so also prints the background and shading associated with the form.

If you just need a quick data reference, you probably don't want to waste the resources and time to print such a detailed view. Fortunately, Access has a feature that lets you quickly print just the data from a form or report.

To do so, view the data you want to print in the form or report.

Then, choose Office button>Print>Print Preview (File >Page Setup) select the Print Data Only check box and click OK.

Doing so hides any graphics, lines, control borders, and label controls so that the print out simply contains data.






See all Topics access

Labels: General, Ribbon, Tips