Multiple Records From A Text Box

[Thomas]

I am working on a previously created access form that has a text box that
drives which reports get returned. Currently the text box only accepts one
entry at a time. For example: I have two reports I want to run. One is titled
"RPT1" and the second is titled "RPT2". If I enter "RPT1" in the text box the
report properly appears. The same happens if I enter "RPT2". However, I would
like to pull both of these at the same time. I thought I could possibly
accomplish this by typing the following: "RPT1, RPT2". Unfortunately this
returns neither report. Since I often need to pull hundreds of reports at a
time, I would like to be able to just copy and paste a generated list of
report numbers from excel and be able to click just one button to generate
all reports. Now I have to enter each individual report number and have to
click the button to enter the next individual report number after each
individual report. This sometimes takes hours. Any input would be appreciated.

 

[tina]

presumably you want to print each report, not open it in Preview. you could
try linking your Excel spreadsheet into Access, then writing code to loop
through each each record in the spreadsheet, generating a report for each
reportname. if you have hundreds of reports to print at one time, though,
i'm wondering if you're going to overload the printer's memory (i don't know
much about printers, and have never had to process such a volume of print
requests at one time before, so i've no idea if it'll be a problem or not.)

hth

I am working on a previously created access form that has a text box that
drives which reports get returned. Currently the text box only accepts one
entry at a time. For example: I have two reports I want to run. One is titled
"RPT1" and the second is titled "RPT2". If I enter "RPT1" in the text box the
report properly appears. The same happens if I enter "RPT2". However, I would
like to pull both of these at the same time. I thought I could possibly
accomplish this by typing the following: "RPT1, RPT2". Unfortunately this
returns neither report. Since I often need to pull hundreds of reports at a
time, I would like to be able to just copy and paste a generated list of
report numbers from excel and be able to click just one button to generate
all reports. Now I have to enter each individual report number and have to
click the button to enter the next individual report number after each
individual report. This sometimes takes hours. Any input would be

appreciated.

 

[Klatuu]

I suggest you use a multi select capable list box to allow the user to select
from a list of available reports.