Update a Report
in [Form]
|
From: Gina Whipp on 4 Jan 2010 22:55 Kunal, Okay then the only thing left to check is the Print Commnad... I assume you used a Command Button. Please look at the Command Button and tell me what you see in the On_Click event of the Command Button. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in message news:958C538A-BA67-434A-B4B9-B91C049F720E(a)microsoft.com... > Hi Gina, > > Thanks for the reply... > > The work same as mi previous one... prints all the data... I just want to > print data related to that particular JobID which is shown on the Fom... > > Mi form is always open as that print command is on the form itself... so I > click the print button and it prints all data one by one... > > "Gina Whipp" wrote: > >> Kunal, >> >> Try changing the Where condition to... >> >> "[JobID]=" & =[Forms]![QuoteForm]![JobID] >> >> Please confirm that the form is open when you run this... >> >> -- >> Gina Whipp >> 2010 Microsoft MVP (Access) >> >> "I feel I have been denied critical, need to know, information!" - >> Tremors >> II >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in >> message >> news:DE473730-9E00-417D-8709-4157695068D7(a)microsoft.com... >> > Gina, >> > >> > Mi Macro Action is "OpenReport" -> Report Name "Quote" -> View >> > "Print" -> >> > Filter Name 'Blank' -> Where Condition >> > "[JobID]=[Forms]![QuoteForm]![JobID]" >> > -> Window Mode "Normal". >> > >> > Regards, >> > >> > Kunal. >> > >> > "Gina Whipp" wrote: >> > >> >> Kunal, >> >> >> >> If the form name is the same and the field name is the same then I >> >> restate >> >> my request. Please type your Macro actions here so we can look and >> >> see >> >> if >> >> we spot any errors. >> >> >> >> -- >> >> Gina Whipp >> >> >> >> "I feel I have been denied critical, need to know, information!" - >> >> Tremors >> >> II >> >> >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in >> >> message >> >> news:1B3FA851-A002-4928-A85D-B1F8F6597296(a)microsoft.com... >> >> > Hi Gina, >> >> > >> >> > Mi JobID is Numeric (Auto Integers). I m trying to set the Print >> >> > Command >> >> > on >> >> > the Form. But I think its the Macros where condition which is having >> >> > trouble... The condition which I pasted before is the one I copied >> >> > from >> >> > one >> >> > of the Templet I downloaded from Microsoft Website. Their Database >> >> > is >> >> > more >> >> > complicated than mine... and it does work there but not with mine... >> >> > All >> >> > names are correct, but still dosent work??? >> >> > >> >> > Thanks. >> >> > >> >> > Kunal. >> >> > >> >> > "Gina Whipp" wrote: >> >> > >> >> >> Kunal, >> >> >> >> >> >> Is the form open? Is JobID text or numberic? Might help if you >> >> >> type >> >> >> your >> >> >> Macro arguements here.. >> >> >> >> >> >> -- >> >> >> Gina Whipp >> >> >> >> >> >> "I feel I have been denied critical, need to know, information!" - >> >> >> Tremors >> >> >> II >> >> >> >> >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> >> >> >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in >> >> >> message >> >> >> news:FA7FABF0-0692-432D-8F43-7CFE6C6AF83E(a)microsoft.com... >> >> >> > Hello John, >> >> >> > >> >> >> > My database have got 3 tables, they have no relationships. First >> >> >> > table >> >> >> > is >> >> >> > the one which captures all the main data off the form. 2nd & 3rd >> >> >> > tables >> >> >> > are >> >> >> > just to fillup the 'Combo Box'. A single form on which all the >> >> >> > data >> >> >> > are >> >> >> > entred and calculated. >> >> >> > >> >> >> > So according to this scenario I think the best reply would be >> >> >> > "the >> >> >> > 1st >> >> >> > Table >> >> >> > is the Record Source for the Report." >> >> >> > >> >> >> > The Where Condition for the Macro is same as I informed in my >> >> >> > earlier >> >> >> > post >> >> >> > "[JobID]=[Forms]![QuoteForm]![JobID]". >> >> >> > >> >> >> > Thanks. >> >> >> > >> >> >> > Kunal. >> >> >> > >> >> >> > "John W. Vinson" wrote: >> >> >> > >> >> >> >> On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala >> >> >> >> <KunalJariwala(a)discussions.microsoft.com> wrote: >> >> >> >> >> >> >> >> >Hi Mires, >> >> >> >> > >> >> >> >> >I m havin trouble generating the report according to the >> >> >> >> >'JobID' >> >> >> >> >specified >> >> >> >> >on the form through a click of the button... My Macro condition >> >> >> >> >states >> >> >> >> >tis >> >> >> >> >"[JobID]=[Forms]![QuoteForm]![JobID]" but tis dosent work... it >> >> >> >> >prints >> >> >> >> >all >> >> >> >> >the records... >> >> >> >> >> >> >> >> Please post your actual code. What's the Recordsource of the >> >> >> >> report? >> >> >> >> -- >> >> >> >> >> >> >> >> John W. Vinson [MVP] >> >> >> >> . >> >> >> >> >> >> >> >> >> >> >> >> >> . >> >> >> >> >> >> >> >> >> . >> >> >> >> >> . >>
From: Kunal Jariwala on 5 Jan 2010 18:10 Gina, The On Click event didnt had anything when I created the command button through the wizard in which I defined wat report I want to print... so I opened mi form and and defined the event as the Print Macro which we made... Do you think it could b a problem wit the record source of the Report... it just struck in mi mind tat the record source of the report is the Table... and not the Form...??? Regards, Kunal. "Gina Whipp" wrote: > Kunal, > > Okay then the only thing left to check is the Print Commnad... I assume you > used a Command Button. Please look at the Command Button and tell me what > you see in the On_Click event of the Command Button. > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in message > news:958C538A-BA67-434A-B4B9-B91C049F720E(a)microsoft.com... > > Hi Gina, > > > > Thanks for the reply... > > > > The work same as mi previous one... prints all the data... I just want to > > print data related to that particular JobID which is shown on the Fom... > > > > Mi form is always open as that print command is on the form itself... so I > > click the print button and it prints all data one by one... > > > > "Gina Whipp" wrote: > > > >> Kunal, > >> > >> Try changing the Where condition to... > >> > >> "[JobID]=" & =[Forms]![QuoteForm]![JobID] > >> > >> Please confirm that the form is open when you run this... > >> > >> -- > >> Gina Whipp > >> 2010 Microsoft MVP (Access) > >> > >> "I feel I have been denied critical, need to know, information!" - > >> Tremors > >> II > >> > >> http://www.regina-whipp.com/index_files/TipList.htm > >> > >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in > >> message > >> news:DE473730-9E00-417D-8709-4157695068D7(a)microsoft.com... > >> > Gina, > >> > > >> > Mi Macro Action is "OpenReport" -> Report Name "Quote" -> View > >> > "Print" -> > >> > Filter Name 'Blank' -> Where Condition > >> > "[JobID]=[Forms]![QuoteForm]![JobID]" > >> > -> Window Mode "Normal". > >> > > >> > Regards, > >> > > >> > Kunal. > >> > > >> > "Gina Whipp" wrote: > >> > > >> >> Kunal, > >> >> > >> >> If the form name is the same and the field name is the same then I > >> >> restate > >> >> my request. Please type your Macro actions here so we can look and > >> >> see > >> >> if > >> >> we spot any errors. > >> >> > >> >> -- > >> >> Gina Whipp > >> >> > >> >> "I feel I have been denied critical, need to know, information!" - > >> >> Tremors > >> >> II > >> >> > >> >> http://www.regina-whipp.com/index_files/TipList.htm > >> >> > >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in > >> >> message > >> >> news:1B3FA851-A002-4928-A85D-B1F8F6597296(a)microsoft.com... > >> >> > Hi Gina, > >> >> > > >> >> > Mi JobID is Numeric (Auto Integers). I m trying to set the Print > >> >> > Command > >> >> > on > >> >> > the Form. But I think its the Macros where condition which is having > >> >> > trouble... The condition which I pasted before is the one I copied > >> >> > from > >> >> > one > >> >> > of the Templet I downloaded from Microsoft Website. Their Database > >> >> > is > >> >> > more > >> >> > complicated than mine... and it does work there but not with mine... > >> >> > All > >> >> > names are correct, but still dosent work??? > >> >> > > >> >> > Thanks. > >> >> > > >> >> > Kunal. > >> >> > > >> >> > "Gina Whipp" wrote: > >> >> > > >> >> >> Kunal, > >> >> >> > >> >> >> Is the form open? Is JobID text or numberic? Might help if you > >> >> >> type > >> >> >> your > >> >> >> Macro arguements here.. > >> >> >> > >> >> >> -- > >> >> >> Gina Whipp > >> >> >> > >> >> >> "I feel I have been denied critical, need to know, information!" - > >> >> >> Tremors > >> >> >> II > >> >> >> > >> >> >> http://www.regina-whipp.com/index_files/TipList.htm > >> >> >> > >> >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in > >> >> >> message > >> >> >> news:FA7FABF0-0692-432D-8F43-7CFE6C6AF83E(a)microsoft.com... > >> >> >> > Hello John, > >> >> >> > > >> >> >> > My database have got 3 tables, they have no relationships. First > >> >> >> > table > >> >> >> > is > >> >> >> > the one which captures all the main data off the form. 2nd & 3rd > >> >> >> > tables > >> >> >> > are > >> >> >> > just to fillup the 'Combo Box'. A single form on which all the > >> >> >> > data > >> >> >> > are > >> >> >> > entred and calculated. > >> >> >> > > >> >> >> > So according to this scenario I think the best reply would be > >> >> >> > "the > >> >> >> > 1st > >> >> >> > Table > >> >> >> > is the Record Source for the Report." > >> >> >> > > >> >> >> > The Where Condition for the Macro is same as I informed in my > >> >> >> > earlier > >> >> >> > post > >> >> >> > "[JobID]=[Forms]![QuoteForm]![JobID]". > >> >> >> > > >> >> >> > Thanks. > >> >> >> > > >> >> >> > Kunal. > >> >> >> > > >> >> >> > "John W. Vinson" wrote: > >> >> >> > > >> >> >> >> On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala > >> >> >> >> <KunalJariwala(a)discussions.microsoft.com> wrote: > >> >> >> >> > >> >> >> >> >Hi Mires, > >> >> >> >> > > >> >> >> >> >I m havin trouble generating the report according to the > >> >> >> >> >'JobID' > >> >> >> >> >specified > >> >> >> >> >on the form through a click of the button... My Macro condition > >> >> >> >> >states > >> >> >> >> >tis > >> >> >> >> >"[JobID]=[Forms]![QuoteForm]![JobID]" but tis dosent work... it > >> >> >> >> >prints > >> >> >> >> >all > >> >> >> >> >the records... > >> >> >> >> > >> >> >> >> Please post your actual code. What's the Recordsource of the > >> >> >> >> report? > >> >> >> >> -- > >> >> >> >> > >> >> >> >> John W. Vinson [MVP] > >> >> >> >> . > >> >> >> >> > >> >> >> > >> >> >> > >> >> >> . > >> >> >> > >> >> > >> >> > >> >> . > >> >> > >> > >> > >> . > >> > > > . >
From: Gina Whipp on 5 Jan 2010 19:04 Kunal, What is the RecordSOucre of the report and what is the RecordSource of the form? Also, did you type in the name of the Macro or select it from a drop down list? Also, what version of Access? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in message news:B565CA5B-F392-4FF6-923E-F8DEFEC6DA92(a)microsoft.com... > Gina, > > The On Click event didnt had anything when I created the command button > through the wizard in which I defined wat report I want to print... so I > opened mi form and and defined the event as the Print Macro which we > made... > > Do you think it could b a problem wit the record source of the Report... > it > just struck in mi mind tat the record source of the report is the Table... > and not the Form...??? > > Regards, > > Kunal. > > "Gina Whipp" wrote: > >> Kunal, >> >> Okay then the only thing left to check is the Print Commnad... I assume >> you >> used a Command Button. Please look at the Command Button and tell me >> what >> you see in the On_Click event of the Command Button. >> >> -- >> Gina Whipp >> 2010 Microsoft MVP (Access) >> >> "I feel I have been denied critical, need to know, information!" - >> Tremors >> II >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in >> message >> news:958C538A-BA67-434A-B4B9-B91C049F720E(a)microsoft.com... >> > Hi Gina, >> > >> > Thanks for the reply... >> > >> > The work same as mi previous one... prints all the data... I just want >> > to >> > print data related to that particular JobID which is shown on the >> > Fom... >> > >> > Mi form is always open as that print command is on the form itself... >> > so I >> > click the print button and it prints all data one by one... >> > >> > "Gina Whipp" wrote: >> > >> >> Kunal, >> >> >> >> Try changing the Where condition to... >> >> >> >> "[JobID]=" & =[Forms]![QuoteForm]![JobID] >> >> >> >> Please confirm that the form is open when you run this... >> >> >> >> -- >> >> Gina Whipp >> >> 2010 Microsoft MVP (Access) >> >> >> >> "I feel I have been denied critical, need to know, information!" - >> >> Tremors >> >> II >> >> >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in >> >> message >> >> news:DE473730-9E00-417D-8709-4157695068D7(a)microsoft.com... >> >> > Gina, >> >> > >> >> > Mi Macro Action is "OpenReport" -> Report Name "Quote" -> View >> >> > "Print" -> >> >> > Filter Name 'Blank' -> Where Condition >> >> > "[JobID]=[Forms]![QuoteForm]![JobID]" >> >> > -> Window Mode "Normal". >> >> > >> >> > Regards, >> >> > >> >> > Kunal. >> >> > >> >> > "Gina Whipp" wrote: >> >> > >> >> >> Kunal, >> >> >> >> >> >> If the form name is the same and the field name is the same then I >> >> >> restate >> >> >> my request. Please type your Macro actions here so we can look and >> >> >> see >> >> >> if >> >> >> we spot any errors. >> >> >> >> >> >> -- >> >> >> Gina Whipp >> >> >> >> >> >> "I feel I have been denied critical, need to know, information!" - >> >> >> Tremors >> >> >> II >> >> >> >> >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> >> >> >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in >> >> >> message >> >> >> news:1B3FA851-A002-4928-A85D-B1F8F6597296(a)microsoft.com... >> >> >> > Hi Gina, >> >> >> > >> >> >> > Mi JobID is Numeric (Auto Integers). I m trying to set the Print >> >> >> > Command >> >> >> > on >> >> >> > the Form. But I think its the Macros where condition which is >> >> >> > having >> >> >> > trouble... The condition which I pasted before is the one I >> >> >> > copied >> >> >> > from >> >> >> > one >> >> >> > of the Templet I downloaded from Microsoft Website. Their >> >> >> > Database >> >> >> > is >> >> >> > more >> >> >> > complicated than mine... and it does work there but not with >> >> >> > mine... >> >> >> > All >> >> >> > names are correct, but still dosent work??? >> >> >> > >> >> >> > Thanks. >> >> >> > >> >> >> > Kunal. >> >> >> > >> >> >> > "Gina Whipp" wrote: >> >> >> > >> >> >> >> Kunal, >> >> >> >> >> >> >> >> Is the form open? Is JobID text or numberic? Might help if you >> >> >> >> type >> >> >> >> your >> >> >> >> Macro arguements here.. >> >> >> >> >> >> >> >> -- >> >> >> >> Gina Whipp >> >> >> >> >> >> >> >> "I feel I have been denied critical, need to know, >> >> >> >> information!" - >> >> >> >> Tremors >> >> >> >> II >> >> >> >> >> >> >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> >> >> >> >> >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote >> >> >> >> in >> >> >> >> message >> >> >> >> news:FA7FABF0-0692-432D-8F43-7CFE6C6AF83E(a)microsoft.com... >> >> >> >> > Hello John, >> >> >> >> > >> >> >> >> > My database have got 3 tables, they have no relationships. >> >> >> >> > First >> >> >> >> > table >> >> >> >> > is >> >> >> >> > the one which captures all the main data off the form. 2nd & >> >> >> >> > 3rd >> >> >> >> > tables >> >> >> >> > are >> >> >> >> > just to fillup the 'Combo Box'. A single form on which all the >> >> >> >> > data >> >> >> >> > are >> >> >> >> > entred and calculated. >> >> >> >> > >> >> >> >> > So according to this scenario I think the best reply would be >> >> >> >> > "the >> >> >> >> > 1st >> >> >> >> > Table >> >> >> >> > is the Record Source for the Report." >> >> >> >> > >> >> >> >> > The Where Condition for the Macro is same as I informed in my >> >> >> >> > earlier >> >> >> >> > post >> >> >> >> > "[JobID]=[Forms]![QuoteForm]![JobID]". >> >> >> >> > >> >> >> >> > Thanks. >> >> >> >> > >> >> >> >> > Kunal. >> >> >> >> > >> >> >> >> > "John W. Vinson" wrote: >> >> >> >> > >> >> >> >> >> On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala >> >> >> >> >> <KunalJariwala(a)discussions.microsoft.com> wrote: >> >> >> >> >> >> >> >> >> >> >Hi Mires, >> >> >> >> >> > >> >> >> >> >> >I m havin trouble generating the report according to the >> >> >> >> >> >'JobID' >> >> >> >> >> >specified >> >> >> >> >> >on the form through a click of the button... My Macro >> >> >> >> >> >condition >> >> >> >> >> >states >> >> >> >> >> >tis >> >> >> >> >> >"[JobID]=[Forms]![QuoteForm]![JobID]" but tis dosent work... >> >> >> >> >> >it >> >> >> >> >> >prints >> >> >> >> >> >all >> >> >> >> >> >the records... >> >> >> >> >> >> >> >> >> >> Please post your actual code. What's the Recordsource of the >> >> >> >> >> report? >> >> >> >> >> -- >> >> >> >> >> >> >> >> >> >> John W. Vinson [MVP] >> >> >> >> >> . >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> . >> >> >> >> >> >> >> >> >> >> >> >> >> . >> >> >> >> >> >> >> >> >> . >> >> >> >> >> . >>
From: Kunal Jariwala on 5 Jan 2010 22:02 Gina, Record Source for both Form and Report is same "Quote" which is the 'First Table' I selected the Macro from the Dropdown list. I am using Access 2003 "Gina Whipp" wrote: > Kunal, > > What is the RecordSOucre of the report and what is the RecordSource of the > form? Also, did you type in the name of the Macro or select it from a drop > down list? Also, what version of Access? > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in message > news:B565CA5B-F392-4FF6-923E-F8DEFEC6DA92(a)microsoft.com... > > Gina, > > > > The On Click event didnt had anything when I created the command button > > through the wizard in which I defined wat report I want to print... so I > > opened mi form and and defined the event as the Print Macro which we > > made... > > > > Do you think it could b a problem wit the record source of the Report... > > it > > just struck in mi mind tat the record source of the report is the Table... > > and not the Form...??? > > > > Regards, > > > > Kunal. > > > > "Gina Whipp" wrote: > > > >> Kunal, > >> > >> Okay then the only thing left to check is the Print Commnad... I assume > >> you > >> used a Command Button. Please look at the Command Button and tell me > >> what > >> you see in the On_Click event of the Command Button. > >> > >> -- > >> Gina Whipp > >> 2010 Microsoft MVP (Access) > >> > >> "I feel I have been denied critical, need to know, information!" - > >> Tremors > >> II > >> > >> http://www.regina-whipp.com/index_files/TipList.htm > >> > >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in > >> message > >> news:958C538A-BA67-434A-B4B9-B91C049F720E(a)microsoft.com... > >> > Hi Gina, > >> > > >> > Thanks for the reply... > >> > > >> > The work same as mi previous one... prints all the data... I just want > >> > to > >> > print data related to that particular JobID which is shown on the > >> > Fom... > >> > > >> > Mi form is always open as that print command is on the form itself... > >> > so I > >> > click the print button and it prints all data one by one... > >> > > >> > "Gina Whipp" wrote: > >> > > >> >> Kunal, > >> >> > >> >> Try changing the Where condition to... > >> >> > >> >> "[JobID]=" & =[Forms]![QuoteForm]![JobID] > >> >> > >> >> Please confirm that the form is open when you run this... > >> >> > >> >> -- > >> >> Gina Whipp > >> >> 2010 Microsoft MVP (Access) > >> >> > >> >> "I feel I have been denied critical, need to know, information!" - > >> >> Tremors > >> >> II > >> >> > >> >> http://www.regina-whipp.com/index_files/TipList.htm > >> >> > >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in > >> >> message > >> >> news:DE473730-9E00-417D-8709-4157695068D7(a)microsoft.com... > >> >> > Gina, > >> >> > > >> >> > Mi Macro Action is "OpenReport" -> Report Name "Quote" -> View > >> >> > "Print" -> > >> >> > Filter Name 'Blank' -> Where Condition > >> >> > "[JobID]=[Forms]![QuoteForm]![JobID]" > >> >> > -> Window Mode "Normal". > >> >> > > >> >> > Regards, > >> >> > > >> >> > Kunal. > >> >> > > >> >> > "Gina Whipp" wrote: > >> >> > > >> >> >> Kunal, > >> >> >> > >> >> >> If the form name is the same and the field name is the same then I > >> >> >> restate > >> >> >> my request. Please type your Macro actions here so we can look and > >> >> >> see > >> >> >> if > >> >> >> we spot any errors. > >> >> >> > >> >> >> -- > >> >> >> Gina Whipp > >> >> >> > >> >> >> "I feel I have been denied critical, need to know, information!" - > >> >> >> Tremors > >> >> >> II > >> >> >> > >> >> >> http://www.regina-whipp.com/index_files/TipList.htm > >> >> >> > >> >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in > >> >> >> message > >> >> >> news:1B3FA851-A002-4928-A85D-B1F8F6597296(a)microsoft.com... > >> >> >> > Hi Gina, > >> >> >> > > >> >> >> > Mi JobID is Numeric (Auto Integers). I m trying to set the Print > >> >> >> > Command > >> >> >> > on > >> >> >> > the Form. But I think its the Macros where condition which is > >> >> >> > having > >> >> >> > trouble... The condition which I pasted before is the one I > >> >> >> > copied > >> >> >> > from > >> >> >> > one > >> >> >> > of the Templet I downloaded from Microsoft Website. Their > >> >> >> > Database > >> >> >> > is > >> >> >> > more > >> >> >> > complicated than mine... and it does work there but not with > >> >> >> > mine... > >> >> >> > All > >> >> >> > names are correct, but still dosent work??? > >> >> >> > > >> >> >> > Thanks. > >> >> >> > > >> >> >> > Kunal. > >> >> >> > > >> >> >> > "Gina Whipp" wrote: > >> >> >> > > >> >> >> >> Kunal, > >> >> >> >> > >> >> >> >> Is the form open? Is JobID text or numberic? Might help if you > >> >> >> >> type > >> >> >> >> your > >> >> >> >> Macro arguements here.. > >> >> >> >> > >> >> >> >> -- > >> >> >> >> Gina Whipp > >> >> >> >> > >> >> >> >> "I feel I have been denied critical, need to know, > >> >> >> >> information!" - > >> >> >> >> Tremors > >> >> >> >> II > >> >> >> >> > >> >> >> >> http://www.regina-whipp.com/index_files/TipList.htm > >> >> >> >> > >> >> >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote > >> >> >> >> in > >> >> >> >> message > >> >> >> >> news:FA7FABF0-0692-432D-8F43-7CFE6C6AF83E(a)microsoft.com... > >> >> >> >> > Hello John, > >> >> >> >> > > >> >> >> >> > My database have got 3 tables, they have no relationships. > >> >> >> >> > First > >> >> >> >> > table > >> >> >> >> > is > >> >> >> >> > the one which captures all the main data off the form. 2nd & > >> >> >> >> > 3rd > >> >> >> >> > tables > >> >> >> >> > are > >> >> >> >> > just to fillup the 'Combo Box'. A single form on which all the > >> >> >> >> > data > >> >> >> >> > are > >> >> >> >> > entred and calculated. > >> >> >> >> > > >> >> >> >> > So according to this scenario I think the best reply would be > >> >> >> >> > "the > >> >> >> >> > 1st > >> >> >> >> > Table > >> >> >> >> > is the Record Source for the Report." > >> >> >> >> > > >> >> >> >> > The Where Condition for the Macro is same as I informed in my > >> >> >> >> > earlier > >> >> >> >> > post > >> >> >> >> > "[JobID]=[Forms]![QuoteForm]![JobID]". > >> >> >> >> > > >> >> >> >> > Thanks. > >> >> >> >> > > >> >> >> >> > Kunal. > >> >> >> >> > > >> >> >> >> > "John W. Vinson" wrote: > >> >> >> >> > > >> >> >> >> >> On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala > >> >> >> >> >> <KunalJariwala(a)discussions.microsoft.com> wrote: > >> >> >> >> >> > >> >> >> >> >> >Hi Mires, > >> >> >> >> >> > > >> >> >> >> >> >I m havin trouble generating the report according to the > >> >> >> >> >> >'JobID' > >> >> >> >> >> >specified > >> >> >> >> >> >on the form through a click of the button... My Macro > >> >> >> >> >> >condition > >> >> >> >> >> >states > >> >> >> >> >> >tis > >> >> >> >> >> >"[JobID]=[Forms]![QuoteForm]![JobID]" but tis dosent work... > >> >> >> >> >> >it > >> >> >> >> >> >prints > >> >> >> >> >> >all > >> >> >> >> >> >the records... > >> >> >> >> >> > >> >> >> >> >> Please post your actual code. What's the Recordsource of the > >> >> >> >> >> report? > >> >> >> >> >> -- > >> >> >> >> >> > >> >> >> >> >> John W. Vinson [MVP] > >> >> >> >> >> . > >> >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> . > >> >> >> >> > >> >> >> > >> >> >> > >> >> >> . > >> >> >> > >> >> > >> >> > >> >> . > >> >> > >> > >> > >> . > >> > > > . >
From: Gina Whipp on 5 Jan 2010 22:13
Kunal, Then the RecordSource is not the problem. Is the field JobID on the form and can you confirm that that is the field name? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in message news:9FCF5F06-10B0-4603-9DC5-67F639CA3549(a)microsoft.com... > Gina, > > Record Source for both Form and Report is same "Quote" which is the 'First > Table' I selected the Macro from the Dropdown list. I am using Access 2003 > > "Gina Whipp" wrote: > >> Kunal, >> >> What is the RecordSOucre of the report and what is the RecordSource of >> the >> form? Also, did you type in the name of the Macro or select it from a >> drop >> down list? Also, what version of Access? >> >> -- >> Gina Whipp >> 2010 Microsoft MVP (Access) >> >> "I feel I have been denied critical, need to know, information!" - >> Tremors >> II >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in >> message >> news:B565CA5B-F392-4FF6-923E-F8DEFEC6DA92(a)microsoft.com... >> > Gina, >> > >> > The On Click event didnt had anything when I created the command button >> > through the wizard in which I defined wat report I want to print... so >> > I >> > opened mi form and and defined the event as the Print Macro which we >> > made... >> > >> > Do you think it could b a problem wit the record source of the >> > Report... >> > it >> > just struck in mi mind tat the record source of the report is the >> > Table... >> > and not the Form...??? >> > >> > Regards, >> > >> > Kunal. >> > >> > "Gina Whipp" wrote: >> > >> >> Kunal, >> >> >> >> Okay then the only thing left to check is the Print Commnad... I >> >> assume >> >> you >> >> used a Command Button. Please look at the Command Button and tell me >> >> what >> >> you see in the On_Click event of the Command Button. >> >> >> >> -- >> >> Gina Whipp >> >> 2010 Microsoft MVP (Access) >> >> >> >> "I feel I have been denied critical, need to know, information!" - >> >> Tremors >> >> II >> >> >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in >> >> message >> >> news:958C538A-BA67-434A-B4B9-B91C049F720E(a)microsoft.com... >> >> > Hi Gina, >> >> > >> >> > Thanks for the reply... >> >> > >> >> > The work same as mi previous one... prints all the data... I just >> >> > want >> >> > to >> >> > print data related to that particular JobID which is shown on the >> >> > Fom... >> >> > >> >> > Mi form is always open as that print command is on the form >> >> > itself... >> >> > so I >> >> > click the print button and it prints all data one by one... >> >> > >> >> > "Gina Whipp" wrote: >> >> > >> >> >> Kunal, >> >> >> >> >> >> Try changing the Where condition to... >> >> >> >> >> >> "[JobID]=" & =[Forms]![QuoteForm]![JobID] >> >> >> >> >> >> Please confirm that the form is open when you run this... >> >> >> >> >> >> -- >> >> >> Gina Whipp >> >> >> 2010 Microsoft MVP (Access) >> >> >> >> >> >> "I feel I have been denied critical, need to know, information!" - >> >> >> Tremors >> >> >> II >> >> >> >> >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> >> >> >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote in >> >> >> message >> >> >> news:DE473730-9E00-417D-8709-4157695068D7(a)microsoft.com... >> >> >> > Gina, >> >> >> > >> >> >> > Mi Macro Action is "OpenReport" -> Report Name "Quote" -> View >> >> >> > "Print" -> >> >> >> > Filter Name 'Blank' -> Where Condition >> >> >> > "[JobID]=[Forms]![QuoteForm]![JobID]" >> >> >> > -> Window Mode "Normal". >> >> >> > >> >> >> > Regards, >> >> >> > >> >> >> > Kunal. >> >> >> > >> >> >> > "Gina Whipp" wrote: >> >> >> > >> >> >> >> Kunal, >> >> >> >> >> >> >> >> If the form name is the same and the field name is the same then >> >> >> >> I >> >> >> >> restate >> >> >> >> my request. Please type your Macro actions here so we can look >> >> >> >> and >> >> >> >> see >> >> >> >> if >> >> >> >> we spot any errors. >> >> >> >> >> >> >> >> -- >> >> >> >> Gina Whipp >> >> >> >> >> >> >> >> "I feel I have been denied critical, need to know, >> >> >> >> information!" - >> >> >> >> Tremors >> >> >> >> II >> >> >> >> >> >> >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> >> >> >> >> >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> wrote >> >> >> >> in >> >> >> >> message >> >> >> >> news:1B3FA851-A002-4928-A85D-B1F8F6597296(a)microsoft.com... >> >> >> >> > Hi Gina, >> >> >> >> > >> >> >> >> > Mi JobID is Numeric (Auto Integers). I m trying to set the >> >> >> >> > Command >> >> >> >> > on >> >> >> >> > the Form. But I think its the Macros where condition which is >> >> >> >> > having >> >> >> >> > trouble... The condition which I pasted before is the one I >> >> >> >> > copied >> >> >> >> > from >> >> >> >> > one >> >> >> >> > of the Templet I downloaded from Microsoft Website. Their >> >> >> >> > Database >> >> >> >> > is >> >> >> >> > more >> >> >> >> > complicated than mine... and it does work there but not with >> >> >> >> > mine... >> >> >> >> > All >> >> >> >> > names are correct, but still dosent work??? >> >> >> >> > >> >> >> >> > Thanks. >> >> >> >> > >> >> >> >> > Kunal. >> >> >> >> > >> >> >> >> > "Gina Whipp" wrote: >> >> >> >> > >> >> >> >> >> Kunal, >> >> >> >> >> >> >> >> >> >> Is the form open? Is JobID text or numberic? Might help if >> >> >> >> >> you >> >> >> >> >> type >> >> >> >> >> your >> >> >> >> >> Macro arguements here.. >> >> >> >> >> >> >> >> >> >> -- >> >> >> >> >> Gina Whipp >> >> >> >> >> >> >> >> >> >> "I feel I have been denied critical, need to know, >> >> >> >> >> information!" - >> >> >> >> >> Tremors >> >> >> >> >> II >> >> >> >> >> >> >> >> >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> >> >> >> >> >> >> >> >> "Kunal Jariwala" <KunalJariwala(a)discussions.microsoft.com> >> >> >> >> >> wrote >> >> >> >> >> in >> >> >> >> >> message >> >> >> >> >> news:FA7FABF0-0692-432D-8F43-7CFE6C6AF83E(a)microsoft.com... >> >> >> >> >> > Hello John, >> >> >> >> >> > >> >> >> >> >> > My database have got 3 tables, they have no relationships. >> >> >> >> >> > First >> >> >> >> >> > table >> >> >> >> >> > is >> >> >> >> >> > the one which captures all the main data off the form. 2nd >> >> >> >> >> > & >> >> >> >> >> > 3rd >> >> >> >> >> > tables >> >> >> >> >> > are >> >> >> >> >> > just to fillup the 'Combo Box'. A single form on which all >> >> >> >> >> > the >> >> >> >> >> > data >> >> >> >> >> > are >> >> >> >> >> > entred and calculated. >> >> >> >> >> > >> >> >> >> >> > So according to this scenario I think the best reply would >> >> >> >> >> > be >> >> >> >> >> > "the >> >> >> >> >> > 1st >> >> >> >> >> > Table >> >> >> >> >> > is the Record Source for the Report." >> >> >> >> >> > >> >> >> >> >> > The Where Condition for the Macro is same as I informed in >> >> >> >> >> > my >> >> >> >> >> > earlier >> >> >> >> >> > post >> >> >> >> >> > "[JobID]=[Forms]![QuoteForm]![JobID]". >> >> >> >> >> > >> >> >> >> >> > Thanks. >> >> >> >> >> > >> >> >> >> >> > Kunal. >> >> >> >> >> > >> >> >> >> >> > "John W. Vinson" wrote: >> >> >> >> >> > >> >> >> >> >> >> On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala >> >> >> >> >> >> <KunalJariwala(a)discussions.microsoft.com> wrote: >> >> >> >> >> >> >> >> >> >> >> >> >Hi Mires, >> >> >> >> >> >> > >> >> >> >> >> >> >I m havin trouble generating the report according to the >> >> >> >> >> >> >'JobID' >> >> >> >> >> >> >specified >> >> >> >> >> >> >on the form through a click of the button... My Macro >> >> >> >> >> >> >condition >> >> >> >> >> >> >states >> >> >> >> >> >> >tis >> >> >> >> >> >> >"[JobID]=[Forms]![QuoteForm]![JobID]" but tis dosent >> >> >> >> >> >> >work... >> >> >> >> >> >> >it >> >> >> >> >> >> >prints >> >> >> >> >> >> >all >> >> >> >> >> >> >the records... >> >> >> >> >> >> >> >> >> >> >> >> Please post your actual code. What's the Recordsource of >> >> >> >> >> >> the >> >> >> >> >> >> report? >> >> >> >> >> >> -- >> >> >> >> >> >> >> >> >> >> >> >> John W. Vinson [MVP] >> >> >> >> >> >> . >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> . >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> . >> >> >> >> >> >> >> >> >> >> >> >> >> . >> >> >> >> >> >> >> >> >> . >> >> >> >> >> . >> |