Enter your email address:

Delivered by FeedBurner



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












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



  Saturday, May 23, 2009 – Permalink –

Compact-Repair Shortcut

Desktop convenience


You can make compacting and repairing databases easier by providing a desktop shortcut.

Right-click on the Windows desktop and select New>Shortcut from the shortcut menu. Then, set up a Command Line entry in the form:

"Path to Access.exe" "Path to Database.mdb" /compact

For example, to create a shortcut to compact Northwind, you might use:

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb" /compact

Click Next and continue through the shortcut setup wizard, naming the shortcut appropriately.

In Access 2000+, the database is both compacted and repaired when the /compact switch is applied.

Access 97 executes these processes separately, so Access 97 shortcuts should use a Command Line in the form:

"Path to Access" "Path to Database" /compact /repair

Also note that you can compact to a different location by specifying a target database name after the /compact switch.

If you omit a target file name following the /compact option, the file is compacted to the original name and folder. To compact to a different name, specify a target file.

If you don't include a path in target database or target Access project, the target file is created in your My Documents folder by default.

(Even though a shortcut will open the database without it, in order for the command line flag to work, you MUST include the path to the executable - Access.exe)




See all Topics

Labels: ,


<Doug Klippert@ 3:31 AM

Comments: Post a Comment


  Sunday, May 17, 2009 – Permalink –

New Fields from Datasheet View

Table fields on the fly



We all, of course, pre-plan our table layouts. However, if you need to create a table field while working in Datasheet view, you don't have to switch to Design view.

There's a quick way to create a field from Datasheet view.

Right-click on the column heading of the column you want to the right of your new field.
Choose Insert Column from the shortcut menu.

Access creates a field with a name such as "Field1".

You can then immediately start entering data in. You can also use the shortcut menu to rename or delete the newly created field.

Later you can go to Design view to set the field's properties.




See all Topics

Labels: ,


<Doug Klippert@ 3:19 AM

Comments: Post a Comment


  Sunday, May 10, 2009 – Permalink –

Shortcuts to Access Objects

Quick way in


If you often work with a certain Access objects (specific forms, queries, etc.) in a database, you can create a shortcut to it on your desktop.

Click on the Object and drag it to the desktop..


Access will create the shortcut on your desktop, or another location.




See all Topics

Labels:


<Doug Klippert@ 3:18 AM

Comments: Post a Comment


  Wednesday, May 06, 2009 – Permalink –

Who was that font I saw you with last night?

That was no font, that was my typeface


You can find the Fonts supplied with some Microsoft products
Select a product name from the list to get a list of fonts supplied with that product.

Microsoft's Typography is an interesting site to poke around in.

Here are some books I use for reference material:

Words into Type

by Marjorie E. Skillin, Robert Malcolm Gay ISBN 0139642625


Stop Stealing Sheep & Find Out How Type Works


by Erik Spiekermann, E.M Ginger ISBN 0201703394


The Elements of Typographic Style

by Robert Bringhurst ISBN 0881791326

A font can be defined as a collection of characters with the same style and size. A typeface is the design of the characters regardless of size or style. The terms are used interchangeably today.




See all Topics

Labels:


<Doug Klippert@ 3:12 AM

Comments: Post a Comment


  Sunday, May 03, 2009 – Permalink –

Crosstab Query Column Headings

Using Month Numbers


If you display a crosstab query as a datasheet, consider using a month's or day's number as a column heading instead of a text abbreviation (e.g., 1 instead of Jan or January, or 2 instead of Mon).

Text abbreviations are sorted alphabetically. Apr appears before Feb, Mon appears before Sun, etc. Number representations will sort in their proper order.




See all Topics

Labels:


<Doug Klippert@ 3:03 AM

Comments: Post a Comment