Adding Hyperlink to Control Panel in Help Workshop

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ray - 30 Jul 2007 16:48 GMT

Since MS controls my date formats from the regional settings I want to enable
users to open control panel regional settings from the help file I have
created with HTML Help workshop.

Os there any way to do that. I know I will most likely need different links
for different OS's.

Ant help appreciated.

Ray

Reply to this Message

Douglas J. Steele - 30 Jul 2007 17:56 GMT

Are you suggesting you're going to suggest your users change their regional
settings? Whatever for? I know I'd quickly scrap any application that forced
me to change my settings!

Changing regional settings will affect all other programs that are running.

What problem do you think you'll solve by having the users change their date
format?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Since MS controls my date formats from the regional settings I want to
> enable
[quoted text clipped - 8 lines]
>
> Ray

Reply to this Message

Ray - 30 Jul 2007 18:12 GMT

I have an Access 2000 db that uses Canadian date formats DD/MM/YYYY and uses
these dates for range calculations. Most computers in Canada come of the
shelf with regional settings at the default US English which uses MM.DD/YYYY
format. A lot of users dont even know these settings exist let alone realize
that when their dates come out all screwed up a simple change to the regional
settings will fix it.

Do you have a different suggestion?

Ray

> Are you suggesting you're going to suggest your users change their regional
> settings? Whatever for? I know I'd quickly scrap any application that forced
[quoted text clipped - 17 lines]
> >
> > Ray

Reply to this Message

Douglas J. Steele - 30 Jul 2007 18:25 GMT

Regardless of what your Short Date format may be, Access will always
recognize nn/nn/nnnn as mm/dd/yyyy if it can. Changing their regional
settings will NOT make a query that treat 04/08/2007 as 4 August, 2007: it
will ALWAYS treat that as 8 April, 2007. It's only if the first two digits
are greater than 12 that it will correctly interpret the date as dd/mm/yyyy.

Take a look at what Allen Browne has in "International Dates in Access" at
http://allenbrowne.com/ser-36.html , or what I had in my September 2003
Access Answers column for Pinnacle Publication's "Smart Access" newsletter.
(The column and accompanying database can be downloaded for free at
http://www.accessmvp.com/djsteele/SmartAccess.html)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I have an Access 2000 db that uses Canadian date formats DD/MM/YYYY and
>uses
[quoted text clipped - 36 lines]
>> >
>> > Ray

Reply to this Message