Image control source linked to text box as descibed by Allen Brown

C

Chris

I am using Access 2007. I just read and attempted to apply the solution by
Allen Browne for making the image control on a form display the image linked
to the database via a text box which has the path name. It did not display
the image. I do not know what I am doing wrong.

I created a table [Table1] with has a textbox [field1] which has a path and
filename of the image that I want to display. When I put the image control
onto the form that is bound to [Table1] , I cancel the wizard which selects
the image from my files. I set the image control source as on the form as
=[Table1]![Field1]. I know that the path is correct because I can set
[field1] textbox in the form to be a hypelink and it will take me to the
image. Unfortunately, the image box is still blank. On the picture property
for the image contol, it is still listed as (none). I don't know if this has
something to do with this. What have I missed?

Thank you,
Chris
 
A

Allen Browne

Is your form bound to Table1?

If so, set the Control Source to just the field name (omiting the table1.)
 
C

Chris

Allen,

Thank you for such a quick response. Yes, the form is bound to Table1. I
also took out the [table1] section so that the control source only has
=[field1] in the property. Unfortunately I still have a blank image control.
Do you have any other suggestions? Could it be something wrong with my
path? An example of one of my fields is #C:\Documents and Settings\Chris\My
Documents\5.8.05 008a.jpg.

Thank you,

Chris

Allen Browne said:
Is your form bound to Table1?

If so, set the Control Source to just the field name (omiting the table1.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Chris said:
I am using Access 2007. I just read and attempted to apply the solution by
Allen Browne for making the image control on a form display the image
linked
to the database via a text box which has the path name. It did not
display
the image. I do not know what I am doing wrong.

I created a table [Table1] with has a textbox [field1] which has a path
and
filename of the image that I want to display. When I put the image
control
onto the form that is bound to [Table1] , I cancel the wizard which
selects
the image from my files. I set the image control source as on the form as
=[Table1]![Field1]. I know that the path is correct because I can set
[field1] textbox in the form to be a hypelink and it will take me to the
image. Unfortunately, the image box is still blank. On the picture
property
for the image contol, it is still listed as (none). I don't know if this
has
something to do with this. What have I missed?

Thank you,
Chris
 
A

Allen Browne

What's the # at the beginning of that file name? Does it work without that?

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.
Chris said:
Allen,

Thank you for such a quick response. Yes, the form is bound to Table1. I
also took out the [table1] section so that the control source only has
=[field1] in the property. Unfortunately I still have a blank image
control.
Do you have any other suggestions? Could it be something wrong with my
path? An example of one of my fields is #C:\Documents and
Settings\Chris\My
Documents\5.8.05 008a.jpg.

Thank you,

Chris

Allen Browne said:
Is your form bound to Table1?

If so, set the Control Source to just the field name (omiting the
table1.)

Chris said:
I am using Access 2007. I just read and attempted to apply the solution
by
Allen Browne for making the image control on a form display the image
linked
to the database via a text box which has the path name. It did not
display
the image. I do not know what I am doing wrong.

I created a table [Table1] with has a textbox [field1] which has a path
and
filename of the image that I want to display. When I put the image
control
onto the form that is bound to [Table1] , I cancel the wizard which
selects
the image from my files. I set the image control source as on the form
as
=[Table1]![Field1]. I know that the path is correct because I can set
[field1] textbox in the form to be a hypelink and it will take me to
the
image. Unfortunately, the image box is still blank. On the picture
property
for the image contol, it is still listed as (none). I don't know if
this
has
something to do with this. What have I missed?

Thank you,
Chris
 
C

Chris

Allen,

I found out that Access automatically added the # when I attempted to add a
path in the form instead of the table. There are no problems if I add the
path in the table.

I deleted the # and it now works. It is odd, this morning when I attempted
to erase the #, this did not fix the problem. The only thing different
between the two trials is that I had turned off my computer between trials.
I had even tried to compact and repair the database this AM but this did not
fix the problem.

I appreciate your help in problem solving this issue. I have been wanting
to have this functionality for quite some time but I did not know how to do
it.

Thank you for your help,
Chris

Allen Browne said:
What's the # at the beginning of that file name? Does it work without that?

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.
Chris said:
Allen,

Thank you for such a quick response. Yes, the form is bound to Table1. I
also took out the [table1] section so that the control source only has
=[field1] in the property. Unfortunately I still have a blank image
control.
Do you have any other suggestions? Could it be something wrong with my
path? An example of one of my fields is #C:\Documents and
Settings\Chris\My
Documents\5.8.05 008a.jpg.

Thank you,

Chris

Allen Browne said:
Is your form bound to Table1?

If so, set the Control Source to just the field name (omiting the
table1.)

I am using Access 2007. I just read and attempted to apply the solution
by
Allen Browne for making the image control on a form display the image
linked
to the database via a text box which has the path name. It did not
display
the image. I do not know what I am doing wrong.

I created a table [Table1] with has a textbox [field1] which has a path
and
filename of the image that I want to display. When I put the image
control
onto the form that is bound to [Table1] , I cancel the wizard which
selects
the image from my files. I set the image control source as on the form
as
=[Table1]![Field1]. I know that the path is correct because I can set
[field1] textbox in the form to be a hypelink and it will take me to
the
image. Unfortunately, the image box is still blank. On the picture
property
for the image contol, it is still listed as (none). I don't know if
this
has
something to do with this. What have I missed?

Thank you,
Chris
 
A

Allen Browne

Sounds like you used a field of type Hyperlink instead of Text, or you used
the InsertHyperlink dialog to add the path.

Good to know it's now solved.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.
Chris said:
Allen,

I found out that Access automatically added the # when I attempted to add
a
path in the form instead of the table. There are no problems if I add the
path in the table.

I deleted the # and it now works. It is odd, this morning when I attempted
to erase the #, this did not fix the problem. The only thing different
between the two trials is that I had turned off my computer between
trials.
I had even tried to compact and repair the database this AM but this did
not
fix the problem.

I appreciate your help in problem solving this issue. I have been wanting
to have this functionality for quite some time but I did not know how to
do
it.

Thank you for your help,
Chris

Allen Browne said:
What's the # at the beginning of that file name? Does it work without
that?

Chris said:
Allen,

Thank you for such a quick response. Yes, the form is bound to Table1.
I
also took out the [table1] section so that the control source only has
=[field1] in the property. Unfortunately I still have a blank image
control.
Do you have any other suggestions? Could it be something wrong with my
path? An example of one of my fields is #C:\Documents and
Settings\Chris\My
Documents\5.8.05 008a.jpg.

Thank you,

Chris

:

Is your form bound to Table1?

If so, set the Control Source to just the field name (omiting the
table1.)

I am using Access 2007. I just read and attempted to apply the
solution
by
Allen Browne for making the image control on a form display the
image
linked
to the database via a text box which has the path name. It did not
display
the image. I do not know what I am doing wrong.

I created a table [Table1] with has a textbox [field1] which has a
path
and
filename of the image that I want to display. When I put the image
control
onto the form that is bound to [Table1] , I cancel the wizard which
selects
the image from my files. I set the image control source as on the
form
as
=[Table1]![Field1]. I know that the path is correct because I can
set
[field1] textbox in the form to be a hypelink and it will take me to
the
image. Unfortunately, the image box is still blank. On the picture
property
for the image contol, it is still listed as (none). I don't know if
this
has
something to do with this. What have I missed?
 

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