Search results

  1. A

    One Subreport and two Main Reports???

    I am trying to use one subreport in two different main reports. The DB is about facilities inventory in a university. The subreport is showing PCs info, and the 1st main reports showing administrative departments and another showing academic departments. I use yes/no field to mark academic...
  2. A

    Results Show in Print Preview but not in the Report View

    I have main report and subreport and trying to reference the count() of supreport with =Iif(subform.Report.HasData, NZ(subform.Report.control, 0), 0) I got in the REPORT VIEW: #Name? in the PRINT PREVIEW THE EXACT COUNT HOW CAN i FIX THIS, PLEASEd?
  3. A

    Displaying Total Count() in Main Form

    I built a database inventory for a UNVERSITY to keep track of facilities (PCs, Printers …) Now I am working in reports: I created a main report showing Building/College and Department/Major and a SubReport to display PCs in each department/Major with count of PCs I am trying to find a way to...
  4. A

    Opening Query after combobox selection

    Hi, I am trying to run query after selecting from cobmbobox list. I did the following but no luck: rivate Sub Comb_AfterUpdate() DoCmd.OpenQuery "Function" End Sub And wrote in the criteria [Forms]![Printer Or Scanner]![Comb] Function is the query, Printer Or Scanner -- the form. Could...
Back
Top Bottom