E
EAL via AccessMonster.com
I asked this question on the Usenet forum, and a very helpful fellow provided
me with an answer that he guessed would be fairly labor intensive. I'm hoping
perhaps there is a simpler solution, and also, I am not sure that I explained
very well what I was trying to accomplish. Will be excruciatingly detailed
here:
1) I have a series of horse sculptures in an Access database table called
Master. It stores text data:
Horse_ID (Autonumber) | Name
126 Arabian
2) I have a related table called Photos, which contains data like this:
Horse_ID | Secondary_ID (Autonumber) | Navigation (Checkbox)
126 527 Yes
3) I built a Query which adds the full path to the "Photo Name," so that for
each photo the complete path can be displayed. E.g., "c:\mysculptures\126\527.
jpg."
4) I built a Form which displays all of the text info from "Master." I would
like to be able to navigate the text information from the Master table on
this form, by selecting from images that have the "Navigation" checkbox
checked in the Photos table. Something like this:
http://www.mink-studios.com/sample_form.jpg
The left side of the form would be the navigation area, the right side the
text from Master table. When I click one of the images on the left side, I
want the text information for that sculpture to appear on the right side. If
it helps to know why I'm handling it this way - there is no better way to
identify the sculptures than through a visual. Just seeing "126" or "Arabian"
on the form won't be enough to help me identify the sculpt.
I've found a lot of scripts which permit me to display one image at a time
based on the image's path. But when I run the scripts and set the form's
Default View to "Continuous," I see one picture, repeated over and over. The
only way that I can see another photo is to move the focus to that photo's
section of the form. I want to see all of my "Navigation" photos at once.
The only way that I can seem to make this work is to store the images as OLE
objects, which I do not want to do because I cannot then have the database
name the images for me... which the Autonumber function is doing very nicely.
Can someone please help this Access novice accomplish this task? I am only
minimally functional in VB, but I'm enthusiastic about learning.
Thanks so much for any help you can provide!
me with an answer that he guessed would be fairly labor intensive. I'm hoping
perhaps there is a simpler solution, and also, I am not sure that I explained
very well what I was trying to accomplish. Will be excruciatingly detailed
here:
1) I have a series of horse sculptures in an Access database table called
Master. It stores text data:
Horse_ID (Autonumber) | Name
126 Arabian
2) I have a related table called Photos, which contains data like this:
Horse_ID | Secondary_ID (Autonumber) | Navigation (Checkbox)
126 527 Yes
3) I built a Query which adds the full path to the "Photo Name," so that for
each photo the complete path can be displayed. E.g., "c:\mysculptures\126\527.
jpg."
4) I built a Form which displays all of the text info from "Master." I would
like to be able to navigate the text information from the Master table on
this form, by selecting from images that have the "Navigation" checkbox
checked in the Photos table. Something like this:
http://www.mink-studios.com/sample_form.jpg
The left side of the form would be the navigation area, the right side the
text from Master table. When I click one of the images on the left side, I
want the text information for that sculpture to appear on the right side. If
it helps to know why I'm handling it this way - there is no better way to
identify the sculptures than through a visual. Just seeing "126" or "Arabian"
on the form won't be enough to help me identify the sculpt.
I've found a lot of scripts which permit me to display one image at a time
based on the image's path. But when I run the scripts and set the form's
Default View to "Continuous," I see one picture, repeated over and over. The
only way that I can see another photo is to move the focus to that photo's
section of the form. I want to see all of my "Navigation" photos at once.
The only way that I can seem to make this work is to store the images as OLE
objects, which I do not want to do because I cannot then have the database
name the images for me... which the Autonumber function is doing very nicely.
Can someone please help this Access novice accomplish this task? I am only
minimally functional in VB, but I'm enthusiastic about learning.
Thanks so much for any help you can provide!