Bound Image Control problem

[Gilberto]

Hello

Ive been trying to find a way to reduce database size (image related) and the only solution ive found (http://support.microsoft.com/default.aspx?scid=kb;en-us;285820) only deals with continuous forms in order to create some kind of "image catalog".

What im trying to find is a way to display the SWITCHBOARD FORM "background picture", which would be the same for ALL records, hoping i can reduce .mdb size (already ALL the pics are only LINKED).

Im good with access but ive been learning fast i just cant figure out the code to use so that i can indicate WHICH exact image"path" to set as the property for image control.

So far im using:

Private Sub Form_Load()
 On Error Resume Next
    Me![Image].Picture = Me![txtImageName]
 
End Sub

but i need to display ONLY ONE picture and with this code the picture changes to display the records (image paths) i have in the tblImage.

Any ideas,
Gilberto

[MMcCarthy]

Hello

Ive been trying to find a way to reduce database size (image related) and the only solution ive found (http://support.microsoft.com/default.aspx?scid=kb;en-us;285820) only deals with continuous forms in order to create some kind of "image catalog".

What im trying to find is a way to display the SWITCHBOARD FORM "background picture", which would be the same for ALL records, hoping i can reduce .mdb size (already ALL the pics are only LINKED).

Im good with access but ive been learning fast i just cant figure out the code to use so that i can indicate WHICH exact image"path" to set as the property for image control.

So far im using:

Private Sub Form_Load()
 On Error Resume Next
    Me![Image].Picture = Me![txtImageName]
 
End Sub

but i need to display ONLY ONE picture and with this code the picture changes to display the records (image paths) i have in the tblImage.

Any ideas,
Gilberto

What is the data type of the txtImageName field?

[Gilberto]

What is the data type of the txtImageName field?

Its TEXT, and contains the image files paths.

[MMcCarthy]

Its TEXT, and contains the image files paths.

OK I would advise changing the datatype to an OLE object and link the files.

[Gilberto]

OK I would advise changing the datatype to an OLE object and link the files.

Thanks ive done so and the size decreased around 15mb.

Thanks a lot!!!

[MMcCarthy]

Thanks ive done so and the size decreased around 15mb.

Thanks a lot!!!

You're welcome.