Recent content by binbin

Hi mahenkj2, I looked at your sample, it would work if the process was structured like that, that is why I SHOULD have stated the whole process in detail... sorry for that mahenkj2 :o They need the "tblLoad" with two sub-tables "tblLoadProduct" and "tblLoadInvoice" with existing data. It is...

Hi everyone! Do you guys mean the process? Here it is... We have a warehouse of products. For a product to be taken out of the warehouse, the stockman generates a Load summary receipt which he gets from tblLoad. Now there are two ways for a "Load Ticket" to be generated, these are by: 1)...

All help are appreciated. Can you elaborate on how I can improve my table relationship? Because I'm all for improvement ;)

I tried to replicate the table, since it would be just to long to find the necessary objects in the original database. So I just made a simpler database that shows the problem. In this database, "tblLoad" serves as the record for all products taken out of the warehouse. this table is linked...

Ok, will just remove some data. It may take a while...

It did not work also, after verifying the values, it turns out that the same thing is happening with the method. Only 1 value is appearing. Took me a while to check since I have hundreds of items to check. I'm out of ideas...

Hi Galaxiom, I tried out your suggestion but did not quite work. If the join is #1, no records appeared, so I tried changing the joins to #2 and #3. Either "qryQuantityB.TotalQuantity" or "qryQuantityA.TotalQuantity" will have give a value, but not at the same time, which means I could not...

Hi everyone! I need help regarding subtracting two values from two queries. I have search around and found some examples, but I could not make them work with mine because it involves SQL statements and I'm not that familiar with them. Basically I have two queries that sums up the value from...

I see, I get what you mean, I actually setfocus to another control then bring it back to "txtLoadID"... ok, I will try it out. Be back in a bit... Update: :D It worked! A simple yet awesome workaround mahenkj2! What I was doing before is putting this code on the "On Enter" event of the...

Hi, I'm stuck with almost the same problem. I have a mainform with a tabbed control that each tab has a subform in it. I have a bound textbox control on mainform named "txtLoadID." What I want to do is when "txtLoadID" loses focus and "is null," a message will be displayed that "txtLoadID"...

I'm glad it helped you. You also must not forget the fundamentals of normalization... since I'm fairly new to access myself, I often find my database bloated with unnecessary data. Allan Browne's site have helped me fine tune my database. Tons of tips and tricks are also here in the forum as...

Almost everyone have encountered the "Price History" concept. In my opinion, you can handle it a couple of ways. You can have another table that saves the price of the item as per date and time and use a combobox list to select the most up to date price based on date and time. Second is you...

Hi there, Upon reading your post, if I understand you correctly, you are asking help in designing a database? If you are, what I do is make a flow chart of the processes, in each process, I then decide what kind of records I would be keeping and on which table it would belong. The forms and...

Hi, that is a very good alternative, not that precise, but then again, I just want to warn the user that a discount has been applied, so I guess this will definitely be applicable. Thanks!

Hi again, If you're wondering, I did find the Round Function already, but is there another way not to use that? Because I don't want to round the gross amount also...