Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Location
    Chichester
    Posts
    3

    Smile Unanswered: Printing Specific Reports

    Hi
    The users of my database have a main Internal Job Order form which gets populated every day from a web form completed on line around the college. At the moment the users click on a print button and they are then forced to put in a date specifying which day's reports they want printed.
    What they want to do is to be able to click on a button and for it to immeditately print (within any prompting or asking for dates) all the records that haven't already been printed. For example, if 10 forms have been completed today and the info is in the databse, the user wants to be able to click on the print button and have all 10 reports printed, then if later that day or the next day 5 more forms have been completed, they want to be able to click on the same button and have only those 5 forms printed - if none have been received, then a message should inform them of this.
    If anyone can help with this, it would be great
    thanks
    Jane

  2. #2
    Join Date
    Dec 2002
    Posts
    60

    Re: Printing Specific Reports

    Time stamp when forms are filled out (field with default value=Now()). Store time/date when ever forms are printed. Base report on query that selects records where time stamp > time/date last printed

  3. #3
    Join Date
    May 2003
    Location
    Chichester
    Posts
    3
    HI,
    what would the code look like on the query in order to get it to print 'records where time stamp > time/date last printed'. am a bit confused by this at the moment.!!
    thanks for your help
    j

  4. #4
    Join Date
    Dec 2002
    Posts
    60
    You need two queries:

    First query (named qryLastPrinted) to find last time report was printed:

    SELECT TOP 1 DateLastPrinted FROM tblLastPrinted ORDER BY DateLastPrinted DESC;

    where tblLastPrinted is table containing date report last printed, DateLastPrinted is field (Date type) where date last time report was printed is stored (see last post)

    Report sould be based on the following query:

    SELECT tblInternalJobOrder.* FROM tblInternalJobOrder, qryLastPrinted WHERE(tblInternalJobOrder.DateEntered)>[qryLastPrinted].[DateLastPrinted];

    where tblInternalJobOrder contains Internal Job Order information, DateEntered is a date type field in tblInternalJobOrder that has default value=Now() (See last post)

    I haven't tested this, but it should work.

  5. #5
    Join Date
    May 2003
    Location
    Chichester
    Posts
    3
    Wow
    that all sound a bit mindblowing - will try and work it out later today. thanks for your efforts - Jane

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •