[help] import invoice from access to excel (1 Viewer)

[roger89]

hi,

i am using office 2007.

i have an invoice table in Access and want to import the data into Excel.

i have an invoice layout in excel, i want to have a combo box with the INVOICEID's in from the access table, then when the invoiceid is selected, information such as duedate invoice id, customerid (e.g. fields from invoices table) to automatically appear in the appropriate excel cells.

so, what should i do? i want to use vba, to clarify since i'm rambling...

i have an invoices table.

i have a dropdown/combo box in excel.

i want select invoiceID in a drop down box. and then have other cells populated with other fields from the table.

hopefully this is enough info, if not let me know..

do i need to import the table to a separate excel sheet first?

thx

 

[HiTechCoach]

If it were me, I would create a report in Access to print your invoice. Access's report write is a lot more powerful that Excel when it comes to printing. Microsoft even recommend using Access's reports to print your Excel data. It works great!

If you must use Excel to print, then I would use automation to insert the data onto the excel worksheet.

This example may help:
Export Data To Excel

 

[roger89]

hi, i must use excel yes for invoices hence the complex way i am proposing i am doing it.

thanks for your example i am now checking it out,

if there is a more simple way to achieving what i want, would be greatful,

thanks for interest, i'll report back soon

 

[HiTechCoach]

if there is a more simple way to achieving what i want, would be greatful, ...

Without knowing more about what you are doing, I would have to say that there is probably not a simpler way to do what you want.

I have has to send data to an excel template to be sent to another system to be imported. It was not an easy task. Lots of coding.

 

[roger89]

im still having trouble, im pretty sure first of all, there is an easy way to populate a combo/listbox with invoiceID right? could you assist?

then i'll worry about generating cell data based on the invoiceID

thanks, you are the only 1 showing interest, hopefully you have a little more time to continue helping me

much appreciated.

 

[HiTechCoach]

If you are wanting to use a combo box to pick an existing invoice, then you can use a query that selects all the Invoice IDs as the row source for the combo box. You can use the combo box control wizard to create the combo box with the list of Invoice IDs.