Printing a single record from a tab control subform
in [Getting Started]
|
From: Duane Hookom on 10 Apr 2010 11:36 You can use a value from any field in your report's record source. Use a zip code or city if you like. Keep in mind your report will include all records that match. It's like going to a car dealer to buy a car. You can ask for cars where the color equals red or you can ask for a car where the gas mileage is better than 25 mpg. If you have visited before and bought a car, you can ask for the car that matches your VIN number. -- Duane Hookom MS Access MVP "forest8" <forest8(a)discussions.microsoft.com> wrote in message news:588B42F3-EA6B-4865-B348-8C72726DCA32(a)microsoft.com... > The primary keys are Autonumbers. > > The Master and child fields are text. Is it possible to use the > non-primary > keys as the basis of the "Where" statement? > > Thanks > > "Duane Hookom" wrote: > >> Learn the basics of trouble-shooting. Try add a msgbox, debug.Print, or >> breakpoint to your code so you know if the code is being run: >> Also, always provide the significant data types. Is ID_General text or >> numeric? >> >> Private Sub Print_Click() >> >> Dim strDocName As String >> Dim strWhere As String >> strDocName = "R1-1 GPS_GeneralInfo" >> strWhere = "[ID_General] = " & Me.[ID_General] >> debug.print "strWhere: " & strWhere >> MsgBox "strWhere: " & strWhere >> DoCmd.OpenReport "R1-1 GPS_GeneralInfo", acPreview, , strWhere >> >> End Sub >> >> >> -- >> Duane Hookom >> MS Access MVP >> >> >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message >> news:09A72E68-6E87-4C60-BB51-BA3B6AFD4ED5(a)microsoft.com... >> > Hi >> > >> > This is the code for the print function as an Event procedure. I'm not >> > sure >> > what I'm missing. >> > >> > Private Sub Print_Click() >> > >> > Dim strDocName As String >> > Dim strWhere As String >> > strDocName = "R1-1 GPS_GeneralInfo" >> > strWhere = "[ID_General] = " & Me.[ID_General] >> > DoCmd.OpenReport "R1-1 GPS_GeneralInfo", acPreview, , strWhere >> > >> > End Sub >> > >> > The name of the report is R1-1 GPS_GeneralInfo >> > The primary key of the subform is "ID_General" >> > >> > The main form is called GPS. One of the subforms in the tabcontrol is >> > called >> > General. >> > >> > I saved the GPS form and General form as reports (by using save as). >> > Then >> > I >> > created the report by using the GPS form as the report and the General >> > form >> > as the subreport. The Masterlink is GPSID and the ChildLinkID is >> > GPSID_FK. >> > >> > The form doesn't have the primary key in it. It's just in the Table >> > called >> > T_General. >> > >> > I should also mention that the Print button with the Click event is on >> > the >> > subform in the tabcontrol. >> > >> > If I can get this one report to work, I can use the same logic and fix >> > all >> > the other reports in my database. >> > >> > Thank you. >> > >> > >> > "Duane Hookom" wrote: >> > >> >> What makes you think your "Print" button should work? How did you >> >> create >> >> it? >> >> Did you use the wizard? What is the code? >> >> >> >> >> >> -- >> >> Duane Hookom >> >> MS Access MVP >> >> >> >> >> >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message >> >> news:C40D9BDE-5071-4CAA-92C6-18BE8DDF67B1(a)microsoft.com... >> >> > Hi >> >> > >> >> > I have created a Case Management Database of students. It consists >> >> > of a >> >> > main >> >> > form >> >> > and a subform. The main form consists of information that must be >> >> > seen >> >> > at >> >> > all times. since it consists of information about each student. >> >> > >> >> > The subform consists of a tab control. There is a different subject >> >> > on >> >> > each >> >> > page of the tab contol, e.g. General Information, Current Student >> >> > Information, etc. >> >> > >> >> > I need to print out the mainform and subforms so I created reports >> >> > for >> >> > each >> >> > subform in my tab control. >> >> > >> >> > I want to put a "Print" button on each page of my tabcontrol so that >> >> > when >> >> > clicked, that specific report for that particular record is printed? >> >> > >> >> > The thing is that my "Print" button does not work. That is, when I >> >> > click >> >> > on >> >> > it, nothing happens. >> >> > >> >> > How do I fix it so that it prints that report for that particular >> >> > record? >> >> > >> >> > Thank you for your help in advance. >> >> > >> >> >
From: forest8 on 10 Apr 2010 21:03 Hi there I'm having another issue with this. As I mentioned earlier, my report is based on a report and subreport. When I see my report for a single record, it's only showing the report portion of my document. I don't see the subreport. Also, I'm getting an "Enter Parameter Value" error wbere I'm asked to enter a value for the ID_General field. I've checked my tables and forms and the fields I am using are the same as in my macro. Thank you again. "Duane Hookom" wrote: > You can use a value from any field in your report's record source. Use a zip > code or city if you like. Keep in mind your report will include all records > that match. It's like going to a car dealer to buy a car. You can ask for > cars where the color equals red or you can ask for a car where the gas > mileage is better than 25 mpg. If you have visited before and bought a car, > you can ask for the car that matches your VIN number. > > -- > Duane Hookom > MS Access MVP > > > "forest8" <forest8(a)discussions.microsoft.com> wrote in message > news:588B42F3-EA6B-4865-B348-8C72726DCA32(a)microsoft.com... > > The primary keys are Autonumbers. > > > > The Master and child fields are text. Is it possible to use the > > non-primary > > keys as the basis of the "Where" statement? > > > > Thanks > > > > "Duane Hookom" wrote: > > > >> Learn the basics of trouble-shooting. Try add a msgbox, debug.Print, or > >> breakpoint to your code so you know if the code is being run: > >> Also, always provide the significant data types. Is ID_General text or > >> numeric? > >> > >> Private Sub Print_Click() > >> > >> Dim strDocName As String > >> Dim strWhere As String > >> strDocName = "R1-1 GPS_GeneralInfo" > >> strWhere = "[ID_General] = " & Me.[ID_General] > >> debug.print "strWhere: " & strWhere > >> MsgBox "strWhere: " & strWhere > >> DoCmd.OpenReport "R1-1 GPS_GeneralInfo", acPreview, , strWhere > >> > >> End Sub > >> > >> > >> -- > >> Duane Hookom > >> MS Access MVP > >> > >> > >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message > >> news:09A72E68-6E87-4C60-BB51-BA3B6AFD4ED5(a)microsoft.com... > >> > Hi > >> > > >> > This is the code for the print function as an Event procedure. I'm not > >> > sure > >> > what I'm missing. > >> > > >> > Private Sub Print_Click() > >> > > >> > Dim strDocName As String > >> > Dim strWhere As String > >> > strDocName = "R1-1 GPS_GeneralInfo" > >> > strWhere = "[ID_General] = " & Me.[ID_General] > >> > DoCmd.OpenReport "R1-1 GPS_GeneralInfo", acPreview, , strWhere > >> > > >> > End Sub > >> > > >> > The name of the report is R1-1 GPS_GeneralInfo > >> > The primary key of the subform is "ID_General" > >> > > >> > The main form is called GPS. One of the subforms in the tabcontrol is > >> > called > >> > General. > >> > > >> > I saved the GPS form and General form as reports (by using save as). > >> > Then > >> > I > >> > created the report by using the GPS form as the report and the General > >> > form > >> > as the subreport. The Masterlink is GPSID and the ChildLinkID is > >> > GPSID_FK. > >> > > >> > The form doesn't have the primary key in it. It's just in the Table > >> > called > >> > T_General. > >> > > >> > I should also mention that the Print button with the Click event is on > >> > the > >> > subform in the tabcontrol. > >> > > >> > If I can get this one report to work, I can use the same logic and fix > >> > all > >> > the other reports in my database. > >> > > >> > Thank you. > >> > > >> > > >> > "Duane Hookom" wrote: > >> > > >> >> What makes you think your "Print" button should work? How did you > >> >> create > >> >> it? > >> >> Did you use the wizard? What is the code? > >> >> > >> >> > >> >> -- > >> >> Duane Hookom > >> >> MS Access MVP > >> >> > >> >> > >> >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message > >> >> news:C40D9BDE-5071-4CAA-92C6-18BE8DDF67B1(a)microsoft.com... > >> >> > Hi > >> >> > > >> >> > I have created a Case Management Database of students. It consists > >> >> > of a > >> >> > main > >> >> > form > >> >> > and a subform. The main form consists of information that must be > >> >> > seen > >> >> > at > >> >> > all times. since it consists of information about each student. > >> >> > > >> >> > The subform consists of a tab control. There is a different subject > >> >> > on > >> >> > each > >> >> > page of the tab contol, e.g. General Information, Current Student > >> >> > Information, etc. > >> >> > > >> >> > I need to print out the mainform and subforms so I created reports > >> >> > for > >> >> > each > >> >> > subform in my tab control. > >> >> > > >> >> > I want to put a "Print" button on each page of my tabcontrol so that > >> >> > when > >> >> > clicked, that specific report for that particular record is printed? > >> >> > > >> >> > The thing is that my "Print" button does not work. That is, when I > >> >> > click > >> >> > on > >> >> > it, nothing happens. > >> >> > > >> >> > How do I fix it so that it prints that report for that particular > >> >> > record? > >> >> > > >> >> > Thank you for your help in advance. > >> >> > > >> >> >
From: Duane Hookom on 11 Apr 2010 00:50 What values do you have entered into the Link Master/Child properties? Can you see the ID_General field in the record sources of the main and subreports? -- Duane Hookom MS Access MVP "forest8" <forest8(a)discussions.microsoft.com> wrote in message news:F2DD4A07-935C-47AD-9512-EC5EAA96BD97(a)microsoft.com... > Hi there > > I'm having another issue with this. As I mentioned earlier, my report is > based on a report and subreport. > > When I see my report for a single record, it's only showing the report > portion of my document. I don't see the subreport. > > Also, I'm getting an "Enter Parameter Value" error wbere I'm asked to > enter > a value for the ID_General field. I've checked my tables and forms and the > fields I am using are the same as in my macro. > > Thank you again. > > > > "Duane Hookom" wrote: > >> You can use a value from any field in your report's record source. Use a >> zip >> code or city if you like. Keep in mind your report will include all >> records >> that match. It's like going to a car dealer to buy a car. You can ask for >> cars where the color equals red or you can ask for a car where the gas >> mileage is better than 25 mpg. If you have visited before and bought a >> car, >> you can ask for the car that matches your VIN number. >> >> -- >> Duane Hookom >> MS Access MVP >> >> >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message >> news:588B42F3-EA6B-4865-B348-8C72726DCA32(a)microsoft.com... >> > The primary keys are Autonumbers. >> > >> > The Master and child fields are text. Is it possible to use the >> > non-primary >> > keys as the basis of the "Where" statement? >> > >> > Thanks >> > >> > "Duane Hookom" wrote: >> > >> >> Learn the basics of trouble-shooting. Try add a msgbox, debug.Print, >> >> or >> >> breakpoint to your code so you know if the code is being run: >> >> Also, always provide the significant data types. Is ID_General text or >> >> numeric? >> >> >> >> Private Sub Print_Click() >> >> >> >> Dim strDocName As String >> >> Dim strWhere As String >> >> strDocName = "R1-1 GPS_GeneralInfo" >> >> strWhere = "[ID_General] = " & Me.[ID_General] >> >> debug.print "strWhere: " & strWhere >> >> MsgBox "strWhere: " & strWhere >> >> DoCmd.OpenReport "R1-1 GPS_GeneralInfo", acPreview, , strWhere >> >> >> >> End Sub >> >> >> >> >> >> -- >> >> Duane Hookom >> >> MS Access MVP >> >> >> >> >> >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message >> >> news:09A72E68-6E87-4C60-BB51-BA3B6AFD4ED5(a)microsoft.com... >> >> > Hi >> >> > >> >> > This is the code for the print function as an Event procedure. I'm >> >> > not >> >> > sure >> >> > what I'm missing. >> >> > >> >> > Private Sub Print_Click() >> >> > >> >> > Dim strDocName As String >> >> > Dim strWhere As String >> >> > strDocName = "R1-1 GPS_GeneralInfo" >> >> > strWhere = "[ID_General] = " & Me.[ID_General] >> >> > DoCmd.OpenReport "R1-1 GPS_GeneralInfo", acPreview, , strWhere >> >> > >> >> > End Sub >> >> > >> >> > The name of the report is R1-1 GPS_GeneralInfo >> >> > The primary key of the subform is "ID_General" >> >> > >> >> > The main form is called GPS. One of the subforms in the tabcontrol >> >> > is >> >> > called >> >> > General. >> >> > >> >> > I saved the GPS form and General form as reports (by using save as). >> >> > Then >> >> > I >> >> > created the report by using the GPS form as the report and the >> >> > General >> >> > form >> >> > as the subreport. The Masterlink is GPSID and the ChildLinkID is >> >> > GPSID_FK. >> >> > >> >> > The form doesn't have the primary key in it. It's just in the Table >> >> > called >> >> > T_General. >> >> > >> >> > I should also mention that the Print button with the Click event is >> >> > on >> >> > the >> >> > subform in the tabcontrol. >> >> > >> >> > If I can get this one report to work, I can use the same logic and >> >> > fix >> >> > all >> >> > the other reports in my database. >> >> > >> >> > Thank you. >> >> > >> >> > >> >> > "Duane Hookom" wrote: >> >> > >> >> >> What makes you think your "Print" button should work? How did you >> >> >> create >> >> >> it? >> >> >> Did you use the wizard? What is the code? >> >> >> >> >> >> >> >> >> -- >> >> >> Duane Hookom >> >> >> MS Access MVP >> >> >> >> >> >> >> >> >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message >> >> >> news:C40D9BDE-5071-4CAA-92C6-18BE8DDF67B1(a)microsoft.com... >> >> >> > Hi >> >> >> > >> >> >> > I have created a Case Management Database of students. It >> >> >> > consists >> >> >> > of a >> >> >> > main >> >> >> > form >> >> >> > and a subform. The main form consists of information that must be >> >> >> > seen >> >> >> > at >> >> >> > all times. since it consists of information about each student. >> >> >> > >> >> >> > The subform consists of a tab control. There is a different >> >> >> > subject >> >> >> > on >> >> >> > each >> >> >> > page of the tab contol, e.g. General Information, Current Student >> >> >> > Information, etc. >> >> >> > >> >> >> > I need to print out the mainform and subforms so I created >> >> >> > reports >> >> >> > for >> >> >> > each >> >> >> > subform in my tab control. >> >> >> > >> >> >> > I want to put a "Print" button on each page of my tabcontrol so >> >> >> > that >> >> >> > when >> >> >> > clicked, that specific report for that particular record is >> >> >> > printed? >> >> >> > >> >> >> > The thing is that my "Print" button does not work. That is, when >> >> >> > I >> >> >> > click >> >> >> > on >> >> >> > it, nothing happens. >> >> >> > >> >> >> > How do I fix it so that it prints that report for that particular >> >> >> > record? >> >> >> > >> >> >> > Thank you for your help in advance. >> >> >> > >> >> >> >
From: forest8 on 11 Apr 2010 10:40 The value in the Link Master/Child properties is the Students_ID. If I don't try to print a single record, I could see the report/subreport. When I try to isolate a single record, the report section only prints. "Duane Hookom" wrote: > What values do you have entered into the Link Master/Child properties? Can > you see the ID_General field in the record sources of the main and > subreports? > > -- > Duane Hookom > MS Access MVP > > > "forest8" <forest8(a)discussions.microsoft.com> wrote in message > news:F2DD4A07-935C-47AD-9512-EC5EAA96BD97(a)microsoft.com... > > Hi there > > > > I'm having another issue with this. As I mentioned earlier, my report is > > based on a report and subreport. > > > > When I see my report for a single record, it's only showing the report > > portion of my document. I don't see the subreport. > > > > Also, I'm getting an "Enter Parameter Value" error wbere I'm asked to > > enter > > a value for the ID_General field. I've checked my tables and forms and the > > fields I am using are the same as in my macro. > > > > Thank you again. > > > > > > > > "Duane Hookom" wrote: > > > >> You can use a value from any field in your report's record source. Use a > >> zip > >> code or city if you like. Keep in mind your report will include all > >> records > >> that match. It's like going to a car dealer to buy a car. You can ask for > >> cars where the color equals red or you can ask for a car where the gas > >> mileage is better than 25 mpg. If you have visited before and bought a > >> car, > >> you can ask for the car that matches your VIN number. > >> > >> -- > >> Duane Hookom > >> MS Access MVP > >> > >> > >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message > >> news:588B42F3-EA6B-4865-B348-8C72726DCA32(a)microsoft.com... > >> > The primary keys are Autonumbers. > >> > > >> > The Master and child fields are text. Is it possible to use the > >> > non-primary > >> > keys as the basis of the "Where" statement? > >> > > >> > Thanks > >> > > >> > "Duane Hookom" wrote: > >> > > >> >> Learn the basics of trouble-shooting. Try add a msgbox, debug.Print, > >> >> or > >> >> breakpoint to your code so you know if the code is being run: > >> >> Also, always provide the significant data types. Is ID_General text or > >> >> numeric? > >> >> > >> >> Private Sub Print_Click() > >> >> > >> >> Dim strDocName As String > >> >> Dim strWhere As String > >> >> strDocName = "R1-1 GPS_GeneralInfo" > >> >> strWhere = "[ID_General] = " & Me.[ID_General] > >> >> debug.print "strWhere: " & strWhere > >> >> MsgBox "strWhere: " & strWhere > >> >> DoCmd.OpenReport "R1-1 GPS_GeneralInfo", acPreview, , strWhere > >> >> > >> >> End Sub > >> >> > >> >> > >> >> -- > >> >> Duane Hookom > >> >> MS Access MVP > >> >> > >> >> > >> >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message > >> >> news:09A72E68-6E87-4C60-BB51-BA3B6AFD4ED5(a)microsoft.com... > >> >> > Hi > >> >> > > >> >> > This is the code for the print function as an Event procedure. I'm > >> >> > not > >> >> > sure > >> >> > what I'm missing. > >> >> > > >> >> > Private Sub Print_Click() > >> >> > > >> >> > Dim strDocName As String > >> >> > Dim strWhere As String > >> >> > strDocName = "R1-1 GPS_GeneralInfo" > >> >> > strWhere = "[ID_General] = " & Me.[ID_General] > >> >> > DoCmd.OpenReport "R1-1 GPS_GeneralInfo", acPreview, , strWhere > >> >> > > >> >> > End Sub > >> >> > > >> >> > The name of the report is R1-1 GPS_GeneralInfo > >> >> > The primary key of the subform is "ID_General" > >> >> > > >> >> > The main form is called GPS. One of the subforms in the tabcontrol > >> >> > is > >> >> > called > >> >> > General. > >> >> > > >> >> > I saved the GPS form and General form as reports (by using save as). > >> >> > Then > >> >> > I > >> >> > created the report by using the GPS form as the report and the > >> >> > General > >> >> > form > >> >> > as the subreport. The Masterlink is GPSID and the ChildLinkID is > >> >> > GPSID_FK. > >> >> > > >> >> > The form doesn't have the primary key in it. It's just in the Table > >> >> > called > >> >> > T_General. > >> >> > > >> >> > I should also mention that the Print button with the Click event is > >> >> > on > >> >> > the > >> >> > subform in the tabcontrol. > >> >> > > >> >> > If I can get this one report to work, I can use the same logic and > >> >> > fix > >> >> > all > >> >> > the other reports in my database. > >> >> > > >> >> > Thank you. > >> >> > > >> >> > > >> >> > "Duane Hookom" wrote: > >> >> > > >> >> >> What makes you think your "Print" button should work? How did you > >> >> >> create > >> >> >> it? > >> >> >> Did you use the wizard? What is the code? > >> >> >> > >> >> >> > >> >> >> -- > >> >> >> Duane Hookom > >> >> >> MS Access MVP > >> >> >> > >> >> >> > >> >> >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message > >> >> >> news:C40D9BDE-5071-4CAA-92C6-18BE8DDF67B1(a)microsoft.com... > >> >> >> > Hi > >> >> >> > > >> >> >> > I have created a Case Management Database of students. It > >> >> >> > consists > >> >> >> > of a > >> >> >> > main > >> >> >> > form > >> >> >> > and a subform. The main form consists of information that must be > >> >> >> > seen > >> >> >> > at > >> >> >> > all times. since it consists of information about each student. > >> >> >> > > >> >> >> > The subform consists of a tab control. There is a different > >> >> >> > subject > >> >> >> > on > >> >> >> > each > >> >> >> > page of the tab contol, e.g. General Information, Current Student > >> >> >> > Information, etc. > >> >> >> > > >> >> >> > I need to print out the mainform and subforms so I created > >> >> >> > reports > >> >> >> > for > >> >> >> > each > >> >> >> > subform in my tab control. > >> >> >> > > >> >> >> > I want to put a "Print" button on each page of my tabcontrol so > >> >> >> > that > >> >> >> > when > >> >> >> > clicked, that specific report for that particular record is > >> >> >> > printed? > >> >> >> > > >> >> >> > The thing is that my "Print" button does not work. That is, when > >> >> >> > I > >> >> >> > click > >> >> >> > on > >> >> >> > it, nothing happens. > >> >> >> > > >> >> >> > How do I fix it so that it prints that report for that particular > >> >> >> > record? > >> >> >> > > >> >> >> > Thank you for your help in advance. > >> >> >> > > >> >> >> >
From: Richard on 11 Apr 2010 13:12 Forest, Take a look at this thread by Albert Kallal. http://www.accessmonster.com/Uwe/Forum.aspx/access/117721/print-just-1-record-from-the-subform Richard
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: Plaease Help with fileds in Inventory template Next: A Go To Box in a Form |