Search results

Would I need an SQL code, or is there a VB or query to add that data into the table?

Okay I have an Orders Form, which generates a SubTotal Price (ex VAT), VAT, Shipping & Freight Charge based on an IIF statment of being under a £50.00 order apply £20.00 charge. And finally a Order Total with it all added together. This works fine, however I cannot seem to find a way to post...

Hi all I have a table with ProductName and QuantityAvailable I have made a combo box which contains these 2 columns however there is no fieldname which I want.

Thank you! Is there a way to say if the actual Sub Total is UNDER £50.00 apply a £20.00 fee in the Shipping & Handling? To do with If statement, but not sure where to post it?

Sorry for late reply finally got it uploaded. As you can see from the Order form the VAT is not being added at the bottom.

Hi all I'm still trying to upload it and it still seems to be going very slow, even if I have compacted it. :(

Still not working correctly.

Is it possible to PM me they're email so I could send it via email? Thanks.

Okay I have attached a copy of the DB I am working on. As you can see from first order that appears the VAT is not being added. Seem to be having some issues uploading this.

I cannot find the record source, I can find the control source. can I zip it up and post it on here?

I'm not really savvy with Access, how would I do that?

Hi all I currently have an Orders form for which it is supposed to breakout the Subtotal, VAT, Shipping Charge and Total. In my VAT code I have =[txtOrderSubtotal]*1.2-[txtOrderSubtotal] This breaks the VAT out. However in Order Total it does not seem to be adding the VAT on to the price...

Clearly I forgot a query. Thank you! That's what I was after!!

Okay I've posted it in 2003 format, however the form in the 2003 version seems to have disappeared. Don't even know why it has done that.

Hi all, I have 2 combo boxes, one Categories and Products. However I have follows a tutorial and when I select the Categories, the products do not show even though the tutorial says it does. :banghead: I have little experience with this and I really hope somebody can help me on this. I have...

Hi, is it possible to split orders up based on ID and append to a table with an Order Item ID? For example a custom phones up and places an order for Product A x 3 and we have 2 in stock. It will then append an Order ID of 20. However I want to split this order up and give it an Order Item ID...

I'm still struggling tbh. I only have one customer table and its still confusing. I don't know much about Access.

Combo Box Filter Okay sorry I was meant to ask how do I filter using a combo box. For example I have an Account Numbers for different companies, when I click a certain account number on the combo box, I wish for it to bring up that company in another combo box, with a list of employees in a...

I have a list of customers, with Account Numbers and Company Names. Now I have entered a combo box in my form control with a list of Account Numbers, how ever I wish to group these Account Numbers because some are the same, with the same company but a different Employee. So how do I group...

Hi all I have recently downloaded a free orders database from MS, however I am really struggling when it comes to doing anything on it as I am still a novice and with very little experience. I am able to create an order within the form which is fine, however I need an Invoice in either a report...