Recent content by sazd1

I have three tables: PurchasesTable: PId, ItemId, PDate, ItemName, PQuantity, PPrice, PAmount. SalesTable: SId, ItemId, SDate, ItemName, SQuantity, SPrice, SAmount. I want to construct a query to make a StockTable: SDate, ItemId, ItemName, QuantityPurchased, QuantitySold, Balance. The sample...

I am working on an application for Point of Sale system. I am using Vb Express 2008 with MsAccess as database. I am almost at the final stages and now i am stuck up with the stock position system. Like I have SaleTransaction table and also a PurchaseTransaction table. I want to design a table...

Thanks for your response. And sorry for the double post of question. I thought that it may be either related to a Query or a Table. So i posted it to both the forums. I am working in Vb Express with MsAccess as database. I am trying to develop a Point of Sale. The data from ListView is...

How the data of one table can be automatically transferred to other table in MsAccess? For example: How data of TableCustomer(CustId,Description,Quantity,Price,Amount) can be transferred to TableTransaction(TransId,TransDate,AccountId,Description,Quantity, Price,Amount,CustId). Please guide.

How the data of one table can be automatically transferred to other table in MsAccess? For example: How data of TableCustomer(CustId,Description,Quantity,Price,Amount) can be transferred to TableTransaction(TransId,TransDate,AccountId,Description,Quantity,Price,Amount,CustId). Please guide.

I am using vb express 2008. How can i format(fontsize,fontcolour,fontstyle) the header of ListView?

you are using VB Express? If yes then you might have coded on FormLoad event like connection and Sql Statement. You need a button and Some Textboxes to transfer data from textboxes into DataGridView and also to a table in MsAccess. Please provide the relevant information so that your question...

I am working in Vb Express with MsAccess as database. I want to transfer Listview records in a table in MsAccess. Please suggest the code for the insertion of records from LIstView to table.