Printing Only One (current) Record In A Report
Hi Everyone,
I'm probably going about this the wrong way all together, but what I'm trying to do is print a single record from a form in a report.
Basically after the client fills in the form they can print their "results report" using the click box (command button) in the bottom corner of the form. When the client clicks on the button it prints all the records ("result reports") of all the clients...no good of course.
Here's the code for the button:
Private Sub PrintSingleChamber_Click()
On Error GoTo Err_PrintSingleChamber_Click
Dim stDocName As String
stDocName = "SingleChamberPrintOut"
DoCmd.OpenReport stDocName, acNormal
Exit_PrintSingleChamber_Click:
Exit Sub
Err_PrintSingleChamber_Click:
MsgBox Err.Description
Resume Exit_PrintSingleChamber_Click
End Sub
Can someone point me in the right direction? :confused:
Thanks again,
Mark
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Printing A Report Based On The Current (new) Record
Hi All, Having a problem with a report, I have a form that i use to enter a new record to my database, what I want to do is put a button at the bottom of the form to print the record (via a report) If I base this on a record that already exists, it works fine. However, If I have just entered the record the query the report runs off doesn't see the new record. To print that record I have to exit the completed record, then go back in to it and print. My aim is to remove this additional part of the process, I'm sure it's something really simple, but can anyone help? Many Thanks Paul
View Replies !
View Related
Printing Current Record
This could go in forms or reports, I think but: I have a database which I am developing over time as I see ways of improving it and as I learn bits of vba. My current problem relates to invoicing (that I have probably created for myself!): I currently have two invoice report layouts because of different invoicing addresses. I now want to add a cmd button to my invoice entry form that will firstly preview, then print the current record. I found elsewhere in the forum a way of previewing just the current record by way of specifying in the underlying qry the ClientID so that it selects the record displayed on the form. I have this line of code which then previews the invoice: DoCmd.OpenReport "rptInvoicePrivateClients", acViewPreview This does not take account, though of the different invoice layouts. I think strictly speaking I should only have one invoice report, but what I want to say is this: If the client is a private client, then preview rptInvoicePrivate, Else preview rptInvoiceLocumWork I have tried entering this code that does not work If SolicitorID = "1" Then DoCmd.OpenReport "rptInvoicePrivateClients", acViewPreview Else DoCmd.OpenReport "rptInvoiceLocumWork", acViewPreview End If It comes back with a message that SolicitorID is not defined, but I have included Option Explicit. Any help please
View Replies !
View Related
Printing The Current Record Which Has A Subform
Hello, I have done a search on this forum and found all the postings relating to printing only the current record for a report. I have a command button and have followed what these posts say. The report prints the current record but leaves out the data from the subform. The database is a recipe organizer. The main form is called Recipes and the subform contains the ingredients for each recipe. This subform is called Ingredients. I set up a command button with the following code: Private Sub Print_Recipe_Click() On Error GoTo Err_Print_Recipe_Click Dim stDocName As String stDocName = "Family Recipes" DoCmd.OpenReport stDocName, acNormal, , "[RecipeID] = " & Forms!RECIPES![RecipeID] Exit_Print_Recipe_Click: Exit Sub Err_Print_Recipe_Click: MsgBox Err.Description Resume Exit_Print_Recipe_Click End Sub Since the RecipeID is used in both forms and the report, I thought it would be the best field to use since it linked all the information together. So what do I need to do so that the subform data prints out on the report? Thanks GeekyGirl
View Replies !
View Related
Printing Current Record On Form And Subform
I currently am trying to print the current record that I have selected on my form and the subform that I have on the same page. If I try to print selected record it will only print out the main form correctly and will print out the first record on the sub form. I have tried to make a reprot of the current form and it only will do the main form and nothing from the sub form. I am willing to try whatever method would work in getting this to work. Thanks
View Replies !
View Related
Report Of Current Record
I have got a tricky problem, for which I can find no answer - but then I am a bit of a novice here. I have created a (probably too-) complicated relational database but what I really need is to be able to make abutton on the page of my address book form, so that when I hit it it creates a report of an address label for that current record on the screen only. I hope this makes sense. If this is possible, I then need to extrapolate this technique to print a report of a subform (of samples sent) of a current client record. All help gratefully received Xenia
View Replies !
View Related
Print Current Record To Report
I'm having hard trouble doing print preview current record from form with subform to a report. When using the code below I'm getting an error for: The specified field [PolicyNum] could refer to more than 1 table listed in the from clause of your sql statement. Dim strDocName As String Dim strLinkCriteria As String strDocName = "rptCurrentInfo" strLinkCriteria = "[PolicyNum] = Forms![frmAdjusterMod]![PolicyNum]" DoCmd.OpenReport strDocName, acViewPreview, , strLinkCriteria Command button is in the main form frmadjustermod - sbfm is sbfmMoreMod foreign key is PolicyNum Thanks, Michael
View Replies !
View Related
View Current Record On A Report
I have a report which shows all the records in my database. I have a command button on my form which brings up that report for preview. How can I get the button to bring up that report showing only the current record being viewed on the form? Do I need a separate report and what criteria/VB code is required?
View Replies !
View Related
Report Filter To Show Only Current Record
Help needed again please I have managed to link a report to a form where you can double click on the surname and the report opens automatically BUT I want the report to only show the data from the record that I have double clicked - at teh moment the report is coming up with thousands of pages - one for each record. Can anyone help me with this - I think it's probably something simple but I can't work it out on my own :eek:
View Replies !
View Related
Printing Only One Record Details On Report
I have a form which is used for data entry for a new record only. I then wish to print some of this record's details on a report, using a command button on the form. At present I cannot filter to get just the current records details on the report - I am getting the report containing all records in the table. Thank you
View Replies !
View Related
Print Current Record - In Form View Not Report
hi i have 3 queries brought together in 1 form. i do not want a report to be printed out just the current record in form view. this is because i have a number of images per record. if i print out the current record and it only has 1 photo in a sub-form attached to the main form record, then the main form will print on 1 page which is what i want [screenshot 1]. But if there are 2 or more photos attached to the main record then the print command button prints out 2 pages for 2 photos, 3 pages for 3 photos and so on [screenshot 2]. any ideas as to how to limit the print command button to print out only 1 page per record regardless of how many photos their are attached to each record?? thanks
View Replies !
View Related
Printing One Page Of Report Linked To Record...
I would like to know if someone can help me with this. I am currently in the final stages of completing an asset database. Each computer (asset) is linked to an ID number. I have also created a "Print Label" button on the form in which when I press it, I only want it to print that page from the report. Right now, when I press the button, it prints all the pages from the report (say I have ten assets in the database). How can I go about doing this? I would appreciate the help. Thanks!
View Replies !
View Related
Printing Current Records
Hi Guys (again), Hope you can help and I'll explain this as well as I can but I've put it in general as it's a culmination of things. I have written a call monitoring database for a call centre (all good so far), but they want historical searches (again all good). I've written the relevant queries for these so that the searches can be done for Adviser, Manager and also by a date range. However, they now want to be able to print out the current search from the screen. The way I have done it is this. I have written the report be adding in a subreport and putting in the relevant historical search form, and then written a macro that is assigned to a button on the historical search form to print the current record. The problem that I am having is that when they click on the button to give them the history they fill in the relevant advisor or manager name and the date range which gives them the info in form format but, when they click on the button to print the current 'screen' if you like, it asks for the information again. I know this is because the actual report is written from the same query but is there anyway that it will just print what's displayed on the screen? I don't do VBA so if it has to be done that way could you please display it as it should be inserted. I do hope that that has made sense and that someone can at least help me, cos you're all wonderful and I've had some really excellent help in the past from this site. Thanks in advance. Donna x :confused: (as always)
View Replies !
View Related
Dynamically Update Field Of A Current Record Based On Previous Record
I need a way to dynamically store a particular value in "field_2" of the CURRENT record depending on whether or not the value of "field_1" of the CURRENT record is identical to the value of "field_1" of the PREVIOUS record within the same table. The table is sorted on "field_1". So, if the value of "field_1" in the CURRENT record is "ABC" and the value of "field_1" in the PREVIOUS record is also "ABC", then store a value of "PPP" in "field_2" of the current record. IF on the other hand, the value of "field_1" in the CURRENT record is "ABC" and the value of "field_1" in the PREVIOUS record is "XYZ", then store a value of "WWW" in "field_2" of the current record. I have a report that will use these results to count only the number of records that have a "WWW" in "field_2". Is this doable, maybe in a query somehow? I should add that whatever the solution, it needs to be compatible with Access 2000.
View Replies !
View Related
Refer To Previous Record In Current Record Query
In my query, i want to automatically display the value of another field from the previous record in a field in my current record. i.e. Name Value Previous Record 1 1 Record 2 2 1 Record 3 7 2 Record 4 1 7 Is it possible to create some kind of simple expression to refer to data in another record? Cheers, Ben
View Replies !
View Related
Can I Use Combo Box List Out My Record With Going To The Current Record ??
Hi all, Another problem bothering me. Wish someone can help me to solve it. I am doing the 'Edit' Option right now ... As a user friendly propuse, I had try to use a combo box to let user to choose my employee record with all the detail on but the problem is the program 'JUST' list the record they can not go to the current record!! When i try to edit my record, the program is not allow (for sure because they can't have a duplicate record on it). The reason is because the record just stay in the FIRST record but can not go to the current record. I do believe is the problem of i using the way of listing the record as below: Me.EmployeeName = Me.EmployeeName.Column(0) Me.IC = Me.EmployeeName.Column(1) Me.Nationality = Me.EmployeeName.Column(2) Me.Race = Me.EmployeeName.Column(3) Me.Sex = Me.EmployeeName.Column(4) Me.FMU = Me.EmployeeName.Column(5) Me.Position = Me.EmployeeName.Column(6) Me.SectionField = Me.EmployeeName.Column(7) Me.DOEmploment = Me.EmployeeName.Column(8) Me.DOResign = Me.EmployeeName.Column(9) Me.Remarks = Me.EmployeeName.Column(10) So, Could someone help me to solve it like when i can use the combo box to select the Employee record with the details are on as the same time can go to current record... Thanks alot!!! i do have the confident if i can go to the current record then my edit option can be working properly. P/S: I had attach the picture... showing my program problem (with the red circle)
View Replies !
View Related
Need Form For New Record/edit Current Record
I have a table called tblFinishedGoods. There are 3 fields in the table:Serial Number, Model Number and Location. I would like to have a form that will take input from my barcode reader and input the data for the 3 fields, if the serial number is not already in the table.(I have this already working). But now I would like the same form to also check the table for any serial number that is scanned in...and if it is in the table already, have it bring up the model number and location for that record. I'm thinking maybe there is something I can do with Serial Number afterupdate. Basically I'm looking for a way to not require the user to input anything via a mouse or keyboard. If the 1 form could accept the 3 scans:Serial Number,Model Number and Location, and either 1)enter a new record if that serial number isnt in the table or 2)find that the serial number already exists and overwrite the model number and location with whatever the next 2 scans are. Thanks
View Replies !
View Related
|
TRACKER
