Any way to have a photo box without written code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hot said:
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
Click to expand...

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 said:
growl ...ok more experimentation required
Click to expand...

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.
 
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.
 
Hot said:
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.
Click to expand...

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?
 
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.
 
Hot said:
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.
Click to expand...

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
 
Back
Top