database with pictures for baseball card collection

[moise57]

How do I set up a database with pictures for my baseball card collection?
Thank you for your response.
(e-mail address removed)

 

[Olduke]

How do I set up a database with pictures for my baseball card collection?
Thank you for your response.
(e-mail address removed)

First, scan the cards and keep the images in a separate folder. Access
works best if you save them as a .gif.

Create a table which has the fields you want. Example:
PlayerName - text
Season - text
Team - text
etc.
Your last field should be ScannedImage as an OLE Object.

Enter the data into the fields. When you come to ScannedImage, double click
the field. This should start the wizard.
You want to LINK the images from the separate folder. You can Embed them
but this increases the size of your database geometrically with the resulting
loss of speed.

 

[Olduke]

First, scan the cards and keep the images in a separate folder. Access
works best if you save them as a .gif.

Create a table which has the fields you want. Example:
PlayerName - text
Season - text
Team - text
etc.
Your last field should be ScannedImage as an OLE Object.

Enter the data into the fields. When you come to ScannedImage, double click
the field. This should start the wizard.
You want to LINK the images from the separate folder. You can Embed them
but this increases the size of your database geometrically with the resulting
loss of speed.

OOPS
Don't double click the OLE field, right click and select Insert

 

[Dale Fye]

I recommend against storing the image in an OLE field. This will rapidly
bloat your database. If you have very many cards, you could exceed the 2GB
database size very easily.

Instead, I would recommend that your last field be a text field, where you
store the filename of the image. Then, when you use your form, use the
Current event to set the Picture property of an image control to the filename
of your card.

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[strangersnor]

"use the Current event to set the Picture property of an image control to the
filename of your card. "

HUH?

 

[Dale Fye]

Assuming that the table contains a field CardFilename and that the form
contains a text field txt_CardFilename, then use the forms current event to
change the Picture property of the image control (imgBBCard). Once you set
the picture property of the image , the image will load.

Do something like:

Private Sub Form_Current:

me.imgBBCard.Picture = me.txt_CardFilename

endif

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.