Pls point me to method to add jpg images to a form

W

Wayne

Please, point me to method needed to add photos to a form.

I already have a column (field/record) with links to a file of photos.

Added a bound object frame to form.
Msg: appears noting problem with OLE Server (??) :) or Active X Control.
Close Server.
What is this about? What am I to close?

Please advise. (Using XP and Access 2002.)
Thank You!
Wayne
 
D

Dirk Goldgar

Wayne said:
Please, point me to method needed to add photos to a form.

I already have a column (field/record) with links to a file of photos.

Added a bound object frame to form.
Msg: appears noting problem with OLE Server (??) :) or Active X
Control. Close Server.
What is this about? What am I to close?

Please advise. (Using XP and Access 2002.)
Thank You!
Wayne
Click to expand...

The easiest way is to use an unbound Image control, not an object frame,
and set its Picture property at run time to the path to the picture you
want to display.
 
W

Wayne

Arvin:

Upon dwnld'g, unzipping, your file comes up with a msg, etc. about Read-Only
followed by your msg. I click OK. System does not permit going further;
had to use Task Mngr to get out of loop. Clearly I did something wrong.
BASIC 101 Question: How do I open the file?? (Using Access 2000 here.
Maybe a comp problem w/'97 version?)

Best Regards,
Wayne
 
W

Wayne

Wayne said:
Arvin:

Upon dwnld'g, unzipping, your file comes up with a msg, etc. about
Read-Only followed by your msg. I click OK. System does not permit going
further; had to use Task Mngr to get out of loop. Clearly I did
something wrong. BASIC 101 Question: How do I open the file?? (Using
Access 2000 here. Maybe a comp problem w/'97 version?)

Best Regards,
Wayne
Click to expand...
 
D

Dirk Goldgar

Wayne said:
Arvin:

Upon dwnld'g, unzipping, your file comes up with a msg, etc. about
Read-Only followed by your msg. I click OK. System does not permit
going further; had to use Task Mngr to get out of loop. Clearly I
did something wrong. BASIC 101 Question: How do I open the file??
(Using Access 2000 here. Maybe a comp problem w/'97 version?)
Click to expand...

With the downloaded database closed, right-click it the file in Windows
explorer, open its Properties, and check its Read-only attribute. If
it's checked as read-only, uncheck it. Then see if it will work.

If you downloaded the file Arvin posted the link to, it's not really in
Access 97 format, even though it's startup form says it is. So you
shouldn't have any problem with version incompatibilities.
 
W

Wayne G. Dengel

Dick:

Thank You. I tried that. Attributes are 'grayed' out ~ also nothing, no
check mark in any one of them..

Wayne
 
D

Dirk Goldgar

Wayne G. Dengel said:
Dick:

Thank You. I tried that. Attributes are 'grayed' out ~ also
nothing, no check mark in any one of them..
Click to expand...

Then I don't know what's wrong. Can you quote the exact message you
get? I just downloaded and opened the fie with no problems. If I were
you, I'd try downloading it again.
 
W

Wayne G. Dengel

Sure.

Click on zip file - opens to Picture2k.mdb

Click on file to OPEN (call Access). Msg: "The database "Picture 2k" is
read only.
Click on "OK"
Then Arvin's screen appears.
...
....
....

"OK" window is at lower-right
Click on OK
Msg appears: "Cannot update. Database or object is read-only."
Click on OK (to continue)
Nothing happens.
Attempt to Close window. Cannot. Only way to close is to use the Task
Manager.

That is it.

Cannot open via Access since file is in ZIP format.

Thank you for your persistence!
Wayne
 
D

Dirk Goldgar

Wayne G. Dengel said:
Sure.

Click on zip file - opens to Picture2k.mdb

Click on file to OPEN (call Access). Msg: "The database "Picture
2k" is read only.
Click on "OK"
Then Arvin's screen appears.
...
....
....

"OK" window is at lower-right
Click on OK
Msg appears: "Cannot update. Database or object is read-only."
Click on OK (to continue)
Nothing happens.
Attempt to Close window. Cannot. Only way to close is to use the Task
Manager.

That is it.

Cannot open via Access since file is in ZIP format.
Click to expand...

Hmm. It sounds to me like you never actually extracted the .mdb file
from the .zip file. Are you just looking at this in one of Windows XP's
"zip folders" or something of that sort? If that's the case, I don't
remember exactly how zip folders work, because I'm running Windows 2000,
but try either (a) dragging the .mdb file out of the zip folder and
dropping it in another, normal folder, or (b) right-clicking on the zip
file and choosing some menu item that implies it will extract the files
in the folder. Then open the extracted file.
 
W

Wayne G. Dengel

Dirk:

I dragged the extracted file to the Desktop - easy place to dump it. "It"
then opened properly!
A lesson learned at this end . . . . I hope!

Thank You

Wayne
 
Top