Search results

Hi I have Qty, mass and UOM If mass is not required as per the product master, then mass control should not be enabled TabStop does not seem to work in this case, unless I am not using the code correctly No matter what I do with the code, it either goes toe this control or skips this control no...

No, Qty and mass should never be multiplied together Am I missing something in the formula?

Thank you arnelgp What I would like if possible is when I raise an invoice, to look at the date and the supplier currency then update the exchange from the web. I dont neceseraly want to go to a seperate form to enter the date en select the from to currency Most of the time it would be...

May I please use the same post to ask a different question? Does this mean that if Mass required is true that Mass control will be active If mass require is false, Mass control will not be active Does not seem to work as required Currently the Mass tab stop is set to yes whatever I change...

Wow, thank you so much, works great

May I please ask you to assist in extending this formula Not sure what the contention should be I also need to add that when the currency is UGX then same formula applies If the currency is not UGX then it should be Qty * unit price * exchange when mass is null or if the currency is not UGX...

Will I be able to enter a date and the exchange rate of that date to be displayed, not just the rate of the day?

The base currency will be Uganda shilling

Do you manually download the exchanges from the website or do you retrieve them via Access? I do not do the exchanges that often but would like Access to look for the exchange for the Invoice date selected and the from / to unit as the invoice is generated I am not sure on how to do this...

Hi all, I am opening a new post for this, I asked about this before but did not get to where I want I need to be able to profide an exchange rate from currency and a to currency and if possible as in googles sheet, when you supply a date it will give the exchange rate of that day as in google...

Qty and mass could be either just qty or qty and mass Not all qty will have a mass Sample bacon 200g pack will only have qty 1 and no mass as you purchase 1 pack at a price per pack Fresh meat you would purchase per kg but still I would add a qty of the amount of say 1 beef fillet Everything...

Basically all then needs to happen is when I select the product from die drop down box, the qty and or mass is entered with the unit price If the mass is entered, i need mass * unit price, if no mass the qty * unit price initially i based my query if UOM is KG then the above should apply but I...

Thank you What would be the correct approach to accomplish the desired result? I used this formula in the underlying query but gives me a null result

Thank you Not sure how to handle this When the product is selected from the drop down box, I need to have the Unit of measure updated to be able to do other calculations If I can not update the UOM after the product has been selected, I a not sure how to get the UOM in place I can not link the...

Hi all, I have a form where I select the product If the product has a unit of measure as Kg, the i need to multiply Mass * Unit price If not Kg then Qty * Unit price What is the proper way to do these calculating with an If statement Not sure if this can be done with an unbound control and...

I found the currency exchange sample DB Will have a look at it in depth but I dont see a from currency to To currency and the exchange

Please could you give me the likn to the sample DB

My purchase order form has Vendors from around the globe, if i select a vendor which is not my country, I want to be able to add the exchange rate of that day to the order to calculate the correct total cost If this could be done automatically this would be great instead of having to look up on...

Than you, works awesome Is there a way to link an exchange from the web into access?

Yes I am updating the same table that is in the form