Current Date and time in a form when record is created

[haylau]

We are considering switching from MS Access to Excel for a simple (??) time logging system

Using our access database, when a worker starts a new part of a job they go to the computer, grab the barcode scanner. They scan their name, the process the are embarking on (e.g Bending, or threading) they then scan the job number of the job they are working on. A record is then created and the record creation time is automatically added to the record. We use the time to calculate how lon a particular job has been worked on for our costings

So looking at excelI can see we can build a table, and use a form for data entry. So the process is identical- BUT i cannot think how to put the current date and time into the record automatically.

Any ideas? (See screen shot for more details)

https://www.dropbox.com/s/keixdzt5u04drv9/05-02-2019 13-05-47.png

 

[haylau]

That is great thanks. For this line: ws.Cells(newRow, 4).Value = Me.TextBox2.ValueI can change that to ws.Cells(newRow, 4).Value = Now

So then i don't need the "time" box at all. As soon as the record is created that field is updated at the time of record creation without having to "update". Perfect

 

[Logit]

.
Changing the one line of code as you outlined is accurate.

Glad it works as desired.

May I suggest .. if the employees were able to scan the information previously .... not having that ability now will most likely be frustrating to them.
It will seem in their minds the time it takes type the data will be tiresome. A reason to also include the bar scanning which another member has indicated
he can assist with.

Of course if they are not scanning now ... disregard the above.

I'm curious .. how many different PROCESS's ... STAFF ID's ... JOB ID's are there to choose from ?

 

[haylau]

They will still be able to scan. The handheld barcode scanners basically just act like a keyboard as far as excel is concerened.

No, I am more than happy with your solution.

A bigger problem now is what I do with the data after entering. On the database I could do some queries and calculations that would show how long each person worked on each job, and each process of the job. At this stage I am not convinced I can do that with Excel. But having fun trying

 

[Logit]

.
You could add another field for time job complete.