Re: Okay--another idea about linking
From: MacDermott (macdermott_at_NoSpam.com)
Date: 01/07/05
- Next message: Fie: "Last Modification Date on a field"
- Previous message: Albert D. Kallal: "Re: Execute DIR via shell and get results back into a table ?"
- In reply to: Scott: "Okay--another idea about linking"
- Next in thread: Albert D. Kallal: "Re: Okay--another idea about linking"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 7 Jan 2005 06:16:26 -0500
Interesting -
The other post I saw on this topic (very similar) came from a different
poster, and was in a different forum.
If you're multi-posting - posting the same question in separate posts to
different forums - please don't! People in one forum don't know what people
in others are saying. Instead, put all of your newsgroups in the To: (or
Newsgroups:) line of your post. That way the post and all responses go to
all the newsgroups, and anybody looking at the thread sees all of it.
Now, as to your question:
It's not too hard to display an image as you describe:
Put an Image Control on your form.
Whenever you want to display the image for that record (typically in the
form's Current event, or when the path is changed), reset the control's
Picture property.
But your previous post (if it really was yours) suggests that you
already know that, and that the real problem is that you want to display a
different image for each record in a continuous form.
The only way you can display different data for each record in a
continuous form is to have that data bound to an underlying table. As I
think you also indicated, you know that storing images directly in the
database causes a lot of bloat.
One work-around I've seen is to use an alternative design, which puts the
image control in the form header or footer. It displays the picture for
whichever record is selected.
I think I've also heard of 3rd-party controls which could display multiple
images as you request.
(If a Google search doesn't find one, post back and I'll see what I can
dig up.)
Or you could use a report instead of a form...
HTH
"Scott" <Scott@discussions.microsoft.com> wrote in message
news:997998AB-ECF5-422C-9382-EA663BE35C71@microsoft.com...
> Hm. If anyone knows the solution to the situation I posed earlier, please
let
> me know. But here's another workaround that would work (I think).
>
> I have 250 entries, each has a matching picture named primarykey.jpg, (not
> that all pictures are actually called primarykey, but that the name of
each
> graphic is just the primary key) which I want to link to rather than
embed,
> because that makes it huge.
> I have an entry called 50-00104. I want to make a form button I can click
on
> that will automatically load the picture in the associated graphics
program
> on the computer. This entry's picture is located at
> C:\2004picture\50-00104.jpg . (and the database is in C:\ ) Is that
doable?
>
> Thanks
> Scott
- Next message: Fie: "Last Modification Date on a field"
- Previous message: Albert D. Kallal: "Re: Execute DIR via shell and get results back into a table ?"
- In reply to: Scott: "Okay--another idea about linking"
- Next in thread: Albert D. Kallal: "Re: Okay--another idea about linking"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
