Recent content by jumpyhu

Thanks alot for your help. It took me a bit to figure out that your code basically adds up the Null Fields, so (as another half-baked move by me) I created another field in the query which does the math to give me my positive values per store. You're a life saver :] Kelly Warner

AH! SQL view! New to me. I feel like a plumber now, actually working with the pipes and fixtures behind the scenes for once

Fortunately, I never will need additional name fields, but YES- you are absolutely correct. I realized that my architecture was faulty when I got to this point. You know how it is sometimes (as a newbie); you build a db only to realize that your core logic is not up to par ;[ Well, now I've...

Each record in my table (called Brooks) is a separate order. Each order/record includes a store number, as well as a bunch of name fields (name1, name2, name3, etc). The idea is that a store can enter a bunch of names into the table and we can process an order (each record). I would like to be...

I have a form working as a front end for my dockets table. Each Record is a seperate order, ID'd by Docket ID (key). I would like to be able to have my sales reps be able to search by Customer and automatically create a new record, duplicating the old information into the new so that they can...

Hi, I am working on a e-docket system. All docket info is stored in the same table; I would like to have a search form wherein a sales rep can recall the name of a specific client and be able to click a button which will open my current on-screen docket (to be filled out by them for an order)...

Thanks so much for your reply! I suspect that certain barcode types will function fine as a font, but if I'm not mistaken, there are a couple of types that adjust several aspects of themselves based on content, and therefore can't be created linearly as a 'typed word'. This, however, is...

How might i generate barcodes for items in my table? I'd love to output the values to my labelling report for scanning. Oh, and once that is done, have you got suggestions as to how I may unite a wand with Access 97 to do inventory evaluation? Hardware/software? A big mouthful to chew on, I...

I've created a form which generates new inventory numbers for our stock based on a series of pulldowns and text fields. I'd like to allow the user the option of clicking thru a macro which will paste the value (field is called Text12) contained in the generated field into a specific cell in the...