Dayoffs
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 18 articles for 0.302 sec
Set rst = Currentdb.OpenRecordset("YourTable", dbOpenDynaset) this line opens the table and establishes the recordset object. dtmLoopDate = DateAdd("d",1,Me.txtOffDate) This line initialized the date varialbe you will use to write new records the the database. For info on the DateAdd function, see VBA Help. Where you put the code depends on how you want your form to work.     

Group: relcom.hotnews · Group Profile · Search for Dayoffs in relcom.hotnews
Author: "Lenta.RU"
Date: Sep 8, 2008 02:30

Thank you so much for the quick response! I am a beginner at best in Visual Basic and writing code so I am a little confused. I understand how to modify the code from the "With rst" down to suit my database but I do not understand the first two lines. Could you please explain what they mean and also tell me where I insert the code? "Klatuu" wrote: You could add records to the table
Show full article (0.55Kb)
You could add records to the table with a loop. Since your form will add a record for the original date entered, you want to start with the next day and add records until you get to the last date. Set rst = Currentdb.OpenRecordset("YourTable", dbOpenDynaset) dtmLoopDate = DateAdd("d",1,Me.txtOffDate) With rst Do Until dtmLoopDate > Me.txtLastOffDate .AddNew     

Group: microsoft.public.access.forms · Group Profile · Search for Dayoffs in microsoft.public.access.forms
Author: Klatuu
Date: Jul 24, 2008 10:12

Hello all.. I have userform, not linked to tables. I have textboxes which I caluclate data from and then input that into tables. So what I want to do is, make a budget program. The user enters a brand new job, with a start date, end date, pay freq and rate and everything else. Right now when this happens, I have it calculating the expected pay every pay perird from now till an end date
Show full article (2.47Kb) · Show article thread
On 12 Dis, 15:52, bc...@FreeNet.Carleton.CA (Eleonore Beaudoin) wrote: > Nil (janila...@gmail.com) writes: > > On 11 Dis, 15:55, bc...@FreeNet.Carleton.CA (Eleonore Beaudoin) wrote: > >> "Ollie Sandcastle" (noth...@omegapoint.com) writes: > >> > But (I shouldn't start a sentence this way) what about - FOUND OBJECTS? > >> > Especially ones in dreams. > > >> > What of those, pray? > > >> You     

Group: microsoft.public.access.forms · Group Profile · Search for Dayoffs in microsoft.public.access.forms
Author: AccessIM
Date: Jul 24, 2008 10:01

This is guaranteed spam from unconfirmed opt-in mailing lists for spurious addresses at poopypants.com or other vanity domains. hormboy@fw.merk.com is a USENET spamtrap seed. ---------------------- From jqsvd@ter.com Mon Nov 5 11:59:43 2007 Received: from mx0.public.com (mx0.public.com [66.112.160.20]) by public.com (8.12.10/8.12.10) with ESMTP id lA5GxhST005865 for <x@public.com>;
Show full article (1.85Kb) · Show article thread
Mr. Muzak wrote: > Let me set it up for you. > I have several people with different days off. I'm trying to count the > total number of days they are out ill without counting their Days off. I > have a query that takes the 1st date they were out and subtracts it from the > current date giving me the total # of days out. In the query I have the > persons days off noted in different columns     

Group: microsoft.public.access.forms · Group Profile · Search for Dayoffs in microsoft.public.access.forms
Author: Klatuu
Date: Jul 24, 2008 07:22

Let me set it up for you. I have several people with different days off. I'm trying to count the total number of days they are out ill without counting their Days off. I have a query that takes the 1st date they were out and subtracts it from the current date giving me the total # of days out. In the query I have the persons days off noted in different columns under the header of 1st DayOff
Show full article (1.41Kb) · Show article thread
On Aug 28, 12:35 pm, surhall <surh...@gmail.com> wrote: > On Aug 27, 2:05 am, Surjit Singh <surjit_si...@yahoo.com> wrote: > > > > > Hi RMIMers: > > > We (my wife and I) had to return to San Diego on Saturday leaving the > > venue at about 5:30 PM, so can't tell you about the whole meet. Have > > been busy all day. In any case, we will all wait for the official > > report. I can tell you     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Dayoffs in microsoft.public.access.modulesdaovba
Author: Kavy
Date: Jul 17, 2008 12:49

Show full article (4.43Kb)
    

Group: alt.support.loneliness · Group Profile · Search for Dayoffs in alt.support.loneliness
Author: Nil
Date: Dec 12, 2007 22:46

Show full article (11.85Kb)
    

Group: news.admin.netabuse.sightings · Group Profile · Search for Dayoffs in news.admin.netabuse.sightings
Author: USENET n.a.n-a.s reports
Date: Nov 5, 2007 09:30

Show full article (4.76Kb)
    

Group: microsoft.public.access · Group Profile · Search for Dayoffs in microsoft.public.access
Author: James A. Fortune
Date: Aug 29, 2007 17:12

Show full article (2.54Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for Dayoffs in microsoft.public.access
Author: Mr. Muzak
Date: Aug 29, 2007 08:54

Show full article (0.52Kb)
    

Group: rec.music.indian.misc · Group Profile · Search for Dayoffs in rec.music.indian.misc
Author: surjit singh
Date: Aug 28, 2007 13:33

Show full article (4.04Kb) · Show article thread
1 · 2 · next