Search results

Hello all, There is one field "DeliverDate" on my purchase order report. What I want that if this field is empty, then should print "ASAP" otherwise print delivery date. I am giving this command but showing error: IIF([deliveryDate]=null, "ASAP", [deliveryDate]) Thanks mithani

Thank MStef, I deleted subform and regenerate and working fine... thanks a lot mithani

Sorry that's record not 'ecorc'. I have supplierInvoice common in main & subform. Its hidden in subform. But still not saving data from subform. any clue? thanks mithani

Hello, When ever I want to save my data, I am getting error "You cannot add or change record". I have checked both tables relational, everything seems fine and I don't know where is the problem. Can you please check attached screen. mithani

Hello, I have two combo boxes, First combo I will select invoice number and when I click on my second combo, should bring all matching with same invoice number. I am trying the this sQL statement but not working. SELECT QueryInvoiceChild.description FROM QueryInvoiceChild WHERE...

Dear friends, I have one form for Invoice Entry. What I want that when I enter Purchaser Order number in PurchaseOrderNo text box, system should seek this number in Purchase Query and if found then fetch the other record(PODate, ProjectName, etc.) and show in my form. This is just for display...

bob please help me.... mithani

bob please help me. thanks

Hello friends, I have one delivery advice form. What I want that whenever I fill up all field and press print button, system should look the purchse order number in purchase order table and update "PrintOut" filed which is bolean, as a TRUE. So if some one wants to print, he can only print...

Please reply me.... thanks

Hello friends, I have made one purchase order module. When I enter my purchase order detail, I have one button to take print out. For printing I am using DoCmd.OpenReport command and working fine. What I am looking for that when I press print button, I should: 1. Get three copies. 2. First...

thanks bob. I was in Dubai for 12 years and now in Sydney Australia.

Bob, appreciate your support. thanks mithani

Hello, I have purchase order and I want everytime I make purchase order, system should give me last purchase order number + 1 automatically. How can I do? Thanks Mithani

thank bob, mithani

Hello, Is it possible to change my text color even if I set enabled false? thanks mithani

hi neileg, my SQL query: SELECT STATUS.PROJECT_CODE, PROJECT.PROJECT_NAME, STATUS.ITEM_CODE, STATUS.ITEM, STATUS.FINISH, STATUS.QTY, STATUS.UNIT, STATUS.PCS, STATUS.SUPPLIER_CODE, supplier.supplier, STATUS.CONTACT, STATUS.ORDER, STATUS.ORDER_DATE, STATUS.FI_ORDER_NO FROM (STATUS INNER JOIN...

Bob you are Great!

thanks bob

Thanks Bob, I entered this code: ="From " & [Forms]![PO-REPORTS]![OstartDate] & " to " [Forms]![PO-REPORTS]![OendDate] But showing this error "The expression you entered contains invalid syntax" Thanks mithani