Search results

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...

Re: 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...

Thanks Boyd - however can you give me the exact string I need to put for NameOfReport? i.e. in the code starts as follows:- Public Function SendReporttoGroup (NameOfReport As String, _ [anything I put in at this point comes up with compile error]. Your help would be appreciated.

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...

Thanks Danny - I used the On NoData event in the report as there are multiple different reports running from the command key - It worked fine - you don't happen to know how to change the length of a report do you - These reports I am doing usually have a first page which has variable data on it...

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...

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...

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...

Thanks Mailman - however - this appears not to work - I want the macro to stop i.e. don't print the report so I created another Macro to stop the report but it comes back with an error "This action can't be carried out while processing a form or report event" - any ideas?

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.