Solved

Time/date log: Phase 1

Posted on 2013-12-06
9
309 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
  • 5
  • 4
9 Comments
 
LVL 57

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 57

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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

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 57

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 57
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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…

809 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