Search results

Thank you, I solved this problem. Mithani

Mates Any help? Thanks mithani

Thanks Bob, mithani

Thanks Bob, I used % but not printing in one page. Even I reduced upto 25% minimum but still I can print only an few line in one page. What could be reason? Thanks a lot mithani

Hi, I have one form with subform. I want to have sum at main form. I am using below code, but showing Error. Sum is based on weight(subform), cutting length(subform), Qty unit(subform) and Quantity(main form). =Sum([tblEstimatingChild subform].Form!weight*([tblEstimatingChild...

Bob, While printing form, can i shrink my form? Because I can't print form in one page and no way to reduce the form width or height through design. There are many many information there. Thanks Mithani

Bob, thats wonderful. Thanks a lot Mithani

Hi all, I have one estimating screen where I enter all my data. I don't want to make any report, just the form screen need to be printed out. So what I do when I finish my data, I pressed Print Screen key and go to paint brush and copy and take print out. Is there any way to take print out my...

Dear Zaqyu You are great! thanks mithani

Dear Pbaldy, I did the requery but still same problem. Both combo are on subform so I don't think I have to give any form reference. Am I right? I spent hours to rectify this problem but no solution. did you see my attached DB? Thanks Mithani

Hi, Please see attached my DB. Please check and see where I am wrong. Thanks mithani

Deat Zaqyu & Ortaisa, Thanks a lot. Zaqyu, You are right, sectionTyp is text but your example not fetching any record. Ortaisa, As i mentioned above, both text boxes are on Reference Subform, so If i give form reference than, does not fetch any record but if I give without any form reference...

Hi Everyone, To make it more clarify. Both text boxes "SectionType" & "Die_no" are in subform. So first I select type of section from "SectionType" and than select my die number from Die_number. The above select statement written on Die_no. Since both text boxes are in sub form so I changed my...

Hi everyone, Can anyone please tell me why where condition is not fetching any record? SELECT DIE_NUMBER, DIE_DESCRIPTION, SECTIONTYPE FROM EXTRUSION WHERE ((Extrusion.SECTIONTYPE)=(FORMS!Reference!SectionType)) ORDER BY DIE_DESCRIPTION; Thanks for your help. Mithani

Thanks MStef, I appreciate your help. Users need to see all description, metal & weight per row. In this case I think I have to include these field in my tblInvoiceChild table which is really not a professional step. Please, is there any other way to solve this problem other than increase...

Thanks MStef/ajetrumpet, I have checked your demo but the DESCRIPTION, METAL & WGH/M you assigned as a bound. Let me tell you structrue of my database. For this form, using three table: 1. Extrusion die_number TEXT die_description TEXT metal TEXT weight NUMBER 2. QUERY BASED ON TWO TABLES...

Dear All, I will try to clarify my problem. If I am not clear, please let me know. I have one form with subform. All text boxes are bound except DESCRIPTION, METAL, WGH/M. When I select any Die #, unbound text boxes take data from die table. Whats happening, the first row is fine, but as I...

Hi bob, Oh ya diffinately, I appreciate your help always. thanks mithani

Thank you very much Bob. Working great mithani

Thanks Bob Please see the attached file. Thanks mithani