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 !!!

http://www.microsoft.com/downloads/details.aspx?familyid=4D951911-3E7E-4AE6-B059-A2E79ED87041&displaylang=en&Hash=7%2bTy7ugkpmBwPRVL1Dq%2bud8w4FvNSDiedrzTno1LEPanuBQ5lr9saQcf21CDLnfwrBkog1DAUmX5D3bL74r2kg%3d%3d

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


http://office.microsoft.com/en-us/excel/HA011366161033.aspx?pid=CL100570551033

Thanks

Do you need a TAP qualification ?

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

http://www.trainingfoundation.com/

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 !)

http://www.officezealot.com/

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

see the link below:

http://msdn2.microsoft.com/en-us/library/aa167840(office.11).aspx

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:

http://msdn2.microsoft.com/en-us/library/aa167800(office.11).aspx#odc_acbasicsofruntime_introduction

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

http://mvps.org/access/general/gen0040.htm

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

http://www.mvps.org/access/api/api0021.htm

--
Wayne Morgan
MS Access MVP"

The Wow starts now !!!

Yes folks Windows Vista is launched today so go and take a look at the link below :

please visit www.windowsvista.co.uk.

John Walkenbach - Excel Guru !

Check out Johns website, he is the author of many books including The Dummies guides - Excel VBA Programming for Dummies !

His site is: htttp://j-walk.com

also author of : "The Excel 2003 Bible" and "Excel 2003 Power Programming with VBA."

Keyboard Shortcuts are back in fashion

Most people love a few keyboard shortcuts to help speed up things in Word, Excel and other applications.
I will be compiling a list for each application although quite a few work on all packages.

So get ready to be aware of what F5 does in Excel and F9.
What does CTRL + Scroll wheel do in Excel ?
WOW it zooms in to the worksheet ( very handy for a trainer with the projector).

"Shortcuts are back in fashion as many will testify, if your cordless mouse battery packs in on the train you will wish you paid attention to those keyboard shortcuts !"

Using dynamic and static dates in Excel

hi again,
We all need to put dates and times into Excel to "timestamp" orders, deliveries and sales invoices etc.

The dynamic functions:
try putting 10,000 into a cell and format it with CTRL + 1 .
Set it to a date format. What date do you get ??? Strange but true !
Excel operates using the 1900 date system, so its 10,000 days after 1st Jan 1900. Hence 18th May 1927.

So with this in mind we can put calcs into your worksheets.

Try :

=TODAY() for todays date
=NOW() for current date and time

These will update automatically each time you recalc the sheet or open it next day !

Static Dates
If you want to time stamp your sheets use the following :

CTRL + : snapshot of current Date
CTRL + SHIFT + ; snapshot of current Time

Nicknames in Outlook

If your wondering how to save the predictive typing when you type in someones email address then its called "Nicknames" in Outlook. Its saved to a file called Outlook.NK2, so search your pc for this type of file using *.nk2

Copy it to a memory stick and keep a backup or transfer it to your new PC.

Jamie

Get into the groove ....

Use this link below to have a look at Microsoft Groove, a great new collaboration tool from Microsoft :

http://www.microsoft.com/uk/atwork/office/groove2007.mspx

Thanks
Jamie

MS Office Newsletter

Hi. I receive this newsletter every month and thought you might like to take a look. The latest issue can be found here - http://www.microsoft.com/uk/atwork/newsletter. If you like what you see and want to get it yourself just sign up!

Google Docs and Spreadsheets

Don't forget other options are closing in on Microsoft !
Have a try at Google's offerings !!!

http://docs.google.com/

A Blog of MS Office tips, tricks and golden nuggets !

Hi all, welcome to my blog !

I will be compiling an ongoing blog of MS Office training "extras" to complement the training courses I deliver for QA-IQ.

This will be split into Windows, Excel, Word, Access and PowerPoint, plus other packages like Project, OneNote etc.

Thank you !

Jamie