Search results

Hi All, Got something I want to do but not sure if it is possible I have searched through the forum and have not found exactly what I wanted hense this post.. Simplified I have 2 tables. tbl_Employees EmployeeID - Auto First_Name - Text Last_Name - Text Department - Lookup to...

I have included a start, Am I on the right lines, if anyone wants to have a quick look and let me know what I have or am doing wrong I would be extremely greatful :)

Hi all. What would be the best way to go about this: I want a database for employees to use. Employees select there name from a dropdown. Then a week number I have been trying to get the form to default the current week number but its proving difficult. Saturday to Saturday weeks. They go to...

Code works like a charm, Thank you so much vbaInet, and pbaldy I added that line thank you. Only thing I had to do was counter = 1 to counter = 0 so it added all 8 serial numbers. Thanks Again. All the Best

Here you are this is my novice start to the DB

I have a Work Order Table of which you enter in the AutoID, BatchNumber, PartNumber, Quantity, Operator, Notes, Complete (Yes/No) I have a Seperate Table Contains SerialAutoID, BatchNumber, Serial. I have other tables but they are the main relevent ones.

On the Job Card Issues, it says to the Employee that this batch contains serial numbers from 12320 - 12328. I dont need to know which individual component has which number, but what I need to know is what serial number came from what batch. So I tried to make it easy and quick when adding to...

The numbers are issued to the components already, before they enter the Clean Room, they have a job card with the batch ID part Number and serial Numbers with them. So the DB is basicly just a DayBook Log of which batches to be worked. I wanted to log the serial numbers so if a part comes...

Im not sure if this is the right catagory im posting this in but... I need to work out what would be the best way for a user to enter in one Serial number into a field then once submitted it would automaticly add 7 more plusing one each time as. EG. 8 Components Per batch each having a...

What I am trying to aim for is: Each batch of parts have a Unique workorder number - they come with a jobcard which has a range of operations to complete the batch of jobs. There are many operations that need to be completed at a range of workcentres but each operation needs to be...

Hi I have included the start of my database basicly it will tell me locations of certain jobs, which include part number operations, I need to know if im attempting this project correct or not. Thanks in advance

Great Thanks, all sorted now. Ideal Thanks Pat

Probably heard this one a lot before. Im after a solution to this: A table with 5 Fields (ID, PartNumber, OperationNumber, WorkCentre, Machine) In the form I got 4 TextBoxes and want it to automaticly enter the WorkCentre and Machine if the PartNumber and OperationNumber is entered. If...