Search results

Hi All I need help with allocating a value for a group of products I have products A1, A2, A3 , A4, A5,A6, A7. A8, A9, A10, B1, B2, B3, B4, B5, B6, B7 etc. A1 to A6 have a category Bags A7 to A10 have a category Sacks B1 to B3 category Rolls B4 to B7 category sheets Instead of listing each...

Thanks Guys...Let me start with the code :)

Hi All I have a form with a subform that requires inputting invoices from suppliers. For quite a lot of them, the majority of the information is a repeat of the previous invoice. Is there a command function that I can use to copy all the information from the previous record and insert them into...

Hi Static The result I want can be seen in the form "Delivery Note". If you can help me get the result using your code, I will be grateful. I am not advanced enough to apply the. Thanks Rob :)

Thanks Static...I am not sure how I can apply it to my database to make it functional. I am posting the database, that sort of works using ideas from Steve original database but not using the postcode groups. But, the form that it needs to be applied to is the Delivery note form. If you get a...

Hi Static I am sorry I thought you were Steve..Apologies for assuming.. Now, I have a very basic knowledge of Access 2003. From your instructions, I can see only 1 table and many codes. How do I apply this to my requirements? I have multiple variables - Different freight companies, pallets...

Thanks Steve again I will do a DB along the lines of your recommendation and if I get stuck, I will request your help. I think, we can disregard one or 2 prefixes and will have a redundancy plan whereby, for any that we cant deal with, we will have a message box asking the operator to...

Hi Steve So using the examples: In the table pc Group say for post codes BD1, BD2,...to BD10 TblpcGroup pcID - number (This is autonumber with value 1) pcArea - Text i.e. BD pcDistrict - number - start number for the group - This will be 1 pcDistrict2 - number - end number for the group -...

Hi Steve thank you very much. I will try and get this done in a database. Just to clarify about the following: "pcDistrict2 - number - end number for the group" I suspect that this is the suffixe eg for DB1 2PY, pcDistrict2 is BD1 and pcDistrict2 is 2PY? Regards Rob

Hi Steve I have to apply it to an existing database similar to what I posted where the whole postcode is already in the field. Unfortunately, I cant see how I can apply your solution to this database. This is why, I had to improvise. Regards Rob

Hi Steve You are right!! Even this doesnt help when we have post codes have common characters in the prefix like BD1 and BD11. The query picks up both values, but displays the first, which is BD1. Can anything be done eg, a function that looks for the characters upto a character that is a...

Hi Steve I changed the query where it looks for either the first 3 characters or the first 4 characters to get a match. This should capture all the post code prefixes: SELECT QPostCodeCharges.Charge FROM QPostCodeCharges WHERE...

Hi it works!!...Thank you the correct syntax is (QPostCodeCharges.PostCodePrefix= Left(forms!FolCustDN.Cust_DelPCode,4)) :)

Hi Plog I tried the following but its not accepting: ((QPostCodeCharges.PostCodePrefix)=forms!FolCustDN !(Left[Cust_DelPCode],4)) Its not working. Could you give me the correct syntax please? Thanks Rob

Hi Steve I modified your database to come very close to what I need. I thank you for it. But, I hit a stumbling block in the syntax of the query. This works: SELECT QPostCodeCharges.Charge FROM QPostCodeCharges WHERE (((QPostCodeCharges.Courier_Company)=forms!FolCustDN!Cust_Transport_Company)...

Hi All I am so close to a solution that you have helped me towards. I am stuck at a syntax in a query. The following query works fine SELECT QPostCodeCharges.Charge FROM QPostCodeCharges WHERE (((QPostCodeCharges.Courier_Company)=forms!FolCustDN!Cust_Transport_Company) And...

Hi All This is the Test database that I need the function to work on :) Rob

Hi All I need help with a code for a DLookupFunction. I will try to attach my simple database The database has 2 parts to it. The first part One part is for inputting the delivery charges for a postcode prefixes for Freight Companies (in my example it is ADD and FR). You can see in the...

Hi JDraw We have been running an access database for a few years now that we have been using. Besides this, there is no other electronic operational system for day to day administration. You are correct. I am trying to adapt the current database to record shipping rates by freight companies to...

Hi JDraw...Sorry for the delay in replying. I just got back from my break...The purpose is this. The customer places an order by phone. The staff have to create a delivery note for the warehouse to dispatch and the transport company to deliver. On the delivery note, we have a mainform and a...