Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

Time/date log: Phase 1

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
PipMic
Asked:
PipMic
  • 5
  • 4
5 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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
 
PipMicAuthor Commented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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
Industry Leaders: 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!

 
PipMicAuthor Commented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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
 
PipMicAuthor Commented:
Thanks.......phase 1 complete I think...
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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
 
PipMicAuthor Commented:
ooops ....accidentally clicked it thinking it was yours.
0
 
PipMicAuthor Commented:
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.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now