Solved

Time/date log: Phase 1

Posted on 2013-12-06
9
284 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
 

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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now