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 Westi 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: *

  1. LittleC

    A Way To Stop Access From Printing Subform With Reports?

    For anyone interested, here is a fix for the problem: Private Command1_Click() Me.Refresh Me.Visible = False Dim strDocName As String Dim strFilter As String strDocName = "CoverLetter" strFilter = "ID = Forms!frmIssues!ID and OrderNumber =...
  2. LittleC

    Can't Figure Out Why Form Prints Out With Reports

    For anyone interested, here's the fix for the problem: Private Command1_Click() Me.Refresh Me.Visible = False Dim strDocName As String Dim strFilter As String strDocName = "CoverLetter" strFilter = "ID = Forms!frmIssues!ID and OrderNumber =...
  3. LittleC

    How to Stop Access 97 From Printing Form With Reports

    Thank you dhookom! Adding the Me.Visible = false line of code, which i inserted at the beginning, solved the problem. You sure do deserve a star! Thank you! Thank you! :-)
  4. LittleC

    How Do i Prevent Access From Printing Subform When Reports Print Out?

    I tried this fix before Glohamar's suggestion & it did the trick: Private Command1_Click() Me.Refresh Me.Visible = False Dim strDocName As String Dim strFilter As String strDocName = "CoverLetter" strFilter = "ID = Forms!frmIssues!ID and OrderNumber =...
  5. LittleC

    Cannot Stop Access From Printing Subform When Reports Print Out

    I tried foolio's suggestion & i'm not sure why it did not solve the problem. For anyone who runs in to the same trouble, here is a fix that did work: Private Command1_Click() Me.Refresh Me.Visible = False Dim strDocName As String Dim strFilter As String strDocName =...
  6. LittleC

    Cannot Stop Access From Printing Subform When Reports Print Out

    Thank you, foolio. Again, i apologize for posting in different forums; i thought i would get a range of opinions by asking a range of experts. In the future i'll post questions in just one forum.
  7. LittleC

    How Do i Prevent Access From Printing Subform When Reports Print Out?

    Glohamar: Thank you! i'll give that a whirl & let you know how it works out. ===================================== foolio: I'm feeling like the fool, as i see i've breached a message board etiquette. My thought was that posting in different threads would result in different opinions as to...
  8. LittleC

    How to Stop Access 97 From Printing Form With Reports

    RoyVidar: Yep, acNormal works much better. Thanks! =============================================== dhookom: Right; i should have referred to it as a popup form that is linked to the main form. My goal was to create something like a custom-made dialog box. Thanks for your suggestion! I'll...
  9. LittleC

    Can't Figure Out Why Form Prints Out With Reports

    Hi there, Hey, I've gotten helpful advice from the experts @ Tek-Tips in the past & thought i'd ask for assistance on this one. When i attempt to use an on click event to print reports, the subform also prints. Is there a fix for this bug in Access 97 or is there something wrong with my...
  10. LittleC

    How Do i Prevent Access From Printing Subform When Reports Print Out?

    Hello, I've gotten helpful advice from the experts @ Tek-Tips in the past & thought i'd ask for assistance on this one. When i attempt to use an on click event to print reports, the subform also prints. Is there a fix for this bug in Access 97 or is there something wrong with my code? Here...
  11. LittleC

    A Way To Stop Access From Printing Subform With Reports?

    Hey, I've gotten helpful advice from the experts @ Tek-Tips in the past & thought i'd ask for assistance on this one. When i attempt to use an on click event to print reports, the subform also prints. Is there a fix for this bug in Access 97 or is there something wrong with my code? Here is...
  12. LittleC

    Cannot Stop Access From Printing Subform When Reports Print Out

    Hi! I've gotten some helpful advice from the experts @ Tek-Tips in the past & thought i'd ask for assistance on this one. When i attempt to use an on click event to print reports, the subform also prints. Is there a fix for this bug in Access 97 or is there something wrong with my code? Here...
  13. LittleC

    How to Stop Access 97 From Printing Form With Reports

    Hi! Hope someone may help me out with this one: THE GOAL: I'm trying to improve the design of a form by removing the buttons used to print reports to a subform that pops up like a dialog box. This custom-made dialog box has one button for each report a user needs to print (nine reports in...

Part and Inventory Search

Back
Top