I have an Access 2003 database which is used to print an Invoice into a pre-printed 8.5 x 14 form in the printer.
The report design uses an Ole (Unbound Ole Frame) of Microsoft Word.
The users need to be able to print the invoice but I need to add a big text watermark saying 'DRAFT' accross EVERY page within the report that the user prints.
How can I programatically print this water mark unto the pre-printed form when user clicks a cmdDraft button.
I have come across something to do with this in the past (but have no idea how to implement it)...I am also familiar with pdf format at: http://www.verypdf.com/art
...but I dont really need this format what I need is something built in into the report design - like an overlay of the text word "Draft" in the background of the OLE that perhaps may be hidden or visble when Access form button is clicked
What is this the best way forward? I will appreciate it someone would be willing to post a sample db or a link to a sample to illustrate this technique.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
billcute,
"How can I programatically print this water mark unto the pre-printed form when user clicks a cmdDraft button."
Preprinted Access "Report" or preprinted Access "Form", or is this a preprinted "Paper Form".
For example If they have a 4 page "Preprinted Report", you want to be able to load the preprinted pages back into the printer and print the word "DRAFT" on each sheet?
Jeff:
It's preprinted "Paper Form".
When user wants to print, he has the option to choose between printing just the data on to the preprinted paper form or print the report (OLE and the data) to a plain paper. This means that both the graphics and data are printed.
Currently user prints the data only by hiding the Ole with code and makes the Ole visible again when user decides to print both data and graphics.
Jeff:
In my question, I asked...
1). ....How can I programatically print this water mark unto the pre-printed form when user
clicks a cmdDraft button.
2). What is this the best way forward? I will appreciate it someone would be willing to post
a sample db or a link to a sample to illustrate this technique.
If you could assist with these, it will be appreciated.
Regards
Bill
Jeff:
Thanks for your sample but I did not see thje graphics sample you described under ID: 22410036
Your noted:
"Add a logo or background image (a watermark) to a form or report
When you add a background image or watermark, the other controls on your form sit on top of the image. For an example of a background image on a form, start the Northwind Traders sample database and open the Customers form."
Also under ID: 22410202
For example If they have a 4 page "Preprinted Report", you want to be
able to load the preprinted pages back into the printer and print the
word "DRAFT" on each sheet?
Regards
Bill
Opps, I forgot to include the linked image.
You can create your own "Fake" Watermak image and use that.
Just use Word's WordArt and insert the word "Draft" and rotate it diagonally then do a screenshot of it, and name that to the same name as my linked file, and put it in the same relative location.
If not, I will post the File tonight,
let me know.
Jeff
Yes, in the sample I use two linked Images.
One was the waterMark and the other was a "Blank" image.
The Report needs them to be in C:\
(Your Root Directory/Folder)
Here they are.
JeffCoachman
DRAFT (Watermark)
"Blank" image
Jeff:
Thanks for your sample.
I am abit confused as to why you referenced blank.bmp in printing "Report only" from this
function... couldnt you just hide the watermark at this time while report prints..
...what if I want to print "data only" to the pre-printed form ...
then Me.Picture would be.....what? .....C:\Blank.bmp ....?
Here is your function:
_____________________
If strpubReportPrintOptions = "ReportOnly" Then
'
Me.Picture = "c:\Blank.bmp"
ElseIf strpubReportPrintOptions = "ReportAndWatermark" Then
' nothing
ElseIf strpubReportPrintOptions = "WatermarkOnly" Then
Dim ctl As Control
For Each ctl In Me.Controls
ctl.Visible = False
Next ctl
End If
End Sub
***********
Regards
Bill
Oh, OK.
;-)
A few reasons:
1. It is not inherently obvious how to turn off the watermark.
Me.Picture.visible=False, wont do it.
Neither will: Me.Picture="", or Me.Picture=Null.
Setting the image to a "Blank" image simply changes the source image so I do not have to worry about "File not found" or "Invalid use of Null" errors.
2. It is consistent.
I can use this technique for Unbound image controls on Forms and Reports (Viewing record linked images).
This way I handle all my "Image/No Image" situations in the same manner.
Some controls will accept "Null" Images, other will not.
This technique insures that there will be no issues.
And you know me, &I hate "issues".
;-)
JeffCoachman
I used it to copy Ms. word form template into a report design and then printing back to that preprinted form in the printer.. Sending access data directly to the word form was a bit problematic, especially when I want to draw a circle round some words, place some checkmarks on the form.. I would have loved to try access data to pdf. It was quite tougher without having to pay for a software.
Business Accounts
Answer for Membership
by: boag2000Posted on 2008-09-06 at 20:32:32ID: 22410036
billcute,
Here is a pretty good MS link on the subject:
It is a rather long article, because the actual MS link does not provide a hyperlink to jump to the specific section, I will post it here with the link for reference:
http://office.microsoft.co
Add a logo or background image (a watermark) to a form or report
When you add a background image or watermark, the other controls on your form sit on top of the image. For an example of a background image on a form, start the Northwind Traders sample database and open the Customers form.
Open the form or report that you want to change in Design view.
How?
In the Database window, select the form or report to which you want to add a background image, and then click Design . Access opens the form or report in Design view.
Double-click the form selector or the report selector to open the property sheet for the form or report.
On the Format tab, in the Picture property box, click the Build button and use the Insert Picture dialog box to locate your image.
In the PictureType property box, specify whether you want to embed the image or link to the image.
After you add the image to the form, click the SizeMode property and select one of the following values. Setting Description
Clip Displays the picture at actual size. If the picture is larger than your form window, Access cuts off the image.
Stretch Sizes the picture to fit the form window. This setting may distort the image.
Zoom Maintains the correct proportionality of the image regardless of how you size the from. This setting won't clip the picture or distort its proportions.
Note If you need help with a property, select that property and press F1.
If you want to change the alignment of the picture, click one of the settings in the PictureAlignment property box.
Note If you want to center the background picture on a form or report, and you want the background picture to resize when you size the form or report window, click the Center setting. If you don't want the background picture to resize when you size the window, click the Form Center setting.
If you want to tile (repeat) the picture across the background of the form or report, set the PictureTiling property to Yes, and set the SizeMode property to Clip. Tiling starts at the position that is specified for the PictureAlignment property.
Note The background picture will not tile if you set the SizeMode property to Zoom or Stretch.
(Again, this text was copied directly from here:
http://office.microsoft.co
JeffCoachman