How to see a picture in reports and Forms

[Tamer Sabry]

Hi,

I am making a real estate database for my company. I am new to access. I
made a picture field and I want to have different pictures for every record.
My problem is no matter if I have an OLE filed or not I cannot see my
picture in the form and report views. My other dilemma is that I want to
create ASP code to connect the database and pull up the information from the
web. So my questions are:

1- What type of field should the picture field be?? (OLE, Text or what)

2- How do I make this picture appear in the report and Form views? I would
prefer if they were file locations because then, the database is small in
size.

3- Last, how do I make this appear on the web?

I am actually wiling to pay a developer to give me a code and a working
access template if they have.

[Jim Allensworth]

On Mon, 02 Feb 2004 18:27:49 GMT, "Tamer Sabry" <ta****@cretool.com>
wrote:

Hi,

I am making a real estate database for my company. I am new to access. I
made a picture field and I want to have different pictures for every record.
My problem is no matter if I have an OLE filed or not I cannot see my
picture in the form and report views. My other dilemma is that I want to
create ASP code to connect the database and pull up the information from the
web. So my questions are:

1- What type of field should the picture field be?? (OLE, Text or what)

2- How do I make this picture appear in the report and Form views? I would
prefer if they were file locations because then, the database is small in
size.

3- Last, how do I make this appear on the web?

I am actually wiling to pay a developer to give me a code and a working
access template if they have.

Generally speaking, don't store images in your DB. There is a huge
overhead for each image that you store - your db will bloat quickly.

The best approach is to keep them in their own directory and store the
path to them in your db.

For more on that see...

http://www.mvps.org/access/forms/frm0030.htm

To get this on the web you will need a separate application - ASP or
somthing else. This will most likely involve VBScript, ADO, HTML and
probably some Javascript.

Still you wouldn't store them in the db use a different directory.
A testing site I have developed that uses stored images is at...

http://www.traderann.com/
- Jim