Help Please (1 Viewer)

[crann]

Hi Guys,

Really need some help with this one, i have been searching other messages but can't really find the answer.

Ok i want to use a invoice that was designed in Excel as a report, i want to create a form so that when i enter information, (i,e name , address invoice description) and click process it sends the info from that form into the right places on the finished invoice.

I don't want to use excel, it is just that the invoice has already been designed, and i don't know if it is possible to use that as a report, but then how do i link my form boxes to what is in effect an excel style invoice, even though it is in as a access report.

As you can see it is hard for me to explain.

If anyone can make sense of this, any advice is appreciated greatly.

Thanks Crann

 

[WayneRyan]

crann,

This is just something that I've had for a while.
It isn't exactly what you need, but I hope it helps.
I think you would need to do an "app.FileOpen" and
point to your template invoice.


' ***********************************
Dim app As Excel.Application
Dim wb As Excel.Workbook
Dim sht As Excel.Worksheet

Set app = CreateObject("Excel.Application")
app.Visible = True
Set wb = app.Workbooks.Add
Set sht = wb.ActiveSheet

sht.Cells(3, 1) = Me.txtSomeField
' ***********************************

Experiment with it. I hope it gets you started.
Wayne