Any way to have a photo box without written code

[Hot Diggety]

If I need a blank photo box in my database, can I do this in access without
writing code. Photos wil be stored in a seperate folder not in the database

 

[Rick Brandt]

If I need a blank photo box in my database, can I do this in access
without writing code. Photos wil be stored in a seperate folder not
in the database

With exactly one line of code yes. With *no* lines of code no.

With an image control and a field in the table that the form is bound to that
contains the path to the picture file you would have code in the Current event
of the form similar to...

Me.ImageControlName.Picture = Me.PathFieldName

 

[Hot Diggety]

growl ...ok more experimentation required

 

[Rick Brandt]

growl ...ok more experimentation required

It's not that bad..really.

I tested what I suggested to make sure I was remembering correctly and it took
maybe 1 minute to set up.

 

[Hot Diggety]

These books are terrible that come with 2000 developer. I'll keep trying.
Built the database in no time ..2 days trying get that box where you can
click on it and select a photo.

 

[Rick Brandt]

These books are terrible that come with 2000 developer. I'll keep
trying. Built the database in no time ..2 days trying get that box
where you can click on it and select a photo.

Okay now, your original post did not say anything about "clicking on the box and
selecting a photo". My response assumed that the database would hold data
giving the path to the file and the "box" only needed to display the picture.

What exactly is it that you need?

 

[Hot Diggety]

I want to have a blank photo box in the database, as i will be using the
database on a computer that does not have access. As the data is entered the
photo can then be added.

 

[Rick Brandt]

I want to have a blank photo box in the database, as i will be using
the database on a computer that does not have access. As the data is
entered the photo can then be added.

If the PC will not have Access installed were you planning on using the runtime
distribution? An Access file cannot be run on a PC without Access installed.

Essentially your table needs to store the path to the file you want displayed.
The path can get into the the table by any means you like. To allow the user to
"browse" to the file so that they don't have to enter the path manually will
require more code and that code will have to make use of a fairly advanced
Windows API call. Example of this code can be found at the link below...

http://www.mvps.org/access/api/api0001.htm

 

[Hot Diggety]

Ok I guess i need a template for this. Looked at many ..but they do not fit
my needs

 

[Lynn Trapp]

Take a look at the Northwind database. It has a pretty good example in the
Employee form.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Hot Diggety]

Where would i find that template?