Posts for 09/2009

28 September 2009 - 13:46

Limitations in MS Project

There are a couple of limitations in MS Project which probably will never 'limit' you, till the day of course you really need to go beyond.

One such example could be the latest day till which you can schedule. That hasn't changed in MS Project 2007 and still is 31 dec 2049 (and indeed people who need such days for good reasons exist, as I discovered today through a course participant working on dismantling nuclear power stations !).

A limitation which I always found, well .. limiting, is the maximum space of about 10 to 12cm you can code for the legend text box, or the limitation of using 3 lines in this text box.
Just another example... so if ever you want a nice overview of some limitations in MS Project 2003, you'll find them at Microsoft Office Online. Luka Gospodnetic lists simular, but not always matching figures on his blog for MS Project 2007.

(0) Comments ·
20 September 2009 - 12:12

Centering horizontal menu in CSS

Rob Glazebrook recently posted a sample of a super simple horizontal navigation bar with CSS.
It's always great to have simplicity - something which isn't always the case, especially with CSS - so I'm just promoting the approach here as well :-)

Along the post someone asked for a solution to center the horizontal menu in CSS.
Well centering in CSS is also something simple generally; you basically put the object to center in a container which you style with auto-left and right margins. Something like

#menuHolder {margin:0 auto;}

Of course with menus you can always expect 'unexpected' behavior; so for some robust techniques on the matter Stu Nicholls is your man - he has been tireless in publishing huge amounts of code on his site; You'll find two very simple implementations of this technique over here:

(0) Comments ·
14 September 2009 - 12:07

Shared mode in an Access database - who’s in?

If you're using Access in shared mode, you might be wondering who's currently using the database.

Well this information is actually stored in the *.ldb file (pre Access 2007) or *.laccdb file (Access 2007).
This file automatically opens when you open your Access database in shared mode (this is the default - you can open a database in Exclusive Mode, through the options of the File/Open window) - it manages users and record locking in shared mode.
And you can actually read this file, you only need a more advanced text editor. However, Microsoft offers a special tool, called Jet utilities, containing a LDB viewer which withdraws more exact information about your connected users; you can download it here : http://support.microsoft.com/kb/176670. It also seems to working under Access 2007.

For any problems with the lockfile, you might go through this article: http://support.microsoft.com/kb/299373/EN-US/

And if you want to list users and access through VBA code, this is possible to; for a nice module on this topic go here: http://support.microsoft.com/kb/285822/

(1) Comments ·
09 September 2009 - 04:39

Default database & templates in Access 2007

When you'd like to create a default database in Access 2007, containing your preferences, settings, tables, forms, modules and so on of your choice, you can do so more or less as before in previous versions of the program.
Basically you'll have to create a new database, save it in the system's or your profiles' Templates folder for Access and just make sure you've made all changes in preferences and imported all objects you want by default.

You'll find the procedure nicely described on the Office Online Section for Access or also at Allen Brown's pages: http://allenbrowne.com/ser-43.html#dbtemplate.

templates folder and database in Access

But new in Access and a really cool feature is the possibility to use Database Templates (accdt files). Those Templates files are available from the Access Getting Started Page and are presented in different Template categories in the left navigation area.
To create such Database Templates files you'll need the Access Developer Extension tools (ADE), which is not included in the default install files. You can download this package at the Microsoft Download center.

Once installed you'll find a link on the Office Button at the bottom: Developers / Save As Template - once you've saved your template in one of the dedicated Templates folders (see previous section), your templates become automatically available from the Getting Started window.

(1) Comments ·
07 September 2009 - 04:03

Deploy Trusted Locations in Office 2007 system

If ever you need to deploy Trusted Locations in one of the Office 2007 programs and / or want to understand a bit more about the 'Group Policy Object Editor' here's the official Technet link: http://technet.microsoft.com/en-us/library/cc178948.aspx.

And following discussion might throw some light as well: http://www.access-programmers.co.uk/forums/archive/index.php/t-136411.html
(0) Comments ·
Page 1 of 1 pages