Replies

Jim,
Check out Wasp scanners – they seem to have many options. Do a google search if necessary, but I think their site it http://www.waspbarcode.com
Kathi

And VOILA!!! There we have it.

I should have seen that myself, I suppose, but I got so wrapped up in making sure all the DAO references were set and the items were declared. You know, “Can’t see the forest for the trees.”

Once again, you are my hero!

Thanks, Kathi

Hans, thanks for replying. I set the reference, pasted your code as a Public sub on an unbound form that contains a single command button. I named the sub ProcessTable and changed the constants to the names of my tables. The OnClick event for the button has one line “ProcessTable”

What have I missed? The very informative (sarcasm) error I get when I click the button is “Item not found in this collection”. No identification of which item was not found, no debug button and highlighted code, nothing.

Any ideas?
Kathi

I don’t know if you’re asking about Access’ ability to interpret barcode data or the hardware issues associated with a particular barcode scanner. What I can tell you is that I have successfully incorporated reading barcodes with a very inexpensive little scanner called a CueCat (available on eBay for less than $10) and free barcode fonts. I tried 2 types of CueCats – one was USB and the other piggybacked through a PS2 keyboard. Surprisingly the keyboard type worked more reliably and is cheaper. Since this scanner actually emulates keyboard strokes it works very well with Access and you still program with actual ascii characters. The wireless scanner manufacturers promise the same ease of use, but I haven’t tried them yet. Good luck!

Kathi Mills
Pitt graduate, go Stillers! BSEE ’86

Hi everyone. Wow, over a year ago I got outstanding help with simple printing of a Word document.

As you’ve probably guessed I now need to take the issue further. Here’s the situation:
The overall project is to create test procedure books for over 60 differently configured locations. Each location can have any or all of 10 different subsystems. Each subsystem can require any or all of numerous test procedures, and a single location’s subsystem may require 2 or more of the same test procedure. Is that clear? (In all, there are over 60 individual test procedures)

The status right now is that a team has produced all of the individual test procedures as individual Word documents. They all follow the same required format as such:
1.1.1 Name of Test
1.1.1.1 Introduction
1.1.1.1.1 Purpose of Test
1.1.1.1.2 Subsystem or Equipment to be Tested
etc.

Each Word doc begins as if it is the 1st test proc in a particular book, i.e. they all start with the number “1”. The thinking was to simply append each required doc, in order, into a “master” document for each location. Then auto-renumber the master, create a table of contents, slap in a cover page, and call that location done. They got ONE done, and quickly realized that any change to a particular test procedure would soon become a monumental task since they would have to open each master and make the same change.

I was asked to write an application in Access that would always link the actual latest revision of each test procedure. I can PRINT, in order, all the test procedures for a particular location. BUT, they all begin with “1” AND the contract requires that each book also be delivered as a master Word document.

Is there a way to manipulate Word via Access code to append the required docs into a master file and save it as a new file? I don’t even need to be able to print it from Access, just create it.

ANY suggestions or solutions will be greatly appreciated — it’s my little brother that is responsible for this project so I’m quite motivated to help! Thanks in advance, Kathi

Thank you, my friend. I commented out the last line and all is working perfectly now. You are the master!!!

Thank you, my friend. I commented out the last line and all is working perfectly now. You are the master!!!

Brent,
I’ve found that most people have a hard time converting time to decimals. I’ve overcome this by having them input into 2 separate text boxes: 1 for hours, 1 for minutes. Default for both is zero. In your case it seems that minutes are in intervals of 15, i.e. .25, .5. .75. If that is always the case, you could make the minutes a list box (or combo box with appropriate Not In List event). Also, if you want to go further you could go the “start time”/”end time” and calculate from there. Good luck.
Kathi

Brent,
I’ve found that most people have a hard time converting time to decimals. I’ve overcome this by having them input into 2 separate text boxes: 1 for hours, 1 for minutes. Default for both is zero. In your case it seems that minutes are in intervals of 15, i.e. .25, .5. .75. If that is always the case, you could make the minutes a list box (or combo box with appropriate Not In List event). Also, if you want to go further you could go the “start time”/”end time” and calculate from there. Good luck.
Kathi

Charlotte, Wendell,
Thanks for your replies. If I read you correctly, I guess I’m SOL. Why would MS make such a thing so difficult? In fact, I’m wondering why such a versatile product (Access) is virtually unknown to the mass majority. Are there really that many users who couldn’t benefit from its abilities, ease of use, etc? Thanks for trying to help.
Kathi

Charlotte, Wendell,
Thanks for your replies. If I read you correctly, I guess I’m SOL. Why would MS make such a thing so difficult? In fact, I’m wondering why such a versatile product (Access) is virtually unknown to the mass majority. Are there really that many users who couldn’t benefit from its abilities, ease of use, etc? Thanks for trying to help.
Kathi

Hey Dude,
I’m not quite sure I understand your form — is the Combo Box in the header and the rest of the data in the detail section? I’m assuming you’re not trying to use a subform, right? If you can you be more specific, I’m sure I have the answer since I deal extensively with 17 character VIN’s off vehicles. They are, as you say, “meaningful” codes BTW, don’t knock them too much, just break them up into different fields upon entry and then forget having to decode on the fly.
Kathi

Hey Dude,
I’m not quite sure I understand your form — is the Combo Box in the header and the rest of the data in the detail section? I’m assuming you’re not trying to use a subform, right? If you can you be more specific, I’m sure I have the answer since I deal extensively with 17 character VIN’s off vehicles. They are, as you say, “meaningful” codes BTW, don’t knock them too much, just break them up into different fields upon entry and then forget having to decode on the fly.
Kathi

Hans,
You are my hero!!!! Exactly what I needed. Thanks, Kathi

Hans,
You are my hero!!!! Exactly what I needed. Thanks, Kathi