Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Wednesday, February 06, 2008 – Permalink –

Quick Subforms and Subreports

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

Labels: , ,


<Doug Klippert@ 7:03 AM

Comments: Post a Comment

  Monday, January 07, 2008 – 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.
  1. While holding down the [Shift] key, select adjacent fields with data you want to copy. You can also select fields from adjacent records.
  2. When you've finished, press Ctrl+C to copy the data.
  3. Then, choose Edit>Paste Append (Paste>Paste Append in 2007)
  4. 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

Labels: ,


<Doug Klippert@ 8:04 AM

Comments: Post a Comment

  Tuesday, December 11, 2007 – 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 Access's Relationships window.



See all Topics

Labels: ,


<Doug Klippert@ 8:04 AM

Comments: Post a Comment

  Wednesday, October 03, 2007 – 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

Labels: ,


<Doug Klippert@ 7:59 AM

Comments: Post a Comment