Recent content by ErinB

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?

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...

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...

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!

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...

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...

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...

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...

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...

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?

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...

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...