Search results

Hi All, I have one form with subform(tabular). In subform I am listing detail of expenses. How could I reference any particular row? Thanks mithani

MStef, My running sum is working great. How about if I want the running date and wants to calculate days? Bellow are two text boxes "Date" & "Day" Date/Days 12/02/2007/ (first date should be date()-12/02/2007) 14/02/2007/2 days came(14/02/2007-12/02/2007) 18/02/2007/4 days...

Thanks Banana.

Dear Banana, Thanks for your reply. I have gone through your link and tried and tried but not suceed. would you please let me know the correct syntax? thanks man mithani

Hi all, I have one form with subform. In subform, i am doing datediff from two different dates, one text box from subform and other from main form. How can i correspond the main form text box in sub form. Like i have given code: =([Week_ending_date]-(Form!job_costing_week_ending))*7 But not...

Oh thanks bob, so kind of you. mithani

Dear All, I have two date text boxes and I want to calculate the days difference between two dates. I have put this code but not working. =NZ(DateDiff("d",[date],[week_ending_date])) Can anyone help me please? mithani

MStef, so kind of you

Hi all, I have one form with subform. Two tables are using Parent & child table. Subform is in tabular form. I have three fields, invoice #, date & amount in subform. I want to include one more field for sum. I don't know what you call this kind of sum: invoice, date, amount, sum 1001...

thank a lot

Repeat Value in Combo Box pbaldy My actual db is very big so I have made the example one. when you open the form, just click my combo and you will see project 1095 showing 4 times, 1096 2 times and so on. I want to show each project code only one time. any help? ameer

yes the same query without DISTINCT or GROUP BY returns repeating project code. When I put distinct or group by, then no record returns MY ACTUAL DATA PROJECT CODE & INVOICE NO 1095 - 139 1095 - 140 1095 - 141 1095...

thank pbaldy, I have tried this code: SELECT DISTINCT ProjectBudgetChild.project_code FROM ProjectBudgetChild; Not showing any record. Any idea? mithani

Dear All I have one combo box based on project number from Child Table. So each project number can be repeated number of times. So what I want that when I click combo box, should not repeat same project number(although table container same number hundred times). mean one project should show...

Thanks Pbaldy mithani

Thanks Pbaldy, Showing error "Run Time error 2001, You cancelled the previous operation". Any help mithani

Hi, I am trying this code to show my product based on supplier code: Me.txtsupplier = DLookup([products], "SUPPLIER", "[SUPPLIER_CODE] = '" & Forms!TRYING1!Text5) & "'" but showing error: Run Time error 3075 - Syntax error in string in query expression '[supplier_code = '1001'. Thanks mithani

thanks Dennisk click on this link http://www.popular-pics.com/pictures.aspx?photoid=422 mithani

Hi All, I am trying to creat Menu for my progamm like shows at the top " File, Edit, View.....". Can anyone give me hint or any link where I can find how to creat. thanks mithani

thanks bob, By the way whenever I try to add reputation, i get message "You must spread some Reputation around before giving it to boblarson again." Why I can't add reputation? mithani