Re: Report issue

Hi Crystal: 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
report. I have used regular query without any coding. I need to know how to
code so that the report with one record will print as seperate printout.

Thanks Rose.

"strive4peace" wrote:

Hi Rose,

It appears that you are changing the recordset for a particular file
number in your SQL statement (/query) for the report recordsource.

Are you saying that this is the solution you have used?

Did you change recordsource through code before rendering report? Or are
you picking file numbers one by one, possibly what the slelected recs
query is for?

.... or do you have code that loops through the records you wish to process?

.... do you still have a question...? ask blatently!

you're welcome, but I am not sure for what ;)

please explain further, thanks!

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



R Alapatt wrote:
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: Truncating of memo fields
    ... Robin wrote: ... >The data is not being compared in the memo field although ... >the query in a list box. ... >to run this report with many records, ...
    (microsoft.public.access.reports)
  • 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 with each field showing data from all records
    ... You could create this kind of query programamtically. ... Since the report is based on this query, and it still uses the same aliases (we used TheField and TheValue), you can then run the report based on that query. ... If you want to combine the values from multiple records and combine them into one memo field, that would need a different approach. ...
    (microsoft.public.access.reports)
  • Re: Truncated memo fields from queries within queries
    ... because of the fact that I need to get this report out to the ... I went ahead this morning and created a higher-level query for my ... > I even tried adding the brackets just for fun, but the memo field was ... >> aggregation of any sort and got the same result. ...
    (microsoft.public.access.queries)
  • Re: Truncated memo fields from queries within queries
    ... You might try downloading SP8 for JET 4 from: ... because of the fact that I need to get this report out to the ... > problem--the resulting query structure is positively unholy, ... >> I even tried adding the brackets just for fun, but the memo field was ...
    (microsoft.public.access.queries)