On Tue, 10 Apr 2007 08:59:12 -0400, "Lloyd E. Sponenburgh"
<(E-Mail Removed)> wrote:
>My dad can't work an abacus, let alone a computer, but I want to enable him
>to do inventories of our feed, supplies, fertilizer, tractor parts, etc.
Sounds familiar. In the distant past, I had to translate all the
Altos AOS menus on my fathers computah into Polish in order for him to
use it effectively. I later arranged to do the same into Spanish for
the employees.
>For this purpose, I ebay-hooked a used Symbol 9660 handheld computer with a
>bar code scanner. It runs Windows CE.net 4.2.
Nice. What are you using for access points? What are you using for a
router? What application is your temporary server running? A web
server?
>When _I_ go to each building, I pop up an excel spreadsheet unique to the
>building, tally the goods, then print a "re-order" sheet on the local
>printer (by manually selecting which printer I'll use). The sheet gets hung
>up on a clip board for another helper to collect during rounds, and to fill
>on his trip to town.
You couldn't do this on one big Excel spreadsheet with all the various
barns listed? Excel can easily setup a spreadsheet into "sheets", one
for each barn.
<http://j-walk.com/ss/excel/usertips/tip049.htm>
>What I'd like dad to do is find that whenever he enters an access point's
>field, a "web page" unique to the building automatically pops up, giving him
>only the lists/fields appropriate to that building, and enabling him to just
>scan what's there by 'dumb' trigger pulls on the 9660. No thinking, just
>point-n-push. Then, by scanning a special bar code hung up on a post, to
>trigger printing of the order sheet on that local printer.
Ok. So have the bar code scan do everything for him. Have it run a
batch file or VBS script that starts the correct spreadsheet, and runs
an Excel Macro with whatever startup menu he needs. You don't need to
know which access point he's using as scanning the bar code on the
post will have that and the corresponding spreadsheet recorded. The
rest is programming, which I'm not very good at and don't want to
offer any code. However, with protected cells on the spreadsheet, and
custom menus, you should be able to create something useful.
<http://j-walk.com/ss/excel/tips/tip53.htm>
The menus can be invoked by a function key combination or button
somewhere on the spreadsheet.
>So... how do I get an unique page to display when each access point is in
>range?
You don't. You use the bar code scan on the pole to tell the computah
where it's located and which spreadsheet (or which sheet) to use.
>I think I can make the application select the printer - believe I
>know how to do that.
Same deal. The batch file or VBS script run from the bar code on the
pole selects the printer. Here are several ways to reset the default
printer on the fly:
<http://www.netadmintools.com/art194.html>
<http://www.ss64.com/nt/prnmngr.html>
or you can do it in VBS with an incantation:
<http://www.ss64.com/wsh/defaultprint.html>
If you're a true masochist, there's also this mess from Microsoft:
<http://support.microsoft.com/kb/246772>
>But how to I "push" a new page onto the browser from
>each access point without any interaction on dad's behalf?
Browser? What browser? I thought you were using an Excel spreadsheet
and not a web browser.
>Was I clear?
Not really. You described what you want to accomplish without much
concern for describing what you have to work with (hardware and
software).
>Dad's not terribly happy with "machines" doing what a pencil
>could do.
Hint: Automating the process will only make it worse. If he feels
he's not doing anything useful, he just won't do it, or possibly won't
even try. Leave in a few bugs that even he can find, so that he
doesn't feel like he's been replaced by a computah.
>But heck... this is a toy, and it's fun (so far). Now I need to
>make it so dad can use it. (please, don't say, "train him to do it"....
>that _never_ did work<G>)
That's a much bigger challenge than automating the system. It may be
fun for you, but not for him. Ask him how *he* wants to have it work
so that it's easier for him to do (i.e. less work, fewer keystrokes,
less reading, fewer steps, etc) and make it sufficiently reliable so
everything doesn't have to be done twice. You might be surprised at
what you learn in the process.
Incidentally, forget about putting a bar code on everything in sight.
That's the maintenance nightmare from hell. Look into RFID and do
your inventory while just walking around without any button pushing.
--
# Jeff Liebermann 150 Felker St #D Santa Cruz CA 95060
# 831-336-2558
(E-Mail Removed)
#
http://802.11junk.com (E-Mail Removed)
#
http://www.LearnByDestroying.com AE6KS