creating a OLE-Object field

S

sb

Hi,

I'm would like to create a field that is a OLE-Object, but I don't have that
to choose from in the datatype-field. I need that sort of field to be able
to insert a picture to a certain post.
What shall I do?

/Staffan
 
V

Van T. Dinh

Actually, it is good that you didn't find it. Access is very inefficient in
storing graphic files.

The recommended method is to store the graphic file separately from Access
and simply store the path / file names (as Text Field) in Access.
 
S

sb

Hi,

But how do I do that? When I insert the path/file name, I only see the text,
not the picture.

/Staffan
 
V

Van T. Dinh

Use Image Control on the Form and set the Property "Picture" to the full
path-name to your picture file.
 
S

sb

Thanx for your help but I still have a stuid question.

I can't find Image control anywhere. Where is it?

/Staffan
 
V

Van T. Dinh

Open any Form in DesignView, make the ToolBox visible by clicking the
ToolBox icon (the icon with the hammer and spanner crossing) or the Menu
View / ToolBox.

The Image Control is the Icon with twin mountains & the sun in the ToolBox.
You can also hover the mouse pointer over each Control in the ToolBox and
the ToolTip will show the name of the Control.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top