469,946 Members | 1,988 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

Calculating tenure and Using Option Buttons

I have had many questions answered in this forum and I am trusting that one
of the readers may help me find a simple solution.

(1) Using a field called Date_Hired (type: Date/Time), how do I use a label
to display a value that checks the current date, Date() and minus it from
the date hired to show tenure displayed as Years Months Weeks and days ?

(2) How do I use multiple option buttons with only one selected and if so it
stores a value in a table and then allows specific selectable options (it
should be able to show only certain items, depending on which option is
selected and then the user can select from that list and the selectable
stored in the database ?

Thanks for the opportunity to use this forum and I look forward to any
possible solutions ...

Omey

Nov 12 '05 #1
2 3394
Re 1:
See Doug Steele's and Graham Seach's:
A More Complete DateDiff Function
at:
http://members.rogers.com/douglas.j....iff2Dates.html

Re 2:
Create an Option Group, and place the option buttons in the group.
In the AfterUpdate event procedure of the group, set the RowSource of your
list, as described in this article:
http://www.mvps.org/access/forms/frm0028.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Omey Samaroo" <no****@replytogroup.com> wrote in message
news:Bs*********************@news04.bloor.is.net.c able.rogers.com...
I have had many questions answered in this forum and I am trusting that one of the readers may help me find a simple solution.

(1) Using a field called Date_Hired (type: Date/Time), how do I use a label to display a value that checks the current date, Date() and minus it from
the date hired to show tenure displayed as Years Months Weeks and days ?

(2) How do I use multiple option buttons with only one selected and if so it stores a value in a table and then allows specific selectable options (it
should be able to show only certain items, depending on which option is
selected and then the user can select from that list and the selectable
stored in the database ?

Thanks for the opportunity to use this forum and I look forward to any
possible solutions ...

Nov 12 '05 #2
Once again Allen, thanks, you saved me a lot of time.

Omey

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Re 1:
See Doug Steele's and Graham Seach's:
A More Complete DateDiff Function
at:
http://members.rogers.com/douglas.j....iff2Dates.html

Re 2:
Create an Option Group, and place the option buttons in the group.
In the AfterUpdate event procedure of the group, set the RowSource of your
list, as described in this article:
http://www.mvps.org/access/forms/frm0028.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Omey Samaroo" <no****@replytogroup.com> wrote in message
news:Bs*********************@news04.bloor.is.net.c able.rogers.com...
I have had many questions answered in this forum and I am trusting that one
of the readers may help me find a simple solution.

(1) Using a field called Date_Hired (type: Date/Time), how do I use a

label
to display a value that checks the current date, Date() and minus it from the date hired to show tenure displayed as Years Months Weeks and days ?

(2) How do I use multiple option buttons with only one selected and if so it
stores a value in a table and then allows specific selectable options

(it should be able to show only certain items, depending on which option is
selected and then the user can select from that list and the selectable
stored in the database ?

Thanks for the opportunity to use this forum and I look forward to any
possible solutions ...


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Stephen D Cook | last post: by
3 posts views Thread by brian210 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.