Hi,
I have a two page report (it is formatted to always be exactly two pages) and I need to print it on the front (page one of the report) and on the back (page two of the report) of the same piece of paper. The less user input the better.
Is this an Access thing or a printer thing (We have a HP 6P).
Anyone doing this ???
Thanks
Mike
I need to have the last page of a report in access print to an 8.5x11 instead of 11x17 (the rest of the report has to print 11x17). No clue how to set it up so it's automatic...
View 2 Replies View RelatedI have a report that should print on labels ready to be stick on a book, but how can I tell the report to start from 3th row 2nd column so I do not waste any labels?
View 4 Replies View RelatedI have a database of musical events. Now im creating flayers for each event. My Q is how the Information for each event should fit on one A4 page and should start on a new page of the report.
View 2 Replies View RelatedI have a non standard size report (for printing labels)
The report is just over 10cm wide and just over 15cm deep.
I have solved the blank pages caused by exceeding the width but I'm still getting a blank page when I move some data down. I am still within 15 cm but it's throwing me a blank page. Even if I extend the in design mode depth to say 20cm (ie the height in Detail) it's throwing a blank page (I can see this in print preview).
I initially set up the report (it's a long time ago so memory fades) using the label wizard setting up a label 4*6 inches (10.16 * 15.24 cms) and it is this i'm trying to tweak. Is there a property I'm missing somewhere?
How do I stop the report footer from printing on a separate page. I have seen several suggestions but nothing seems to work.
View 1 Replies View RelatedI have one-page forms which print a second page, blank except for a block of grey shading at the top. I have tried moving the content of the form up but that doesn't eliminate the second page. If I look at print preview, every second page of the entire database shows up as blank, regardless of where that happens to appear in the record.
View 2 Replies View RelatedMy Access 2010 application has many reports. On almost every report, the user can select a new paper size. This paper size is remembered, so the next time the user selects the same report, he no longer have to set the paper size (I guess this is the default behavior for Access programs).One report does not behave properly. This report is a LEGAL size report. EVERY times the user selects this report, it prints on LETTER size, so the form is split in two pages. If the user selects teh LEGAL size paper, it works, but the next time the report defaults back to LETTER size paper.
I checked everywhere in the code, nowhere the paper size is set. In development, I selected the report, I changed the paper size to LEGAL, I ran the report. The next time I check the paper size of the report, it is back as LETTER size.After my OpenReport statement, I tried manally setting the paper size with "Reports(xxx).Printer.PaperSize = acPRPSLegal" but my report still defaults to LETTER size paper.
i have made table to store mcq questions. i need to know how can i select random mcqs from table and print using reports to take tests..
View 1 Replies View RelatedAfter having designed a series of forms, I have just been told that users would like to occasionally print the data.
On testing this, it seems that the data does not print onto 1 page.
Are there any settings to fit data to 1 page wide only?
Aternatively, is there a better way of doing this? Perhaps by using a report or something like that?
The form has a whole load of calculated fields (calculated control boxes with expressions) so would I run into any problems doing it ths way ?
Thanks.
I have created a report in MsAccess for a typical stock ledger page as is shown below:
ITEM MODEL: XYZ
TRANS DT <------- RECEIPT -----> <---- SALES ---> BAL
DATE INV No INV DATE QTY INV NO INV DT QTY QTY
25/05/07 0278 27/03/07 10 ---- ---- ---- 10
25/05/07 ---- --- --- 07/01 25/05/07 4 6
26/05/07 ---- ---- --- 07/02 25/05/07 6 0
26/05/07 0291 12/05/07 27 ---- --- --- 27
I wish to print the stock ledger from one transaction date to another with the last balance qty appearing as the first row with the “brought forward” message. The report would look like this:
TRANS DT <------- RECEIPT -----> <---- SALES ---> BAL
DATE INV No INV DATE QTY INV NO INV DT QTY QTY
Brought forward 6
26/05/07 ------ ------ ---- 07/02 25/05/07 6 0
26/05/07 0291 12/05/07 27 ------ ------ ----- 27
Require expert advice & help.
I have an excel sheet having coloumns as under
Payee_Name Amount CHQ# Date
There are about 100 record in my excel sheet and the i have import report by linking from desktop for updating purpose. when i tried to print report its result came not as i desired.
These words i like to print on last page of report but the words like:
( Cheque writer Accounts officer Zonal accountant) print on each page.
How can i print these signatures at the end of last page.
I have created a report in MsAccess for a typical stock ledger page as is shown below:
ITEM MODEL: XYZ
TRANS <------- RECEIPT -----> <----- SALES ----> BAL
DATE INV No INV Dt QTY INV NO INV Dt QTY QTY
25/05/2007 0278 27/03/2007 10 ------ ------ ---- 10
25/05/2007 ------ ----- ---- 2007/0001 25/05/2007 4 6
26/05/2007 ------ ------ ---- 2007/0002 25/05/2007 6 0
26/05/2007 0291 12/05/2007 27 ------ ------ ----- 27
I wish to print the stock ledger from one transaction date to another with the last balance qty appearing as the first row with the “brought forward” message. The report would look like this:
TRANS <------- RECEIPT -----> <----- SALES ----> BAL
DATE INV No INV Dt QTY INV NO INV Dt QTY QTY
Brought forward 6
26/05/2007 ------ ------ ---- 2007/0002 25/05/2007 6 0
26/05/2007 0291 12/05/2007 27 ------ ------ ----- 27
Require expert advice & help.
I have a report that should only show 1 page yet I have 2 and one is blank . I cannot find out why?
View 3 Replies View RelatedHello I’m trying to get a little bit of code to work in a database and I was wondering if any of you could see why my piece of code isn’t working .
Basically I have a list box with drive number and severity looking like below
LIST BOX
Drive Severity
1001
1012
1025
1031
1042 etc.
I have a form with corresponding picture frame style boxes on which I would like to have their backs change color when I click on the list box.
so the code I have is
If Me![List181] = 1 Then [Box “&” Me![list181.Column.0]].BackColor = 65280
Its the [Box “&” Me![list181.Column.0]].BackColor = 65280 I have wrong. How can you use the value returned from a list box and use that value to as part of the object name you want to change the color of?
Using Access 2013, what would cause a one-to-many relationship to work ONLY in one direction? Say from Table A to Table B, and when I attempt to change the direction of the relationship, so that is should be Table B to Table A, it doesnt work. I dont get an error, but Access reverts any changes I make while in the Relationship Design. I have four tables: Renter, Location, Condo, and Agreement.
RENTER (RENTER_NUM, FIRST_NAME, LAST_NAME, ADDRESS, CITY, STATE, ZIPCODE, TELEPHONE, EMAIL)
LOCATION (LOCATION_NUM, LOCATION_NAME, ADDRESS, CITY, STATE, ZIPCODE)
CONDO (UNIT_NUM, LOCATION_NUM, SQR-FT, BDRMS, BATHS, WEEKLY_RATE, RENTER_NUM)
AGREEMENT (RENTER_NUM, UNIT_NUM, START_DATE, END_DATE, WEEKLY_FEE)
I can link RENTER to AGREEMENT using the RENTER_NUM field, which enables one renter for multiple agreements. I can link CONDO to AGREEMENT using the UNIT_NUM field, which enables one condo for many agreements, but I need AGREEMENT to be the one side and CONDO the many.
The problem is Access will lead me to believe I can change the sides, but when I create it after making my selections in the Relationship Design window, it reverts back, and doesnt even give me an error or a reason why. I closed out of Access and tried it again but same thing.Could it be related to the AGREEMENT table using two foreign keys as primary keys?
I have an asset data base to generate individual asset detail reports with a sub report on the same page listing similar assets from a separate query. I have set the master and child fields, one to many. This works perfectly for the first two assets (pages), however the sub report stops showing data on the third asset (page).
View 13 Replies View RelatedWhen trying to match people's names - sometimes with a middle initial, sometimes without - I'd like to try to wildcard each side of it.
So this
Code:
varProblem = DLookup("EMAIL_ADDRESS", "tblUsers", "EMPLOYEE_NAME Like '" & varString & "*'")
but also something like this.
Code:
varProblem = DLookup("EMAIL_ADDRESS", "tblUsers", "EMPLOYEE_NAME* Like '" & varString & "'")
I have a list of PC SN#s in tbl1;
I have a list of other PC SN#s in tbl2
I want to display ALL records of tbl1, AND ALL records of tbl2, matching up the SN#s (where there is a match) - but I want to display all records whether they match or not.
How can I accomplish this?
Hi I am new to the forum. :)
I am creating an access database that holds customer information for a friend of mine. I am struggleing to think of ways to make Access do several tasks.
I have created several forms that display when reletive buttons are clicked and some run automatically using queries, one of which runs a query that displays any upcoming service inervals that are within thirty days of the current date, and allows the user to print a report that is designed to be a service notice for the relevant Customer/s which contains the customers address, phone numbers and service due date with a small pre-made text insert that advises the Customer about the upcoming service recommedation. The Form also provides the ability to print address labels for the same customers, making it quick and easy to send them out by post. The problem that I am having is that I would like the customers information that has already been printed to be removed or greyed out in someway so that the query does'nt print out duplicates but also have the ability to allow user control to reprint any result that may for any reason need reprinting.
Thanks for any help
Christopher
Hi
I'm pretty new to all of this. I've set up a simple database. I have a form in it for inputting information and then there is a command button on the bottom which prints out a report I've created with the information on it. This is all working great except it prints evey record and I only want the current record printed out.
I've tried the help and it goes into detail about OpenReport and PrintOut in macros. I have no idea what a macro is or what to do with it.
Can anybody please help me and give me step by step instructions as to how to print out only the current record in the report from the command button.
Your help is greatly appreciated:)
I have a form (entry screen to enter data) I then created a report in the layout I need for my order form. I want to creat a button that a user can press and it will print the current record to the report (order form layout)
Here is my current code for the print button on the form page:
Private Sub btnPrtOrderFrm_Click()
On Error GoTo Err_btnPrtOrderFrm_Click
Dim stDocName As String
stDocName = "rptOrders2"
DoCmd.OpenReport stDocName, acNormal
Exit_btnPrtOrderFrm_Click:
Exit Sub
Err_btnPrtOrderFrm_Click:
MsgBox Err.Description
Resume Exit_btnPrtOrderFrm_Click
End Sub
The only problem is when I tell it to print if I am on record number 2 on the form, it prints both record 1 and record 2. I only want the current record i am in to print. Any ideas much appreciated
Dean
Hi all, i'm having a rather annoying problem. When I view my report I have 2 sets of conditional formatting that run, one that changes the back colours of certain fileds when the criteria is meet, and the second, the text colour of certain fields, both of which work fine when previewing the report. However, when I print the report, any of the back colour in the preview does not print out but text colour does. If I print from another office programme i.e. Word, block colour is printed fine its just seems to not work in my access.
Please note that if the same report is printed from another computer, it prints fine.
Please does anyone have any idea on why this is happening and how to sort it. Thanks in advance for any ideas and help.
I had made my own database for my own business.
I am trying to print a report from a form. Once i enter an order detail i finish off by printing a letter. At the moment we are doing this via a query by entering the order id.
I want to automate this so for the form record i am in i want a button to print a report for that record only.
I know this can be done as i rember doing this in college but i cant get my head round it at the moment.
Please help
Hi, Ive read all I can on forums and web and am still unable to print the current forms report using a command buttons on click. This is the code i have been playing with:
Dim strDocName As String
Dim strWhere As String
strDocName = "Home_Oxygen_Report"
1. 'strWhere = "[general_info.HospitalNumber]= Me!Home_Oxygen_Form!general_info.HospitalNumber"
2. strWhere = "[general_info.HospitalNumber]= "" & Me![general_info.HospitalNumber] & """
3. 'strWhere "[general_info.HospitalNumber]='" & Me![general_info.HospitalNumber] & "'"
DoCmd.OpenReport strDocName, acViewPreview, , strWhere
Number 3 gives the closest result but it prompts me to enter the primary key when i hit the command button but i need it to do this automatically. The primary key is a text box not number. Note that the primary key is HospitalNumeber of Table general_info (form and reports record source is query of many tables).
any help would be muchly appreciated!!
Tania
MS Access 2003
I inserted an image (jpg) in a report, it appears in PrintPreview, but not when I print it on my printer.
Please help me. I do not if the problem is with my printer or I'm doing something wrong when inserting the image.
update: It seems to work when printing from Print icon, but does not work when printing from File/Print menu. Is this a known bug?