Report limits based on user entry

  • Thread starter Thread starter Serendipity
  • Start date Start date
S

Serendipity

I need to limit a report that I have built. This will be an option from a
switchboard. I want the user to input data into a form to restrict the data
on the report.

1- First by Address ID(each facility has a unique one IE R00054) – would
like a dropdown list showing only the locations that have inspection reports
entered into the database.
2- Then by the Equipment # entered for that location (each section of roof
has unique ID to that location, but may be reused across multiple address
ID’s, may have multiple of these #’s assigned to a location, IE 14001-1R01 or
14002), maybe an option for all equipment?
3- finally by the date of the inspection. Maybe the option for all dates?
4- Need to be able to print report or export to Word. FYI database is locked
to keep people from accessing design mode etc. This removes the export /
analyze option.

Report Name: rptRoofInspectionGeneralReport
Address ID : tblBuildings, AddressID
Equipment #: tblInspectionReport, SectionNumber
Inspection Date: tblInspectionReport, InspectionDate

Thanks for the help…
 
Okay... got part of it to work, but VBA and I are not the best of friends.

I have a form that has a combo box (cmbSelectInspctn) that is 4 column with
the first column not showing (primary key) and the second column set to group
by to eliminate duplicates in the list. The bound column (1) is the one that
does not show.

Upon selection I want it to open the report(rptRoofInspectionGeneralReport)
based upon the selection in the combo box(InspectionReportID). I know how
with a macro, but I am trying to avoid macros because of a upcoming upgrade
to 2007 and we have been warned about problems with macros. I'm also learning
VBA. The database was created in 2000, but is now 2002.

Can someone walk me through on how to do this?
 
Back
Top