Recent content by dcmphi

Thanks @arnelgp. How to insert too many fields like <code> CurrentDb.Execute "INSERT INTO tblContactData...

Thank you @arnelgp for reply. I want to format my BillNo as "123/1245" How can i do this format.

I have table with 4 field (1) ID (Primary Auto Increment) (2) TDate (3) BillNO (4) Taka (5) Vat and i have a form with text box "txtID", "txtTDate", "txtBillNo", "txtTaka", "txtVat" an a update button. I want to update record through the from with event procedure. i use the following code to...

error on "_" underscore vb not recognized when i type the code.

When i want to add a record by a form in the table one record increased with autonumber. Example: my table named user and that has two fields: One is ID and two is Name and have two records. ID Name 1 Debashish Mahonta 2 Shajib...

Thanks MarkK. But how to use your code. Please explain it.

Thanks MarkK. It works. Can you help me how to show a table data in a message box. Example: I have a table Transaction. The table has a field named TransactionID which is Auto Number. When i add a record in the transaction table by a form after record added successfully it shows a msgbox with...

Thank you for your reply. See my attach file boss. In that db project i have a customer, Nominee, Transaction, TransactionType, VoucherType table. And i have frmTransaction form which is linked transaction table to store data in transaction table. To add a transaction by the form i want to...

I Have one Table named of "User" with following Column: ID as PK Autonumber and Name, And a form following with text box ID and Name All text box is unbound. when ID text box is updated with User's table id value its shows the name against the entered ID in the Unbound Name text box which ID is...

All Access Experts please help me. I attach a access db file. please help me how to develop a db with following requirements. In transaction form i needs following input validation (1) when ACNo text field is null or filled with any number it checks existing data (Name field) from a...