Scan a file and save to existing record in Access Database

by: alanwarrenPosted on 2003-12-10 at 03:20:45ID: 9911352

Hi jeffraven,

Create a new table called YourTable
Create a field in your table called oPic of type OLE Object and another field called ID of type autonumber.
Create a new AutoForm and using YourTable as the source.
Save the form then open it in design view.
Add a new command button called btnScan
View properties for btnScan
Give the command button an OnClick event [Event procedure]
Click the build button alongside the onclick event to open the code window looks like [...],
Paste this code into the code window for the btnScan on Click event

Private Sub btnScan_Click()
Me.oPic.SetFocus
Me.oPic.Action = acOLEInsertObjDlg
End Sub

When you click the button the Insert Object Dialog will appear, choose Microsoft Photo Ed Scan from the list.

Alan :)

by: jeffravenPosted on 2003-12-10 at 04:30:59ID: 9911677

blimey that what quick...

have tested your solution and all works fine.................
I shall award you your points

thanks kindly

Jeff

by: alanwarrenPosted on 2003-12-10 at 15:11:45ID: 9916746

Glad you got it happening Jeff, good one!

Alan :)

by: jadedataPosted on 2004-02-04 at 08:06:35ID: 10271996

No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: alanwarren {http:#9911352}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jadedata
EE Cleanup Volunteer

by: jeffravenPosted on 2004-02-04 at 08:12:46ID: 10272047

unfortunately although it appeared that the solution from alanwarren was successful, it turned out to be the contrary.

I have now resolved the issue by outsourcing to a contractor

by: jadedataPosted on 2004-02-04 at 10:27:31ID: 10273439

unforturnately you claimed it worked and failed to return to recant the claim.
I am certain that if you had returned to continue alanwarren would have ably and readily assisted you.

I get the action that alanwarren states would occur.

by: jeffravenPosted on 2004-02-05 at 01:08:39ID: 10278881

unfortunately time was against me, and the contractor issue just came along by chance, so i took it. Indeed if I had of had more time then I would have cotinued with alanwarren and no doubt inevitably came up with the solution as is normally the case with the site

jeff

by: alanwarrenPosted on 2004-02-05 at 02:09:59ID: 10279174

Hi jeff,

yeah, there is no way to address the acOLEInsertObjDlg dialogue programatically, except to invoke it, bummer.

Do a lot of scanning stuff here,
I get the scanners to save to wherever is their default save location. I give the users of the access app a browse for scanned files form that prompts for location, the location is preserved in windows registry, so my attach scanned files dialogue always opens at previous selected dir. Then I invoke a sub to do a binary read on the files that the user selects in the dir so I can append them as Binary Long Objects in tables in the connected data source.

I find this to be the most efficient method of managing large amounts of raw binary data.

If you are interested I have a page on Using BLOB's with microsoft access here: www.cashoz.com/samples/blobs.asp
http://www.cashoz.com/samples/blobs.asp
The sample download is fairly basic, I have since modulised this functionality.
The code I originally posted here served me well for a number of years, but as the business grew so did the need for further automation, I guess it all depends on the gettin on point.
I'm currently looking for a solution to read a binary stream from a table field and displaying it on a web-page without writing it to disk. hmmm. Any ideas how to achieve this would be welcomed. Apparently dotnet can do it, no problem, huh.

Jack,

sorry I didn't get back to you this mornin, I've had my head in the sand for a couple of days, deployment woes and glitches, ya know, everything is super urgent mode, after you've been bullied into deploying (ready or not)

Alan warren

by: jadedataPosted on 2004-02-05 at 05:45:50ID: 10280295

alan: been there...

by: jadedataPosted on 2004-02-05 at 05:47:57ID: 10280311

A Moderator will be by later to make the final call on the question.

by: jeffravenPosted on 2004-02-11 at 14:57:28ID: 10337190

i appreciate your fairness in this matter.

Like I said, if I had had more time, I would have pursued wth alan and no doubt would have came up with a workable solution....

thanks

Question

Scan a file and save to existing record in Access Database

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

Microsoft Access Database

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Need individual assistance?

Our experts are ready to help.

Want to learn from the best?

Read articles from industry experts.

Working on a long term project?

Store your work and research.

What Makes Experts Exchange Unique?

Trusted by the world's most respected brands.

Faithfully serving IT professionals since 1996.

Related Solutions

Free Tech Articles

Cloud Class Webinars

Join the Community

Give a Little. Get a Lot.

Answers

3 Ways to Join

The Experts

The Experts

Testimonials

Testimonials

Testimonials

Business Clients

Business Clients

In the Press

In the Press

In the Press