Modules & VBA :: Restrict Printing Rights To Users - Print Blank Pages
Feb 10, 2014
I've been asked to make sure only certain users in my database are able to print anything (i.e. Administrators). Is there any option/property to do this?
I have already built in User Access controls using the ctl.Tag property. The only way I can think off the top of my head is when a 'general user' uses it, to ensure that every control is displayed 'on screen only'. This of course doesn't stop them printing - just makes them print blank pages!
I'm designing this system in which each end user should has a password, and each user has different rights, some can just read, some can add, some can update and some can delete.
how can I achieve that?
I also want to know how can I disable the auto save in MS access, as we know access does auto save. I want access to save only when a save button is clicked.
Can someone please help me out? I have a login form which asks for the users name and password and that all works fine. However, I then want to open a form giving them different editing rights depending on the access level I have assigned them. I have copied the code below. The intAccessLevel is being read in properly but when the form "Sample" opens it ignores the Me.Allow.... statements which corresponds to the different access levels. Does anyone have any ideas why this is the case?
I want to restrict the users to only be able to access certain tabs in the ribbon .example "user1" cannot access the external tab and the create tab, but can access all others.
I have a report where the detail section, holding 4 subreports, takes up 5 inches in the middle of the page between the header and footer. We want the entire 5 x 8 area enclosed in a box on every page. I have tried to achieve this by putting a line in the Detail_Format section:
Code: boxDetail.Height = 5 * 1440 * Pages
However, when I run the report, I get pages 1/3 correctly, then 2/3 and 3/3 with no detail section or box, and then pages 4/3, 5/3, and 6/3 with blank detail sections and no box. If it's a 1-page report, the same - page 1/1 is perfect and page 2/1 is blank, no data and no box. I also sometimes (but not always) get overflow errors from the Detail_Format event.
I know it's not a margin error because that would be every other page, and the page count wouldn't be doing that. (Still, I have scrupulously checked every margin, and they all look fine.) Getting this look on the report is a priority. Any way to achieve the same result with the box without causing the missing data and extra pages?
I am displaying table records in access form Datasheet view. While business users accessing that form, they are hiding and rearranging some columns for their use. So it will be hard for other users to access. I just want to know any settings are avaible in MS Access or can we accomplish this using any events or macro or modules??
When I print reports, Access is printing 2 pages per sheet, making the text VERY small. However, EVERY setting that I can find, whether the main printer setup or the Access program itself, shows that it's supposed to print only ONE per page.
The only program that this occurs with is Access. Is there a setting somewhere that I'm missing? Thanks.
I've got a report, which on the screen is three chrts and a page break in between. Page is set up to print landscape.
When I print the report or save to pdf it adds a lot of pages in between 2 and 3. It seems to be of chart no.2 getting smaller and smaller. I've attached a copy of the pdf so you can see what I mean.
While I have worked with computer all my life I am new to Access. I managed to create my database and the report I wanted to generate. However; I cannot get the Report Header to print on all pages. It only prints on the first page.
I'm working with getting a 3 page report to print/create PDF of the 3 pages. Right now I have the formatting set up for the 3 pages but each is an individual report.Is there a way to combine the reports into a single report? I've been messing around with subreports but can't get it to display correctly.
I have several tables and the default layout is one table per page. In some cases, there are a couple of fields...a waste of paper. Can this be changed?
I have set up a report in Access. However, when I look at it in print preview, I get the message that the section width is greater than the page width, and that some pages will be blank. It is obvious that the Detail Section is the issue, but I can't figure out how to reduce the section width. The detail section only contains a few text boxes that are well within the margins of the other sections.
How do I adjust the section width so there won't be any blank pages?
I created a form that opens to a blank form. I also have a print button on the form. I want to be able to print the blank form, but nothing happens unless the primary key has a value in it. Is there a way to print just a blank form? I have been working at this problem for a few weeks. Please help!
I have a bound form that I created. I want to be able to print a blank form. When I click on my print button, nothing happens. Also, when I click on the print icon, I get the following error:
I just updated to the latest version of Office 365 and now have MS Ascess "2016 MSO (16.0.4229.1029) 32-bit" installed on my Win 10 PRO 64-bit system.
I have images in several reports that I print out. These images displayed and printed just fine under the older version of Access. Under the new version, they neither display, nor print. They are visible in Report, Layout and Design view, but not in print view. They do not print nor do they export to a PDF file either.
I was having trouble just setting each report with a particular print method - for some reason they just kept forgetting their individual settings and resorting to default on the machine.
This meant reports were printing on the wrong paper, or the wrong size paper, the wrong orientation and some times refusing to print if it couldn't find the paper (which is useful in runtime as it doesn't display error messages)
So I used Reports(rpt).printer properties (I forgot where I found this) to hard code the printer properties into each print command... this meant I had to use another function to insert the variables.
So all I had to do was say:
Code: PrintMe("Invoice","InvoiceID",iID)
and a report would print to exactly how I wanted... but it's just too slow!
See attached for full code, I have a niggling feeling it may be the function: PrinterOK, to make sure the printer exists or not.
Code: Function PrinterOK(sPrinterName As String) As Boolean Dim MyPrinter As Printer PrinterOK = False For Each MyPrinter In Printers If MyPrinter.DeviceName = sPrinterName Then PrinterOK = True Exit Function End If Next End Function
I know it's the printing code, because if I stop the printing and just preview then it shows up almost instantly.
I have an Access 2000 form containing several subforms that needs printing on a regular basis, which works fine when the subform contains data, but sometimes the subforms contain null values. We want to print the subforms without the data to maintain consistency, but when printed they have disappeared and a blank space in the form is printed. The subforms view perfectly in print preview... any help would be appreciated, I have spent a good deal of time researching this issue without any leads
Hello Here's the problem: I'd like to print multiple reports using a button in a form. I guess I could use something like that: DoCmd.OpenReport "report1", acNormal DoCmd.OpenReport "report2", acNormal DoCmd.OpenReport "report3", acNormal DoCmd.OpenReport "report4", acNormal etc in the command.click sub but here's the tricky section: Some of my reports (they are all based in select queries) do not contain data. How can I make access print only these forms that include records ? For example if the query that provides records to the "report2" returns nothing, I would like on the commabd click event mentioned above, only the report1,3and 4 to be printed. Am I asking too much?Hope you guys understand what I'm talking about. Sorry , if my English isn't too good Thank you in advance
I have a form that that contains a button that opens a report. The code I use to open said report is:
Code : DoCmd.OpenReport "Comp and NB Targets Q4", acViewPreview, , strWhere
The issue is that occasionally when the user prints from that preview, it can instead print out the form in the background that was used to open the report.
This seems to happen at random and I have not yet found a pattern or solution to the problem.
Is there a reason this could be happening and is there anyway to stop it?
I have report that i have in preview. In that report i have ribbon that has buttons close and print. Close works fine, with print it goes ok but when "printer selection" comes, i try to change printer it informs that not enough memory. All this code that is in ribbon buttons is in VBA.
What could be the reason for memory stuff or how could this be made that this inform wouldn't come.
Code below: Sub EnnakkoMyButtonCallbackOnAction(control As IRibbonControl) Select Case control.ID Case "MyBtn1" DoCmd.OpenReport "Tuotanto Ennakko", acViewPreview
I'm having an odd problem with a form. We noticed this since migrating it from adp to accdb.
It's a form with two subforms in datasheet view, that contain data on a certain employee, which is selected on the main form.
If you use print preview before printing, it all prints out fine. However, if you use quick print, it does something weird. If you Pull up Employee A, then Employee B, and do a quick print, it will print the data for Employee A in subform 1, and the data for Employee B in subform 2. It displays correctly on the screen though, and the 2nd time you quick print, it comes out right.
All i want to do is to print my report (with the records ideally!) which has a subreport header at the top but all i am getting is a single blank record?!
Surely this is not too much to ask but it is holding up the whole project!!!
