Search results

Yesterday I kind fellow here gave me a piece of code for a dlook which has worked fine. However Since pasting it into a query, it has completely slowed my database down. Is there an alternative for this? I basically have 2 tables, one with customer details etc, a second table with duplicate...

Hi all I have 2 tables, one called Addresses and Extended Areas. Within my imported orders I have addresses with postcodes and countries. My Extended Areas table has Country, zip_low, zip_high and extended area with a Y. I wish to check certain postcodes from a particular country between...

Okay I'm little confused about how I am going to go about this. When an Order is created based on whats in stock. So if quantity of stock is 10 and I order 11, within my form it will automatically be placed as Quantity - 10, Quantity To Follow will be 1. My boss wishes for some sort of...

Order ID help/question *SOLVED* Hi all, hopefully this will make sense as I type it out. I currently have an purchase orders database which is working fine. When an order is created through my form the details are stored in 2 tables 'Orders' & Orders 'Details'. Both are linked with an Order ID...

Hi all I currently have =Round(Sum([Extended Price]*1.2-[Extended Price]),2) however I want to Int instead because of the third decimal place.

Hi I am fairly new to Access and have been struggling all weekend to try and accomplish this task. I have been asked to create an orders database for purchase orders on certain products which is fine. However I have now been told that each customer will have they're own many discounts on...

I'm having some trouble getting this to work, I have an orders form and what I wish to do is when somebody creates an order with a company based on an item it automaticially gives them a discounted price on that product. I have a table within my database with an Account Number, SKU, and a...

I have been asked to create a database that creates orders, debits stock etc for my company. Now I have been asked to put in some kind of discount table with percentages for each individual item for each individual customer. What would the best way of doing this? I figured in the Customer...

Hi all I currently have =Sum([Extended Price]*1.2-[Extended Price]) however it is showing a price of 9.144, however I want it to just show 9.14. is it something to do with round?

Hi all I seem to be having some trouble with my unit price. Its not round up correctly. I currently have this : Extended Price: CCur(Nz([Quantity]+[QuantityToFollow],0)*[UnitPrice]*(1-[Discount])) which comes to £45.74, but the actually price should be £45.72. Its some how rounding up. I...

Hi all, I currently have a dropdown menu with a list of products called ProductName that is updated with a price etc. That works fine, however When I come to create another combo box with ProductTitle, I cannot quite seem to get it to update the ProductName combo box. Basically a customer orders...

Good eveing all, I ahve 2 questions regarding Access and didn't know where to post. Firstly, we have an Orders DB that also includes Back Orders, when a user opens up the orders I wish to flag up an message about the remaining orders "You have X Back Order(s) left." I don't really know how to...

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.

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...

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 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...

Is it possible to add a <br> after every full stop within access? I currently had a description field that contains carriage returns. What I wish is add a <br> after every fullstop instead. Can it be done within a query? Example I currently had a description field that contains carriage...