Trying to Create a booking in and out system

[ellisp999]

Hi all,

I have a few problems with creating a booking in and out job system let me explain the intended use before i explain the problems:

The idea is that you will be able to book a job onto the excel sheet using a "book in" button this button will take you to a form to fill in then add your job to the list (with a time stamp)
then the same thing for booking out but when booking out you click the "book out" button and search for your job using a user form then press complete and your job will be deleted and moved to another sheet called completed jobs.

Current issues i am facing are:

When booking in the only thing that transfers from the form to the job list (sheet2) is the timestamp nothing else will transfer.

When booking out the search button wont delete the correct row it will only delete from sheet 1 and not sheet 2.


also the titles currently do not tie up as i have used a macro for the booking out from a different form i plan to tidy these up when its all working.

Please help!!

Booking System to upload.xls

[AlphaFrog]

Current issues i am facing are:

1.) When booking in the only thing that transfers from the form to the job list (sheet2) is the timestamp nothing else will transfer.

2.) When booking out the search button wont delete the correct row it will only delete from sheet 1 and not sheet 2.

1.) In the CommandButton1_Click (Submit) procedure, your code clears the textboxes before writing the values to the worksheet. Move the highlighted code like below so it is after the values are written

Please Login or Register  to view this content.

2.) Just specify the worksheet to delete from.

Please Login or Register  to view this content.

[ellisp999]

I think i love you!

Thats really helped thanks.

How about if i want to keep the data so say cut then paste into another sheet?

Any ideas on how i can time how long a job has been waiting even if its like 10 days?

Thanks again!