MS Access experts please!!!!!!! (Full Version)

All Forums >> [Community] >> Computer Software and Hardware issues



Message

jaybee -> MS Access experts please!!!!!!! (9/21/2004 17:44:45)

How the *&9^% do I get a button on a page that does the following....

Click on it and it automatically scans in whatever is on your scanner as a B&W jpg, puts it on the page as a thumbnail and a hyperlink in the table.

This is driving me nuts.



Giomanach -> RE: MS Access experts please!!!!!!! (9/22/2004 3:32:07)

Via Code View....well, if you want to do it from within Access.

But to run an external program...how to get it into Access...will require advanced knowledge of VB (for Access version 6, anything else and go learn VB.NET).

Easy way, but this just launches the app:

Insert Button Via Design View>>On the wizard, select Application>>Run Application>.Next>>Enter Command Line>>Next>>Enter text>>Finish

I'll look about see if I can find the VB coding to store the image within a DB, but no guarantees, well, unless you write the DB Program from scratch using VB

Dan



jaybee -> RE: MS Access experts please!!!!!!! (9/22/2004 5:23:10)

I've got it set up so it brings up PSP to do the scan and puts a link into the field and then with a bound box displays the pic. Works fine but the client is insisting that in his old database there was a button which had a camera on it. He clicked on the camera and the scanner started up, scanned the map and placed it straight on the page. He doesn't want PSP to appear or any other package for that matter.

I've turned the web upside down looking for software, add-ins etc that do it. Unfortunately, he doesn't have the old database around for me to look at to check.



Giomanach -> RE: MS Access experts please!!!!!!! (9/22/2004 5:29:50)

Can I call BS.....[:-]

It wouldn't have been access if that is the case, it would have been a custom written VB/VB.NET/C++ program, not an MS Access DB. Technically, with Access, what he's asking is not possible.

You can take the basis of Access and use MSVB6 Pro and turn it into a program...but thats also hard work.

quote:

He doesn't want PSP to appear or any other package for that matter.

So how does he intend on scanning then?[8|][:-]

Whether it be a silent scan or not, something will still appear in either the system tray, task bar, or on his screen, M$ Access doesn't have a built in scan function, that uses its own drivers, t requires a thrid party program...no matter how hard you try

Sorry....Speaking as VB Programmer....with M$ Access experience..

Dan



jaybee -> RE: MS Access experts please!!!!!!! (9/22/2004 5:58:37)

Yup, my thoughts exactly.

He insists that he clicked the button and a box appeared round the bound field, he then pressed Ctrl C and the image was scanned in. No pop-ups, no applications, nothing. I've tried allsorts but everything goes back to the app appearing. I even downloaded an access add-in demo that does scanning but that also pops a box for scan settings.

I'm on the verge of writing the whole thing off and telling him to go buy his old database back.



Giomanach -> RE: MS Access experts please!!!!!!! (9/22/2004 6:44:16)

And don't send him in my direction! lol...I don't have the experince or knowledge to go all out on Custom written VB progs...[&o]

quote:

He insists that he clicked the button and a box appeared round the bound field, he then pressed Ctrl C and the image was scanned in. No pop-ups, no applications, nothing.

Be Oh Double El Oh Ex

There's some form of third party program in action there.....

With Access...it's a no-no....with VB....yes, but hard work (for me anyway)...C++......I hear it's a piece of cake[:D]

Dan



jaybee -> RE: MS Access experts please!!!!!!! (9/22/2004 11:54:06)

Ah HA!!!!!

I managed to get a copy of the original system off one of his backups.

It's some sort of scanning package which seems to come from Hewlett Packard and ties in with a scanner he no longer has. [:@]



jaybee -> RE: MS Access experts please!!!!!!! (9/24/2004 2:27:36)

For info if anyone is trying to do something similar....

There are a few ActiveX controls knocking around on the Web which appear to do what is required. Some are quite pricey though, $49 upwards.

Do they work? Well yes BUT.....

It depends on the security settings on the machine you run them on. If it's set to Medium or High then forget it.



mar0364 -> RE: MS Access experts please!!!!!!! (9/24/2004 16:14:18)

Jaybee, what did you end up doing with this? I've got a similar problem. Did you go with and Active X control? If so which one?

Thanks!
Rich



jaybee -> RE: MS Access experts please!!!!!!! (9/24/2004 17:06:25)

Hi Rich,

Truth be told I'm still banging my head against the desk on this one.

I've got a temporary get round. Bound Object Frame, Insert Object, PSP8 Image.

That opens up PSP and you can scan in then copy/paste. Not ideal but it works.

The two I've started looking at are

http://www.ciansoft.com/twaincontrolx/default.asp

http://www.soft32.com/download-VintaSoftTwain_ActiveX_Control-26119-5.html

As soon as I get the security warnings to stop popping up all over the place, I'll be laughing.

If you find any others let me know. Especially if they're free. [:D]

Depending on what you're trying to do, this might also be of interest......

http://www.ammara.com/support/samples/showsam6258.html



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
6.298828E-02