RE: Please help me find some direction

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Why not just a query filtered for records with unpaid time with dates prior
to the current week as the record source of a form?
--
Dave Hargis, Microsoft Access MVP


"Preston" wrote:

Hi,
I have been creating a database that generates timesheets for technicians
based on a given date range and filter criteria. I have a question and am not
sure how to proceed. If there is unpaid time for a technician that is prior
to the week we are generating the timesheet for I want to be able to decide
whether or not to include this time. If I don't then the time will be lost
and the user will not have another chance to pay the technician for this
time. As it works right now the user selects the tech he/she wants timesheets
for and gives a weekending date (sunday) the db then generates a report
(timesheet) for each tech based on the week ending on the date specified.
This is done using a recordset and a loop to filter a report. I would like
the user to be prompted if there is time prior to this week. If there is time
unpaid prior to the given week then i would like the user to have the choice
of selecting (by using a checkbox) each instance of time that they would like
to pay (include on the timesheet report).
I'm not sure how to tackle this. Should i build a temporary table with
the records prior to the date range and then present this in a form with
checkboxes? Should i simply use a recordset to handle the question? Any help
you can give will be greatly appreciated.
Thank you,
Preston
.

Relevant Pages

  • [UNIX]Cross-Site Scripting Filter Evasion in Various Frameworks / Applications
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Cross-Site Scripting Filter Evasion in Various Frameworks / Applications ... Popoon/Flux-CMS version r22196 and prior ...
    (Securiteam)
  • Re: Its driving me crazy!
    ... A wealth of information and easy to understand. ... I have taken steps, prior to this problem, to filter my ... about attachments period - no matter who they are from - ...
    (microsoft.public.security.virus)
  • Re: Has Prior broken the record?
    ... I couldn't work out how to apply an appropriate filter, but a search by hand puts him ahead of all the obvious targets. ... 41 WI v Eng Georgetown 1929-30 EAC Hunte ... 41 Eng v Aus The Oval 1934 LEG Ames/FE Woolley ... 38 Eng v WI St John's 2008-09 MJ Prior ...
    (rec.sport.cricket)
  • RE: Advanced Filter Using Calculaions
    ... I built a model of your structure (including dates from prior and future ... List Range: $A$8:$S$5000 ... Also verify that all Col_D items are dates ... Using that technique the Advanced Filter will sequentially apply the formula ...
    (microsoft.public.excel.worksheet.functions)