Search results

thanks bob, you are right but to just for knowledge where can Find Macro Security level? mithani

Hi all, Whenever I open my db I get attached message. How can I get rid off this message?? thanks mithani

set control source of your ID =DMAX("[yourfieldname]", "yourTableName")+1

hello, please help me.

No to worry about startup issue. Thats working. Press swift key while opening database. This forum really saved me. mithani

Thanks Doc, Got info that I have to run security wizard again. I can't even run security wizard. reason I have set STARTUP that not to show any system menu. So I can't even edit my forms. Please tell me if I am not clear. How can I edit startup again. thanks man mithani

Hi all, I am in a trouble now..... please save me. I did User Level Security wizard for my application. Is there any way to reverse that step I mean how can I delete this security option to make my application normal to open. thanks for your help mithani

don't worry man, i fixed it.

Still waiting for your help. If anything is not clear, please reply me. mithani

hi I have tried this code: update tblInvoiceParent set receivedInvoice = -1 where InvoiceNo =Forms!invoiceEntry!comPurchaseOrderNo But updating next record. For example I want to update invoice number 1012, macro will update 1013. Any idea. thanks

thanks ted. I would appreciate if you could give me any example code. thanks man mithani

Friends, I want to create macro to update my table. How i will referene my form and field in macro. update dailytable set recNo = 1 where fileno = form????.fileno(field)??? thanks mithani

I am keep trying but no use. Any help is appreciated.

please see the attached, just showing only one record. It should show all records from purchase minus the records are existing in Invoice table. Any idea? SQL = SELECT QueryPurchaseParent.PurchaseOrderNo, supplierInvoice.SupplierInvoice FROM QueryPurchaseParent INNER JOIN SupplierInvoice On...

Hello everyone, The following SQL query is for my combo box where I am fetching records from QueryPurchaseParent table. I want to check one more table to see whether I have received invoice or not. If i have received invoice, should not show in my combo box. The second table name is...

Not to worry, my report working. Problem was in relation area. mithani

hi, Here I am attaching my db. Please see where I am doing mistake. thanks mithani

:confused: hi all, I have four tables: PurchaseParent PurchaseOrderNo PurhcaseDate Payment PurchaseChild PurchaseOrderNo ItemCode Unit UnitPrice Length Finish Qty Remarks ReceiptParent PurchaseOrderNo ReceiptNo Date dueDate ReceiptChild ReceiptNo ItemCode IQty IUnit IRemarks With the help...

thanks bob, working perfect. mithani

thanks bob but showing #Error