Search results

Hi all, I am back to the same problem When Products are updated, PurchaseOrder_GRV and PurchaseOrderGRVSubform does not requery I tried al the below

All good thank you Thanks for the assistance

Hi, No does not have the same name I got this one sorted This form has a sub form that needs to be updated I am now looking at the same senario but the main form must requery, not the sub form Seems like the same code wont work if there is no sub form with .RowSource

Neither seems to work No errors, new record just not available in the other forms sub form

Hi all, I am updating a form and after another form with a sunform must requery Somehow it is not refreshing and the new record added does not appear in the drop down box of the sub form

Thank you all, It works Removed the , and replaced with space

When I set the format to currency and decimal 2, I do get R4 424 200,00 Even when I set the decimal to 0, still the correct output as I dont want to see decimals Which looks good but the incorrect currency I dont want to change the windows currency tp UGX though

It formats to 2553440 instead of 2,553,440 (Original value 2553440.23) I don't want to see the decimals so that is correct Window currency is set to ZAR, don't want to change that

Hi all, Any reason why my value control wont format to currency with thousand separator and no decimals? The data type is number, double

Got it working as required Thank you

No just 2 levels If the supplier selected has a product marked with the same supplier, then to the top Then any other products There will be 2 fillets, one raw and one manufactured, when purchasing i only look at raw product, selling would only be manufactured products

Products table see below When I select Rogers meat, I would like to see the products from the product table marked as rogers meat preferred supplier on the top of the list before any other product is displayed When crown national is selected as supplier, I would like to see the spices on the...

For instance if you normally purchase bread from one supplier but that day you purchase from the garage, the option to purchase any product from any supplier should be available

Apologies, I was referring to suppliers I have 100 products When I select a supplier, I want to se all 100 products Lets say I purchase meat and spices Meat I purchase from Meat Supplier and spices from a supplier in South Africa When I select the meat supplier, I want to see all 100 products...

Hi all, I have a preferred customer set up in my products table When I raise a new purchase order and I select the customer, I would like to have the items with the customer as preferred customer to be sorted to the top of the combo box and the balance of the products below. If no preferred...

Thank you all

I can use the built in windows calculator but some of the staff don't really have much computer literacy, so having the calculator on the same form where a few values needs to be added, will make it much easier for the user, instead of having to open up the windows calculator, just a preference

I sum them all together, for November, there is figures for all Just Profit/Loss is blank But NZ seems to work just fine Thank you

Hi all, Is there an easy way to create a calculator on a form?

Hi all, Quick question Below is a table with temporary data I need to add fields together Query comes out blank What am I doing incorrectly?