If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Update a Report
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" wrote in message ... 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" wrote in message news 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" wrote in message ... 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" wrote in message ... 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 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] . . . . |
#22
|
|||
|
|||
Update a Report
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" wrote in message ... 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" wrote in message news 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" wrote in message ... 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" wrote in message ... 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 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] . . . . . |
#23
|
|||
|
|||
Update a Report
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" wrote in message ... 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" wrote in message ... 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" wrote in message news 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" wrote in message ... 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" wrote in message ... 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 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] . . . . . |
#24
|
|||
|
|||
Update a Report
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" wrote in message ... 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" wrote in message ... 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" wrote in message news 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" wrote in message ... 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" wrote in message ... 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 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] . . . . . . |
#25
|
|||
|
|||
Update a Report
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message news 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" wrote in message ... 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" wrote in message ... 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 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] . . . . . . |
#26
|
|||
|
|||
Update a Report
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message news 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" wrote in message ... 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" wrote in message ... 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 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] . . . . . . . |
#27
|
|||
|
|||
Update a Report
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message news 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" wrote in message ... 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" wrote in message ... 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 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] . . . . . . . |
#28
|
|||
|
|||
Update a Report
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message news 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" wrote in message ... 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" wrote in message ... 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 wrote: Hi Mires, |
#29
|
|||
|
|||
Update a Report
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message news 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" wrote in message ... 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" wrote in message ... 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 wrote: Hi Mires, |
Thread Tools | |
Display Modes | |
|
|