Setup Linked Photos in Database 1

[3063]

Help!! I am trying to setup an employee database that has pictures of employees and information about them, similar to the Northwind Database. I have looked at the Northwind Database and cannot figure out how the code for the pictures work. I would like to set it using a table and have a field for the photo and have it linked instead of embedded. Then create a form using the table and have the pictures and information displayed utilizing info from the table. If anyone can help me, it would be greatly appreciated. I've been trying struggling to figure it out. I need something thats simple.

 

[ssatech]

Try this link - I think its what your looking for....

http://www.rogersaccesslibrary.com/download3.asp?SampleName=PicturesLoad.mdb

 

[3063]

Thank you that was very helpful. Do you know if there is a way to show it in a continous form, where all records will show up in the form?

 

[TheAceMan1]

How are ya 3063 . . .

Sorry! . . . [blue]no can do in continuous view[/blue]. Your stuck with [blue]OLE linked[/blue] . . .

See Ya! . . . . . .

 

[3063]

Okay...If it will only work with a single form, is there a way to setup a command button on the last record of that form? I don't want it to show up until all the records are viewed first. This would solve my problem.

 

[MajP]

command button name "cmdPicture"

Private Sub Form_Current()
  If Me.NewRecord Then
    Me.cmdPicture.Visible = True
  Else
    Me.cmdPicture.Visible = False
  End If
End Sub

To ensure that the user views all records and does not skip to the end, you will have to remove the navigation buttons from the form and build your own navigation buttons forcing the user to start at the beginning and click through each record.

 

[sxschech]

If you are only showing records rather than editing records, you could create a report and display it in preview mode to simulate what a continuous form would display.