473,657 Members | 2,801 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Slightly O.T. - Oh hell, way O.T! Need to scan data directly into Access data fields

MLH
I would like a scanner - something like a pencil that would
allow me to attempt to scan printed text off hardcopies. Not
all text on a page, mind you. Something I could use to scan
just the words "scan printed text" off the second line in this
post would be great! A selective scanning tool - I guess is
what you would call it.

I did a search for pencil type scanners and came up empty
handed. Anybody got ideas?
Nov 13 '05 #1
6 2051
MLH
A bit more follow-up...

What I wanna do is allow slow typists entering data
into MS Access forms from printed hardcopies an
alternative to typing. Holding something in their hand
akin to a pen or pencil, they can move the pointer
over some printed words (kind-a-like they would if
they were holding a hi-liter), scanning the text, OCR'ing
the bitmap and dumping it into the current textbox
control.

It would be nice if the pointer (call it a light-pen or
something) had a button you press and hold down,
then do your drag-n-release to "read" the text and
another button that could be programmed so that
it would be interpreted as a TAB keystroke.
Nov 13 '05 #2
MLH
I'm in luck. Here's what I found...
http://www.wizcomtech.com/Wizcom/pro...fo.asp?fid=100
Its a pen-like device called the InfoScan, mfd by WizCom.

My question now is:
Has anyone ever used the input device as an input tool to scan 'n dump
alphanumeric data directly into MS Access 2.0 forms? If so, Were you
happy with the process?

Nov 13 '05 #3
MLH <CR**@NorthStat e.net> wrote:
I'm in luck. Here's what I found...
http://www.wizcomtech.com/Wizcom/pro...fo.asp?fid=100
Its a pen-like device called the InfoScan, mfd by WizCom.

My question now is:
Has anyone ever used the input device as an input tool to scan 'n dump
alphanumeric data directly into MS Access 2.0 forms? If so, Were you
happy with the process?


To me the biggest problem is going to be the quality of the OCRing. Among other
things the higher the resolution the better. However this may mean they will need
to go slower than they'd like.

Also does this device do on the fly OCRing? Hmm, looks like it might do the OCRing
right in the device. Impressive.

That device just might work. And that price it's almost a throwaway item.

Note that you may still run into problems no matter what you try. FWIW a variable
width font, ie Arial or Times Roman, is significantly worse than fixed width font, ie
Courier..

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #4
MLH
Your concerns were certainly justified. I bought one yesterday and am
returning it today. Oh, it OCR's perfect stuff (IE, typewriter Courier
10) easy enough. But get into fonts with character kerning and you
can forget it. Too bad. It was a sexy idea!

xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxx
On Sun, 10 Oct 2004 23:27:31 GMT, Tony Toews <tt****@teluspl anet.net>
wrote:
MLH <CR**@NorthStat e.net> wrote:
I'm in luck. Here's what I found...
http://www.wizcomtech.com/Wizcom/pro...fo.asp?fid=100
Its a pen-like device called the InfoScan, mfd by WizCom.

My question now is:
Has anyone ever used the input device as an input tool to scan 'n dump
alphanumeri c data directly into MS Access 2.0 forms? If so, Were you
happy with the process?


To me the biggest problem is going to be the quality of the OCRing. Among other
things the higher the resolution the better. However this may mean they will need
to go slower than they'd like.

Also does this device do on the fly OCRing? Hmm, looks like it might do the OCRing
right in the device. Impressive.

That device just might work. And that price it's almost a throwaway item.

Note that you may still run into problems no matter what you try. FWIW a variable
width font, ie Arial or Times Roman, is significantly worse than fixed width font, ie
Courier..

Tony


Nov 13 '05 #5
MLH <CR**@NorthStat e.net> wrote:
Your concerns were certainly justified. I bought one yesterday and am
returning it today. Oh, it OCR's perfect stuff (IE, typewriter Courier
10) easy enough. But get into fonts with character kerning and you
can forget it. Too bad. It was a sexy idea!


Darn, it was a nice looking product. Can you somehow up the resolution. Ie from 150
dpi to 300 or 600 dpi? Mind you each time you double the scanning resolution you
quadruple the CPU power required.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #6
On Tue, 12 Oct 2004 19:50:46 GMT, Tony Toews <tt****@teluspl anet.net> wrote:
MLH <CR**@NorthStat e.net> wrote:
Your concerns were certainly justified. I bought one yesterday and am
returning it today. Oh, it OCR's perfect stuff (IE, typewriter Courier
10) easy enough. But get into fonts with character kerning and you
can forget it. Too bad. It was a sexy idea!


Darn, it was a nice looking product. Can you somehow up the resolution. Ie from 150
dpi to 300 or 600 dpi? Mind you each time you double the scanning resolution you
quadruple the CPU power required.

Tony

If the data entry person is a slow typist, That person probably makes a lot of
typo's also.

Have you considered that maybe the best solution is to hire a very good typist
and pay a good wage for the service.

Does the data you enter have to be editable? Could you copy the material and
enter it as an image? This is the only method that does not introduce its own
errors.

Could you use a scaner that outputs to a text file? Open the text file in
Word, spell check, then copy and paste from Word.

Except for entering an image, the data entered into the program is going to
have to be checked for accuracy. That is a slow process at best.

Any method, except an image, you use for data entry is subject to errors, even
copy and past from errorless text. It is possible to miss the first or last
character when you copy. It is possible to add a leading or trailing space.
And 'Trim' can take care of extra spaces to make the outputs look good, but
that doesn't help the underlying data.

I wish you lots of luck.

Chuck
....
Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
3123
by: Gary Wright | last post by:
I have an Access 2K database split into front and back. Quite often the users want to do some data analysis that I have not created a report for so they want to export some subset of the data into and Excel spreadsheet. Since the data often comes from many different tables, I have decided to create a temporary Access table, put all the data into it then use the Docmd.TransferSpreadsheet command to output the table to a spreadsheet. In...
19
4088
by: James Fortune | last post by:
I have a lot of respect for David Fenton and Allen Browne, but I don't understand why people who know how to write code to completely replace a front end do not write something that will automate the code that implements managing unbound controls on forms given the superior performance of unbound controls in a client/server environment. I can easily understand a newbie using bound controls or someone with a tight deadline. I guess I need...
3
10638
by: google | last post by:
I have a database with four table. In one of the tables, I use about five lookup fields to get populate their dropdown list. I have read that lookup fields are really bad and may cause problems that are hard to find. The main problem I am having right now is that I have a report that is sorted by one of these lookup fields and it only displays the record's ID number. When I add the source table to the query it makes several records...
2
2020
by: ratedr1 | last post by:
I am currently trying to label rings (jewelry). They make specialized tags (shaped like a butterfly, barbell, dumbell, etc) for this purpose, the label goes through the ring, and then the ends stick together. What I want to do is type information on these tags rather than write on them, the only problem that I am having is that there is NO template tht I can find anywhere for these labels. Now I have purchased the labels and I have them...
11
2794
by: my-wings | last post by:
I think I've painted myself into a corner, and I'm hoping someone can help me out. I have a table of books (tblBooks), which includes a field (strPubName) for Publisher Name and another field (strPubCity) for Publisher City. These two fields have a many-to-one relationship with tables, (tlkpPubName and tlkpPubCity) respectively. The lookup tables only have one field (strPubName and strPubCity), which is their primary key. I also have...
7
2725
by: Keith Patrick | last post by:
After completely giving up on finding some way in my ASP.Net app to take a query string URL and redirect to it as a POST instead, I went with a system like so: Upon "redirection," all the QueryString pairs are placed in HttpContext.Current.Items and retrieved with a wrapper for Request.Params that includes checks there. This works in general instances, but one problem has come up that has me stuck: since the stuff is in the context and...
1
2489
by: Phil Latio | last post by:
I have a number of spreadsheets, each with between 1000-6000 rows (each row is a property) and they all need to be combined into a single database. Each spreadsheet contains slightly different information and 80% of the properties in spreadsheet_01 also appear spreadsheet_02. Spreadsheet_03 contains slightly different information again and perhaps has 60% of properties in this one also appear in other spreadsheets. The problem is not...
6
29054
by: hayadooen | last post by:
Hi all, Very new to this forum. Searched for relative postings but found none. Question: Does anyone know of any application that could convert/import scanned docs (PDFs) into access database (specified fields)? I constantly deal with paper works from clients like purchase orders, etc. and data entry into access is very time-consuming and costly.
0
2771
by: LanaR | last post by:
Hello, one sql statement is causing severe performance issue. The problem occurs only in UDB environment, the same statemnt on the mainframe is running fine. I have an explain output from the sql. The statement itself is not that complicated, it is 3 selects and union all. Explain output is pretty big, but I could not find anything unusual. I'm new to db2 and I could be missing stuff. I am posting the explain output below and I really...
0
8302
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8820
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8718
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7314
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6162
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5630
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1937
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1601
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.