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!

Saturday, February 26, 2011 – Permalink –

Access Tutorials

Learning Sites

Microsoft has created a web site for Office. Part of the site is devoted to tutorials touching on:

Word, Access, Publisher , Outlook, PowerPoint, InfoPath , Excel, Visio, OneNote, Expression, and Project.

The Access lessons are located here:

2010 Access Tutorials

2003 Access Tutorials
2007 Access Tutorials

Here are some other sites:

FunctionX Access tutorials

TutorialUSA.com

Access Tutorials, Basic

Bay City Public Schools

See all Topics access
Labels: General, Tutorials

<Doug Klippert@ 3:59 AM

Comments: Post a Comment

Wednesday, February 23, 2011 – Permalink –

Flag Access Controls

Tag Property

The TAG property allows you to associate up to 2,084 characters of text with any form, report, section, or control. This is especially helpful when you want to single out a specific subset of controls.

For instance, say that you want to hide certain controls on a form when a user clicks a button.
You can flag which controls will be hidden by entering the word "Hide" (or any other consistent word) in each control's Tag property. Then, attach the following code to the command button's Click event procedure:

Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "Hide" Then ctl.Visible = False End If Next

See all Topics access
Labels: Customize, Forms, General, Properties, Tips

<Doug Klippert@ 3:56 AM

Comments: Post a Comment

Wednesday, February 16, 2011 – Permalink –

Auto Number

Don't be smart

There should not be any "intelligence" in an AutoNumber field. It is meant as an index field and not anything else.

If the need should arise to reset the field, if your table does NOT contain any records, simply compacting the database again will set the Autonumber field back to 1.

Another way would be to delete the AutoNumber field and re-insert it in the table.

Here's a long way to start at a specific number.

Create your table with an AutoNumber type field, but don't enter any records.

Create another table with only a single Long Integer Number type field.

This field must have same name as the AutoNumber field in the first table.

Enter one record in the second table that is a number one less than the required start of the AutoNumber for the first table.

Now create an append query to append the record in the second table to the first table and run the query.

You can now delete the second table and begin entering your data into the first table.
Also: Access AutoNumber Reset

"This is some sample code that shows how to programmatically reset all AutoNumber fields in an Access Database to a correct value (whether it be 0 or the max value + 1). In addition, it contains code for Compacting and Repairing an MS Access Database. This is perfect for people who are working with a complicated Access Database and have experienced AutoNumber bugs!
And: Creating an AutoNumber field from code

See all Topics access
Labels: Customize, General, Tables, Tips, VBA

<Doug Klippert@ 3:04 AM

Comments: Post a Comment

Monday, February 14, 2011 – Permalink –

Creating Hyperlinks in Access Tables

Simply

When you populate a hyperlink field in a table, you probably cut and paste the URL from your browser into the Insert Hyperlink dialog box.
There's an even easier way to do this using Internet Explorer.

First, open the Access table you're updating and Internet Explorer.

Select the hyperlink field you want to create the link in and choose Insert >Hyperlink from the menu bar.

Press Alt+Tab or use your mouse to select the browser window.

Browse to the page you want to link to and then switch back to Access.

You'll find that the URL is automatically inserted in the dialog box.

See all Topics access
Labels: Entries, General, Internet, Tables, Tips

<Doug Klippert@ 3:04 AM

Comments: Post a Comment

Sunday, February 13, 2011 – Permalink –

Keyboard Shortcuts

Extra pilcrows?

Here is a list of keyboard shortcuts I once or never knew.

The one that struck me was:

Ctrl Alt K — Remove extraneous paragraph marks.

This removes doubled pilcrows (¶¶).

Word-Tips

Alt F6 — Swap open documents

Alt Shift D — Insert date

Alt Shift Up/Down — Move table rows or paragraphs up or down

Shift F5 — Go back to last position

Shift F3 — Change case

Ctrl Space — Remove direct formatting

Ctrl Q — Remove paragraph formatting

Ctrl Shift N — Apply Normal style

Ctrl Y — Repeat action

Ctrl ] — increase font size by 1pt

Ctrl [ — decrease font size by 1pt

Ctrl Shift > — Increase font to next size up

Ctrl Shift < — Decrease font to next size down

CDEV Computing is managed by Chris Devrell located in Southampton UK.

See all Topics access

<Doug Klippert@ 8:05 AM

Comments: Post a Comment

Wednesday, February 09, 2011 – Permalink –

Split Access Database

Separate tables

You don't need to keep all of your data in one file. You can split your MDB file into data and application files.

"Even if all your data is in Access itself, consider using linked tables. Store all the data tables in one MDB file - the data file - and the remaining objects (queries, forms, reports, macros, and modules) in a second MDB - the application file.
In multi-user situations, each user receives a local copy of the application file, linked to the tables in the single remote data file."

Maintenance: To update the program, just replace the application file.
Since the data is in a separate file, no data is overwritten.

Network Traffic: Loading the entire application (forms, controls, code, etc)across the network increases traffic making your interface slower.

In some cases you will link additional files:

Static look-up data such as postal codes might be kept in its own file.

Linked temporary tables might avoid the need to compact the application file.

From Allen Brown's tips for Access users
Access has a tool to do the splitting for you, go to: Tools>Database Utilities Database Splitter
In Access 2007:

On the Database Tools tab, in the Move Data group, click Access Database.

In the Database Splitter dialog box, click Split Database.

Type a name for the back-end database, and then click Split.

Also:
Knowledgebase: How to manually split a Microsoft Access database
MSDN: About sharing an Access database on a network

See all Topics access
Labels: General, Tips, Tutorials

<Doug Klippert@ 3:19 AM

Comments: Post a Comment

Sunday, February 06, 2011 – Permalink –

Runtime for Access

Free Download !

Access is not included in the basic Office 2007+ suites. If you want to distribute your database projects to others in the office, you'll need this download.

The Access 2003 Developer Extensions cost about $500. The 2007-10 downloads are free!

"Microsoft Office Access 2007 provides a rich platform for developing database management solutions with easy-to-use customization tools.

If no end-user customization is required (including report modifications), you can choose to distribute those Access 2007 solutions so that they run without requiring a full installation of Access 2007.

To do so, you must package and distribute your application with the Access Runtime.

The Access Runtime is similar to previous runtimes in that all design-related UI is either removed or disabled.

You do not need to buy any special SKU in order to redistribute the Access Runtime. You can freely redistribute it or point users to this download."

Access 2007 Runtime

Access 2010 Runtime

See all Topics access
Labels: Add-in, General, Runtime, Tips

<Doug Klippert@ 3:18 AM

Comments: Post a Comment

Tuesday, February 01, 2011 – Permalink –

Indent Code

Realign a bunch

Indenting blocks of VBA code, such as statements within loops or If...Then statements, makes reading a procedure much easier.

You probably indent a code statement using the [Tab] key, and outdent by using [Shift][Tab].

However, you may not be aware that the [Tab] and [Shift][Tab] techniques also work when multiple code lines are selected.

The Visual Basic Editor also provides Indent and Outdent buttons on the Edit toolbar that allow you to easily reposition blocks of code.

See all Topics access
Labels: VBA

<Doug Klippert@ 3:22 AM

Comments: Post a Comment