Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Time/date log: Phase 1

Posted on 2013-12-06
9
Medium Priority
?
336 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 1500 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 1500 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

715 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