Update a Report
in [Form]
|
From: Kunal Jariwala on 6 Jan 2010 20:38 Gina, Yes that part is correct as well...!!! Kunal. "Gina Whipp" wrote: > 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] > >> >> >> >> >> >> . > >> >> >> >> >> >> > >> >> >> >> >> > >> >> >> >> >> > >> >> >> >> >> . > >> >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> . > >> >> >> >> > >> >> >> > >> >> >> > >> >> >> . > >> >> >> > >> >> > >> >> > >> >> . > >> >> > >> > >> > >> . > >> > > > .
From: Gina Whipp on 6 Jan 2010 20:43 Kunal, Now, I'm stumped because everything you have confirmed *appears* correct so the report should filter and not show all the records. Is the database in a state where you can send it to me? -- 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:C8AB0BBA-A3F5-4CC1-B101-3264D9BB6C18(a)microsoft.com... > Gina, > > Yes that part is correct as well...!!! > > Kunal. > > "Gina Whipp" wrote: > >> 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] >> >> >> >> >> >> >> . >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> . >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> . >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> . >> >> >> >> >> >> >> >> >> >> >> >> >> . >> >> >> >> >> >> >> >> >> . >> >> >> >> >> .
From: Kunal Jariwala on 7 Jan 2010 23:46 Yes... provide me with your email address... "Gina Whipp" wrote: > Kunal, > > Now, I'm stumped because everything you have confirmed *appears* correct so > the report should filter and not show all the records. Is the database in a > state where you can send it to me? > > -- > 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:C8AB0BBA-A3F5-4CC1-B101-3264D9BB6C18(a)microsoft.com... > > Gina, > > > > Yes that part is correct as well...!!! > > > > Kunal. > > > > "Gina Whipp" wrote: > > > >> 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, > >> >> >> >> >> >> >> >
From: Gina Whipp on 8 Jan 2010 00:05
Kunal, classon <at> aol <dot> com Please replace the <at> with @ and the <dot> with a . Trying to prevent the Spammers from harvesting. -- 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:547B8773-A86D-453E-BA5F-CA2C05F5FE0A(a)microsoft.com... > Yes... provide me with your email address... > > "Gina Whipp" wrote: > >> Kunal, >> >> Now, I'm stumped because everything you have confirmed *appears* correct >> so >> the report should filter and not show all the records. Is the database >> in a >> state where you can send it to me? >> >> -- >> 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:C8AB0BBA-A3F5-4CC1-B101-3264D9BB6C18(a)microsoft.com... >> > Gina, >> > >> > Yes that part is correct as well...!!! >> > >> > Kunal. >> > >> > "Gina Whipp" wrote: >> > >> >> 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, >> >> >> >> >> >> >> >> > |