Calculating the number of Working days

[F6GGR]

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.

[ruralguy via AccessMonster.com]

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

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

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

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

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

[pietlinden]

F6GGR wrote:

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

[Lyle Fairfield]

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

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

[Bob Quintal]

"Lyle Fairfield" <ly***********@aim.comwrote in
news:11*********************@i42g2000cwa.googlegro ups.com:

>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

[rkc]

Lyle Fairfield wrote:

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

[Lyle Fairfield]

Bob Quintal wrote:

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.

[Lyle Fairfield]

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

Lyle Fairfield wrote:

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

[Bob Quintal]

"Lyle Fairfield" <ly***********@aim.comwrote in
news:11*********************@e64g2000cwd.googlegro ups.com:

>
Bob Quintal wrote:

>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

[F6GGR]

Thank you for all theese solutions,

Alan

"Lyle Fairfield" <ly***********@aim.coma écrit dans le message de news:
Xn*********************************@216.221.81.119 ...

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

>Lyle Fairfield wrote:

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