Search results

Hi Steve...Just to clarify why I want to Group certain post codes..>its because certain groups have the same delivery cost. So, Company A will charge the same to deliver to the group of post codes of a certain group. For the same Group , Company B will charge an amount different to company A but...

Thank you again Steve...Rob :)

Hi Steve...About your question below, it is correct...Different delivery companies have different prices for the same group of prefixes for post code. The Groups are however, similar. Thats why I was hoping to have a way to refer to a group of post codes to apply into an If then VBA...I also...

Hi Steve...Thats absolutely fine...:)

Hi steve I have reduced the fields to what is necessary I have my complicated If Then VBA in the After Update Event for the following fields: Customer Transport company Service The User does the following: 1 Chooses a customer 2 Then he/she has delivery address displayed to choose from in...

Hi again (i feel bad that I dont know your name..>I am sorry) I wish I could attach a screen print of the delivery note form where all these things apply. is there a way? 1) All companies have different post codes but the prefixes are common amongst them (Thats why I have to use the 'Like...

Hi again...This is very promising, but there is a snag which I would urge you to get me through. There are 3 more variables that need to be selected leading to a different price. 1) The size of the pallet eg 1,2,3 etc - prices are not multiples of 1 and a linier equation cant be applied 2)...

Thank you Paul...I will work on the recommendation and hopefully achieve my goal ;)

Thank you so much for your effort..I will study these and give it a go at implementing them....You are of great help...Rob :)

Hi all....I am a novice on access and have a very basic knowledge and I need help with VBA coding. I have made an Access 2003 DB. I have a form with Field1, Field2, Field3, Field4. Field1, Field2, Field3 are address fields, but people have used all 3 fields to insert post codes. I need a...

I am a novice at Access. But, I was thinking whether it be possible to group all the post codes with the same charges by giving it a name and then refer to that group in the If then statement?

Hi all....I have an Access 2003DB. I have a form with Field1, Field2, Field3, Field4, Field5, Field6. Field1, Field2, Field3 are address fields, but people have used all 3 fields to insert post codes. Field4 and Field5 are comobo boxes with the following selection options: Field4 - 0.5 and 1...

Hi People I have a very basic knowledge of Microsoft Access 2003 and using it, I have built a rudimentary Access database for our family business. But, now I need it to be a bit more sophisticated if possible. I have used the threads on this site when making my database and I am in awe of...