Search results

Sory the whole setup was wrong from the begging.Calculating the VAT on an order is what I am looking for.....Vat Rate is product based.....

@ Pat Thanks for your reply it is a lesson for me. I might not explain correctly. The query will not produce recordsets, it is only to calculate the price for a product according to customers' VAT category. No need for a cartesian product. Need to calculate the product price per with correct VAT...

Did you not notice that valCalculator returns three of everything? But this is the case I think.... Any customer can purchase any product and based on the client's VAT category ( Low or Hi ) price will be calculated depending product's VAT category Hi VAT is 24% or 13% or 6% and low VAT is 17%...

Isn't it what I did on the last DB I upload? I get rid of columns A and B. Do you mean something else?

I think I am on the right path!!!!!!!!! Query VatCalculator. :)

Thanks for the clew. Let me work on it and will post the DB

Hi I need to make a query to calculate a price. The formula is PoductPrice * Vat. But VAT is not the same for every product and there is some client that has a discount on VAT. Check the table below. Some clients belong to column A values and others at column B How to make the query to choose...

You are awesome!!!!!!!!! Thanks

I don't want to save the data instantly (if I'm right), I need to have the option to cancel the order or the invoice. With the bound method, as soon as I enter data in the form, they are stored in the table, something I want to avoid. I am sure there are several, easier and maybe more efficient...

Here is my DB I assume I have to go through recordsets.!!!!!! As soon as I press the save button it should create a new order record in tblOrders and then use the order number to add new records to TblOrderDetails and empty the table OrderTemp

Sorry, I'm working on it......it's a day off today here in Greece.....:) I will post my project later today........thanks for your kind support

I am not an expert....have some VBA skills.....just a few...I need to build a DB in access for my Storage Warehouse but can't find someone to do the job locally. Anyone who wants to involve will be paid. Am I allowed to ask this here?

Hi I need to build a form with a subform to collect data and save them with a "save button" into two tables, else not (do not save the data if the "save button" won't pressed) Thanks Jiannis

Yeap!!! I follow your instructions. Rst.Edit Rst!Mark = Mark Rst.Update As MARK is included in the first recordset. Thank you for your kind support.

??????? e What. If I understand correctly, I entered the table and to Abbreviation Field in its properties i change index to Yes(duplicates OK) Where to add Indexname: Abbrev IndexField: Abbreviation Why not use Table's Primary insted?

Hi Pat. Not to do this you mean With Rst Do While Not .EOF lngSerial = newSerial("Timologio") DoCmd.RunSQL "INSERT INTO Invoices ( TOT_VALUE, DA_NUM, InvoiceNumber ) SELECT APOST_NUM.TOT_VALUE, APOST_NUM.DA_NUM," & lngSerial & " FROM EkptosiSD...

what is InvoiceType anyway? It is for the Greek TAX system 3 kind of Invoices Domestic, Abroad, etc...... i also tried EidosParas field, but all i get is "???" It was In the Greek language I should change it to English. The connection should be Invoices!EidosParas = InvoicesType!Abbreviation

Yes! I see you use [InvoiceType] (1.1 but this in not an index of table InvoiceType) in the query. Invoices!EidosParas should be = InvoicesType!Abbreviation in my opinion and if I understand the code well. But I get null. If I change the creteria in query 0 instead of Is null I get an empty...

hi arnelgp No, It is not working, instead of your previous method that works perfectly. I add a loop. Check the code attached. Furthermore, the new function adds the same number to all invoices. But I do really appreciate your precious help.

Can export it locally? Did you check?