Solved

Time/date log: Phase 1

Posted on 2013-12-06
9
334 Views
Last Modified: 2013-12-11
Hi all,

Grateful for some advice.

I am preparing a programme to cater for days taken for leave or other forms of leave.

My initial form A allowed for data to be input for a single day where I would allow for additional comments, whether it was taken In the morning (am) or afternoon (pm) and the type of leave.

I then realised that if additional leave was taken then I would have to enter an additional record, i.e. save the record in the form and then redo the whole thing again for the next day. this was totally inefficient.

I would like to ask if there is a way where I could select the days, say from a calendar or a similar form where I could toggle off the day, include the type and whether it is am or pm so that I could do it all in one go.

Thanks

PS.. I am using A03 at the moment
0
Comment
Question by:PipMic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 375 total points
ID: 39700559
Sure, anything is possible.

For this, you would need to modify your record to include an end date/time.   A nice calendar is here:

http://allenbrowne.com/ser-51.html

It doesn't include the time, but typically one does those as seperate inputs anyway.

You could either develop a seperate time popup based on the calendar above, or simply modify that to include a time selection as well.

Jim.
0
 

Assisted Solution

by:PipMic
PipMic earned 0 total points
ID: 39700696
Hi,

So far so good... I have imported the forms and modules ,created an input form and the dates are being saved in the underlying table.

My next step would be to calculate the number of days which should exclude weekends that fall within. Is there any way I could do this without having to input the number of Saturdays and Sundays that fall within the range?

Thanks
0
 
LVL 58

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 375 total points
ID: 39700729
<<My next step would be to calculate the number of days which should exclude weekends that fall within>>

Lots of code floating around to do that.  here's one such:

http://access.mvps.org/access/datetime/date0006.htm

Jim.
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

Author Comment

by:PipMic
ID: 39700798
Thanks Jim,

one final one.....I have imported it. But quite certain where to run it..should I run in the form itself i.e. should I call up the function in a separate textbox and then save the value in another field in the underlying table?

Thanks
0
 
LVL 58

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 375 total points
ID: 39700811
Good relational design practice is never to store a calculated field.  There are times when you want to break that rule (usually for peformance), but if you can get away with not storing a result in a table, you should.

So, you can either use it in a form directly as a controlsource or as a calculated column in a query.

I usually do the first for entry/editing and the second for inquiry/reporting.

Jim.
0
 

Assisted Solution

by:PipMic
PipMic earned 0 total points
ID: 39700840
Thanks.......phase 1 complete I think...
0
 
LVL 58
ID: 39701025
In the future when closing a question, accept comments only from Experts unless you yourself provided part of the answer.

When you accept one of your own comments as part of the solution, it puts the close on a four day hold.

Jim.
0
 

Author Comment

by:PipMic
ID: 39701122
ooops ....accidentally clicked it thinking it was yours.
0
 

Author Closing Comment

by:PipMic
ID: 39710823
Good advice
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question