Search results

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

Hi everyone! This is driving me nuts for hours now... I was trying to look for a solution here, but it seems to relate to a different cases or I'm using the wrong words to search... Anyway, I think this is a very simple problem, yet I'm unable to fix it. I have a subform based on a query...

Hi there! Well, after my last post yesterday, out of frustration, I just deleted the damn heavily formatted subform, but I did make a list of the customization, but it was still a pain to do all over again. Anyway, back to the issue. When I went back to read this thread, I tried replicating...

Hi, swing away, I'm out of ideas. I have named all my textboxes with prefix "txt," so I have "txtPayAmount" (recordsource: "PayAmount") inside the "fsubInvoicePaymentDetail." Then I have a sum textbox with formula "=Sum([PayAmount])" and named that textbox into txtSumPayAmount. So normally...

Hi everyone! This currently affects all my objects, from table up to forms. My problem is that I cannot make the Totals row on the datasheet view to work, nor can I make the form footer sum to work. Usually, I just sum a field at the footer of the subform with a textbox with a value of...

I'm not a guru, as you can see, fairly new to the forum but will try and give you some inputs. Why do you need a pop up form? Why not use a subform in datasheet view to add line items filtered by the comboboxes? Sorry, I'm not familiar with how you want an item be connected to a customer...