Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: scoobypaw
  • Content: Threads
  • Order by date
  1. scoobypaw

    Getting the report parameter to print on a Report

    Hello, I have the following on a report: ="Due Date from " & [Forms]![frmSalesSelectorbyDateRange]![BeginningDate] & " to " & [Forms]![frmSalesSelectorbyDateRange]![EndingDate] However when I print the report it just comes up as "#Name?" When I view, save, or print to a PDF the parameter...
  2. scoobypaw

    Sum Total in a Report

    I am trying to total a status field which is based off a lag time formula which is then turned into a status (Early, on time, late, or pending) I am trying to calculate how many early, on times, lates, and pendings I have for each quarter. This is the formula I am using: =Sum([Status2]="On...
  3. scoobypaw

    Create PDF of a report through a command button

    Hello Is there a way to create a PDF of a report through a command button ? If so, does anyone know how I would write the code ? Thanks
  4. scoobypaw

    Exporting a report into Shapshot based off a Form parameter

    Hello I have created a form with a combo box that pulls a report based on the parameter choosen. I have gotten the command button on the form for view and print to work correctly but I can get the one for export to snapshot to work correctly. When it exports it pulls the whole report and it...
  5. scoobypaw

    Module not found error

    I am really stuck on this one. I made a copy of a form and renamed it. However the copy I made does not show on the database window but does show in the Visual Basic window. Since this happended I have been receiving this error: "Module not found" When I am in the visual basic window to try...
  6. scoobypaw

    Multiple Parameters based on a form for a report

    Hello, I have created a form that opens a report based on the parameters I choose in the form. I got the first parameter to work on it's own "Head Office" , but I can't seems to get the date range part to work. FYI - I gives me this error: Syntax error (missing operator)in queary expression...
  7. scoobypaw

    Missing or Broken Reference Error OWC10.DLL

    Hello, I am getting this message in my Access Database: Your Microsoft Office Access datase or project contains a missing or broken reference to the file 'OWC10.DLL' version 1.1. * To ensure that your datatbase or project works properly, you must fix this reference. I can't figure out what...
  8. scoobypaw

    Requery a Subform

    Hello, I have a mainform: frmLetterApprovalNewCase With a dataview subform: frmApprovalLetterInput_Subform 2 combo boxs in the subform: Sales , Sales2 on the mainform I have a command button that takes me to another form so I can add names to a table which 2 combos are connected to through a...
  9. scoobypaw

    Auto Refresh a Form & Sub Form

    I have created a form with a subform and need it to auto refresh when a new name is added to the list table. The way I have the forms setup is if the sales person is not on the drop down list you link to the name table via a command button and add the name. However once you close the name...

Part and Inventory Search

Back
Top