MS Access experts please!!!!!!!

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

MS Access experts please!!!!!!!

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Community >> Computer Software and Hardware issues >> MS Access experts please!!!!!!!

Page: [1]


jaybee Posts: 14070 Joined: 10/7/2003 From: Berkshire, UK Status: offline	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. _____________________________ If it ain't broke..... fix it until it is. GAWDS* Now where did I put that Doctype?


Giomanach Posts: 6086 Joined: 11/19/2003 From: England Status: offline	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 _____________________________ (in reply to jaybee)


jaybee Posts: 14070 Joined: 10/7/2003 From: Berkshire, UK Status: offline	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. _____________________________ If it ain't broke..... fix it until it is. GAWDS Now where did I put that Doctype? (in reply to Giomanach)


Giomanach Posts: 6086 Joined: 11/19/2003 From: England Status: offline	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? 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 _____________________________ (in reply to jaybee)


jaybee Posts: 14070 Joined: 10/7/2003 From: Berkshire, UK Status: offline	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. _____________________________ If it ain't broke..... fix it until it is. GAWDS Now where did I put that Doctype? (in reply to Giomanach)


Giomanach Posts: 6086 Joined: 11/19/2003 From: England Status: offline	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... 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 Dan _____________________________ (in reply to jaybee)


jaybee Posts: 14070 Joined: 10/7/2003 From: Berkshire, UK Status: offline	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. _____________________________ If it ain't broke..... fix it until it is. GAWDS Now where did I put that Doctype? (in reply to Giomanach)


jaybee Posts: 14070 Joined: 10/7/2003 From: Berkshire, UK Status: offline	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. _____________________________ If it ain't broke..... fix it until it is. GAWDS Now where did I put that Doctype? (in reply to jaybee)


mar0364 Posts: 3046 Joined: 4/5/2002 From: Florida, US Status: offline	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 (in reply to jaybee)


jaybee Posts: 14070 Joined: 10/7/2003 From: Berkshire, UK Status: offline	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. Depending on what you're trying to do, this might also be of interest...... http://www.ammara.com/support/samples/showsam6258.html _____________________________ If it ain't broke..... fix it until it is. GAWDS Now where did I put that Doctype? (in reply to mar0364)

Page: [1]

All Forums >> Community >> Computer Software and Hardware issues >> MS Access experts please!!!!!!!

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts