By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,347 Members | 2,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,347 IT Pros & Developers. It's quick & easy.

Calculating the number of Working days

P: n/a
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.
Oct 29 '06 #1
Share this Question
Share on Google+
10 Replies


P: n/a
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

Oct 29 '06 #2

P: n/a
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

Oct 29 '06 #3

P: n/a

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

Oct 29 '06 #4

P: n/a
http://www.mvps.org/access/datetime/date0006.htm

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

Oct 29 '06 #5

P: n/a
"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

Oct 29 '06 #6

P: n/a
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?
Oct 29 '06 #7

P: n/a

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.

Oct 30 '06 #8

P: n/a
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
Oct 30 '06 #9

P: n/a
"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

Oct 30 '06 #10

P: n/a
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

Oct 30 '06 #11

This discussion thread is closed

Replies have been disabled for this discussion.