Search results

  1. A

    How Do I create Individual report files (Again!)

    Hi: I'm still having problems - I have put in the variables to the code you sent me and created the "tblgroupEmails" table but it keeps coming back with "Can't find the name of report I have specified". I have listed the bit of code below (with some comments beside them) - can you check it...
  2. A

    How Do I create Individual report Files

    I have a report which generates say 5 pages of information - Normal printing is not a problem however I want to email them to the individuals. Each page of the report contains differing data and each page needs to be sent to a different person. Is there anyway that I can produce the report as...
  3. A

    Multiple Pages

    I have a report which provides data on sheet 1 and then needs to be followed by 3 pages of notes/instructions. Currently I can only fit the fron page plus 1 page of notes as access seems to restrict the "depth" of a report. I have generated a second report which contains the last 2 notes pages...
  4. A

    Macro problem again

    Continueing from my previous thread. I created a Macro to stop the print if it has no records The Macro only has one argument cancelEvent in the Properties "On No Data" field of the report. It partially works however I get an error message "The expression you entered has a function name that...
  5. A

    Automate email

    I am producing a number of reports each month - some of these reports are just printed and sent out snail mail however 80% of them can be sent by email. The problem is that each page of the report is for a different email user, and these email users change on a monthly basis - I want (if...
  6. A

    Macro problem

    I'm running multiple reports in a Macro (each report runs an underlying query selecting appropriate data) - if their is no data as a result of the query (which is possible) how do I stop the macro running the report so I can then go onto the next report.
Back
Top Bottom