Search results

Hi JDraw I created a basic database along these lines. I got untangled at the end because when I came to create another Freight Company, its not allowing me due to Primary key issues. I have to go this morning abroad for a week. I will pick up your posts every now and then (Hopefully you will...

Hi JDraw For Freight Route there is a functional relationship but not for ADD. And this complicates the issue you see. (:

Hi Jdraw The starting point is always the same The charges are dependent on the destination prefix, the pallet size and whether its next day delivery or economy delivery. I Tried to give you an example, but the formatting was skewed. I have attached an example of the charges. As you can...

My apologies Jdraw. I referred to you as Frothingloss :)

Hi Frothingloss The Freight Companies give us fixed costs for post code prefixes. It is not something that is calculated by the mileage. Its a bit like airfare. Even though some destinations are farther away, the cost may be a lot less than a closer destination. The weight is not a factor. The...

Hi Frothingslosh One of the experts on this site was taking me in that direction. He even very kindly set me up a dummy database. but right at the end, he decided that this would not be workable as there may be too many variables with different freight companies with different combinations of...

Hi jdraw We are a company selling pallets of industrial bags. We have an access database that was set up a few years ago. unfortunately, there was no set field for post codes and users have used different address fields for post codes. When we have an order, we execute it on an access based...

Thank you Gemma I will give this a go. Just to clarify "Goto NextsteP2- This is your comment correct? :)

Hi Frothingsloss Thank you. I will try the code you suggested If (Me.Cust_Del_PCode.Value Like "BD11*") Then Call DeliveryCompanyZone1 ElseIf (Me.Cust_Del_PCode.Value Like "BD1*") Then Call DeliveryCompanyZone2 Else MsgBox "Input Delivery Cost" End If Rob :)

Hi JD The purpose behind it is this. We have a form with a customer input and on the basis of that input, the address field is filled in. There is a postcode on the address filed. According to the prefix of the postcode, the delivery cost field has to be populated (set up by the courier...

Hi JHB It works perfectly. I have tested it. It works only when the "BD1" condition comes before the "BD11". If there is a "BD" condition, then that has to come before the BD1 condition. If the sequence is incorrect, the logic fails. Thats what I am seeing. I used the following case statement...

Thank you so much JHB and Peter. The one that works perfectly is this: If (Me.Cust_Del_PCode.Value Like "BD1*") Then DeliveryCompanyZone2 If (Me.Cust_Del_PCode.Value Like "BD11*") Then DeliveryCompanyZone1 Else MsgBox "Input Delivery cost" End If End If When I had the ElseIf against the...

Thank you for the post Pls see my comments below. The Private subs are working great without the Else MsgBox "Input Delivery cost" Can you suggest please? Thanks again. Rob If (Me.Cust_Del_PCode.Value Like "BD1*") Then MsgBox "DeliveryCompanyZone2" This is not a message box but a...

My Code is this: If (Me.Cust_Del_PCode.Value Like "BD1*" Then DeliveryCompanyZone2 If (Me.Cust_Del_PCode.Value Like "BD11*") Then DeliveryCompanyZone1 Else MsgBox "Input Delivery cost" If the Else MsgBox code is not there, it works beautifully. I have tried combinations such as you...

Hello Tried this. But on running it, it gives me the message: Compile Error: Else without If AND highlights the Condition 2 line I dont understand why this is not taking it :)

Hi All I am desperate for the correct syntax in the following: If condition1 Then Statement1 If condition2 Then Statement2 Else: MsgBox "Do X" I am getting an error on the Else: MsgBox Line Can someone PLEASE HELP Rob :)

Hello again...I tried the case statement but its not carrying out the statement I require. I will need to expand on the statement if I can make the basic work. Please note that I have used the post code prefixes "BD11" and "BD1" as will be the case in a real life situation. Here, the first 3...

Your select Case may be a better alternative. I will also try that...Thanks :)

Hello Ranman The Like statements are working perfectly fine. The syntax is with the Else: MsgBox line. Can you help me with that? Rob :)

I have a simple syntax problem that I want help with. On an after update field in a form I have the following code "If Me.Cust_Del_PCode.Value Like "EN9*" Then Me.Delivery_Cost.Value = "55" If Me.Cust_Del_PCode.Value Like "BD1*" Then Me.Delivery_Cost.Value = "65" Else: MsgBox (“LOOK UP THE...