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!

  • Congratulations Wanet Telecoms Ltd 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: ErinB
  • Order by date
  1. ErinB

    Print Groups separately into PDF files

    I've gotten the report to print in PDF, but it prints the entire report. I would like it to print each group separately into separate PDF files. Do you know if that is possible?
  2. ErinB

    Print Groups separately into PDF files

    I'm not sure if this can be done or not. I have a report that is grouped by sales manager. I want to distribute this report by email so that each sales manager receives their individual information in PDF format. Is there a way that I could generate separate reports for each sales manager...
  3. ErinB

    Exporting reports from Access 95 db to 97 db

    Is it possible to export reports from one Access database to another Access database? We are currently converting a system in Access 95 to an improved system in 97. I have been able to successfully export all of the tables, queries and macros that we need, but i can't export the reports...
  4. ErinB

    Text box properties change based on combo box value

    Is there a way to deactivate a text box based on a value selected in a combo box? I have a combo box that asks for a "yes" or "no" value. If the value is "no", I want to deactivate the text box below it. Is this possible? Thank you!
  5. ErinB

    Controlling the control source in a report!!!

    Try using a DCount statement In the code for your command button to open the report try using something along the lines of this: Dim X as Integer, vsql as String vsql = " " X = DCount("*", "Qry behind the report", vsql) If X > 1 add an S Else don't add S...
  6. ErinB

    Filtering a subform with 3 fields selected from another form

    Hello! I'm hoping someone can help me with this master/child linking problem. I have a form with 3 combo boxes that are used to filter information that is seen in a subform. Once the user has selected the filters from this form, they click a command button to apply the filter. The command...
  7. ErinB

    Creating a "Select All" option in a Combo box that filters a report

    I've tried adding the Like statement into the query behind the report, and I've tried a few other ways, but I still can't get this to work properly. When I select * from the combo box, it doesn't recognize it and says it doesn't find any records with * as the category code. When you run the...
  8. ErinB

    Group header title being split up from Group info on new page

    How can I get all of the information within a group to not separate when it comes to the end of the page. I don't want a separate page for each group, but I don't want the title of the group on one page, then the grouped records on a separate page. I know there is a pretty easy way to do this...
  9. ErinB

    Pop Up Form Search and Sort

    The user wants to be able to search and sort the records that show up in these forms. when the form is set to Pop up, the search and sort options on the toolbar are inactive. I was wondering if there was a way to make those options active when using a pop up form. I am familiar with Visual...
  10. ErinB

    Pop Up Form Search and Sort

    When you set the properties of a form to Pop Up, it takes away the ability to sort and search when using that form. Is there a way to make the sort and search functions work while using a pop up form?
  11. ErinB

    Creating a "Select All" option in a Combo box that filters a report

    I have a combo box of category codes and when a code is chosen from this combo box it filters a report generated by this form by the selected code. I want to be able to select All of the category codes so that a report is generated that displays all of the category codes instead of filtering...
  12. ErinB

    Creating a "Select All" option in a Combo box that filters a report

    I am trying to create a "Select All" option in one of 9 Combo Boxes used in a form to create reports specific to what the user chooses. I have gotten the Union query made to do this using the code SELECT [combo field] FROM [table] UNION SELECT "*" FROM [table] I can't...

Part and Inventory Search

Back
Top