Recent content by krishnanhemanth

hi i have a table called "owner info" 3 fields in this table owner name address phone number what i want is in the report, there are 3 text boxes owner name textbox address textbox phone number textbox the textbox on the report should get the data from the table i cannot use this...

HI GREAT ANSWER SET THE PROPERT TO CAN SHRINK, CAN GROW to YES also, set the height to bare minimum ...may be 0.1 or so it works like charm thanks again

hi every body i have a report for my bill of materials the main report runs on a qry --- displays "model number" the sub report runs on a different qry --- displays parts and sub assemblies the sub sub report (inside sub report) displays parts for the sub assemblies all the three have...

hi everybody iam stuck with configuring a bom for a product the data is... i have three products product white product blue product green all the above three products have the same components and sub assemblies but.. the outer body of the 3 products differ in color ( white, green, blue)...

hi every body iam in a very bizzaire situation i have a form called frmVENDOR invoice with a sub form frmsubVENDOR INVOICE IN the sub form i have unbound textbox "amount" in the subform footer which sums up the amount on the main form i have unbound textbox "total amount" which picks the value...

great perfect answer 5 stars for you ***** thanks again and regards for you missinglinq

HI MISSINGLINQ this is the code iam using on the unbound textbox =nz(IIf(IsError([PONUMBER]),0,DSum("[VAAMOUNT]","VENDORPAYADVANCE","[PONUMBER]=" & [PONUMBER])))

hi everybody i have a unbound textbox that looksup value from a table ....for example in a PURCHASE ORDER form i have an unbound textbox called ADVANCE PAYED THE value for this filed is by using dsum and the value displays correctly but the problem is.... the table "advancepay" has only...

Hi every body I have a invoice that needs to be printed on a A4 size paper i want the detail section height to be constant. the maximum rows in the detail will be 5 records and the minimum is 2 with 2 records or 5 records, i want the detail section height to remain constant. if it is 2...

thankyou missinglinq you people out here are of great help thanks all of you stage 1 is over now stuck with stage 2

i put he condition like this between [upperdate] and [lowerdate] in the query but no results

hi I have got it working to some extent ...that is.. the reports are avilable in the combo box the selected report can be printed using the print button i have attatched a image.... what i want is... to filter the report based on the date selection i make krishnanhemanth

thank you both for your valuable time and idea the table idea is working------reports are visible in the combo but the missinglinq idea...iam not able to get it work.... the combobox is not showing any value krishnanhemanth

hi i have a unbound combo box on a form how do i add reports to the combo box i know i can type it using the value list option but i may have to do it everytime i add a new report is there another way to automate the process plz help krishnanhemanth

i have a problem thats giving me sleepless nights i have a form which does my invoiving i print the invoice from the form on a A4 sheet the print comes out pretty good ------ so far good the issue is... the print area (length) increases / decreases depending on the number of entries...