How to add Patient's picture in the patient's form

[Norbert]

How to add the patient's picture in the form which has all
the patient's information. What is the most practical way
for the user to take the picture and store it in the file?

 

[GVaught]

In an Access database you are better off storing a link to the image file
rather than storing the picture inside Access. If you store images within
Access, you may find that your database will exceed the limits imposed to
the version of Access you are using. This also depends on how many patients
you have in your database.

 

[norbert]

Back end of is in SQL2000.
Total for now of patients: 10,000.
My question was regarding how do I insert the picture to
the form?

 

[Rick Brandt]

Back end of is in SQL2000.
Total for now of patients: 10,000.
My question was regarding how do I insert the picture to
the form?

Put all images in a single folder and name them according to the Primary Key for
your patients table. The use an image control on the form to display them. In
the OnCurrent event of the form, you'll need code to change the picture property
of the control to the path to the image folder and the correct file name.
Something like. . .

Me.ImageControlName.Picture = "PathToImageFolder" & "\" & Me.PrimaryKey & ".jpg"