Ive been asked if it is possible to create a button in excel that when clicked, takes data from another field (containing a job number), opens up Access, goes to a form and jumps to a record with the job number in question.
There are 2 problems with this that need to be considered:-
-The database requires a username and password.
-The Access version is absurdly ancient! (Version2).
Im assuming ill have to create a macro rather than a VB Command button in excel but as of yet i have no idea what to do with this. The Excel version is 2000.