Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / November 2005

Tip: Looking for answers? Try searching our database.

Print content of a form list box in a report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
NielsE - 30 Nov 2005 14:35 GMT
Thanks for the valuable help I have got in this forum so far.
Another, and probably simple question:
I have a form where I ,through three parameters selected in combo boxes,
populate an unbound list box with records. The list box has five columns.
I want to be able to print a report that has all the records and fields in
the list box.
This is probably simple, but I have not been able to find an exampleI can
adjust for my purpose. Thanks for any help.
Niels
Allen Browne - 30 Nov 2005 14:45 GMT
The list box will have a RowSource property that defines the 5 columns and
the records. You can create a query that selects the same fields and
records, and use that as the RecordSource for your report.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thanks for the valuable help I have got in this forum so far.
> Another, and probably simple question:
[quoted text clipped - 5 lines]
> adjust for my purpose. Thanks for any help.
> Niels
NielsE - 30 Nov 2005 21:15 GMT
Thanks Allen. Your advice is always appreciated. However, I still have some
problems, but let me post the query that the form is based upon:

SELECT qryParam3.ProjectID, qryParam3.Projectsymbol, qryParam3.Title,
qryParam3.Region, qryParam3.Status, qryParam3.StatusDate, qryParam3.Budget,
qryParam3.SubjectName
FROM qryParam3
WHERE (((qryParam3.Region)=[Forms]![frmParam3Test]![cboRegion]) AND
((qryParam3.Status)=[Forms]![frmParam3Test]![cboStatus]) AND
((qryParam3.SubjectName)=[Forms]![frmParam3Test]![cboSubject]));

The report called by the print/print preview button on the form comes out
fine except when one or more of the choices in the combos are **ALL**, then
the report returns blank. The **ALL** is added to to each combo (here is one
example):

SELECT tblSTATUS.Status FROM tblSTATUS UNION SELECT "**ALL**" as Bogus from
tblstatus
ORDER BY tblSTATUS.Status;

Niels


> The list box will have a RowSource property that defines the 5 columns and
> the records. You can create a query that selects the same fields and
[quoted text clipped - 9 lines]
> > adjust for my purpose. Thanks for any help.
> > Niels
NielsE - 30 Nov 2005 23:02 GMT
I think I figured it out by adding ..OR criteria="**ALL**

> Thanks Allen. Your advice is always appreciated. However, I still have some
> problems, but let me post the query that the form is based upon:
[quoted text clipped - 32 lines]
> > > adjust for my purpose. Thanks for any help.
> > > Niels
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.