473,386 Members | 1,715 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Defaulting Times in a timesheet

116 100+
I have done a simple datasheet which captures the job events in a shift.

Simply

Title Workcode Start Finish
xxx Waste 16:32 17.00


Basically i am trying to make it so that when the next line is entered it defaults the start time by looking at the last finish time and adding a min. In this case the next start time will show 17:01. that way i will capture all events in a shift. My fields are Date/Time format .
May 25 '10 #1

✓ answered by missinglinq

If you are sitting down and entering one record after the next, without the form being closed between entries, you can use:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Finish_AfterUpdate()
  2.  Start.DefaultValue = """" & DateAdd("n", 1, Me.Finish) & """"
  3. End Sub
Linq ;0)>

7 1379
missinglinq
3,532 Expert 2GB
If you are sitting down and entering one record after the next, without the form being closed between entries, you can use:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Finish_AfterUpdate()
  2.  Start.DefaultValue = """" & DateAdd("n", 1, Me.Finish) & """"
  3. End Sub
Linq ;0)>
May 25 '10 #2
jacc14
116 100+
Hi Thanks for that I will give it a go. However at times the user may log out of the program to do something else as he will keep returning to do this throughout the day.

thanks
Chris
May 26 '10 #3
NeoPa
32,556 Expert Mod 16PB
Hi Christine. Is this an Excel question? It really helps to say so explicitly as many terms are similar and it could be confused for an Access one. Particularly in an Access forum. I believe Linq's suggestion is based on the premise that it's Access related.

We can probably help too, if it's Excel, but we'd need to know before suggesting a solution.
May 26 '10 #4
jacc14
116 100+
Hi there. It is a msaccess problem. sorry i didnt make it clear. Thanks
May 26 '10 #5
jacc14
116 100+
@missinglinq
Thank you for your report. I have tested this and it works a treat.

Best regards
Christine
May 27 '10 #6
NeoPa
32,556 Expert Mod 16PB
No worries Christine. I must have misread it. It might have been a problem if at had been an Excel issue and you hadn't mentioned it
May 27 '10 #7
missinglinq
3,532 Expert 2GB
Glad we could help, Christine!

Linq ;0)>
May 27 '10 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: harsha mogaligundla | last post by:
Dear All , I am trying to develop a web based electronic Timesheet system for the payroll department using ASP and SQL server, the front end has fields like ssn,time -in , tim-out,regular...
4
by: Jyrki Keisala | last post by:
Hi, I have an XML file which I want to present as a HTML table, and I'm looking for a quick way of defaulting all empty elements in my XML file to a nbsp (using the   notation) in my XSL...
2
by: christian | last post by:
I'm creating a Timesheet Database for the employees of my Department. One of my tables is called Fiscalpayperiod and contains: Paysunday, payweek, Date, Day. Pay Sunday Pay week Date Day...
3
by: christian | last post by:
HI, I'm creating a TimeSheet Database for the Employees of my Deparment. One of the Tables is called FiscalPayPeriod and contains the folllowing elements: PaySunday,PayWeek, Date, Day. Pay...
0
by: Redz | last post by:
About SocketTimesheet™ SocketTimeSheet is one of the most practical, affordable and user friendly web-based time tracking software and expenses management system in the market today - it's cheap,...
0
by: wolv0014 | last post by:
I'm tring to create a timesheet to track projects and how long people have been working on those projects. For eah date I want to have at least three project boxes, so on the form it would look...
1
by: LiveTecs | last post by:
http://www.livetecs.com TimeLive Web Collaboration Suite is an integrated suite that allows you to manage project life cycle including tasks, issues, bugs, timesheet, expense, attendance. ...
1
parshupooja
by: parshupooja | last post by:
Hi I am trying to create a timesheet for about 100 users. I want to display spmething like this day date In Out In Out total ...
1
by: architrave | last post by:
I am building a timesheet for my work. Instead of record by record timesheet, I wanted to have a form with 15 unbound fields (pay period) distributed by dates along columns and different projects...
18
Jerry Maiapu
by: Jerry Maiapu | last post by:
I am trying to create a simple clock in clock out (timesheet) in ms access. I have two tables (tblnames for staff names and tbldates for clocking times). tblnames has 2 fields namely...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.