AHHH I think I might be in over my head !! I haven't got a table structure yet cos I wanted to wait until I got the replies to see if it would help me put it together from scratch !! I'll have to take some time to digest your answer and see if I can figure it out ! thanks for taking the time...
Thanks for your reply I'll try and explain !
ok there is really only 1 batch cos we only have 1 stock item and it's not divided into specific batches, my use of the word batches may have been misleading.
We have 1 stock item in which each physical piece of material has an individual...
sort of !
I need to keep a record of
A) the first number in the batch of items
b) the last number in the batch of items
C) The number of items !
I want it to be automated where possible to at least cut down on the human error bit, its for stock records. so what I want is for the user only...
Hope I explain this so that you can follow here is what I wish to do !:)
Form has the following fields (among others)
From: (number field)
To: (number field)
Number of items : (number field)
Here's what I want to be able to do.
From number should appear when form opens cause it is...
First of all apologies if this is in the wrong section but because I think it encompasses a bit of everything I thought the General section was the best place for it !!.
2nd I have searched and read as many of the stock control posts as possible but nobody seems to be looking to do what I am ...
Hi I am having a similar problem to another poster who seems to have received the answer but it was email to him so don't know what it is !!
I need to create a macro to import a spreadsheet on a weekly basis, prob is the spreadsheet needs to be saved with a different name each time, but the...
I was trying to implement some code, (don't ask me what !) and now my database is gone screwy ! none of my command buttons work even if I try to make a new one, it says its not the name of a function, macro etc... my pivot table wizard is not working and is giving me the error Object Variable or...
Hi,
have a query, I have linked an outlook calender into the tables area of my database I am aware that there are limitations on linking with outlook for example if linking contacts custom fields don't appear, anyway I thought I cld make do with the fields that do appear but the main one the...