Prev: Command BUtton Caption on continuous forms
Next: List box formatting
From: Don on 4 Jul 2008 15:59
I have a form with several unbound text boxes.

txtSTART_DATE
txtEND_DATE
txtTOTAL_WORK_DAYS
txtCURRENT_WORK_DAY

I've used the following code to find the values of the first two text boxes,
but I can't come up with anything to give me the last two.

Me.txtSTART_DATE = DatePart("m", DLookup("[INV_THRU]", "tblDATA")) & "/1/" &
DatePart("yyyy", DLookup("[inv_thru]", "tbldata"))
Me.txtEND_DATE = DateAdd("m", 1, Me.txtSTART_DATE) - 1

I only want to return the total work days (Mon-Fri) for the month. Then I
want to return the current number of work days worked so far, in the month.

Am I asking for something that can't be done? Any help would be appreciated.
--
Don Rountree
From: Mr B draccess at askdoctoraccess dot on 4 Jul 2008 18:17
Don,

Not to be short with you, but I would suggest that you do a search in this
newsgroup for "workdays". There are a couple of really good answers that
should get you going.

If that doen't do you some good, then come back and post here and perhaps
someone will be able to assist you.

--
HTH

Mr B
askdoctoraccess dot com


"Don" wrote:

> I have a form with several unbound text boxes.
>
> txtSTART_DATE
> txtEND_DATE
> txtTOTAL_WORK_DAYS
> txtCURRENT_WORK_DAY
>
> I've used the following code to find the values of the first two text boxes,
> but I can't come up with anything to give me the last two.
>
> Me.txtSTART_DATE = DatePart("m", DLookup("[INV_THRU]", "tblDATA")) & "/1/" &
> DatePart("yyyy", DLookup("[inv_thru]", "tbldata"))
> Me.txtEND_DATE = DateAdd("m", 1, Me.txtSTART_DATE) - 1
>
> I only want to return the total work days (Mon-Fri) for the month. Then I
> want to return the current number of work days worked so far, in the month.
>
> Am I asking for something that can't be done? Any help would be appreciated.
> --
> Don Rountree
 | 
Pages: 1
Prev: Command BUtton Caption on continuous forms
Next: List box formatting