StockTake Form

[mea99sdp]

Hi I'm having problems trying to design a stocktake form.

I need a form that displays all parts from my parts table with a box next to it, which will be used for stocktake quantity. After the quantity are updated the information is saved to the stoctake table(StocktakeID,StockTakeDate,PartID,Quantity).


Can anyone help me please.

Cheers

Si

 

[ajetrumpet]

Yes we can probably help Si, but the information you provided is vague.

The database is a little bit too big to be figuring out alone what you want to do with it.

Provide more information please.

 

[mea99sdp]

I will print off a report that has all parts listed on it, with a box for the person who carries out the stock take next to each item to enter quantity.
After that report is filled in, the information need to be inputted into the data base.

So in my database, i need a form that lists all parts with a box next to the part for quantity. after updating stock check information, the data is saved to the tblstocktake table.

hope this helps.

 

[mea99sdp]

help? please

 

[ajetrumpet]

yeah...hang on their chief!!

 

[ajetrumpet]

OK,

Is this all true...??

** You have on hand inventory for each of your parts.
** You need a record of everytime time someone reduces your stock (on-hand).
** You're wanting a form that can assist you with entering this data into the database.

 

[mea99sdp]

yes, that is true

 

[ajetrumpet]

How many parts do you have??

I only ask because if you have too many, putting textboxes on the form for every part will get you frustrated pretty darn quick.

Now that I think about it though, the Multi-Record entry database that I posted in the samples section might get you started.

You can find that here.

I'm not really sure if the background code is too hard to follow, but just knowing what the purpose of the Form is and how it operates will arm you with the knowledge you need to make a successful form yourself...

 

[mea99sdp]

yes there are many parts, and they can change, maybe add/delete afew.

is there anyway i could load all the parts from parts table, add extra column for qty, then save to stocktake table?

 

[ajetrumpet]

Did you look at the sample database?? I think you could use part of it.

Anyway, I would tackle this bear like this...

** Form Recordsource = tblStockTake
** All form's controls are bound to the table's fields
** PartID control = Combo Box Lookup = SELECT "parts" from the PartsTable (this will give you a list)
** Form Type = Data Entry

Sounds like you can do everything you need by doing what I just described.
Your table STOCKTAKE only has four fields, so it should not be that complex.

I only suggested looking at my sample because temporarly storing your current data somewhere will allow you to undo any changes to the data before it actually goes into the source table....