Images

[Tim Mcmurray]

I have a database that holds client info. I want to have
an image that is 1198x900 associated with each client. I
want to add the pictures to a particular folder everytime
so that the new clients pictures will have a naming
scheme for their pictures. please Help!!!

 

[Arvin Meyer]

I have a database that holds client info. I want to have
an image that is 1198x900 associated with each client. I
want to add the pictures to a particular folder everytime
so that the new clients pictures will have a naming
scheme for their pictures. please Help!!!

Use the Primary Key for the client record as the file name for the image.
Use a default value in a separate field for the rest of the path to make it
easier to change, if necessary. The database can then supply you with a name
for each picture entered in the image folder. Unless the image is generated
by the system, you will have to manually enter the name. If you find a
scanning ActiveX control that works from within Access, you can have Access
generate the name and store the file automatically.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Tim Mcmurray]

Is this the only solution?

-----Original Message-----


Use the Primary Key for the client record as the file name for the image.
Use a default value in a separate field for the rest of the path to make it
easier to change, if necessary. The database can then supply you with a name
for each picture entered in the image folder. Unless the image is generated
by the system, you will have to manually enter the name. If you find a
scanning ActiveX control that works from within Access, you can have Access
generate the name and store the file automatically.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003


.

 

[Exponent]

There are many variations, mostly in the implementation details.

Arvin's response describes the general approach to what you asked; to give a more specific answer will
require more info from you.

For example:

What is the source of your images (e.g. file, scanner, digital camera, etc) ?
And how do you want to select/load images into the system ?

What kind of naming-scheme are you looking for ? Arvin's suggestion of using the primary key is usually
the best approach.

Are the images already at the resolution you require (1198x900) or do you need to resample them to these
dimensions ?

Other issues that may be relevant are:
The size, format and number of images.
Number of users, and how they will access the system (Access app, intranet/browser etc).

 

[Tim Mcmurray]

Ok the pictures are from a digital camera. The resolution
is to big but i can deal with that. The user has a form
with tabs. Currently I have 5 tabs with different info.
One will be for the picture of the client in the database.
As far as the resolution the pix are by default 1198 x
798.(size is not an issue though). I thought i could
concantenate the first and last name of the client for a
naming scheme. But if I have to use the primary key that
will be ok too. It needs to be as user-friendly as
possible.

-----Original Message-----


There are many variations, mostly in the implementation details.

Arvin's response describes the general approach to what

you asked; to give a more specific answer will

require more info from you.

For example:

What is the source of your images (e.g. file, scanner, digital camera, etc) ?
And how do you want to select/load images into the system ?

What kind of naming-scheme are you looking for ?

Arvin's suggestion of using the primary key is usually

the best approach.

Are the images already at the resolution you require

(1198x900) or do you need to resample them to these

dimensions ?

Other issues that may be relevant are:
The size, format and number of images.
Number of users, and how they will access the system

(Access app, intranet/browser etc).