help with multipul reccords

[casual-rich]

hi i need help very quick

i have run a parameter query to get some information, of the same customer, i have now this info and created a new form with all the info on it.

but now i would like to transfer the multiple records from access to excel and put them into an invoice that i have created

please can any one help me please

richard

[OBP]

Richard, why not create the Invoice in an Access Report?
You can use something like this for putting the data in to an Excel Workbook
Dim excelname As String, AppExcel As New Excel.Application, Wkb As Workbook, Wksh As Worksheet
excelname = "(the name of your Excel Workbook)"
Set Wkb = AppExcel.Workbooks.Open(excelname)
Set Wksh = Wkb.Sheets(1)
thisday = Wksh.Range("b2")
Wksh.Range("d3").Value = 1
Wkb.Save
Wkb.Close
AppExcel.Quit
Set Wkb = Nothing
Set AppExcel = Nothing

You will probably have to set a Library Reference to Excel to run the code

[casual-rich]

thanks for that i will have a look but this is for uni u see

[Aussiebear]

thanks for that i will have a look but this is for uni u see

We have a policy of not providing code for either school work (or in this case University). As this is in breech of the forum policy this thread is now closed.