A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Display When" field for an Image - Macro??



 
 
Thread Tools Display Modes
  #1  
Old January 31st, 2008, 07:03 PM posted to microsoft.public.access.forms
sandog
external usenet poster
 
Posts: 10
Default "Display When" field for an Image - Macro??

I'm using a signature device to capture signatures/passwords in a
form.
Right now we have 2 options within the form.
1. Print the form
2. Export the form to an archive system where all of our documents
are stored.

I'm working w/ member sensitive information.
The way we want the form to work is that we can print the form WITH
the password displayed.
But when the form is exported to the archive system, the password is
NOT displayed.

The form is exported to the archive system by way of an image print
driver. So, when we click export, it prints the form to a TIFF file
which is then exported.

So, this is my idea of what I want to do.
Set the default "display when" field of the image to "Screen Only"
within the Form itself.
But create a "print" button that will change the "display when" field
to "Print Only" when I hit the print button.
This way when I export the document and it uses the image print driver
to convert it to a TIFF, it won't create it w/ the password b/c it is
set by default to "Screen Only"

Hope this makes sense....
Is this possible, and can someone lead me in the right direction?

Thanks for any help

  #2  
Old January 31st, 2008, 08:30 PM posted to microsoft.public.access.forms
sandog
external usenet poster
 
Posts: 10
Default "Display When" field for an Image - Macro??

On Jan 31, 2:03 pm, sandog wrote:
I'm using a signature device to capture signatures/passwords in a
form.
Right now we have 2 options within the form.
1. Print the form
2. Export the form to an archive system where all of our documents
are stored.

I'm working w/ member sensitive information.
The way we want the form to work is that we can print the form WITH
the password displayed.
But when the form is exported to the archive system, the password is
NOT displayed.

The form is exported to the archive system by way of an image print
driver. So, when we click export, it prints the form to a TIFF file
which is then exported.

So, this is my idea of what I want to do.
Set the default "display when" field of the image to "Screen Only"
within the Form itself.
But create a "print" button that will change the "display when" field
to "Print Only" when I hit the print button.
This way when I export the document and it uses the image print driver
to convert it to a TIFF, it won't create it w/ the password b/c it is
set by default to "Screen Only"

Hope this makes sense....
Is this possible, and can someone lead me in the right direction?

Thanks for any help



I figured it out...
It was actually pretty easy.

Private Sub PrintForm_Display_Click()
On Error GoTo Err_PrintForm_Display_Click

imgSigJointA.Visible = True
DoCmd.PrintOut
imgSigJointA.Visible = False

imgSigJointB.Visible = True
DoCmd.PrintOut
imgSigJointB.Visible = False

Exit_PrintForm_Display_Click:
Exit Sub

Err_PrintForm_Display_Click:
MsgBox Err.Description

thanks
  #3  
Old January 31st, 2008, 08:31 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default "Display When" field for an Image - Macro??

Forms are really not for printing. I would suggest creating a report that
contains the data on the form you want to archive.
--
Dave Hargis, Microsoft Access MVP


"sandog" wrote:

I'm using a signature device to capture signatures/passwords in a
form.
Right now we have 2 options within the form.
1. Print the form
2. Export the form to an archive system where all of our documents
are stored.

I'm working w/ member sensitive information.
The way we want the form to work is that we can print the form WITH
the password displayed.
But when the form is exported to the archive system, the password is
NOT displayed.

The form is exported to the archive system by way of an image print
driver. So, when we click export, it prints the form to a TIFF file
which is then exported.

So, this is my idea of what I want to do.
Set the default "display when" field of the image to "Screen Only"
within the Form itself.
But create a "print" button that will change the "display when" field
to "Print Only" when I hit the print button.
This way when I export the document and it uses the image print driver
to convert it to a TIFF, it won't create it w/ the password b/c it is
set by default to "Screen Only"

Hope this makes sense....
Is this possible, and can someone lead me in the right direction?

Thanks for any help


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.