A new type of data entry system...

[Benjamin Bolduc]

Hi Everyone!

I'm working on a new project for my ever-growing company database. I'd like to implement a new data-entry system that seems like it should be simple enough, but I lack the raw technical knowledge to do so. So that's why I'm turning to you wonderful access experts for help!

Ok, Here's my situation...

I need to computerize an inventory spreadsheet that has been used to keep track of the ingrediants we use during production. (We produce Vinegar and Mustard).

Every week, we receive this spreadsheet with the new balances for every ingrediant.

I currently have 2 tables, one with the list of different ingrediants and one for making inventory changes. I could easily set up a simple inventory system where you choose a product and then type in the new balance, but that would take forever since there are 52 ingrediants.

So here's my idea...

I want to set up a form that pops up with a new ingrediant and gives a feild to type in the new balance. (E.G. A popup box appears with SALT as the ingrediant and you type in the quantity. As soon as you hit enter, it changes to GARLIC etc..) This will create one new record after the other and should dramatically reduce the time it takes to fill out the whole sheet by hand or click and choose each product individually through a combobox.

The only way I can think of to do this is to create about a million macros, codes, and forms. I'm sure there must be any efficient way of doing this.

If anyone has any thoughts, suggestions, technichal advice, I would truly appreciate it. If anyone can help me with this I know you guys can!

Thanks for your help!
Ben Bolduc

 

[reel knotty]

why go to all the work of creating all the pop ups. why not just build a form with all the ingrieds listed with a value box next to it. This way all of the fields are right there infront of you and all you have to do is enter your new value hit your enter button and move to the next field. Maybe I'm not seeing exactly what your trying to do but this seems much easier to me.

 

[Benjamin Bolduc]

Would that create new records in the Transaction table for every item in the Item table? Hmmm that gives me something to play around with. Thanks for the idea!

 

[reel knotty]

do you want to over write your existing inventory or do you want a history? if you want to overwrite you could have it pull up "last weeks numbers" and if it was not used no data entry is needed just move to the next item. If that is the case then you would not need the transaction table you could just add the inventory number field in your item table and pull all your numbers from one table. that would be super easy to do. BTW if you guys need a trucking company to haul your stuff give me a shout I have 3-5 trucks up your way every day. Sorry for the business plug