Noob Macro question

[mattmickle]

I have a database I've built. In it, I have a report that displays all of the issued equipment for an individual, based on Inputting their last name. Is there a way to build a macro that would cycle through all of the names in my database and print this report for each?

 

[DanteAmor]

Adjust your data

Sub PrintTemplate()
    Set h1 = Sheets("database")
    Set h2 = Sheets("report")
    For i = 2 To h1.Range("A" & Rows.Count).End(xlUp).Row
        h2.Range("B5").Value = h1.Cells(i, "A").Value
        h2.PrintOut
    Next
    MsgBox "Finished printing"
End Sub

 

[welshgasman]

This is an Access forum?

 

[welshgasman]

I think that would need to be handled by VBA.?

This should get you started.

https://community.spiceworks.com/to...-create-pdf-report-for-each-item-in-the-table

 

[mattmickle]

there is a section (under which this post is) that is labeled "Microsoft Access".

 

[welshgasman]

there is a section (under which this post is) that is labeled "Microsoft Access".

Correct, however my post about it being an access forum was in response to Dante, who had given you some Excel VBA.

 

[DanteAmor]

I apologize, I was wrong forum.

 

[welshgasman]

It happens quite often. I wouldn't lose any sleep over it. :D