Image in Report

[flavi]

Hello. I have a database for creating customer quotes for our products. I have 6 inside sales reps. I have a different report for each inside sales rep. For example, rptREBATEkbr is for 1 user, rptREBATEkws is for another user. Is there a way to open a report according to the user? For example, all records that are for user kbr opens the rptREBATEkbr and for user kws, all records open the rptREBATEkws? The reason for this is that I have the signature for the corresponding rep.

The other option was to embed the image into the report that when the user selects the report rptREBATE, selects their initials in a combo-box and the form embeds the respective signature from a file location.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me![Imageframe].Picture = Me![Imagepath]
End Sub

If I use this second option, I can use the above code to pull the image, but how do I change the image based on the user. The table I used for this has the fields

fldISRID
fldISRinitials
fldISRfullname
Imagepath

If I use the second option, any suggestions on how I can choose the image for the selected user? I appreciate any help. Thanks.

Brad (using access2003)

 

[The_Doc_Man]

The easiest way to do this is to first assure that each user must log in. You can capture the information about who logged in using CurrentUser() - and there are other functions that also will do this. Search the forum for "Login ID" as a topic.

Once you have the user's ID, you can do a DLookup of a table that contains the expected UserID and the values you want to associate with that ID. Then feed those values to the places that need them once you have done the lookup.