Calculating the number of Working days

Hello any body,

Here is my problem; i use Access 2000. I have found a function named
"Nb.Jours.Ouvres" (in english : "number of working days" , all days but
Saturday and Sunday). The help says that the "reference" "msowcf.dll" has to
be activated. I did it but it does not work and this file is for "MS office
Web Components function librairy" and it seems not to be the good one.
Coulod you help me? Thank you.

Alan.

Look at this post:
http://www.accessmonster.com/Uwe/For...16565/VBA-Code

F6GGR wrote:

Quote:

>Hello any body,
>
>Here is my problem; i use Access 2000. I have found a function named
>"Nb.Jours.Ouvres" (in english : "number of working days" , all days but
>Saturday and Sunday). The help says that the "reference" "msowcf.dll" has to
>be activated. I did it but it does not work and this file is for "MS office
>Web Components function librairy" and it seems not to be the good one.
>Coulod you help me? Thank you.
>
>Alan.

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200610/1

Thank you for that soultion. I keep it for myself, but i need to have a
solution with a simple function because it is for a student of mine...
"ruralguy via AccessMonster.com" <u12102@uwea écrit dans le message de
news: 687cc26a448e2@uwe...

Quote:

Look at this post:
http://www.accessmonster.com/Uwe/For...16565/VBA-Code
>
>
F6GGR wrote:

Quote:

>>Hello any body,
>>
>>Here is my problem; i use Access 2000. I have found a function named
>>"Nb.Jours.Ouvres" (in english : "number of working days" , all days but
>>Saturday and Sunday). The help says that the "reference" "msowcf.dll" has
>>to
>>be activated. I did it but it does not work and this file is for "MS
>>office
>>Web Components function librairy" and it seems not to be the good one.
>>Coulod you help me? Thank you.
>>
>>Alan.

>
--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.
>
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200610/1
>

F6GGR wrote:

Quote:

Thank you for that soultion. I keep it for myself, but i need to have a
solution with a simple function because it is for a student of mine...
"ruralguy via AccessMonster.com" <u12102@uwe>

This should do it:

http://www.mvps.org/access/datetime/date0006.htm

http://www.mvps.org/access/datetime/date0006.htm

Do you think such clumsy, anitquated and inefficient procedures are why
"real" programmers laugh at us?

"Lyle Fairfield" <lylefairfield@aim.comwrote in
news:1162151789.157190.77790@i42g2000cwa.googlegro ups.com:

Quote:

>http://www.mvps.org/access/datetime/date0006.htm

>
Do you think such clumsy, anitquated and inefficient
procedures are why "real" programmers laugh at us?
>

Considering some of the clumsy, new and inneficient procedures I
see in C++, vb.net and other languages, No.

As to antequated procedures on the site, that's because Lyle
Fairfield has neglected his duty to create and submit better code.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Lyle Fairfield wrote:

Quote:

>>http://www.mvps.org/access/datetime/date0006.htm

>
>
Do you think such clumsy, anitquated and inefficient procedures are why
"real" programmers laugh at us?
>

I'll ask the next one I see laughing.
What do they look like?

Bob Quintal wrote:

Quote:

As to antequated procedures on the site, that's because Lyle
Fairfield has neglected his duty to create and submit better code.

http://groups.google.ca/group/comp.d...c47eee72b935ac

I thought that one was batter code but I must have been mistaken
because I can't find it as someone else's original anywhere.

rkc <rkc@rochester.yabba.dabba.do.rr.bombwrote in news:ivb1h.249$zB4.103
@twister.nyroc.rr.com:

Quote:

Lyle Fairfield wrote:

Quote:

>>>http://www.mvps.org/access/datetime/date0006.htm

>>
>Do you think such clumsy, anitquated and inefficient procedures are why
>"real" programmers laugh at us?
>>

I'll ask the next one I see laughing.
What do they look like?

They're orange, with big teeth and eyes, and their heads are pretty-well
empty. They answer to "Jack".

--
Lyle Fairfield

"Lyle Fairfield" <lylefairfield@aim.comwrote in
news:1162168332.718549.42280@e64g2000cwd.googlegro ups.com:

Quote:

>
Bob Quintal wrote:
>

Quote:

>As to antequated procedures on the site, that's because Lyle
>Fairfield has neglected his duty to create and submit better
>code.

>
http://groups.google.ca/group/comp.d...ccess/msg/4ec4
7eee72b935ac
>
I thought that one was batter code but I must have been
mistaken because I can't find it as someone else's original
anywhere.
>

It is definitely an interesting use of the datediff function..
And rather cryptic.

Have you submitted to Dev for the mvps.org site?

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Thank you for all theese solutions,

Alan

"Lyle Fairfield" <lylefairfield@aim.coma écrit dans le message de news:
Xns986BCB130D72Dlylefairfieldaimcom@216.221.81.119 ...

Quote:

rkc <rkc@rochester.yabba.dabba.do.rr.bombwrote in news:ivb1h.249$zB4.103
@twister.nyroc.rr.com:
>

Quote:

>Lyle Fairfield wrote:

Quote:

>>>>http://www.mvps.org/access/datetime/date0006.htm
>>>
>>Do you think such clumsy, anitquated and inefficient procedures are why
>>"real" programmers laugh at us?
>>>

>I'll ask the next one I see laughing.
>What do they look like?

>
They're orange, with big teeth and eyes, and their heads are pretty-well
empty. They answer to "Jack".
>
--
Lyle Fairfield