I have an Access DB with each client having a unique ClientID.
I also have a spreadsheet on Excel that captures specific information on clients for later use on monthly reports (this reports cannot be generated in access, therefore I need to have them in excel)
What I need to know is if when I am in access working on a specific client, I could create a button that would open the spreadsheet that belongs to the same client in excel. I have 1 spreadsheet per client, and I could name the spreedsheet by the same ClientID I use in Access to make it easear.
So basically I want Access to look up the spreedsheet with the same name (ClientID) that I am working at that moment and open it up.
Thank for your help.
I also have a spreadsheet on Excel that captures specific information on clients for later use on monthly reports (this reports cannot be generated in access, therefore I need to have them in excel)
What I need to know is if when I am in access working on a specific client, I could create a button that would open the spreadsheet that belongs to the same client in excel. I have 1 spreadsheet per client, and I could name the spreedsheet by the same ClientID I use in Access to make it easear.
So basically I want Access to look up the spreedsheet with the same name (ClientID) that I am working at that moment and open it up.
Thank for your help.