Search results

I have 3 tables, one is parent and two are child tables. A table named Accounts is parent table and Purchase Journal and Cash Disbursement journal are child tables. 1: Account table contains account information 2: Purchase Journal contains following field. ID, Date, Explanation, A/C ID, Credit...

hello everyone, so far i have started inventory management with accounting system using access 2007, i completed the inventory management part but dont have any idea in designing of accounting system, I studied about accounting principles and rules kinds of accounts etc... but dont know how to...

hello everyone... I developed an inventory database and i want to add some more features on that. In my database i can control inventory very well but not the payments. I have following tables. Orders, order Details, Purchase Order, Purchase Order Details, Inventory Transactions, Product...

Hello everyone. I downloaded Northwind sample database and made changes according to my business. and it works I well. Now I want to add one more feature to my database. The exchange feature. For example, a customer purchase 5 products, and after some days he comes back and want to change some...

Hello guys, A company has 3 locations to store its products, say A, B and C. e.g. there is a product xyz in following locations as per follow: Location A:10 Location B: 10 Location C: 10 QTYAvailabe: 30 My order details subform is as per follows: ProductID Location QTY UnitCost Discount Total...

Hello everyone,, I am facing a problem in my database, I searched this forum and googling but couldnt solve my problem. I have a form name purchase order, there in payment information tab, i have a bound combo box, which has 3 values (different countries currancey) and have 3 bound text boxes...

I have inventory query with following fields Product ID , Purchased, Sold,On Order, Available, LocationA, LocationB, LocationC where locationA, B ,C represent the quantity available in each location. Available represents the total quantity available in 3 locations In order details subform, i...

Hello everyone, in my database there are fields of type Date/Time, their default value is set to now(). But the problem is that those fields are automatically filled up by English system date. I want my own country's date format, without changing my system date format. So I decided, whenever...

Hello everyone, there is a need to make access database (access 2007) accessible over net. I know Access Database is not web based application. So I want to know if there is any way of making it accessible via net. Your guidance and help will be highly appreciated. Thanks

Hello everyone. I developed a database based on inventory control. It is same as Northwind database, the only difference is that here the inventory is in 3 locations. Now I want add a new feature on my database. Beside controlling inventory, it should show daily income as well. Whatever we sell...

Hello everyone, i am making a small database, almost half of that is complete,, and i am facing the following problem. There is one warehouse and two stores A and B respectively. The same product could be at warehouse, Store A and B. As per requirement some of the products are moved from...

There is one warehouse and two stores name A and B. as per need some of the products are moved from warehouse to stores and from stores to warehouse and between stores. Company wants the updated list, that how many of the products are in warehouse and stores. Please tell me how to do it, when...