Roger - how do you get the pictures into the program? I have tried it using the “insert object” but that makes the file very big and access only allows one to use 2 gigs. Are the pictures stored elsewhere on your harddrive? Someone once gave me some code that I could use to them import the picture into my forms but I could not work out where to put the code, what I know about computers is dangerous. Any help appreciated![/quote]
Nothing special needed to create the form fields. You need to create an OLE Object for each view in your table design. Then you need to create a picture box for each view in your from and connect to the table fields that you just created. I just called mine; top, bottom, side1, side2, end1, end2. I originally just used the top and end but we all know that they have many different bottom. If the sides are the same I just use one side image and same for the ends. So Side2 and End2 are not normally used unless there is a difference.
After you have your table and form updated you need a way to acquire the images. I use PhotoShop but I think that PhotoShop Elements will do the same things that are required. with both Access and PS open (I use two monitors but not necessary) I scan the box sides into PS, trim, straighten and adjust whatever is needed, then (here’s the REAL SECRET), just grab the image in PS with the MOVE TOOL and drag it into the appropriate box on you form and let go of the mouse button. PRESTO! the picture is there in Access. There may be other image software that will let you scan into and do this. I have PhotoShop so that’s what I use.
Here was the tricky part, the Search Engine. It took me most of a year to get this to work. You can select any and all criteria from the top Search Criteria boxes, then click on the FIND symbol (the upside-down funnel) and it will search though your entire database and show the matching results. You then have the option to click the “FIND RECORD” button on the right and it will show your the Entry record that is the thread above. Really slick and saves mucho time when you looking up a box that you are thinking about purchasing but want to make sure that you don’t already have it. This has saved me hundreds of dollars and makes the whole shebang work at a show. I too use to print out a hard copy to take to shows but that in itself was expensive.
I looked at the netbooks but don’t think that they have the oomph to run this nor the desktop to display it without constant scanning back and for and up and down. I carry a lightweight 15" widescreen laptop. There is a little Toshiba laptop that weighs about 2 pounds that I hope Santa will consider dropping down my chimney. My HP starts out at 5 pounds at the beginning of a show but quickly triples in weight by the end of the show. Particularly if I’m lugging a couple dozen .22 boxes back home also:)