Search results

Hi and Greeting I need some help with deleting of Record. currently i have a form with subform datasheet Form from Purchase order table Subform from serial table(Brand,Model,Type,Location,Serial) with serialtrans table(InOut,AQty,Comment) (SELECT tbl_Serial.*, tbl_SerialTrans.* FROM...

Please anyone? Could help me thanks

Hi. Inventory table is my product table. And inventory transaction record every product transaction moving in and out of the store. And every transaction has a transaction number recorded in order table And there is 5 order type: Sales order Purchase order Repair order Loan order Adjustment...

new setup tbl = Order Qry = PO from tbl Order form = PO from PO Query with criteria like "PO*" to display all order with PO number and also to create new PO order. now i want to use a single query, rather then to create many query to get other order type is it possible to use the form name of...

i seperate the tabel in the first place because i have different kind of order number example: tbl PO = PO14/02/A0001 or PO14/02/U0001 tbl SO = SO14/02/A0001 or SO14/02/U0001 tbl RO = RO14/02/0001 tbl LO = LO14/02/0001 tbl AO = AO14/02/0001 but now i am trying to put it into 1 table and create...

Hi and Greeting to everyone i need help with the following and i have try my very best to try out every possible way to add the auto reset into it but how ever i am not able to do so and i am new to vba. i learn by searching the web but i could not find any best way to do it. and i am learning...

Anyone Could kindly help please Bump Thanks In Advance to all

Firstly Greeting to all of you. im new in using Access, i have some question on updating table when i using subform Table i have are Inventory Product Categories SO SO Items 1. main form(SO Table) consist of the following StockOrder ID StockOrder Date Customer Jobsite Date Submitted...