Wednesday, February 28, 2007

Accessing other users Mailboxes in Outlook 2003

To create a link to someone elses mailbox do the following :

Go to Tools Options and then Email Accounts and View or Change your existing entry. presumably exchange server, then click onto Change - More Settings - Advanced then Add another mailbox by entering its correct name. and ok all screens.
You can now see the seconadry mailbox listed below yours [ you will need permissions from the owner setup to access the mailbox aswell !]

PDF add-in for Word 2007

Use this link below to download and install the add-in to allow you to create PDF's direct from your Word documents !!!

Saturday, February 24, 2007

Filter for unique records

Filter for unique records :

Select the column or click a cell in the range or list you want to filter.
On the Data menu, point to Filter, and then click Advanced Filter.

Do one of the following :

To filter the range or list in place, similar to using AutoFilter, click Filter the list, in-place.
To copy the results of the filter to another location, click Copy to another location. Then, in the Copy To box, enter a cell reference.
To select a cell, click Collapse Dialog to temporarily hide the dialog box. Select the cell on the worksheet, and then press Expand Dialog .
Select the Unique records only check box.

Thanks MS Help for this one !!

Finding and marking Duplicates via conditional Formatting

This is for the frustrated people who need to find and locate duplicate entries such as invoice numbers etc. in Excel


Sunday, February 11, 2007

Do you need a TAP qualification ?

Then have a click on the link below ....

Saturday, February 03, 2007

Running in Runtime vs. Full Access 2003

Access 2003 Runtime is, in essence, Microsoft Access 2003, but with a few key features disabled. A user with Access 2003 Runtime installed instead of full Access can open and run an Access application (either an MDB file or, with a few extra steps, a SQL Server back-end database) but does not see the Database Window and cannot switch the view of any Access object to Design view.
The following features are not included as part of Access 2003 Runtime without additional customization:
The Database window
Title bar text/icon (can be specified by the MDB instead of by Access)
Some menu items, such as Open and Save in the File menu, and the entire View, Format, and Tools menus
Shortcut menus
Built-in toolbars
Access Help
Designers (including Filter by Form)
VBA editor
The Figure above shows two instances of the same minimal MDB application. The instance on the left is running using Access Runtime, and the instance on the right is running in full Access. Not only is the difference stark, but the Access Runtime instance does provide a direct UI for opening objects as the intent is for developers to create the UI for this purpose.
Figure 1. An Access Runtime instance of a sample application compared to a full Access instance of the same application
The developer of an application destined for an Access Runtime environment must create the application in such a way that the "missing" features of Access in the Access Runtime version are not obvious to the user.

Another Office website ( with Blogs !)

Friday, February 02, 2007

Best Practices When Using Access 2003 in a Multi-user Environment

see the link below:

Deploying an MS Access Database ?

Try using the MS Access 2003 runtime version as it will NOT include Toolbars, menus and VB Editor so users will not be able to edit and hack into your application.

Use this link for more info:

Modules: Disable Shift key

MSAccess :

Modules: Disable Shift key: "Modules: Disable Shift keyAuthor(s)
Dev Ashish

(Q) I want to disable the Shift key so that users cannot bypass the Autoexec macro. How can I do this?
(A) Under Access 2.0, the only way would be to use a runtime version.
Under Access 95/97, you can set the AllowBypassKey property which disables Shift. Search Access help for all the info and code you'll need.
Also see General: Securing AllowBypassKey."

Delay or Wait Subroutine - MS Access

Delay or Wait Subroutine - MS Access: "You may also want to look at the Sleep API call. Once you set the API reference for it in
a module, it is real easy to call, just

Sleep LengthOfTime

The advantage of this, is that it releases resources for other apps running on the system
to use. You can find more information about this at

Wayne Morgan
MS Access MVP"

Search This Blog

Desktop Applications Training Blog

Jamie Johnson
JJSurf IT Training Ltd