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 / Modules / DAO / VBA / February 2008

Tip: Looking for answers? Try searching our database.

Reports programming

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Irina - 19 Feb 2008 21:55 GMT
Is there a way to allow users select the fields that they want in a report
via a form check boxes or radio buttons?
If this is possible, how would the code look like, and where would the code
go under - on Open? and what properties would this involve?
I am not good in VB at all and that is the reason why I am contacting
you guys - the experts!!!! :)

please help
NetworkTrade - 20 Feb 2008 01:00 GMT
you might try putting all the fields on the report

and then in the 'OnFormat' event control a field's visibile state dependent
on the fields in the Form

rough test it with just one....not sure if the Form has check boxes or radio
buttons or text buttons or what....  depending on your version you might have
to research the value representing the control...

If Forms!FormName.CheckBox=Yes then
me.ReportField.Visible=True
End If

Could be very burdensome and crude if there are lots of fields to
control....possibly you can cluster/group them into separate subReports and
make the entire subReport visible or not.....

very sloppy advice...sorry.....
Signature

NTC

> Is there a way to allow users select the fields that they want in a report
> via a form check boxes or radio buttons?
[quoted text clipped - 4 lines]
>
> please help
Irina - 20 Feb 2008 14:45 GMT
thank you very much I will give that a try

> you might try putting all the fields on the report
>
[quoted text clipped - 23 lines]
> >
> > please help
John Spencer - 20 Feb 2008 12:41 GMT
Not exactly what you are asking for, but you might take a look at

The demo available at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
DH Query By Form

You can add the
functionality to any application by
-importing several forms and 2 tables into your app
-creating one or more "master" queries with names like
  <Employee Work>
  <Clients>
All query/reports are saved in the two tables. Results of the queries are
displayed in a datasheet subform on a main form with option buttons to send
to print, Word Table, text file, csv file, Excel, Html...

Signature

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
.

> Is there a way to allow users select the fields that they want in a report
> via a form check boxes or radio buttons?
[quoted text clipped - 5 lines]
>
> please help
Irina - 20 Feb 2008 14:44 GMT
Thanks guys, I will give that a try and get back if I have any questions.

> Not exactly what you are asking for, but you might take a look at
>
[quoted text clipped - 21 lines]
> >
> > please help
 
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.