Problems with Access Reports 1

[klmorgan]

I have set up an access database for a caravan strorage site and have made a report to produce Payment Reminder Letters based on a query that selects customers that have had a flag set to print in the database.

I have two problems with it.

1/ If there are more than one customer selected by the query only the report for the first one prints.

2/ I have embedded/linked a Word document into the report that allows the modifying of the text via Word and although it works it seems nigh on impossible to size the document in the report to the size it is in in Word.

Item 1 is the biggest problem and perhaps item 2 should be in another request.

Kind Regards

Keith

 

[Remou]

Have you considered abandoning the report and going with mailmerge?

'Native' mailmerge reports - as painless as possible
faq181-5088

If you wish to keep the report, please include some code to illustrate what you are doing regarding the query, the report's record source and the way the report is opened.

 

[klmorgan]

Yes Remou but the user is pretty wary of computers and wants to use only one package at a time!

I wrote a mail merge in Word which was really easy but the user wanted it all in access and I have spent an age getting it right.
The only way I can find of enlarging the Word portion
is to set it to Stretch in the properties and that distorts the type face which then looks wrong against the Access type face.

Regards

Keith

 

[Remou]

As regards problem one, please include some code to illustrate what you are doing regarding the query, the report's record source and the way the report is opened.

 

[klmorgan]

I don't have any code Remou, I have just written a reoprt which uses a Query as its source.

The Query finds something like three records out of 300ish for the report and I just wanted to be able to print the report for each of the three records, then reset the print flags with a macro. I have done a macro that resets the flags and works!

It lets me print the first but then I cant go on to the next.

This is my first real attempt at Access ( I used to work at a reasonable level in a DOS based TAS) I have built all the tables, forms, queries and Switchboards but automating the printing is baffeling me!

Thanks for your interest

Keith

 

[Remou]

If you view the report without any macros, can you see three pages?

 

[klmorgan]

No you only see the page for the first record found.

Regards

Keith

 

[Remou]

Please post the SQL[sup]1[/sup] of the query and the Record Source[sup]2[/sup] of the report.



----------------------
1. Choose SQL View from the View menu when you have the query in Design View.
2. Choose Properties from the View menu when you have the report in Design View. The data tab of the propert sheet will show the Record Source.

 

[klmorgan]

Hi Remou

Sorry I was late getting back there is probably a time zone difference, I am in UK where are you?

SELECT Customers.ContactID, Customers.KeyNum, Customers.FirstName, Customers.LastName, Customers.Dear, Customers.Address, Customers.City, Customers.County, Customers.PostalCode, Customers.Region, Customers.[Country/Region], Customers.CompanyName, Customers.Title, Customers.WorkPhone, Customers.WorkExtension, Customers.MobilePhone, Customers.FaxNumber, Customers.EmailName, Customers.LastMeetingDate, Customers.StorageArea, Customers.ReferredBy, Customers.Notes, Customers.Model, Customers.SerialNo,
SQL View of Query
Customers.YearOfManu, Customers.CarReg, Customers.CarMakeModel, Customers.PayType, Customers.PayFrequency, Customers.CaravanType, Customers.Rates, Customers.[Print Flag], Customers.[Start Months], Customers.[Start Day], [Print Choices].Print, [Rental Period].[Rental Period], [Unit Types].UnitType
FROM [Unit Types] INNER JOIN ([Rental Period] INNER JOIN ([Print Choices] INNER JOIN Customers ON [Print Choices].ID = Customers.[Print Flag]) ON ([Rental Period].ID = Customers.RentalPeriod) AND ([Rental Period].ID = [Print Choices].ID)) ON ([Unit Types].ID = Customers.UnitType) AND ([Unit Types].ID = [Print Choices].ID)
WHERE ((([Print Choices].Print)="Print"));


The Record Source is: Print Selected Customers

Many Thanks for your help

Keith

 

[Remou]

I had hoped that would helpme see where the problem was, but I am still in the dark! To restate the problem:

1. The query "Print Selected Customers" has three records when opened from the database window.
2. The report based on "Print Selected Customers" has only one record when opened from the database window.

Is that correct?

Has the Filter property for the report been set?

 

[klmorgan]

Ramou

The problem was me!

I had written two queries one let the user see the records the flags were set for with only a few fields returned, the other found all fields for the report.

I checked that the the first was working but assumed that the other found the same, it didn't!

I have corrected that now and I get a report printed for all those found! But....... Only the first sheet has the header the rest are like continuation sheets, any idea how I can get the header on everyone?

Regards

Keith

 

[Remou]

I find it takes ages to find these things, don't you?

I suggest you put the header in the Page Header section and check the report properties (formst tab) to ensure that Page Header is set for All Pages.

 

[klmorgan]

Yes, it is frustrating, when you are starting out its difficult to to know if it is the way you are trying to do things or if you have made a typo.

Thanks for your help

Keith