Re: DAP that looks like a Calendar?

<cdoyle@xxxxxx> wrote in message
news:1123769125.320483.225780@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
: Hi,
: Thanks for replying.
:
: Hey if you think it will work, then I'll try it :-)
: This doesn't need to be fancy, just easy for the staff to read and see
: who isn't here.
:
: Yes that is how my table is setup. It has the Date, Employee name, and
: Description columns.
:
: How would I go about writing the VBScript to make this work? I'm not
: very familar with that, but I'm sure with some help I could get it to
: work.
:
: Thanks again
: Chris.

Here are some things to try. Not sure if this will even work since I have
not tried it but hopefully will give you some avenues to explore

First create your sub for completion of the form

<SCRIPT language=vbscript event=DataPageComplete(oEventInfo) for=MSODSC>
<!--
'call a subroutine to fill your data
yourSub
-->
</SCRIPT>

Then create your subroutine - I can try and help you with the code here, but
I'm not going to write it for you, sorry I don't have the time :(

<SCRIPT language=vbscript>
<!--
private Sub yourSub ()
perhaps a for next loop to count thru each day
set the name of the text boxes to something that ends in a number so
it can be incremented in the same loop
create a query for each date
return the query value to populate each text box
end Sub-->
</SCRIPT>

Good luck
Paul D


.

Relevant Pages

  • forcing immediate output of a subroutine
    ... I wanted to do something fancy for the user when they run my script ... I wrote this subroutine so that it ... $FlashIndex and $StatusLine are scoped globally, ...
    (perl.beginners)
  • Re: Shift vs. @_
    ... parameters passed to a subroutine and when it is appropriate to just ... sub fancy_sub { ... ...do some fancy stuff... ... my $a = shift; ...
    (perl.beginners)
  • Re: Find The Bug
    ... >> They are done inside a SUBROUTINE. ... Hey, at least I didn't invoke it with GOSUB. ...
    (comp.lang.cpp)