Create Control for VBA using .Net

  • Thread starter Thread starter Michael Fitzpatrick
  • Start date Start date
M

Michael Fitzpatrick

I have an access 2000 database form and need an image control that will
display a PNG file. The PC's all run Windows 2000. The image control in
access 2000 does not support PNG so I tried to create a VB.Net project
control with only the image control in it. Unfortunately, I cannot load this
control into Access 2000, since it is a .NET control!

How can I create a windows control in .NET that I can use in VBA (or for
that matter, VB6).
 
Surely there is a third party ActiveX control out there which can display
PNG images on Access 2000

Regards - OHM

Michael said:
I have an access 2000 database form and need an image control that
will display a PNG file. The PC's all run Windows 2000. The image
control in access 2000 does not support PNG so I tried to create a
VB.Net project control with only the image control in it.
Unfortunately, I cannot load this control into Access 2000, since it
is a .NET control!

How can I create a windows control in .NET that I can use in VBA (or
for that matter, VB6).
Click to expand...

Regards - OHM# OneHandedMan{at}BTInternet{dot}com
 
* "Michael Fitzpatrick said:
I have an access 2000 database form and need an image control that will
display a PNG file. The PC's all run Windows 2000. The image control in
access 2000 does not support PNG so I tried to create a VB.Net project
control with only the image control in it. Unfortunately, I cannot load this
control into Access 2000, since it is a .NET control!
Click to expand...

..NET Windows Forms controls can (in general) not be used as ActiveX
controls. You will have to implement your control in VB Classic, C++,
....
 
There are some controls that I could use, but I wanted to learn some .NET
stuff. It is easy to learn when I have a project in mind, especially when I
can do it on company time ;-).

If I use VB6 I don't think I can get support for PNG. I have thought about
using the API StretchDIBits() to convert the PNG file to a buffer in JPG
format compatible to the image control in access 2000. Any suggestions on
this?
 
Cant say I have tried it I am afraid, but give it a go, what have u to lose
?

Regards - OHM

Michael said:
There are some controls that I could use, but I wanted to learn some
.NET stuff. It is easy to learn when I have a project in mind,
especially when I can do it on company time ;-).

If I use VB6 I don't think I can get support for PNG. I have thought
about using the API StretchDIBits() to convert the PNG file to a
buffer in JPG format compatible to the image control in access 2000.
Any suggestions on this?
Click to expand...

Regards - OHM# OneHandedMan{at}BTInternet{dot}com
 
Back
Top