Reports :: Margins Change Between Computers
Apr 1, 2014
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?
View Replies
ADVERTISEMENT
Dec 30, 2013
I'm using Access 2003.
Is it possible to set the top margin on the first page of an Access report different from all the other pages?
View 10 Replies
View Related
Jul 11, 2015
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.
View 1 Replies
View Related
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.
View 3 Replies
View Related
Dec 26, 2006
Well...here's the deal. Four computers were replaced in our office and now three of them are having problems with the database. The database is written in Access2003 and all computers (the old ones and the four new ones) are running on WindowsXP Professional w/ Office 2003.
The problems that comes up only involves reports (viewing, email, exporting). When they try to view a report, a message comes up
Cannot find object ".
When they try to email or export a report the function is cancelled due to the error.
I'm going to have the computer admin re-install Access to see if that helps.
I've been searching around trying to find some info on various settings that would cause this, but I'm pretty ignorant in this arena. I checked the references in Access and they are both the same. That's about the extent of my knowledge in thise area.
Any insight would be great.
Thanks for the help.
BB
View 7 Replies
View Related
Jan 17, 2015
I have a report that was created on my computer. When this report is opened on other computers (2 that I've tried) the text alignment is way off. Originally I thought it had to do with printer margins dictating something but that is not the case as the margins remain identical on all computers. It's not a font issue because it's Arial which all computers have. The text is written inside a "label".
View 5 Replies
View Related
Apr 24, 2013
I have a report (Access 2007) with subreports that is being exported to pdf. It all works fine on PC except for on a virtualbox and a laptop. When the user exports the report to pdf, it leaves some subreports blank! If the report is opened in the DB it pulls data as it should and all looks fine.
In the report, the missing data is from 4 subreports in the same top section of the report where a 5th subreport also resides. Subreport 5 is displayed OK. There is no dynamic formatting nor filtering in the reports.
These two machines had to have the 2007 Microsoft Office Add-in: Microsoft Save as PDF installed for the PDF export to work at all. Both machines are up-to-date on the latest windows updates. The virtual box runs XP while the laptop runs Windows 7.
This is the strangest error I have ever encountered as it only partially fails and it cannot be replicated on a regular PC.
View 4 Replies
View Related
May 4, 2005
I have set individual margins inside text boxes in my app.
I want to set some white space inside the combo boxes, too, but that option isn't available in properties.
Is there a straightforward way to set inside margins on combo boxes?
Thanks in advance!
View 2 Replies
View Related
Mar 27, 2006
I have an Access 97 reporting DB.
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 ....
Cheers!
QT
View 2 Replies
View Related
Aug 18, 2006
Hi Everyone
I wonder if anyone can help me please.
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.
Kindest regards
Tony
View 4 Replies
View Related
Jan 19, 2006
I want to print a page with .5 magin instead of the typical 1 inch. I am using access 2000, so i can not use printer.leftmargin. Is there a way i can do this through code somehow instead of going into page setup on each users computer? If the page margin is set to larger than 1" it will print on 2 pages.
Anyone have any suggestions on whare to start? All i can find is how to adjust page margins in a report. Or with a later version of access.
View 3 Replies
View Related
Feb 6, 2008
Good morning all.
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.
Any suggestions would be appreciated.
Thanks
Martin
View 1 Replies
View Related
Aug 19, 2007
IS IT POSSIBLE TO AUTOMATICALLY SET THE REPORT PAGE MARGINS (TOP, BUTTOM,LEFT, RIGHT) at the Report Open event?
View 3 Replies
View Related
Mar 21, 2014
I have the following code in a module to set certain formatting properties when exporting an Access 2010 query to Excel:
With xlApp
.Application.Sheets("Spoilage").Select
.Application.Cells.Select
.Application.Selection.ClearFormats
.Application.Range("A1:K1").Select
.Application.Selection.Font.Bold = True
[code]....
This works perfect but now I need to set some of the page layout properties (margins, orientation, etc.)
I have tried adding this:
With ActiveSheet.PageSetup
.LeftMargin = Application.InchesToPoints(0.5)
.RightMargin = Application.InchesToPoints(0.5)
.TopMargin = Application.InchesToPoints(0.75)
.BottomMargin = Application.InchesToPoints(0.75)
.Orientation = xlPortrait
.PaperSize = xlPaperA4
End With
But I get a complie error (Method or data member not found) on the .InchesToPoints part of the line.
But I get a complie error (Method or data member not found) on the .InchesToPoints part of the line.
View 2 Replies
View Related
Jul 30, 2007
I have a program thats work perfectly in some computers useing the network but when i try to open it in other computers i get an error and when i try to debug the error it highlit the line that i am calling the micro that open the mainform in it, i hope some one have an idea for what is going on with the program
View 12 Replies
View Related
Apr 24, 2007
Hey, My access database will be used to make computer reservations for an internet cafè. The user makes their reservation date by using a calendar control, they choose their start and end time, and they also choose the amount of computers they can book (no more than X). Would it be possible to create a query that will limit the user from overbooking the computers?
View 14 Replies
View Related
May 26, 2006
I created the database on my computer. I added security and split the database to put the tables on the the server. Everything works just fine on my computer. However, when I try to copy the 3 files for the front end of the database to other computers on the network, it won't work.
Perhaps I'm confused as to what files need to be migrated to each additional computer or I don't have the security setup properly.
Right now, I move 3 files. The main database file with the front end. The shortcut file that is created when you add security and the security file that is created when you add security to the database.
I'm stumped.
View 4 Replies
View Related
May 9, 2005
Hello All,
I have MSAccess ade working in some computers which has WindowsXP-pro(SP1 and SP-2) without any problem. But It doesnot work(When i said it doesn't work means it doesn't work in certain parts which i will give an example) in some computers that has exact same configaration. The problem is when I try to instance a class using a TypeName function, it doesnot recognize the class name and just returns an object rather than recognizing the class's name. Its a strange thing because I have some .ade from past works fine in all machines. The only difference is In the new .Ade is I have included the Microsoft outlook 11.0 object library. But the part of the code thats not working doesn't even use the Outlook library at all. So did anyone has this kind of problem, PLease suggest or ask me if you have more details of this problem. I really appreciate your help.
Thanks again
ds111
View 2 Replies
View Related
Feb 4, 2008
Hi,
Hopefully this is a really simple requiring a simple answer.... hopefully
On one of my forms I have a combo box thats values are generated by a parameter query. On my computer and a couple of others i tested it (on the same network) this combo box populates fine, but i put it on a couple of other computers today and it doesn't show any values. I checked and the query itself runs fine, plus a combo box that runs off a table populates fine.
not too sure if its relative but the database is split with the tables sitting on the network share and the database sitting on the main computer. or perhaps this could have something to do with blocking unsafe expressions.. i am not sure
any help on this would be greatly greatly appreciated
View 8 Replies
View Related
Apr 26, 2007
I have 2 tables tblComputers & tblComputerAllocations
tblcomputers has 85 records & tblComputerAllocations has 71.
I would like a query that returns the 14 computers that have no allocations.
I tried a union query on field ComputerID but i must misunderstand its use!!
Thanks in advance,
Phil.
View 14 Replies
View Related
Jan 4, 2005
Does anyone know/how my forms' background colors are different from one computer to another? The computers that are showing the correct color are both XP and Access 2002 (one is a laptop and one is a desktop)... but then someone else.. on a laptop (with XP and access 2002).. the forms' background colors are not good (purple)... vs. blue on my laptop and the desktop. Thanks!
View 3 Replies
View Related
Sep 26, 2005
I have a report that can be used for 3 different queries. I've been trying for the last hour or so to get three different buttons on a form to open this report but give it an appropriate record source.
I figured there's got to be a way that's easier than three queries, and three reports...?
I was trying to use the same format as with forms :
[Reports]![rptReportName].recordsource = "qryQueryName"
or variations of that. Am I way off? It keeps saying that I've misspelled the name or it doesn't exist.
View 7 Replies
View Related
Feb 28, 2015
Is it possible to conditionally change a font name? Report field is set for Wingdings 2 so I can print a check mark if underlying value is true. Wanting to change back to calibri to print "X" if not true. Haven't been able change it in an if statement. A macro setvalue fieldname.fontname to "calibri" throws type mismatch error. Setproperty choices don't include fontname.
View 2 Replies
View Related
Sep 21, 2011
I would like to change the reports drop down.
1) Change the names of the reports
2) Add additional reports.
View 5 Replies
View Related
Jan 8, 2013
I recently completed a database project and was set to launch it today for use throughout the company. The database is split, and both ends are saved in the same folder on the company server. I have copied a shortcut to the front-end file onto the desktop of each of the four user computers. Two of the four users are able to open and operate the front-end with no issues. The other two won't run the 'Default Value' formula for the "Order#" field in the front-end form. This being the case, I'm certain this is not a code issue.
Form
- Field
- Control Source
- Default Value
PO#
= [YEAR] & ["P"] & [Order#]
N/A
[code].....
When I opened the form on the two noncompliant computers the PO# field displayed #Type!.I deleted the Order# default value to confirm that that was indeed the source of the problem, and it is. When deleted, the PO# field displays "13P" instead of "#Type!".
I've tinkered around with Trust Center to no avail. And I'm almost certain this is not an upgrade/patch issue as one of the nonconcompliant computers had Access 2010 downloaded yesterday. The server and all users have Access 2010.As well, the option settings on the front-end are set to only open the form, with no editing capabilities. However, when using Shift+Enter to open the edit capable version, there is no issue; the PO# populates.
View 3 Replies
View Related
Jun 25, 2015
I have an estimating database, the "main" database is on my desktop, then it is also on a Notebook and Laptop and goes out with the bidders. At the end of the day, I want to sync all 3. I may enter info throughout the day on my desktop (which needs to sync up to the other 2) and vise versa. Using SharePoint is not an option as the Notebook and Laptop will not always have internet access.
View 1 Replies
View Related
