Recent content by Ratib Hussaini

thanks Hartman for the reply, at first I used select query, it was showing some aggregate functions error,, but later I got to know that it wont work by select query. So I tried union instead, it works fine but some errors there, like new transactions comes to the top of other transactions not...

thank you sir for the reply.and sorry for some confusing points in my question. As you said i made the corrections in fields name. I dont know why you have used AccountID from purchase journal. I think my question is not very clear, I make it much clear by changing number of fields and fields...

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...

thanks. I dont know, whenever i put the higher value for each location, it shows my msg, but jst after that it says property not found jst need to press ok and it works fine. According to my code it works fine, just as an information it says property not found. But in before update event of the...

Thanks Mr. Hartman for the reply. I made little bit changes to the code according to my need, but it shows the same msg "property not found". here is the code Dim LocationID As Long Dim productid As Long Dim qtyA As Long Dim qtyB As Long Dim qtyC As Long Dim qtyAvailable As Long Dim response As...

can you please give more details, and also we have customers that save their money with us.

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...

Sorry, Mr. Hartman I put the code in forms before updates event but it wont work, by doing this after completing each record it shows the message, "qty high", in either way weather it is low or high. And by putting code in before update event of location and qty..... Mr. JHB and Mr. Hartman's...

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...

thank you, I got your point and the attachment is helpful, but it will take time for me to change it,, for now if possible could you please tell me how to solve this error,,, and one thing more I checked that by changing any controls on the same tab shows the same error, and by clicking OK it...

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...

Thanks Mr. JHB, and sorry for late reply, as I was not well,,, Your code works fantastic !!!!!!!!!!!!!!!!!!!!!:)

As you said, I placed validation rule in the before update event for both location id and qty. code is below. Private Sub Location_ID_BeforeUpdate(Cancel As Integer) Dim LocationID As Long Dim ProductID As Long Dim qty As Long ProductID = Me.Product_ID LocationID =...