Question about MS Access - TranceAddict Forums

TranceAddict Forums (www.tranceaddict.com/forums)
- Chill Out Room
-- Question about MS Access

Posted by kadomony on Sep-05-2008 23:07:

Question about MS Access

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?

Posted by XaNaX on Sep-06-2008 00:24:

why not just create an invoice report in access?

Posted by kadomony on Sep-06-2008 00:43:

quote:
Originally posted by XaNaX
why not just create an invoice report in access?

doing that now. just dragged the excel document into the report area and it imported the design.

cool shit.

thanks

Posted by Krypton on Sep-06-2008 02:05:

Mail merge.