Update a Report
in [Form]
|
From: John W. Vinson on 3 Jan 2010 21:12 On Sun, 3 Jan 2010 18:44:17 -0500, "Gina Whipp" <NotInterested(a)InViruses.com> wrote: >Kunal, > >Try changing the Where condition to... > >"[JobID]=" & =[Forms]![QuoteForm]![JobID] > >Please confirm that the form is open when you run this... Gina, don't you have an extra = sign there? It should probably be "[JobID]=" & [Forms]![QuoteForm]![JobID] -- John W. Vinson [MVP]
From: Gina Whipp on 3 Jan 2010 22:06 John, Thank you... I have the sister to David Fenton's typist! -- 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 "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message news:5kj2k5h4iueg3skahm90osvupsgbf9lo09(a)4ax.com... > On Sun, 3 Jan 2010 18:44:17 -0500, "Gina Whipp" > <NotInterested(a)InViruses.com> > wrote: > >>Kunal, >> >>Try changing the Where condition to... >> >>"[JobID]=" & =[Forms]![QuoteForm]![JobID] >> >>Please confirm that the form is open when you run this... > > Gina, don't you have an extra = sign there? It should probably be > > "[JobID]=" & [Forms]![QuoteForm]![JobID] > -- > > John W. Vinson [MVP]
From: John W. Vinson on 4 Jan 2010 00:00 On Sun, 3 Jan 2010 22:06:01 -0500, "Gina Whipp" <NotInterested(a)InViruses.com> wrote: >John, > >Thank you... I have the sister to David Fenton's typist! LOL!!! Is that a case of "typecasting"? -- John W. Vinson [MVP]
From: Gina Whipp on 4 Jan 2010 00:04 Hmmm, I guess it is! <g> -- 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 "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message news:4et2k5h52pi0looi3tbdesdc8l79vp677u(a)4ax.com... > On Sun, 3 Jan 2010 22:06:01 -0500, "Gina Whipp" > <NotInterested(a)InViruses.com> > wrote: > >>John, >> >>Thank you... I have the sister to David Fenton's typist! > > LOL!!! > > Is that a case of "typecasting"? > -- > > John W. Vinson [MVP]
From: Kunal Jariwala on 4 Jan 2010 22:41
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] > >> >> >> . > >> >> >> > >> >> > >> >> > >> >> . > >> >> > >> > >> > >> . > >> > > > . > |