Recent content by honey2wood

Thank you to all that have got back to this 'problem'. I now have the solution I needed. I just now need to understand how it works. :)

Hi, Thanks for getting back to help all. I have been trying to get a sample which has all the different possibilities as requested by Gizmo. I have attached if it clarify. Hi Pat. Updating the date and version would work but not everyone would have the training at the same time. arnelgp. I need...

Hi, I have had a quick look through these threads but can find nothing that gives me the answer I need. I have a Training Database with a Query that I need to identify/remove duplicates from. There are 35 employees (EMP_ID) with around 40 different procedures (Pro_Num). Each Procedure has at...

Hi theDBGuy, Thanks for getting back to me. The form is for collecting information for training courses. The combo box is from a table that has the list of possible courses with number Description and issue no. The number is saved to a table that is used to produce a training record along with...

Hi, This is probably a really simple request but I have spent hours looking for a solution. I have a form with a combo box. The first column of the combo is captured on a table. There are other columns which I am displaying on the form as text boxes but I need the results of the text boxes on...

Hi, This is probably a really simple request but I have spent hours looking for a solution. I have a form with a combo box. The first column of the combo is captured on a table. There are other columns which I am displaying on the form as text boxes but I need the results of the text boxes on...

Hi Sneuberg That has worked just fine thank you. Graham

Hi All, I have a database that I need to print labels from. I want to be able to select an address and print a single label, any number of the same label or different addresses.. I have gleaned enough information from this and other forums to now have a form with a list of addresses with a...

each batch as it arrives is stored in a box with the GRN number attached to it. That GRN (Goods Receipt number) and batch no. is recorded on the work sheets to indicate what batch was used. This can then be traced back to the delivery.

Hi Jdraw, Batches are normally in 100s A lot of the time we have orders that will use all of a batch which I am able to deal with 1 order for 1 batch. But for about a third we have two or three orders per batch. I need to be able to know how many of a batch have been rejected or left in stock.

Hi Dave / I think this is why most posts on inventory databases just give an overall figure. Traceability is the issue here. I am looking at parts for medical devices which need a degree of traceability. Hi Uncle Gizmo We do give an individual Goods Receipt number (GRN) when we receive each...

Hi I have been looking through the forum for a solution to an inventory database problem but can't find anything that helps. I work with an inventory database that I produced a long time ago and it works well. Basically the stock is booked in onto a transaction table where I have the ability...

Very Many thanks that works just right. I know what you mean about field names and normally I do try. In this case I am adjusting someone else's database and don't want to change much in case it stops other parts from working. Kind regards Graham

Hi Everyone, I hope someone can help I seem to be going round in circles at the moment. I am taking a value from one form into another. The value I am taking needs to select an item In a combo Box. So far I can move the value to the new form but cant seem to copy the value into the...

Hi JDraw, Many thanks for the reply. This is just what I needed. Sorry I have not got back before but have been away. Graham