Displaying Images on Forms

[Guest]

In the article "How to Display Images in a Form Without Storing the Images in
a Table" it is explained that you put the filename in a text box, add an
image control to the form, and then put a tiny bit of code in the OnCurrent &
After Update events:

Me![name of image control].Picture=Me![name of text field w/filename]

It works, or seems to. However, when I exit Access and then restart it, it
stops working!

I have found that it starts working again if I go into design view on the
form and reselect an image for the image control using the ... button.

I am not providing fully qualified filenames in the text field because the
images are in the same directory as the database (I had assumed the default
directory would be the current directory).

I am perplexed by this behavior - any thoughts???

 

[Rick Brandt]

In the article "How to Display Images in a Form Without Storing the Images in
a Table" it is explained that you put the filename in a text box, add an
image control to the form, and then put a tiny bit of code in the OnCurrent &
After Update events:

Me![name of image control].Picture=Me![name of text field w/filename]

It works, or seems to. However, when I exit Access and then restart it, it
stops working!

I have found that it starts working again if I go into design view on the
form and reselect an image for the image control using the ... button.

I am not providing fully qualified filenames in the text field because the
images are in the same directory as the database (I had assumed the default
directory would be the current directory).

I am perplexed by this behavior - any thoughts???

Your assumption is wrong. Include the full path.

 

[Stephen Lebans]

I'll guess that once you manually select an image to load into the Image
control, the current path remains the default path for any further
images you load into the Image control durring the current session.

Just make a small modification to your existing code to add the desired:

Me![name of image control].Picture="C:\TheFullPathToYourImages\" &
Me![name of text field w/filename]


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

Very cool! Thanks a bunch Stephen!

I'll guess that once you manually select an image to load into the Image
control, the current path remains the default path for any further
images you load into the Image control durring the current session.

Just make a small modification to your existing code to add the desired:

Me![name of image control].Picture="C:\TheFullPathToYourImages\" &
Me![name of text field w/filename]


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

In the article "How to Display Images in a Form Without Storing the Images in
a Table" it is explained that you put the filename in a text box, add an
image control to the form, and then put a tiny bit of code in the OnCurrent &
After Update events:

Me![name of image control].Picture=Me![name of text field w/filename]

It works, or seems to. However, when I exit Access and then restart it, it
stops working!

I have found that it starts working again if I go into design view on the
form and reselect an image for the image control using the ... button.

I am not providing fully qualified filenames in the text field because the
images are in the same directory as the database (I had assumed the default
directory would be the current directory).

I am perplexed by this behavior - any thoughts???

 

[Guest]

This solution works for the first form, but when you go to the next form the
images that you had in the first form carry over. Is there any way to stop
this? When I go to the next (new) form I would like to have a default image
that displays instead of the ones from the first form.

Thank you,
Short_sweet

I'll guess that once you manually select an image to load into the Image
control, the current path remains the default path for any further
images you load into the Image control durring the current session.

Just make a small modification to your existing code to add the desired:

Me![name of image control].Picture="C:\TheFullPathToYourImages\" &
Me![name of text field w/filename]


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

In the article "How to Display Images in a Form Without Storing the Images in
a Table" it is explained that you put the filename in a text box, add an
image control to the form, and then put a tiny bit of code in the OnCurrent &
After Update events:

Me![name of image control].Picture=Me![name of text field w/filename]

It works, or seems to. However, when I exit Access and then restart it, it
stops working!

I have found that it starts working again if I go into design view on the
form and reselect an image for the image control using the ... button.

I am not providing fully qualified filenames in the text field because the
images are in the same directory as the database (I had assumed the default
directory would be the current directory).

I am perplexed by this behavior - any thoughts???