Printing a single record in a report

[pbaldy]

If you look at VBA help on OpenReport, you'll see the argument you can set to preview rather than print. The blank page can be caused by the report plus margins being wider than the paper, so that's the first thing I'd check.

[kelann]

Thank you so much! Accessing the helpand using the preview fixed both the view (of course) and the extra blank page, as well.
Now, the only problem I have is that it works for some of the organizations -- I get the report -- but for others, I get the blank form.
Any thoughts there????

[pbaldy]

At a guess, same problem you had with the form: the name selected does not exist in the report's source.

[kelann]

I double-checked that first -- and I just double-checked them now!!! It is called OrgName in both items. The odd thing is that some of them DO work. When I press the button (ButtonOpenOrgReport) I either get the report for that particular org, or I get a blank report that only has the report "background" and hard text. Any thoughts? Renewed thanks!

[pbaldy]

Not the field name, the value. In other words, if you chose "ABC Company" to run the report on and that company didn't exist in the report's source data, you'd get a blank report. You had the same issue with the form where it was only coming up with the blank new record.

[kelann]

Thank you so much. I hate to be difficult, but the OrganizationsT, which houses all the organizations, has all of the entries, which is the main source data.

In OrganizationsT, there are selection boxes for the type of organization (athletics, entrepreneurship), etc.
In the YPsT, there are the same selection boxes for the interests of the young professional (athletics, entrepreneurship), etc.

The report with the button (EngageAllYPRep) pulls from a query (EngageQAllMatches) which looks at both OrganizationsT and YPsT and matches a YP with an Org, provided they have one interest in common. The button on the EngageAllYPRep pulls a report (OrgReport) that simply carries the data for that particular organization, as a sort of handout or to see further details to determine if it really is a good match.

In other words, all the data exists, because it's all pulled, ultimately, from two tables: OrganizationsT and YPsT.

Sorry to be such a beginner, but I hope this is helpful, and I appreciate your help so much!

[pbaldy]

Can you post the db here?

[kelann]

Thank you!

Event.zip

If you double-click on the report EngageAllYPRep, this will give you the buttons I speak of.
The report they represent is a report called OrgReport.
Everything is created from the query EngageQAllMatches.
The query pulls from the tables OrganizationsT and YPsT.

Many, many thanks!!! This is my first DB, and I really appreciate your help!

[pbaldy]

Sadly, I'll be the one being difficult.

Open OrgReport in design view. Open the properties window to the data tab. Click on the ellipsis (...) to the right of the record source to open the query in design view. Run the query. As you can see, and confirming what I suspected, the only OrgName's available for that report are AIESEC and Alliance Credit Counseling Inc. Any other choice will return the blank report.

[pbaldy]

Should have added that if I had to guess, you want to change the join between those tables so that all records from the organization table are returned.

[kelann]

Thank you, Paul!

It is now Access that's being difficult ... not it's fault, I guess, if I can't figure out how to modify this join!!! I've tried lots of things that seemed possible to me, but I just don't know enough.

Here's the SQL language. I've tried a bunch of things, only to error out or get dialogs asking for info. Can you please suggest how to modify for the correct results?

SELECT OrganizationsT.*, ContactsT.ContactFullName, ContactsT.PrimaryContact, ContactsT.PrimaryContactText, ContactsT.ContactPhone, ContactsT.ContactEmail, ContactsT.ContactAddress1, ContactsT.ContactAddress2, ContactsT.ContactCity, ContactsT.ContactState, ContactsT.ContactZip
FROM OrganizationsT INNER JOIN ContactsT ON OrganizationsT.OrgName = ContactsT.ContactOrg

Many thanks!!!

--ak

[pbaldy]

Change INNER to LEFT.

[kelann]

OMG, thank you so much! I would havae been a moldin' in the cold, cold ground long before I would have arrived at that!

[pbaldy]

LOL! You can also change the join in design view by right-clicking on the join line. You'll get a better description of what it's doing there.