Rosterd
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 16 articles for 0.302 sec
No. You cannot filter a report by a result that it does not have until after it has laid out the records on the report. You will need to find a way to get that figure before the report runs. It may be possible to do that with a Totals query. Alternatively, you might be looking at designing a subquery to use as the report's filter (typically in the WhereCondition of OpenReport.) If subqueries     

Group: microsoft.public.access · Group Profile · Search for Rosterd in microsoft.public.access
Author: Allen Browne
Date: Apr 3, 2008 21:41

It does have to ask for the parameters. If it is asking multiple times, the way around that is to create a form, and put 2 text boxes on the form. Then in your query, use this kind of thing: WHERE RosterDate Between [Forms].[Form1].[Enter First Date] And [Forms].[Form1].[Enter Second Date]; Now open the form and put the dates in before you run the query, and it will read the dates
Show full article (1.55Kb) · Show article thread
Presumably you have a table of employees (say tblEmployee), and another table (say tblRoster, with a RosterDate field.) You want to limit the report to dates in a range, so create a query like this: SELECT * FROM tblRoster WHERE RosterDate Between [Enter First Date] and [Enter Second Date]; Save it as (say) qryRosterRange. Now create a query using tblEmployee and qryRosterRange     

Group: microsoft.public.access.reports · Group Profile · Search for Rosterd in microsoft.public.access.reports
Author: Allen Browne
Date: Mar 27, 2008 18:22

Fred, Thank you for your help, I never considered the word wrap (sorry for that). It all works great now, I apologise for taking so long to reply but I am in Australia and the time difference makes it difficult but great work and thank you again. Rodney "fredg" wrote: On Fri, 17 Aug 2007 23:36:00 -0700, Rodney wrote: Fred, Thank you for your help. I have
Show full article (2.41Kb) · Show article thread
On Fri, 17 Aug 2007 23:36:00 -0700, Rodney wrote: > Fred, > > Thank you for your help. > I have tryed your suggestions and the first I get a syntax error on the line > > Exit_This_Sub: > > And the second one get a syntax error on the line > > If DCount("*","tblRoster","[TrainerID] = " & Me!TrainerID & " and > > Than you again > > Rodney > > "fredg" wrote: > >> On Thu,     

Group: microsoft.public.access.reports · Group Profile · Search for Rosterd in microsoft.public.access.reports
Author: Allen Browne
Date: Mar 27, 2008 09:17

Fred, Thank you for your help. I have tryed your suggestions and the first I get a syntax error on the line Exit_This_Sub: And the second one get a syntax error on the line If DCount("*","tblRoster","[TrainerID] = " & Me!TrainerID & " and Than you again Rodney "fredg" wrote: On Thu, 16 Aug 2007 22:38:00 -0700, Rodney wrote: Could I please have some help with
Show full article (1.78Kb) · Show article thread
On Thu, 16 Aug 2007 22:38:00 -0700, Rodney wrote: > Could I please have some help with this code. > > I have the below code so far but it don't do what I would like. > > I want it to check if there are [RosterDate] bewteen Me!LeaveStartDate and > Me!LeaveEndDate > but I also want to include the first day of leave LeaveStartDate and the > last day of leave LeaveEndDate not just dates     

Group: microsoft.public.access.formscoding · Group Profile · Search for Rosterd in microsoft.public.access.formscoding
Author: Rodney
Date: Aug 18, 2007 17:02

Could I please have some help with this code. I have the below code so far but it don't do what I would like. I want it to check if there are [RosterDate] bewteen Me!LeaveStartDate and Me!LeaveEndDate but I also want to include the first day of leave LeaveStartDate and the last day of leave LeaveEndDate not just dates between them and if there are [RosterDate] within that period then display
Show full article (4.57Kb) · Show article thread
Dale, I have tryed the options you heve suggested below and, Option 1: works but we want the user to receive a message to remind them that the trainer is no leave and the period they are on leave for. Option 2: For some reason doesn't work, I select a trainer from the TrainerID combo box and it doesn't populate the TrainerID control, With no error messages or anything. And my apologies     

Group: microsoft.public.access.formscoding · Group Profile · Search for Rosterd in microsoft.public.access.formscoding
Author: fredg
Date: Aug 18, 2007 06:51

Thanks dale, I will try both of these and see how they go. I will get back to you. Thank you Rodney "Dale Fye" wrote: Rodney, I cannot tell what is going on either. But I have two suggestions, but I recommend option #1? 1. If your RosterDate field is filled in before the TrainerID, why not use a combo box for the trainers that automatically filters out the trainers
Show full article (4.03Kb) · Show article thread
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Rosterd in microsoft.public.access.formscoding
Author: Rodney
Date: Aug 17, 2007 23:36

Show full article (2.99Kb) · Show article thread
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Rosterd in microsoft.public.access.formscoding
Author: fredg
Date: Aug 17, 2007 07:51

Show full article (2.52Kb) · Show article thread
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Rosterd in microsoft.public.access.formscoding
Author: Rodney
Date: Aug 16, 2007 22:38

Show full article (1.01Kb)
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Rosterd in microsoft.public.access.formscoding
Author: Rodney
Date: Aug 14, 2007 17:52

Show full article (3.92Kb) · Show article thread
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Rosterd in microsoft.public.access.formscoding
Author: Rodney
Date: Aug 14, 2007 16:22

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