473,320 Members | 1,930 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Print Security

Hi guys good day, can anybody help me to solve my problem this is the scenario:

All the forms must be filled up completely before printing,
The administrator want to have security in all reports,
the condition is if the user will attempt to print a blank report it will be printed but their will be a bold font in a report saying its just a "SAMPLE REPORT" so that all the reports will not be forge manually by the user, they must filled up the report by using forms, my Control ID is nature by Autonumber.... thanks in advance....
Mar 20 '07 #1
9 1411
Hi guy i think its not much clear for you guys about my problems bacause i dont get any reply from you so i reconstruct my wording

this my problem i have different forms with different reports i want is if the user
is attempting to print a blank report i will allow to print but i want to put on that report a big bold word "FOR SAMPLE REPORTS ONLY" so that the user cant forge the report manually because i want all the reports to filled up by its form hope its kinda clear for now i need some idea how to do it thanks in advance
Mar 20 '07 #2
Rabbit
12,516 Expert Mod 8TB
Create a non-visible Label and use:
Expand|Select|Wrap|Line Numbers
  1. Dim rst As Recordset
  2. Set rst = CurrentDb.OpenRecordset(recordset of report)
  3. If rst.RecordCount = 0 Then
  4.    LabelName.Visible = True
  5. End If
Mar 20 '07 #3
Hi rabbit i tried the code uve given to me but i encounter some errors

" Compile Error : Expected: list separator or ),

should i put the script on the form right? thanks
Mar 21 '07 #4
Hi rabbit i tried the code uve given to me but i encounter some errors

" Compile Error : Expected: list separator or ), The error pointing to the
Set rst = Currentdb.openrecordset(recordset of report)

should i put the script on the form right? thanks
Mar 21 '07 #5
Rabbit
12,516 Expert Mod 8TB
You should put it in your On Open event of the report and you'll have to rename some of the things. If you did all this, post your code and we'll take a look.
Mar 21 '07 #6
hi rabbit i cant find the do open event in the report where can i see that? sori im new in access : (
Mar 21 '07 #7
NeoPa
32,556 Expert Mod 16PB
Try this (It can't be done in the report's Open procedure as the property has not been set yet - at that point) :
  1. Open your report in Design View.
  2. Use Alt-F11 to open the VBA Window.
  3. Near the top of the code pane you will see two drop-down boxes. In the left one, select your Page Header (probably called PageHeaderSection).
  4. In the right-hand one select Format.
  5. Paste the following procedure in.
Expand|Select|Wrap|Line Numbers
  1. Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
  2.     Me.YourLabel.Visible = (Not Me.HasData)
  3. End Sub
This should create a procedure for you. Remember to change "YourLabel" to the actual name of your label. Don't forget, I don't know what you've called the label that Rabbit got you to set up as you haven't told us :s
Mar 21 '07 #8
Thanks NEoPA and Rabbit for the big help it works smooth and properly...Thanks again
Mar 22 '07 #9
Rabbit
12,516 Expert Mod 8TB
Not a problem, good luck.
Mar 22 '07 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: CrazyCoder | last post by:
Dear all, I'm trying to find the solution where to print my reports without using IE's print functions. Most of my required report needs to print out 'clean' ...... I checked around with...
0
by: Tessa | last post by:
Is there any security reason why you cannot print to a network printer from ASP.NET under IIS6 on Windows 2003 server? I'm using ASP.NET code to print to a server print queue using...
4
by: rom | last post by:
I need to print a html table when the user clicks on a key. the problem is that i don't want the printer dialog box to appear. i guess this is impossible in javascript so i think to create an...
5
by: Sunil Thomas | last post by:
Hi, I have developed an ASP.Net application to assist our Field Engineers compile online site survey's for on site assets. The application is functional except for a major setback which is the...
4
by: Peter | last post by:
ASP.NET 1.1 Does anyone has an example where user can click on an link or button and print the current page? Thanks Peter
22
by: stephen | last post by:
I have created an order form that users javascript to create a new html document when the customers clicks the "print page" button. Once the new document has been created it then prints the...
3
by: John Peterson | last post by:
Hello all! I'm at my wits end trying to search for what I assumed to be a relatively straightforward task. I have a Web application written in C#, and I have a button on the form that I want to...
4
by: Vera | last post by:
Hi there! I'm a total newbie at web development, so I started bydownloading and installing Visual Web Developer 2005 Express Edition as well as SQL Server 2005 Express Edition. I also downloaded...
10
by: S_K | last post by:
Hi, I have a directory full of a number of .PDF files that I need to print. Is there any simple way to do this? Using PdfReader purhaps? Thanks in advance. Steve
4
by: ems9tech | last post by:
I have code that works fine on my XP machine. It loads an HTML document into the VB 6 WebBrowser control and then uses the following command to print the document without any print dialog box: ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.