Forms - Add pictures

[Jake Abella via AccessMonster.com]

i've design a payroll program and one of my tables - employees, need a
pictures for each employees. what should i do to save pictures to the
tables during runtime? what controls should i use? and what's the code?
thanks a lot for your help...

 

[Guest]

hi,
the control to use would be an immage control on the
form. you can use an immage control on a report too.
I do not advise that you save pic to your tables. this
causes file blote. instead you should put your employee
images in a special directory and then put the file path
to the image in your table. to change images on the form,
you change the image controls picture property to the new
file path. i use this with DLookup.
Imagecontrol1.picture = Dlookup("[filepath]", "emptable",
"[empID] = '"&[forms}![empform]![empID]&"'")
forgive. not sure about the dlookup syntax. it looks ok
but i'm quoting from memory.