| Author |
Pictures with Access
|
|
| Robert 2005-02-23, 8:55 pm |
| I am using VB6.0 SP5
I am trying to use the OLE Control.
I need to save the selected Picture (by user) to
an Access 2000 Table.
I have a table called Pics.
A field called Pic, defined as OLE Type.
How/where to find good samples on the OLE Control.
--
Thanks in advance
Robert
robert11@nas.net
| |
| JP Bless 2005-02-23, 8:55 pm |
| Not a good idea to store pictures in Access table. A good way is to store
the the pictures in a folder (maybe same folder as the Access file) and use
LoadPicture method to load the picture into VB picturebox. You can either
store the picture name and path in Access field... or name the pictures same
as the record's primary key.
When record is opened in VB... picX.picture = LoadPicture(Somepath &
PicureName)
"Robert" <robert11@nas.net> wrote in message
news:u9anjeeGFHA.2976@TK2MSFTNGP15.phx.gbl...
> I am using VB6.0 SP5
>
> I am trying to use the OLE Control.
>
> I need to save the selected Picture (by user) to
> an Access 2000 Table.
>
> I have a table called Pics.
> A field called Pic, defined as OLE Type.
>
> How/where to find good samples on the OLE Control.
>
> --
>
> Thanks in advance
> Robert
> robert11@nas.net
>
>
| |
| Robert 2005-02-23, 8:55 pm |
| That is true, however if one uses a Report Tool like Active Reports 1.0
this method does not allow for the Picture to be displayed.
It only works if the pictured is stored....
Have tried this method. No Good
Thanks anyway.
Robert
robert11@nas.net
"JP Bless" <jp3bless_NoSpam@hotmail.com> wrote in message
news:ON9TZHfGFHA.1456@TK2MSFTNGP09.phx.gbl...
> Not a good idea to store pictures in Access table. A good way is to store
> the the pictures in a folder (maybe same folder as the Access file) and
use
> LoadPicture method to load the picture into VB picturebox. You can either
> store the picture name and path in Access field... or name the pictures
same
> as the record's primary key.
>
> When record is opened in VB... picX.picture = LoadPicture(Somepath &
> PicureName)
>
>
> "Robert" <robert11@nas.net> wrote in message
> news:u9anjeeGFHA.2976@TK2MSFTNGP15.phx.gbl...
>
>
| |
| Paul Clement 2005-02-24, 8:55 pm |
| On Wed, 23 Feb 2005 17:07:11 -0500, "Robert" <robert11@nas.net> wrote:
¤ That is true, however if one uses a Report Tool like Active Reports 1.0
¤ this method does not allow for the Picture to be displayed.
¤
¤ It only works if the pictured is stored....
¤
¤ Have tried this method. No Good
¤
Can't you use the Image control in ActiveReports instead of the OLE Control?
Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)
|
|
|
|