Reports :: Can Report / Printer Margins Be Changed At Runtime
Nov 10, 2013
Access 2007 RUNTIME.I have 2 different printers, 1 for invoices A5 & one for general use A4.
I use
[URL]
and can change printers & some stuff but can't change margins.
Is there a way to change these margins via VBA that can be set in RUNTIME.
Like now, I have just had thousands of invoices pre-printed layout but the company managed to move the margin 5mm over so I have to program my MDB reports to reflect that.
My workstation has a default printer that only prints A4, but I have an Access 2007 file with reports that require A3.
When I open these reports they see the A4 'default' printer.
If I try to change to the A3 printer in the report page setup (in design or print preview mode) it doesn't change - it keeps the default 'A4' and/or Access crashes.
If I change my workstation default printer to
The A3 printer and then open the Access file & report it works Ok (it picks up the A3 printer as default).
Can I use VBA to set the default printer and page setup to A3 when the report opens?
I've got a problem in my access 2007 database. In my office, I have to print invoice reports on pre-ready papers. So the place of every printed object should be fixed. my problem is that whenever the list of sales icons increases or decreases in Detail section of report, the location of total part in report footer goes up or down. I want this location to be immobile and not changed !
I have an unbound form with an associated report. When the user hits the 'print' button on the form/screen, the report is launched in the background. In the On Load event of the report I populate the report fields from the forms field as so:
This works like a charm as long as I call the report in Print Preview mode (i.e. with acViewPreview). But if I send the report directly to the printer, none of the fields print.
I've read about using other report events to populate the fields (e.g., On Format and On Print) and also something about using TempVars to pass the data. But I haven't read anything that's clear and definitive about the full answer.
I have a lovely report that includes a small color photograph. I'm sending the report to print on my HP Color LaserJet, but it is printing in black and white.
I can't find anything in the Properties that specifies whether this prints in color or black & white.
I design/maintain an Access database for a friend's business using my home computer. The printer he uses allows for much smaller margins than mine does, so anytime I edit a specific report that uses very small margins, my computer automatically increases them to the minimum margins my printer allows and when the business owner runs the report on his computer it spills on to extra pages.
Right now every time I make a change, I need to go directly to his computer and adjust the margins within the report after the new front end is uploaded.Is there any way around this, such as telling Access to ignore the printer's minimum margins?
I am having a problem setting the margins to print labels in access. I go to page setup and change the margin size click ok and nothing happens to the label and when I go back to page setup the margins have returned to their original values. I have already selected the label printer and labels that im using.So im baffled as to why it wont accept margin values that don't cause the label to be printed over 3 labels.
I have an annoyance!!! I have a few reports in the access database that I'd like to hard code the print margins so that when I send any database updates to users that have different printers, the margins all come out the same. So that I don't have to then go to each computer I've updated the database on, to open each report and reset the correct print margins.
Another annoyance - along the same lines: A report that previews correctly several times and then - for no reason, previews with larger margins and, hence, data is lost off the right.
I've created a pretty powerful Access Database that pulls information out of some ODBC tables we have on our local server. Of course, I created the database and all the forms and reports on my work computer here. But, when I was finished, I sent that entire database out to probably 20 or 30 people in the company. On a daily basis, they run the same program from their own computer and they like to print/export/etc. the reports that are produced. However, I don't understand why those reports print our on my personal printer (the printer is on the network). If they have a default printer at their site, why wouldn't it print there? Also, I haven't included any printing macros or VBA coding. I'm tired of having 30 or 40 sheets of paper print out on my printer daily. Any suggestions?
I've created labels in my database and when I print them on a label printer, I get a blank label in between my printed labels. I've checked the printer settings and properties and can't find anything. I've also checked the database properties and can't find anything. Is there something in the database that I'm missing?
I have a database with a mail label printer and another printer attached to the computer. I would like the user to hit the command button for each of the printers and have the selected data printed without having to select which printer to use each time.
Note: Printer "set up" doesn't work, even when form is in design view, because after print is done, back to dialogue box when trying to print the next time.
I have a button that I click and it gets a value from my form and opens a query linked to a report, grabs the records, populates the report, and previews the report.
What I want to do now is Run the Query, dont show it, but print it to a deisignated Printer.
1. How can I run the report, not show it, but print it?
2. How can I force a print to a specific printer on my network?
I have recently changed computers from a WindowsNT to and XP. When using the NT machine, I am able to print my Access report. However, when I hook up the XP machine and request a report from one specific database, I get the following message....this message also comes up if I try to open print preview or page setup.
"There was a problem retrieving printer information for this object. The object may have been sent to a printer that is unavailable."
I don't think it is a printer error as the error is occurring in this one database. I have successfully printed a test page and can open up other Access databases and print. I also tried converting the database to the 2002 format....but that did not make a difference either. There must be a setting in the database that is causing the error.....
Can you send a report directly to the printer? We have Clients with multiple Contact Notes, by multiple Clinicians, each of these are separate tables. Every month we print two reports for each client that had at least one contact in that date-range. Usually 200 clients, takes a lot of time. My approach so far is a query within a make-table query to get a list of unique client ID's that had one contact in the date-range. Then I use that table in code to create a recordset, use a Do Loop within that where I print the two reports for the 1st client, move to next record and loop. Now that I've got it working I'm not sure how to print all the reports My 1st question, can you send a report directly to the printer from code? The printer is a networked Konica Minolta Biz-hub so I think it can handle that many jobs being queued that fast.
I have a project which produces a report of names, addresses, etc. I added a print button to the form to send the report to the printer. The code is as follows:
Private Sub Command32_Click() Docmd.SetWarnings False 'Docmd.OpenReport "rptAddresses", acViewNormal Docmd.RunCommand acCmdPrint Docmd.SetWarnings True End Sub
Both alternatives in the code produce the same result described following.However, the printed report includes only the first 2 colums of about 10 of the 90 plus records. If I send to to a PDF, it works fine. If I do a print view on the screen ir looks fine.
I created a query and one of the fields was "name". In the query it listed the names and then changed to the ID number of the names from the name table. The query was created using the wizard. Why did the query change to the ID number mid report and how do I get it to report only the names and not the ID number.
I am using Access Runtime for the database for the staff however some reports have print options at the top of report previews and some don't and I can't figure out why..All the buttons and properties seem to be the same as the ones that are working.
I have built a simple database for a client and create a runtime which all worked fine. I have a question that if I want to update forms and report or queries and then create a new runtime his data will be lost.
Can I create a runtime which uses the original database but updates the forms and reports etc.
On all other systems these reports print out fine.
I just set up this reporting system on a new computer and when I print, the reports print on two pages - second page had a tid bit of an order date.
On the other systems, all the page margins ( top, bottom, left & right ) are set to .25" and the column width is set to 8".
I also receive this message upon running the report: The section width is greater then the page width, and there are no items in the additional space, so some pages may be blank.
If I manually move this Order Date field over it does not properly print in the Order Date box on the form fed document.
This report is printed to a OKI Microline 320 Turbo 9 pin dot matrix printer.
All my margins are at .25" EXCEPT for the right margin, which is at .416" ... WHICH I AM UNABLE TO CHANGE!! Why?
I have reinstalled the proper drivers for this printer and have up to Office SR-2 installed.
Why am I unable to change the right margin to .25", if all the other systems have this setting?
Any suggestions are muchly appreciated, as I am seriously frustrated with this situation .... if I have left out any pertinent info .. please send your questions my way ....
I have a form that nearly fills an a4 sheet of paper when printed. For this reason I have to set the margins from 24.99 down to 5.
This is ok and the form works well and prints out properly about 75% of the time. Occasionaly when I open the form it has reverted back to the 24.99 margins which of course prints out on three sheets of paper and is all over the place.
Is ther a way to set the margins on load and can anyone suggest an appropriate bit of code.
