I am about to start a large ish (hopefully) vba project, and just after some more experienced advice/thoughts on it before I invest too much time.
My company (multinational) has a need for a database of freight costs, each freight cost will have 7 fields (maybe more):
POL (port name) / POD (port name) / Carrier (short string) / Start (Date) / Valid To (Date) / Type (a few set options) / Cost (number) ------- And maybe a few other costs types as well depending on what is needed.
These costs then need to be presented to each user based on what they enter for POL / POD / Carrier / Type etc.
Now I know I can do this in excel, have a sheet with all the rates as each row (hundreds of rows) and then a user form to present to the user, but I was thinking access might be better, having the rows as a backend database, and then a simple front end user form referencing that backend data.
I'm just after what you very talented and knowledgable individuals would do in this case before I invest too much time into it?
I am much much better at Excel vba than Access, but I have made smaller access programs in the past, although I'm worried about the backend being on a server shared drive and that causing issues.
Or is there a whole other alternative I could look into beyond Excel/Access, one that has a short learning curve as I would have to learn how to do this myself.
The backend/master freight costs data would need to be easily updated, excel/access is easy to do this via a template file etc but that needs to be considered.
Thanks in advance