Before I post, please let me preface by I am very new to Access and VBA programming. I am stepping into the middle of code that while i can logically follow, I do not know much about.
Right now, I have an excel sheet where two zip codes are entered.... and then i click a button to have a VBA script run and it will search the DB for shipping zone numbers that link to those two zip codes.
It is working well so far..... but now it is time to add more to the DB referencing.
The ultimate goal is to enter in two zip codes and a weight, and have the excel sheet return a cost.
So in order for the sheet to do that, it needs to look at the two zip codes, and determine a zone number.
Then, depending on the shipping speed, it will look at on of the 5 zone numbers returned, the weight of the item and reference a rate table in the Access DB.
There are 5 choices for shipping speeds... and each of those 5 choices has its own "table" in the database.
If at all possible, i would like to just press the "calculate" button once... and have it pull all of the necessary information.
Access Table names are:
Zone (currently using for zone calculations)
GND - Ground
3DS - 3 Day
2DA - 2nd day
NDA - Next Day Air
NDAS - Next Day Air Saver
Would want the rates to appear in column "p" of the attached file.
Bookmarks