Check Cashing Database

[biggierob]

Program: Access 2003
I am creating a database for my check cashing company. The database is relatively straightforward, contains customer info, transaction history, a check scan and a photo of the customer. The problems i am having are: I want to take the picture with the web cam, can I link the webcam stream as an OLE Object? Can I use the check scanner to embed the image directly to the database? and Finally how to I create a field that when I query a customer by SSN how can I add the second transaction and so on. Any help would be appreciated. Thanks

 

[ecniv]

I am creating a database for my check cashing company. The database is relatively straightforward, contains customer info, transaction history, a check scan and a photo of the customer. The problems i am having are: I want to take the picture with the web cam, can I link the webcam stream as an OLE Object?

Use a scanner for the cheques image. Better than a web cam (unless you have the webcam on a brace pointing at a selected area where the cheque rests?).

vbforums in the database section there is a sticky thread with a tutorial on putting picture/files into databases including Access, should you want to.

I would have a shared area for pictures, not sure exactly how to organise, folders by :
year/month/date/ unique record id number.tif (whichever format)
customerID/ unique record id number.tif

Then you just need to store a link in the db, or if the picture is compulsory then you just grab the records ID and retrieve the pic... perhaps?

Can I use the check scanner to embed the image directly to the database?

As to getting the pic into the db, you'd need to pick a scanner/webcam and go to the manufacturers to see if they have some dlls/documentation on using the sacnner/webcam that you can call from Access. Best to get via them and see if there are licensing issues etc.

and Finally how to I create a field that when I query a customer by SSN how can I add the second transaction and so on...

Table of customers
CustomerID - auto - pk
other fields of details

Table of customerTransactions
CustTransID - auto - pk
CustomerID - number - long
Other transaction fields

 

[The Berry]

<I want to take the picture with the web cam, can I link the webcam stream as an OLE Object?>

I, too, am writing a database. It is for daycare centers and they want to store pictures of the children for identification. They want to be able to grab the pictures from a web cam using a mouse click when they can get the little darlings standing still. I have tried running their capture software in both bound and unbound frames, and a directX control they sent with the camera. The control just sits there and says "Connecting" but never connects. I am very interested in this thread! I know it has been done, my boss saw it (possibly in VB) in Jamaka sp? of all places. Has anyone here done it?

I will keep watching.