I Keep Losing My Margins

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 Replies


ADVERTISEMENT

How To Set Margins In Combo Box

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

!@#$ Page Margins ...

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

Can You Automatically Set A Forms's Margins In A2k.

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

Report Margins (Print Position)

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

Reports :: Different Report Margins On First Page?

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

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 3 Replies View Related

Reports :: Setting Margins To Print Labels

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

Is It Possible To Automatically Set The Report Page Margins (top, Buttom,left, Right)

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

Modules & VBA :: Formatting Page Layout (Margins / Orientation)

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

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.

View 3 Replies View Related

Losing Functionality

May 3, 2006

I am building a database for a client that tracks construction drawings. The client came today to check on progress. Just before he came, I changed the start-up properties to hide the database window, menus etc so it would look more like the finished product.

Problem was, I lost alot of the functionality and had to change it back to demonstrate:( . Is this common and can anyone explain why? much appreciated

View 2 Replies View Related

Is It Corrupting Or ? Losing Use Of Buttons

Aug 22, 2007

Hi,

There's not much space in the title but I hope I caught someones attention that can help.

For starters it's ACCESS97

The database is split into front end and linked tables.

We added few fields a couple of days ago. ( We have a full back-up)

What is happening now is that after a period of time the buttons stop working and give a message saying something like...

The On Click can't find the file or info that it is supposed to be doing. That isn't the exact words, but I don't currently have the damaged version it is deleted. There is no error message number.

The same thing has happened 3 times. Each time I delete the front end and replace it with the backed up copy. This then works again.

Also....

Once the corruption or whatever it is happens, you cannot add any buttons in design view and also you cannot get to the Event Proceedures through the properties and also the Build Event doesn't let you in either. All you get whet trying any of these is a File Not Found message.

Any ideas out there or do I just have to revert back to the copy before the changes ?

It's a very big database about 90Meg Front end and 8Meg Tables

Help Please.

Thank you

Mike:confused:

View 5 Replies View Related

Losing Records In A Query

Jul 20, 2007

Is it possible to have a query retrieve all information from one table, but only partial information from another?

For example, suppose I have two tables, Jobs and Employees.

The Jobs table is a list of all available jobs in the company; some filled, some not. Each job is assigned a Job Number which is unique.

The Employee table is a list of all employees in that company. Each employee is assigned to a particular job, referenced by the Job Number.

The query's job is to provide a list of all Jobs, but with employee information added to those jobs that are filled.

The Jobs table has two fields; JobNum and JobDesc.
The Employee table has three fields; EmpNum, EmpName, JobNum.

Jobs has five records;

100, Boss
105, Aide
200, Manager
201, Worker
202, Worker

Employee has four records;

111, Montgomery Burns, 100
112, Waylon Smithers, 105
121, Homer Simpson, 201
122, Lenny Leonard, 202

Jobnum is the link between the two tables in the query and its fields are;

JobNum, JobDesc, EmpNum, EmpName

What I want is;

100, Boss, 111, Montgomery Burns
105, Aide, 112, Waylon Smithers
200, Manager
201, Worker, 121, Homer Simpson
202, Worker, 122, Lenny Leonard

But, what I get is;

100, Boss, 111, Montgomery Burns
105, Aide, 112, Waylon Smithers
201, Worker, 121, Homer Simpson
202, Worker, 122, Lenny Leonard

Job Number 200, the Manager slot, is being dropped out.

This is the SQL code for the query;

SELECT Jobs.JobNum, Jobs.JobDesc, Employee.EmpNum, Employee.EmpName
FROM Jobs INNER JOIN Employee ON Jobs.JobNum = Employee.JobNum;

How can I get the complete Job list with employee data added to those jobs which are filled, while leaving the vacant positions - well, vacant, but still included in the query's result?

Thanx!

View 4 Replies View Related

Top/Max/Subqueries ... Losing My Mind

Mar 8, 2008

I've looked at so many options for writing this query that I can't see the forest for the trees and hoping you kind folks will point me in the right direction.

I have a table called services that includes:

service_id
prop_id
service_year (ie: 2007, 2008)
service_date (ie: 3/3/08)

service_id is a unique ID for each service which relates to data I will need to pull from another table.

prop_id relates to a property ID in another table, not unique as multiple services against one property.

The problem that I have is that each prop_id can have more than one service_date for the same service_year. I need to be able to find the latest service_date on a prop_id and its associated service_year and service_id.

Any pointers would be greatly appreciated. BTW, using this in Access 2003 & 2007

View 14 Replies View Related

Subform 'losing' Data

May 12, 2006

I have a form and subform. Clicking a record in the subform displays the details of that record in the main form. The form is used for editing, adding and deleting data for a given person's sales record and the subform displays a full list of all records for that person.

When I edit a person's record, using the main form, and click on a button to run the code:

DoCmd.RunCommand acCmdSaveRecord

I can go into the underlying table and see the changes. I can also refresh the subform and see the changes.

However, the next time I click on any of the records in the subform, the value in one of the fields vanishes from both the subform and the table. Any other changes made, to however many fields, remain.

Surely, if there's a problem with that field, the update shouldn't happen at all?

View 3 Replies View Related

Losing Records In Tables

Mar 19, 2012

My company had an Access db created back in 2002 in order to create file names (Legal Labeler). The db consists of many reference tables (Figure 1). The person who created the db created a form to use in order to create the file name and labels. As you can see there are various drop downs where the end user can choose which information to include. I do not think that the tables are linked. Once the end user fills in the form they click Save Label Data and the data is written to a master table (Table tblLevelOneSubject).

One of the problems we are having is that records in any one of the extraneous tables (Company Name, SubCatetory, SubCategories L1/L2, etc.) just disappear. For example, in Figure 3, we have all the entries for the drop down labeled SubCategory (A codes are depicted) but, for some reason, we are randomly missing some of the codes (typically all the A codes and B codes); however, nothing from the master table is missing (that is why I do not believe they are linked).

Another major issue we are running into is in the table named tblLevelFiveSubCatTwo (SubCategory L2 on the form) (Figure 4), which is an auto-numbered table, we are also losing records (as you can see it table starts at 7). When I created a file last week I needed to create a new entry in the drop down SubCategory L2 and it was auto-numbered 8 when it should have been 734. Also, the table shows that there are only 697 records but if we are auto-numbering there should be 734 records. Therefore, we are losing records in this table as well.

Is there any way we can secure the tables so this does not happen in the future? When I export the data into Excel it looks as though all of the data is accounted for - it is just missing in the reference tables.

View 4 Replies View Related

Importing A Csv Losing Trailing Spaces

May 26, 2006

Hi,
I am creating a csv in another application where fields may contain trailing spaces. If I open this in excel, the trailing spaces are preserved, but if I import into Access I lose the trailing spaces. Is there any way to preserve them?
Thanks,
Dave.

View 3 Replies View Related

Refresh Subform Without Losing Place

Feb 10, 2005

Hello,

I have a subform that is based on a SQL statement that sums by Dollar Amount and groups by Account. I have it set up so the user can double-click on an account, which opens an unbound form. I then have the form execute a SQL INSERT INTO statement, which works beautifully.

The form opens as a pop-up, and I have it requery the subform when it closes. However, when the pop-up closes, I go back to the first record on the sub-form. I need it to "remember" the record I was on and take me back to that one. What is the standard procedure for doing this?

Thanks in advance!

Eric

View 2 Replies View Related

Losing The Plot With Subform Update!

Nov 16, 2005

right I have a subform which holds assessment data
it is a tab-control form which monthly assessment data each tab has its own form i.e. "frmCurrentAssessment-October2005", "frmCurrentAssessment-November2005" and they are based on their own queries i.e. "qryCurrentAssessment-November2005". It will not let me update the subform which is joined to frmAllStudents which is based on "qryallStudent"

the form and the subforms are joined by Admission Number. I can update directly from "qryCurrentAssessment-November2005". But the form wont let me update, I have already checked that the fields arent locked or that the form isnt uneditable and everything seems fine.

I am at a complete loss as to what to do here, is there something obvious that I havent checked

View 1 Replies View Related

Tables :: Losing Functionality On FE After Splitting

Mar 3, 2015

I've developing a little Project and have some issues after splitting a db.

I have some forms in wich I want to see some tables with the "+" sign on the rows so I can go to their linked tables. The problem that I have is that everything works perfect until I split the access file.

View 5 Replies View Related

Edit Design And Not Losing Data From An Mde File

Jul 14, 2005

Still not sure how to do this, after I convert my database and create an mde file few changes might accrue in the future, I have tried to make some changes for testing purpose and then create a new mde file and saved it with replacing the older one but I had lost my new data which was entered in the old mde file?

Q: how can I make the new change on my original file and not lose my new data in my mde file.

View 3 Replies View Related

Queries :: Insert Query Losing Decimals

Feb 4, 2014

So, I am inserting new records into a table. The values in the decimals are being stored as zeroes.

Field Properties
Long Integer
Standard (I also tried Currency)
2 Decimal Places

When I remove the "INSERT INTO" part of the query, the decimal data is in the results. I started out not using the FORMAT function. Then I tried it using "Standard", "Currency", and "#,##0.00"

View 3 Replies View Related

Queries :: Select Query Losing Records?

Sep 19, 2013

I have a Union query as follows;

SELECT ALL *
FROM 1st_Lives
UNION SELECT ALL *
FROM 2nd_Lives;

1st Lives has 465,414 records and 2nd Lives has 151,852 records.

When I run the query I only get 604,976 records instead of 617,266 (I basically just want to add the two data items together).

View 1 Replies View Related

Tables :: Getting Rid Of Lookup Fields Without Losing Data

Oct 15, 2012

What is the best way to do this without losing data? I have several FK that I made the mistake of setting up as lookup fields. I now want to correct this without losing data if possible.

DataType currently says "Number" under each of these. So I can't just change them to number. Is there another way to do this?

View 2 Replies View Related

Forms :: Losing Focus After Hitting Enter In Memofield

Jul 5, 2013

I have a form with a memofield (rich text). After hitting enter, a new line is added in, but the focus changes to the top of the memofield (of the same record).

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved