Search results

I realized how it works. So basically in order to get anything other than 0 there should already be at least one record before of the same type Not quite what I was aiming for, but it will do for now Thank you

I deleted all the fake records and rerun it again. It seems I get the same errors with your file as I get with mine. I run it in immediate window too and I also get error (Variable not yet created in this context), while your output says 0.45 I'm honestly buffled

can you please send me your file? it will help me see the differences and understand where I was wrong than trying to find it blind. I don't know what you mean by immediate window

this one gives me this error when I try to run it

That doesn't even give me 0. It stays blank. Why is this so hard :( The logic is pretty simple, but it seems my brain is not braining at the moment

OrderPrice is the the history price that was used in that order so it records the history and saves it in the OrderDetailT You are referring to Price, which is indeed 1 price per product and type and that also exists in the OrderDetailsQ but comes from the ProductDetailsT So basically in the...

Fo the same exact customer I get 0.45 in the retail (I should be getting 0.97 And 0 in the other products Actually it seems it takes only the first price (wholesale) of the first product, that's it

Okay I corrected the name, and it half-works. It tries to frind the price, but it only takes the wholesale price. It doesn't change to the retail price Please check order #4. It's retail. You will see it inputs the same price Also fixed. This is the latest

There really isn't any need for the ProductID to be in the OrderDetailsT. This field is for the categories. Pex I have one product in 3 colours, they have the first initials in the SKU and I only have it to print my wholesale prices. We only need the ProductDetailsID for this function.

Scratch number 2. I solved it. It still doesn't take the proper price

Private Sub AddBtn_Click() If IsNull(ProductCmb) Then DoCmd.GoToControl "ProductCmb" ProductCmb.Dropdown End If DoCmd.GoToRecord , , acNewRec ProductDetailsID = ProductCmb ProductName = ProductCmb.Column(2) Colour = ProductCmb.Column(3) Size = ProductCmb.Column(4) OrderPrice = Nz(Dlookup...

Wow this code is too advanced for me, so Thank you in advance So 2 problems: 1) It should take the Price field from OrderDetailsQ, because that field works on an IF command to understand if it is a Wolesale customer or a Retail Customer. So it can't take just the RetailPrice. I think it's the...

You want OrderT (this has the PriceOrder), OrderDetailsQ (This has the Price with an if command), OrderF, OrderDetailsF and change prices in ProductT. Please only play around with the first one product, as I don't want to redo everything I want PriceOrder to find the values in the Price from...

Hey guys So I want to create invoicing history for the prices. I have done the same for the addresses and it worked but for whatever reason it doesn't work with the prices In the Order Details table I created a field called OrderPrice to indicate at what price that product was actually bought...

I tried compiling and it asks me to put a bunch of brackets on some names. But the database works fine as it is now and I'm afraid I'm gonna screw it up completely if I do. Why does it do that if it works fine?

@The_Doc_Man Thank you for the input. I learned early on not to include spaces so that's not an issue and Microsoft support is always the frst option I look at and try to solve it myself before I ask here. It's a slow learning curve I'm afraid

Fixed. I'm still confused about when it's supposed to be brackets or " Thank you for the input

@Edgar_ Thank you I basically redid all my database but only left a couple of controls in Greek. I have changed them now but still getting the same error I will try the solution you gave me and post here again

My connection is bad. I'll call you in couple of hours when I get to the office

here's the new database