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 |
#11
|
|||
|
|||
Update a Report
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] . . |
#12
|
|||
|
|||
Update a Report
V,
I do not see what fields are in the First table, did you post that information somewhere? -- 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 ... John, 1. I very well knw tat my Database design is not in Third Normal Form neither in Second Normal Form !!! As I am not as good on creating the forms and as this database requirement is urgent I added all the fields required in the form into a single table, which can hav only one adverse effect - 'the size of the database will be big' and I am not worried about the size at tis point !!! To get tis work I made all the fields optional (not required) and thus it allows me to put everything togather in one simple form. The only thing Report has to do is to knw copy data opposite to the relevant JobID and print it !!! Also the Layout of the Report is same as Layout for Form. 2. Regarding the Record Source for the Report, my reply would be same... its the "First Table". 3. Macros DO have WHERE CONDITIONS !!! As Gina replied to ur post, they are used to Open Report or Form through Macros. Thanks. Kunal. "John W. Vinson" wrote: On Tue, 29 Dec 2009 16:30:01 -0800, Kunal Jariwala wrote: Hello John, My database have got 3 tables, they have no relationships. Then it's not really a database. What are the three tables? What Entities (real-life people, things or events) do they represent? How are those entities logically connected to one another in the real world? 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. If you're designing a database starting with a Form, you're probably on the wrong track. Forms do not generally map all that well to logical, normalized designs. So according to this scenario I think the best reply would be "the 1st Table is the Record Source for the Report." If you open the Report in design view, view its Properties, and select the Data tab, what is shown in its "Record Source" property? The Where Condition for the Macro is same as I informed in my earlier post "[JobID]=[Forms]![QuoteForm]![JobID]". Macros don't have Where Conditions. Forms do. -- John W. Vinson [MVP] . |
#13
|
|||
|
|||
Update a Report
On Tue, 29 Dec 2009 20:53:24 -0500, "Gina Whipp"
wrote: Joh,n Ummm, macros do have Where Conditions when using OpenForm or OpenReport actions. blush Sorry, Kunal... shows how much I use macros! -- John W. Vinson [MVP] |
#14
|
|||
|
|||
Update a Report
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] . . . |
#15
|
|||
|
|||
Update a Report
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] . . . |
#16
|
|||
|
|||
Update a Report
On Sun, 3 Jan 2010 18:44:17 -0500, "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, don't you have an extra = sign there? It should probably be "[JobID]=" & [Forms]![QuoteForm]![JobID] -- John W. Vinson [MVP] |
#17
|
|||
|
|||
Update a Report
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" wrote in message ... On Sun, 3 Jan 2010 18:44:17 -0500, "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, don't you have an extra = sign there? It should probably be "[JobID]=" & [Forms]![QuoteForm]![JobID] -- John W. Vinson [MVP] |
#18
|
|||
|
|||
Update a Report
On Sun, 3 Jan 2010 22:06:01 -0500, "Gina Whipp"
wrote: John, Thank you... I have the sister to David Fenton's typist! LOL!!! Is that a case of "typecasting"? -- John W. Vinson [MVP] |
#19
|
|||
|
|||
Update a Report
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" wrote in message ... On Sun, 3 Jan 2010 22:06:01 -0500, "Gina Whipp" wrote: John, Thank you... I have the sister to David Fenton's typist! LOL!!! Is that a case of "typecasting"? -- John W. Vinson [MVP] |
#20
|
|||
|
|||
Update a Report
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] . . . . |
Thread Tools | |
Display Modes | |
|
|