Unofficial Access Stuff

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Host your Web site with PureHost!

Wednesday, May 09, 2018 – Permalink –

List Box Filter

Multiple selections

Filter a Report based on List Box
Fabalou.com:

"How to open a report based on a multiple selection in a list box. For example, you may have a list of makes of car and a report that shows various details for each make of car. You want to allow the users to select a range of cars and pull up the report according to that selection."

Microsoft KB:
How to Use a Multi-Select List Box to Filter a Form

See all Topics access
Labels: General, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:17 AM

Comments: Post a Comment

Monday, May 07, 2018 – Permalink –

Canada/US Postal Codes

Automatic Input masks

If you have a mix of Canadian and US postal codes, you might play with the following code inserted as a Country control "After Update" Event property.

Private Sub Country_AfterUpdate() Dim strCountry As String strCountry = Me.Country Select Case strCountry Case "Canada" Me.[PostalCode].InputMask = ">L0L\ 0L0;;_" Case "USA" Me.[PostalCode].InputMask = "00000-9999;;_" Case Else 'If the country is not Canada or USA no input mask will be used Me.[PostalCode].InputMask = "" End Select End Sub

As a rule, if you won't be performing numeric calculations on the data, entries should be stored as text. Social Security numbers, Phone numbers and postal codes should be stored as text.

You can use alphabetic characters in an input mask. For example, one of the sample input masks is >L0L\ 0L0 used to represent a Canadian postal code.

The ">" character in the input mask converts all the characters that follow to uppercase.

The "L" character requires an alpha entry; the "0" (zero) requires a numeric entry.

A "\"character causes the following character to be displayed as a literal character rather than a mask character.

A space appears between the three character pairs.
For example, V5P 2G1 is one valid postal code that the user could enter. The mask would prevent the user from entering two sequential alphabetic characters or numbers.
See:

You can manipulate postal codes in Access by changing the data type, input mask, or format of a postal code field.

Microsoft KB 207829:
ZIP Codes in Microsoft Access.

Also see:
Postal Codes

See all Topics access
Labels: General, Reference, Tips, Tutorials

<Doug Klippert@ 3:20 AM

Comments: Post a Comment

Friday, April 27, 2018 – Permalink –

Add a Table

Drag drop trick

While working with a query in Design view, you may find that you need to add a table or query. The "book" way to do it is to click the Show Table toolbar button, drag the appropriate objects from the list, and then close the dialog box.
There is another way to do this.

Drag the table or query object's icon from the Database window/Navigation pane directly to the top half of the query design grid.

You can also use this technique in Access's Relationships window

See all Topics access
Labels: General, Reference, Tables, Tips, Tutorials

<Doug Klippert@ 3:44 AM

Comments: Post a Comment

Friday, April 20, 2018 – Permalink –

Week Numbers

Who's counting?

For most purposes, weeks are numbered with Sunday considered the first day of the week. This works most of the time, but it can be a little confusing certain years.

2004 had 53 weeks. January 1 is the only day in the first week of 2005. Week 2 starts on Sunday 1/2/2005.

Chip Pearson is the Date and Time guy:
Week Numbers In Excel

"Under the International Organization for Standardization (ISO) standard 8601, a week always begins on a Monday, and ends on a Sunday. The first week of a year is that week which contains the first Thursday of the year, or, equivalently, contains Jan-4.

While this provides some standardization, it can lead to unexpected results - namely that the first few days of a year may not be in week 1 at all. Instead, they will be in week 52 of the preceding year! For example, the year 2000 began on Saturday. Under the ISO standard, weeks always begin on a Monday. In 2000, the first Thursday was Jan-6, so week 1 begins the preceding Monday, or Jan-3. Therefore, the first two days of 2000, Jan-1 and Jan-2, fall into week 52 of 1999.

An ISO week number may be between 1 and 53. Under the ISO standard, week 1 will always have at least 4 days. If 1-Jan falls on a Friday, Saturday, or Sunday, the first few days of the year are defined as being in the last (52nd or 53rd) week of the previous year.

Unlike absolute week numbers, not every year will have a week 53. For example, the year 2000 does not have a week 53. Week 52 begins on Monday, 25-Dec, and ends on Sunday, 31-Dec. But the year 2004 does have a week 53, from Monday, 27-Dec , through Friday, 31-Dec."

The first week of 2005 should start on January 3. The first and second would be part of week 53 of 2004.

Wikipedia:
Week Dates

If your week starts on a different day, you can use the Analysis ToolPac function:
=WEEKNUM(A1, 2) for a week that starts on Monday, =WEEKNUM(A1) if it starts on Sunday.

Also this from ExcelTip.com:
Weeknumbers using VBA in Microsoft Excel

"The function WEEKNUM() in the Analysis Toolpack addin calculates the correct week number for a given date, if you are in the U.S. The user defined function shown here will calculate the correct week number depending on the national language settings on your computer."

In Access:
DatePart Function

If your work week is always Saturday through Friday then
datepart("ww",[DateField],7,1)

will return 1 for 1/1/2005 through 1/7/2005, 2 for January 8-14/2005, etc.
Otherwise use 1 for Sunday through 7 for Saturday.

The last number sets these parameters:

1, Start with week in which January 1 occurs (default).
2, Start with the first week that has at least four days in the new year.
3, Start with first full week of the year.

See all Topics access
Labels: General, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:24 AM

Comments: Post a Comment

Wednesday, April 18, 2018 – Permalink –

Entry Checks

A second chance

Unlike Word or Excel, Access does not warn you when data is changed.
Unless you make a structural or code change, Access thinks you know what you want to do and allows you to enter or change data and the close the application without a squeak.

There is a way around this:

"In Microsoft Office Access 2007+, by default, users are not prompted to confirm changes after modifying and saving records on a form. But often you might want to prompt users to confirm their changes before the record is saved.

You can use a BeforeUpdate event procedure to display a confirmation prompt and handle a user's response to either cancel or continue with the save.

This visual how-to topic illustrates how to display a custom dialog box to prompt users to cancel or continue with saving changes to a record."

User Prompts
(with a video)

See all Topics access
Labels: Customize, Entries, General, Reference, Tips, Tutorials

<Doug Klippert@ 3:19 AM

Comments: Post a Comment

Sunday, April 15, 2018 – Permalink –

Reminder-task Outlook

Sent from Access

"If you have a table that contains a date field, and you want to make sure that something happens on that date, one way is to create an Outlook task with a reminder that will pop up on the specified date; you can even use the Outlook reminder to create an email message that will be sent on the specified date.

This article will show how to create an Outlook task from Access VBA code, and send an email message when the task's reminder fires."

The file is located on Helen Feddema's site.
Access Archon
Scroll down to #126

The zip file contains the WAW article, in Word format, plus the supporting file.

Helen Feddema has been working with Word since v. 1.1, Access since the beta of v. 1.0, and Outlook since the beta of v. 8.0 (that's where Outlook started its version numbering).

See all Topics access
Labels: General, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:19 AM

Comments: Post a Comment

Saturday, April 14, 2018 – Permalink –

Default Save

Choose your own location

When you choose to save most Office files, the Save dialog box defaults to the Documents or My Documents folder.

(The following directions work in 2007+, but you need to click on the Office button in the upper left corner of the Window)

Word

you can change the default location by going to Tools>Options. On the "File Locations" tab you can modify the storage location.

Excel

Tools>Options. On the "General" tab change the default location.

PowerPoint

uses Tools>Options and the "Save" tab.

Access

Tools>Options and the "General" tab for Databases and Projects

Publisher

Tools>Options "General".

Outlook

will make you take an underground tour into the Registry to change the location to save e-mail attachments.

FrontPage/Expression Web

appears to require the same sort of spelunking.

Change the folder where e-mail messages and attachments are saved

If you don't want to change the default, but would like to be able to quickly go to an alternate site, open the Save or Save Attachment dialog box. On the left side of the box is the Places Navigation bar. If you click the Desktop icon, that location will be used to save the file.

You can add spots to the bar. Browse to the specific folder. Highlight the folder and click the down arrow beside the Tools option. Select "Add to My Places."

The file or e-mail attachment can then be saved where you want.

See all Topics access
Labels: Customize, General, Reference, Tips, Tutorials

<Doug Klippert@ 3:46 AM

Comments: Post a Comment

Wednesday, April 11, 2018 – Permalink –

Form and Data

Good combo

In Access, tables can be a bother to use for data entry.

Constructing a Form can make it easier.

Here is an MS demo about combining the two:

"While working with forms, a split form can be a very useful view because you simultaneously get two views of the form that are connected to the same data source.
This demo shows you how to create a split form view where you can use the datasheet part of the form to quickly locate a record and the form portion to view or modify the record.

You will also learn how to enhance and customize a split form view to suit your needs."

Demo

Form and data

See all Topics access
Labels: Customize, Entries, Forms, General, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:12 AM

Comments: Post a Comment

Wednesday, March 28, 2018 – Permalink –

OLAP Cubes

More dimensions than Star trek

When a company accumulates a great deal of information, it becomes un-wieldy to work with just basic Excel or Access databases.

There is a database concept called on OLAP cube (On-Line Analytical Processing).

This multidimensional collection of data can be thought of as a 3-D pivot table viewed from flat land.

MSDN:
Just What Are Cubes Anyway?
(A Painless Introduction to OLAP Technology)

Wikipedia:
OLAP

See all Topics access
Labels: General, Reference, Tips, Tutorials

<Doug Klippert@ 3:49 AM

Comments: Post a Comment

Sunday, March 25, 2018 – Permalink –

Srt Fields Defaults

Speed up table creation with default field settings

When you add fields to a table, Access assumes you want to use a 50/255-character Text field by default. However, you may typically use a smaller field size or you may personally use Number fields more often than Text ones.

You can avoid having to change the size and data types for new fields by setting defaults that are appropriate to your own design habits. To do so:

Choose Tools> Options from the menu bar and switch to the Tables/Queries sheet.

Select the data type you use most from the Default Field Type dropdown list.

Set the Text and Number sizes you usually want to use in the Default Field Sizes panel and

Click OK.

In Access 2007+ go to Access Options>Object Designers:

See all Topics access
Labels: Functions, General, Reference, Tips, Tutorials

<Doug Klippert@ 3:10 AM

Comments: Post a Comment

Thursday, March 22, 2018 – Permalink –

VBA Named Arguments

An easier read

Use named arguments for cleaner VBA code.

Most likely, you use positional arguments when working with VBA functions. For instance, to create a message box, you probably use a statement that adheres to the following syntax:

MsgBox(prompt[, buttons] [, title] [, helpfile, context])

When you work the MsgBox function this way, the order of the arguments can't be changed.

Therefore, if you want to skip an optional argument that's between two arguments you're defining, you need to include a blank argument, such as:

MsgBox "Hello World!", , "My Message Box"

Named arguments allow you to create more descriptive code and define arguments in any order you wish. To use named arguments, simply type the argument name, followed by :=, and then the argument value.

For instance, the previous statement can be rewritten as:

MsgBox Title:="My Message Box", _ Prompt:="Hello World!"

(To find out a function's named arguments, select the function in your code and press [F1].)

See all Topics access
Labels: VBA

<Doug Klippert@ 3:53 AM

Comments: Post a Comment

Tuesday, March 13, 2018 – Permalink –

Display the Current Record Number

Without navigation

You may want to remove the navigation buttons from an Access form but still display the current record number. Not the ID or serial number, but the record number that would appear in the navigation box.

To provide this feature, you can use VBA to place the form's CurrentRecord value in an unbound text box, and then update the value during the Current event.

To utilize this property, add an unbound text box to your form in Design view. Then, on the Event tab of the form's Property list, click the ellipsis or Build button. Choose Code Builder.

Add the following code in the Visual Basic Editor:

Private Sub Form_Current() MyTextBox = Me.CurrentRecord End Sub

(where MyTextBox is the name of the control that displays the record number.)

Now, when you navigate from record to record, the MyTextBox control will update automatically to reflect the current number.

See all Topics access
Labels: Customize, General, Macros, Reference, Shortcuts, Tips, Tutorials, VBA

<Doug Klippert@ 3:09 AM

Comments: Post a Comment

Saturday, March 10, 2018 – Permalink –

Quick Subforms and Subreorts

Drag 'em on over

When you need to create a subform or subreport, you probably use the Subform/Subreport tool from the Toolbox to draw where you want to add the control.

You can also create subform and subreports using drag and drop.

Simply open the main form or report in Design view, then drag the appropriate form or report from the Database window to where you want the control created.

Note that you'll still need to set Link Child Fields and Link Master Fields properties on the new control.

See all Topics access
Labels: Customize, Forms, General, Reference, Reports, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:32 AM

Comments: Post a Comment

Tuesday, March 06, 2018 – Permalink –

Filter Multiple Fields

Table sorts

In a table's Datasheet view, you can filter multiple selections in a few simple ways.

In the first method, you select one of the fields you want to filter by and click the Filter By Selection button on the toolbar. Access filters the records by that selection. Next, select the second field you want to filter by and click the button again. Access filters the records even further by this second selection. Continue to follow these steps until you have filtered by the desired number of selections.

You can also use Filter by Form. Click the icon on the toolbar. In the displayed form, enter the criteria. You can use And/Or statements, such as "Boston" Or "San Francisco".
(Access will enter the quote marks for you.)

For the third option, you use the Advanced Filter>Sort feature. To do so, select Records>Filter>Advanced Filter>Sort from the menu bar. Access displays a grid similar to the Query By Example grid. Now, drag down all the fields you want to filter by from the field list. Then, in the Criteria cells enter the values you want to filter for. When you have finished, click the Apply Filter button to see the results.

Fourth, you could use Filter by input. Right click any entry in a field you want filtered. Enter the value in the Filter For box and hit Enter. You could then choose another field and sort again by another criteria.
Creating a Query would let you save your filter, but these methods can be used to quickly display the desired information in a table.
(In 2007+ these options are on the Home tab in the Sort & Filter group)

eHow.com:
How to Filter Records in a Microsoft Access Table

Microsoft Kb:
How to filter records in an Access database

See all Topics access
Labels: General, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:19 AM

Comments: Post a Comment

Saturday, March 03, 2018 – Permalink –

Email Access Form

Question and collection

Access 2007-10 has a wizard that will walk you through the process of sending an information gathering form through Outlook. The wizard is on the External Data tab in the Collect Data group.

"You begin with the Collect Data Through E-mail Messages Wizard, which guides you through the steps of creating a form.

The form is sent through Microsoft Office Outlook 2007-10 to your recipients, with your request for new or updated information.

When the recipients reply to your message, Access automatically enters their data into your database.

Collect data by using e-mail

See all Topics access
Labels: E-mail, Forms, General, Internet, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:41 AM

Comments: Post a Comment

Tuesday, February 20, 2018 – Permalink –

Convert Access Macros to VBA

Macros to Modules

Before Access 2000, the speculation was that Access would lose "Macros" and enter the exclusive world of VBA. It hasn't happened yet.

If you have macros in a database that you would like to convert to code, doing so is easy.

In Access 97: Right-click on the macro in the Database window and then choose Save As/Export from the shortcut menu. Then, select the Save As Visual Basic Module option button and click OK. You are then given the option of adding error handling functions and comments to the new module. Select the options you want and click Convert.

In Access 2000/2002+: Right-click on the macro in the Database window and then choose Save As from the shortcut menu. Enter the name of the module you want to create in the text box and choose Module from the As dropdown list. Next, click OK. You will be given the option of adding error handling functions and comments to the new module. Select the options you want and click Convert.

In 2007 go to Database Tools and look in the Macros group.

Pearson Informit:
Taking More Control of Access
By Gordon Padwick.

Access 2007 introduced a new type of macros called embedded macros. Embedded macros are macros that are stored on an event instead of as a separate object. Embedded macros support name fix-up and are used extensively through-out our templates. They are largely targeted to information workers that don’t write code but useful for developers that are trying to perform some simple actions.

See all Topics access
Labels: Customize, General, Macros, Reference, Shortcuts, Tips, Tutorials, VBA

<Doug Klippert@ 3:21 AM

Comments: Post a Comment

Sunday, February 18, 2018 – Permalink –

What the ####

Truncated Numbers

Access has a new option that will show octothorps when the column is too narrow to display the entire value. When this option is not enabled, you see only part of the values in a column rather than ####.

You'll find the selection under Access Options when you click the Office button.
Go to Current Database and make your choice.

See all Topics access
Labels: Customize, Entries, General, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:09 AM

Comments: Post a Comment

Sunday, February 11, 2018 – Permalink –

Copy Access Data to New Records

Fewer steps

The Paste Append feature is often overlooked in Access.

This feature lets you quickly create new records that copy existing information from other records.

To see one way to use the feature, open a table in Datasheet view.

While holding down the [Shift] key, select adjacent fields with data you want to copy. You can also select fields from adjacent records.

When you've finished, press Ctrl+C to copy the data.

Then, choose Edit>Paste Append (Paste>Paste Append in 2007+)

Click Yes when Access asks for confirmation.

You'll now have an appropriate number of new records in the table that contains the information you copied.

See all Topics access
Labels: Entries, General, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:21 AM

Comments: Post a Comment

Friday, February 09, 2018 – Permalink –

Security Questions

2009-2013
This article provides an overview of the security features offered by Access 2009-2013, and explains how to use the tools that Access provides for helping to secure a database. This article also links to more detailed content about various security features.

What's new in Access security

Use an Access database in a trusted location

Package, sign, and distribute an Access 2010 database

Enable disabled content when you open a database

Use a database password to encrypt an Access database

How security works with databases from earlier versions of Access opened in Access 2010

Run unsafe expressions (disable sandbox mode)

Introduction to Security

See all Topics access
Labels: General, Reference, Tips, Tutorials

<Doug Klippert@ 3:11 AM

Comments: Post a Comment

Thursday, February 01, 2018 – Permalink –

Resize Form

It's fitting

When you switch between Design and Form views, the size of the form is dictated by the size of the Design view window, not the size of the form sections.

You often need to expand the window to be able to see the rulers and scroll bars in addition to all of the sections. This means you're left with wasted space when viewing the form in Form view, assuming that you forget to shrink the window back down.

A solution to this annoyance is to use the Size To Fit Form feature.

Simply view the form in Form view and choose Window>Size To Fit Form from the menu bar. If your view of the form is maximized, the menu option will be unavailable and you'll need to click the Restore Window button on the form window to enable the choice.

Once Access has resized the form, you can save its current dimensions by clicking the Save button.

With Access 2007+ go to the Office button, choose Access Options and click Overlapping Windows. The Size To Fit Form icon will appear on the Home tab.

See all Topics access
Labels: Customize, Forms, General, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:01 AM

Comments: Post a Comment

Thursday, January 25, 2018 – Permalink –

Quickly Query Table Names

Change by code

If you've ever developed a dozen or more complex queries, then had to change one of the table names, you know how frustrating it can be to all but rebuild the queries in the Query Design view grid by changing the table name in each cell.

One quick alternative is to choose View >SQL View while the query is open and then cut and paste all the SQL code into Word.

Next, do a Find and Replace, changing all the instances of the old table name to the new table name.

Finally, copy and paste the SQL statements back into the SQL view of your Access queries.

When you go back to the QBE, the new table will replace the old one.

See all Topics access
Labels: General, Queries, Reference, Shortcuts, Tables, Tips, Tutorials

<Doug Klippert@ 3:06 AM

Comments: Post a Comment

Tuesday, January 23, 2018 – Permalink –

Office VBA Tricks

Video + Free code

"Learn tips and use sample code for several Office applications. These tips can help you to be more productive and can also be a starting point for developing your own tools, utilities and techniques."

Update Word Document Statistics in the Title Bar

Create Outlook Rules Programmatically

Delete Repeated Text Throughout a Word Document

Run Macros Based on the Value of One or More Excel Spreadsheet Cells

Disable Related Controls on a PowerPoint Slide After a User Clicks an Input Control

Display Reminder Information When a User Opens an Office Document

Synchronize an Access Main Form to a Subform and Vice Versa

Log Worksheet Changes to an XML File

Merge Body Text from Multiple Outlook E-mail Messages to a Word Document

Use the Office Assistant as an Alternative to Displaying and Retrieving User Input

Ten Tips for Office VBA Developers

VBA Tips & Tricks

Getting Started with VBA in Office 2010

Download Office 2013 VBA Documentation

(VBA is VBA and is, in most cases, usable in all versions of Office)

See all Topics access
Labels: Reference, Tips, Tutorials, VBA

<Doug Klippert@ 3:01 AM

Comments: Post a Comment

Saturday, January 20, 2018 – Permalink –

Add Objects to the Query Grid

Easy additions

If you need to add a table or query to a query you're building in Design view, you most likely click the Show Table button, drag the appropriate objects from the resulting dialog box, and then close the dialog box.

However, there's a much easier way to do this.

Simply drag the table or query object's icon directly to the gray background of the query design grid. This same technique also works with the Access Relationships window.

See all Topics access
Labels: General, Queries, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:16 AM

Comments: Post a Comment

Sunday, December 24, 2017 – Permalink –

Null Parameter

Show something

If a user doesn't specify a parameter value, you can use a wildcard with the parameter in the format

Like [Enter Name] & "*"

The problem with this is that the query will return records that partially match the criteria.

For instance, if users searching for records based on last name enter a parameter value of "Smith" they'll also get the records for Smithers, Smithfield and Smithson.

Another problem is that the parameter query will ignore any records where the field being searched contains a Null value when you try to return the entire recordset with a blank parameter.

To fix this, set up a query to limit responses to explicit parameter entries, but still allow users to return all records by leaving the parameter blank.

If you're searching for LastName, open the query design grid and add LastName to it.

In the Criteria row for the field, enter the parameter prompt

[Enter Name]

Then, in the next blank column of the design grid, enter the same parameter (everything between and including the square brackets) in the Field text box.

Finally, in the Or row, enter the criteria Is Null .

If you're using any additional criteria for other fields, make sure to copy that criteria to the Or line as well.

See all Topics access
Labels: Customize, Entries, General, Reference, Tips, Tutorials

<Doug Klippert@ 3:56 AM

Comments: Post a Comment

Monday, December 11, 2017 – Permalink –

Change Access Ribon

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+."

Customizing Ribbon in Access 2007

See all Topics access
Labels: Customize, Reference, Ribbon, Tips, Tutorials

<Doug Klippert@ 3:24 AM

Comments: Post a Comment

Thursday, December 07, 2017 – Permalink –

Access Developer Extensions

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."

Developer Extensions

See all Topics access
Labels: Functions, General, Tips, Tutorials

<Doug Klippert@ 3:31 AM

Comments: Post a Comment

Tuesday, December 05, 2017 – Permalink –

Send Access to Word

Reformat reports

Not everyone has Access installed on his or her machine.
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+:

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 with automation

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

See all Topics access
Labels: General, Merge, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:07 AM

Comments: Post a Comment

Friday, December 01, 2017 – Permalink –

Update Data to Default

Just a keystroke away

You probably know that you can set up a default value for Access to enter into a field when a new record is created. This can be done in the Design view for a table or form by setting the Default Value property.

Unfortunately, you sometimes may set a default value after you've already entered records into the database. When you do so, the existing records aren't automatically updated to equal the new default.

However, if you're editing a record and you want to update the field to the current default, you can do so with a keystroke shortcut. To do so, simply select the appropriate field and press

[Ctrl][Alt][Spacebar]

See all Topics access
Labels: General, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:54 AM

Comments: Post a Comment

Saturday, November 25, 2017 – Permalink –

Print Raw Data

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, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:02 AM

Comments: Post a Comment

Thursday, November 23, 2017 – Permalink –

Zoom Box Fonts

Customize

Change the appearance of text in Access' Zoom box

Access' Zoom box, allows you to display the contents of a text box in a dialog box for easier editing and viewing. Although viewing long expressions is more convenient in the Zoom box, it is still sometimes difficult to follow what is displayed due to the font Access uses by default.

Access 20xx allows you to change the font that the Zoom box uses. To display the Zoom box, select the text box you want to expand and press Shift+F2. Then, just click the Font button, set the options you want, and click OK. The settings you select are used whenever you display the Zoom box during your current instance of Access. However, the next time you start Access the Zoom box font settings will revert to their defaults

See all Topics access
Labels: Customize, Fonts, Forms, Reference, Tips, Tutorials

<Doug Klippert@ 3:36 AM

Comments: Post a Comment

Sunday, November 19, 2017 – Permalink –

Runtime and PDF

Add-in's complete

Great news, you can now redistribute and use the PDF and XPS add-in with your Runtime solution.
The Runtime's code has not been changed. Your existing runtime solutions can now officially be distributed with the PDF and XPS add-in by chaining the .msi for PDF and XPS into your install process for your app (after the Runtime).

You may copy and distribute the object code form of the add-in listed below together and for use only with the Microsoft Office Access Runtime software, subject to the license terms accompanying the Microsoft Office Access 2007 Runtime software download:

2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS (located at PDF add-in download)

Runtime for Access

See all Topics access
Labels: General, Reference, Runtime, Tips, Tutorials

<Doug Klippert@ 3:40 AM

Comments: Post a Comment