Optimizing form with scanner images

[munger]

I took the Employees form from the Northwind sample data base and am trying to use it to make a data base for labels for wine bottles. I scan the labels and am trying to insert them in the picture part of the Employees form. Maybe because wine labels are complicated images or maybe because I don't know all the possibilities available to me - anyway I need help.

Is there anyone with experience in this area? What settings should I be using and what tools?

Thanks.

munger

 

[hwkranger]

this is actually fairly easy

i answered a similiar post such as this, but it was for a kids hw assignment and it was deleted; dumb kids!

I'm assuming you want the following:

when you pull up a record, there is a picture of the lable that goes to the name of that record. eg..

Night Train - (nice picture of the lable) - other info - etc..

(hahah.. night train )


have a field that you put the NAME of the file that is associated with the Name of your wine.

eg.

name fileName
Night train nighttrainlable.gif

then, on your form you'll have a PICTURE BOX. assume your picture box is named picbxWineLable.

you'll put the following in your on current, on load, and on update subs.

dim path as string
path = "PUT THE PATH TO THE FILES HERE"
pixbxWineLable.picture = path & fileName



this should work for you

although I'm not 100% familiar with the sample database, i don't have it here at work - nor did I take time to look at it, I do believe that is the solution to your problem.

P.S. Don't forget Night Train haha...
Cruz'n and Booz'n always.
This post shows what little I do at work.