Search results

Yes the subform A would only have a single session start & stop time. But an employee could conceivably open and close the form multiple times a day .. so there could be 4 or more Form Session Time Stamps for the employee for that date. Setting a timer i am unsure of, i don't know enough...

sorry i wasn't terribly clear ... there are actually 2 subforms here. the subform with all the data in it works flawlessly for it's purpose and the time start there is for the time they started the Record ... 400# and the time end there is when they completed the processing OF that record...

Ok .. so .. setting it to data entry worked on one hand but i am struggling with the rest of the story! This particular form i am working on is a continuation of previous entry. I use a query to isolate the worker name and date and ID# then run the form off the query so the worker can...

That works perfectly !!!!!!!!!!!!!!!! I didn't realize it was an option ! I was focused on the main form with the subform in it. When I would choose the subform in properties, it did not give me the option to toggle data entry. After your suggestion, I started to think out side the box...

I was hoping there would be a simple solution ... i will try that !!!! Thank you !

I have a form where we track the work the employee is doing. The main form works well and updates well - however if they close the form and work on something else for a bit then come back and restart working this i need to retain the Main record id and the date (easy enough, a query drives...

I figured it out ! Once they enter the case number - they must go to a webpage and do the document processing - then they mark if it was "complete" , a "problem" or "UTL (Unable to Locate)" so I did the following event for each as only 1 will apply : Private Sub UNcp_AfterUpdate()...

maybe? hoping for a much more direct approach!!

i did try putting the expression =time() (Expression builder) in the event - onexit - ongotfocus - onenter - none of these actually put the time in the field... am I missing some other trigger I need to do ? I am fairly new to Access. I know in general what "kinds of things" a data base can...

They move with TAB from field to field then at End Time TAB starts new line. This is a great example ... did i spend from 12:33 to 14:52 ? 2 hours and 19 min OR did i spend 12:33 - 13:00 - 20 minutes then walk away and RESTART at 14:52?

Currently Start Time = time() then there is data entry ..... End time then they move to the next line and do it again, and again , and again etc. If the start and end time are both the same... it will make calculation of total time harder since i won't have minutes/seconds per line to...

ok .. no record exit ...bummer ... is there a way i can get access to record the time when the user enters the end time field? On focus? I am trying to get away from the user having to key the time ... if i can get the database to give me a stop time - i can then calculate the time between...

I have a form that records time() when the record is started. I would like to have it also record the current time when the record is exited. I need to be able to identify how much time has elapsed from the start of the record to the exit of the record. Start Time =time() how do i get the...

is this VBA code or a Macro ? Very new to access - attempting to open a blank form and have someone select from the combo box to find the record to edit OR if no record matches the value to create a new record.

This was why i thought i missed something in the Combo Box regarding OnCurrent. "select & display (make current) the record matching the combo...." I am learning ... i don't know what i don't know!

correct ... but there are other jobs and other types of tracking that occur. so the Employee file is just an ID# field their name_txt. The individual types of tracking and jobs are all in a unique file ... undm - fs- rsci - etc.... the connection is the employee id in each of the...

ok .. the only place i can find OnCurrent is when i have the Form selected in the property sheet. When i have the combo box selected OnCurrent does not display anywhere in the property sheet. I tried making a new combo box using the wizard and nowhere was i given an option for OnCurrent...

Yes .. the name is selected by combo box drop down. and the date is set to date() since they do this work on a daily basis ... if they enter the form today it is because they are working it today. I am unsure of how to access the Select & Display (make current). I have not seen this...

I have a form that multiple people use - i need to isolate them from each other, so DoCmd.GoToRecord =acLast is not an option because the last record may not have been their record.... if they open the form and begin entry and close the form .. then reopen the form to continue entry it...

the report outcome is what i need. Employee Name Date Total Time Spent (currently employees declare i spent 4 hrs and 30 min today ) Total Processed: 300 the detail is Case # Uploaded Case # UTL (unable to locate) Case # Problems X300...