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 =...
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 =...
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!
:-)
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 =...
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 =...
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.
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.