Re: Report issue

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Crystal:

The following is the query that I use to get the information I need.

SELECT ReportsMemo.crreport, """N~FILENO=/"+[selected
recs]!fileno+"~CMT=/Credit Report~OTHER=/"+[selected recs]!reqb+""" ?" AS
Caption, "~0% Var0" AS captionst
FROM ReportsMemo INNER JOIN [Selected recs] ON ReportsMemo.SLNO = [Selected
recs].COUNTER;

The report - in detailed section - contains first the value stored in
captionst, which is made bold, and then next to it is the value stored in
caption. Below it the memo field ReportsMemo.crreport. In the property for
memo I have set 'can grow' to 'yes' as the memo field can go to more than 1
page.

So the report with each memo field should printout as seperate report for
ImageMaster to be able to read the caption strings.

Thanks for all your help.
Rose

"strive4peace" wrote:

Hi Rose,

I'll be happy to, please provide information about the applicable table
structure and relationships using real fieldnames

meanwhile, you can prepare yourself a bit more by sending me an email
and requesting my 30-page Word document on Access Basics (for
Programming) -- it doesn't cover VBA, but prepares you for it because it
covers essentials in Access.

Be sure to put "Access Basics" in the subject line so that I see your
message...

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



R Alapatt wrote:
Thanks Crystal. But I am not familiar with VBA. The logic that you
mentioned should work but how do I do it in VBA. Please help.

Rose.



"strive4peace" wrote:

How about a loop to go through each file number and limit a report to
just one file number at a time?

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



R Alapatt wrote:
I am generating a report with a string (which is concatenation of of some
charectors, file number and name) being the first line in the detail section
of the report and a memo field that may run to more than one A4 size page.
Each new file number starts on a new page. I am printing this report to
'Image Master' which has a database and is able to read information like file
number and name from the string.
My problem is that because the report is printing as 1 document Image Master
is reading only the string one the first page and storing every thing as one
file.
I need a way to print each file number as a seperate report so that Image
Master sees it as seperate document. Please some one help. Thanks.



.

Relevant Pages

  • Re: Report issue
    ... Remote Programming and Training ... I am printing this report to 'Image Master' which has a database and is able to read information like file number and name from the string. ... My problem is that because the report is printing as 1 document Image Master is reading only the string one the first page and storing every thing as one file. ... I need a way to print each file number as a seperate report so that Image Master sees it as seperate document. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Summary of (dis)agreements on latewst FastCode developments
    ... >>> Caption is inconsistent with our naming conventions. ... Currently the form caption says "FastCode Benchmark and Validation ... >>> I would like to see all subbench results in main report as normal. ...
    (borland.public.delphi.language.basm)
  • Re: Access Basics
    ... Remote Programming and Training ... meanwhile, you can prepare yourself a bit more by sending me an email and requesting my 30-page Word document on Access Basics -- it doesn't cover VBA, but prepares you for it because it covers essentials in Access. ... I am printing this report to 'Image Master' which has a database and is able to read information like file number and name from the string. ... My problem is that because the report is printing as 1 document Image Master is reading only the string one the first page and storing every thing as one file. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Report issue -- What is field you want to loop?
    ... Why is the "caption" a quoted string? ... MVP Access ... The resulting list which contains the caption fields and memo field forms the report. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Report issue
    ... The query now selects fields from 2 tables joined by a filed. ... The resulting list which contains the caption fields and memo field forms the ... code so that the report with one record will print as seperate printout. ... Below it the memo field ReportsMemo.crreport. ...
    (microsoft.public.access.modulesdaovba)