| kadomony |
Hey, I have an Access database.
What I want to do is create a default spreadsheet design that can load information from a selected record in my database and put the information in the right places.
This is for invoice purposes.
So, for instance if I wanted to create an invoice for Customer 3, I'd select their record in Access and then click something that would load their information into the pre-made spreadsheet I designed so I could print it out.
Is this possible, and if so, how?
Would I need to create the spreadsheet in Excel first?
Is there a way to add a dropdown menu in a box in Excel full of values from a field in the Access file and have it load the Access values for that record in various cells based on that? |
|
|
