Wednesday, December 12, 2007
Have a look at my latest posting , below I ahve placed a link to TechTrax website that explains the different types of graphical indicators within Project and how to set them up.
You can have "Traffic Light Indicators" for tasks overbudget or slipping dates, etc and Drop down menus (combo boxes) to allow the end user to only choose from the given list, e.g. Task Name , Dept ( Custom Field) etc.
PS have a Merry Xmas and New Year to all the bloggers out there !
Monday, November 19, 2007
Blogging via Word 2007 Blog Editor !!!
Yes I created this using the Blog option now within Word 2007 and then setup my Blogger account within Word to Publish directly to my Blog site.
Give it a try as you then get much better editing and formatting options supported by Microsoft Word 2007.
Tuesday, October 30, 2007
Valid input mask characters
Microsoft Access interprets characters in the InputMask property definition as shown in the following table. To define a literal character, enter any character other than those shown in the table, including spaces and symbols. To define one of the following characters as a literal character, precede that character with a backslash (\).
0 Digit (0 through 9, entry required; plus [+] and minus [-] signs not allowed).
9 Digit or space (entry not required; plus and minus signs not allowed).
# Digit or space (entry not required; blank positions converted to spaces, plus and minus signs allowed).
L Letter (A through Z, entry required).
? Letter (A through Z, entry optional).
A Letter or digit (entry required).
a Letter or digit (entry optional).
& Any character or a space (entry required).
C Any character or a space (entry optional).
. , : ; - / Decimal placeholder and thousands, date, and time separators.
(The actual character used depends on the regional settings
< Causes all characters that follow to be converted to lowercase.
> Causes all characters that follow to be converted to uppercase.
! Causes the input mask (input mask: A format that consists of literal display characters (such as parentheses, periods, and hyphens) and mask characters that specify where data is to be entered as well as what kind of data and how many characters are allowed.) to display from right to left, rather than from left to right. Characters typed into the mask always fill it from left to right. You can include the exclamation point anywhere in the input mask.
\ Causes the character that follows to be displayed as a literal character. Used to display any of the characters listed in this table as literal characters (for example, \A is displayed as just A).
Setting the InputMask property to the word Password creates a password entry text box. Any character typed in the text box is stored as the character but is displayed as an asterisk (*).
Input mask examples
The following table shows some useful input mask (input mask: A format that consists of literal display characters (such as parentheses, periods, and hyphens) and mask characters that specify where data is to be entered as well as what kind of data and how many characters are allowed.) definitions and examples of values you can enter into them.
Input mask definition
Examples of values
( ) 555-0248
MAY R 452B7
Monday, October 29, 2007
Wednesday, May 11, 2005 3:35 PM by Allister_Frost
Another handy way to add appointments to your calendar is by importing from Excel. To do this you first need to create an Excel file containing the appointment information Outlook needs. Your first row should contain columns titles which match Outlook's appointment fields. You don't need many fields to get started, just try the following for a basic import of all day appointments:
Cell A1: Subject
Cell B1: Start Date
Now add the data you'd like to import into your Outlook calendar under each of these column headings, for example: cell A2 could be "Bob's Birthday" and cell B2 could be "11/05/2005"
Now, here's the important bit. Highlight the entire range of cells that you've used (in my example this would be A1:B2) and give this range a name under Insert, Name, Define (or just type into the Name Box just above the top of column A). Outlook needs this range name so it knows where to find the data to import. Save your Excel file and close it.
Now just pop into Outlook and choose File, Import and Export. Then select Import from another program or file, hit Next, then choose Microsoft Excel and hit Next again. Now locate the Excel file you created earlier, hit Next, select your Calendar, press Next again and check that Outlook finds the correct Range Name in your Excel file. Now press Map Custom Fields to verify how Outlook is mapping your Excel column headers to its own Calendar Appointment fields, changing if necessary, then hit OK, then Finish.
If you've done everything right, your Outlook Calendar will now contain the appointments you created in Excel.
There are 22 fields you can import into Outlook in this way. These are: Subject, Start Date, Start Time, End Date, End Time, All day event, Reminder on/off, Reminder Date, Reminder Time, Meeting Organizer, Required Attendees, Optional Attendees, Meeting Resources, Billing Information, Categories, Description, Location, Mileage, Priority, Private, Sensitivity, Show time as.
Top tip: try importing in this way to your Task folder rather than your Calendar. This is a great way to move a list of 'to do' items from Excel or Project directly into your Outlook calendar.
Monday, October 22, 2007
See this link below for the Microsoft guide to Query criteria and SQL commands :
Friday, September 28, 2007
Copy and Paste the code into the VB Editor window maybe on the first sheet or the This Workbook page, Save it !!! and then test it out by running the Code from the Run icon.
PS you could create an icon on the Toolbar to run the Macro later if you are feeling brave !!
I will be adding a little bit of code here and there to the BLOG in the form of Excel Code as I find out a little more on the subject as I go along the path to becoming a VB person !! [anorak not included]
Heres some code that uses the InputBox Function to then add a number of required additional worksheets to your Spreadsheet.
' Code to create additional Worksheets
Dim myNum As String
myNum = Application.InputBox("Enter the number of additional WorkSheets required")
Worksheets.Add After:=Worksheets(Worksheets.Count), Count:=myNum
Wednesday, August 08, 2007
Saturday, July 28, 2007
obviously a lot of these sites you will have to pay for the goods !!
Also check out Microsoft Office Online site for some free templates !
And also check out :
free templates !
Note in PowerPoint 2007 you can have access to a wide range of pre set templates and colour combinations, it makes a lot of the older templates look "out-dated" by comparison.
Monday, July 16, 2007
Its a huge new version with lots of great time saving and impressive features across all the applications :
Friday, July 13, 2007
Have a nice Summer break for those of you going on holiday in 2007 !! :)
Thursday, July 12, 2007
Just done a Project 2003 course and we discovered you can set up graphical indicators for your Project Tasks or overall Project status such as a red dot for Warning, Amber and green dot aswell !
I will document the process in a later Blog, but its a New Custom Field then choose Graphical indicators, when the user selects a drop down option such as R, A or G it uses a graphic instead of text.
A more interactive approach lets you copy a Number column such as Cost or Variance and Paste link it over the top of the indicator column so it keeps changing dependant on the numbers linked to it.
more to follow ...
Monday, June 18, 2007
F1 -- Open Help
F3 -- Open Find dialog or Find pane.
F4 -- Expand dropdown menus, use arrow keys to select from list
F5 -- Refresh the current window (Outlook 2003) - Send/Receive in older versions
F6 -- Move to next window element
F7 -- Run spell check F9 -- Send/Receive
Ctrl+1 -- Inbox
Ctrl+2 -- Calendar
Ctrl+3 -- Contacts
Ctrl+4 -- Tasks
Ctrl+5 -- Notes
Ctrl+6 -- Folder list
Ctrl+7 -- Shortcuts
Ctrl+8 -- Journal
Ctrl+Y -- Folder picker dialog
Read on .....
1. On the Tools menu, point to Macro, and then click Macros.
2. In the Macros in box, click Word commands.
3. In the Macro name box, click ListCommands.
4. Click Run.
5. In the List Commands dialog box, click Current menu and keyboard settings.
6. Click OK.
On the File menu, click Print.
Thursday, May 17, 2007
JJSURF and Crabby Office Lady.
Here's the Ribbon. Note the expandable Groups such as Clipboard and Font. The Office button at top left gives you access to the File Open, Save, Print commands plus others.
Home , Insert Page Layout etc are positioned across the top of the Ribbon.
Dont worry you will soon get used to it !!!
Tuesday, April 17, 2007
Friday, March 30, 2007
Tuesday, March 13, 2007
try the following to quickly get to things in IE7 :
Ctrl D - Add to favourites
Alt Z - for the Add to favourites dropdown
Ctrl + and - for Zoom factor
Ctrl shift I - for favourites menu
Ctrl shift H - for History
Ctrl shift J - for Feeds
Ctrl N - New window
F5 - reload/refresh screen
cheers !! Jamie
Friday, March 02, 2007
my Word tip here courtesy of Microsofts Web cast on Word is to generate some text to play about within a Word doc for alignment testing , layout checking etc.
=rand(3,3) This will generate some text 3 paragraphs with 3 lines in each paragraph !
Use your own values as required. =rand(parag, lines)
Use the following to disable the macro screen updating :
Application.ScreenUpdating = False
Then = True to switch it back on again.
Wednesday, February 28, 2007
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 !]
Saturday, February 24, 2007
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 !!
Sunday, February 11, 2007
Saturday, February 03, 2007
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
Designers (including Filter by Form)
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.
Friday, February 02, 2007
Use this link for more info:
Modules: Disable Shift key: "Modules: Disable Shift keyAuthor(s)
(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."
a module, it is real easy to call, just
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
MS Access MVP"
Wednesday, January 31, 2007
Monday, January 29, 2007
His site is: htttp://j-walk.com
also author of : "The Excel 2003 Bible" and "Excel 2003 Power Programming with VBA."
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 !"
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.
=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 !
If you want to time stamp your sheets use the following :
CTRL + : snapshot of current Date
CTRL + SHIFT + ; snapshot of current Time
Copy it to a memory stick and keep a backup or transfer it to your new PC.
Sunday, January 28, 2007
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 !
Desktop Applications Training Blog
JJSurf IT Training Ltd