Pull Month/Year/WeekDay from Calendar?

[rubyred77]

I've looked and looked and am afraid that I didn't find this because it's not possible...

The forms in my db are not the clearest, but one way of simplifying it for the users is to have them click on the calendar icon and then have a few fields automatically populate with the selected date's month, another with the year, and another with the day of the week.

Is this possible? I figured out how to have a field populated with the date, but with all of the specific queries needed, I have to do it this way...

Any thoughts? Also, is it at all possible (this is totally separate) to have an icon on the desktop that brings up a login sheet for which the entry users only see the front end, but the db admins log in and see the back end?

Thanks in advance!!
E

 

[RuralGuy]

Have you looked in VBA help:
WeekdayName(), MonthName(), and the Year(date) functions?

 

[The_Doc_Man]

1. There is a thing called a "calendar control" that you could perhaps implement on your form. Once you have a specific date, Rural Guy's answer is spot-on.

2. Regarding your "login sheet" question, I'm not sure you want do to something like that in Access. It would be re-inventing a thoroughly developed wheel called the Windows Event Logger. There are utilities you can buy (Search the web for "Windows Event Viewer Utilities" and similar names to that.) Buy one, use it to export selected elements from your Event Log files.

 

[rubyred77]

Sorry for my ignorance, but what do you mean by VB Help?

I've created the Calendar so you click on a drop down and it populates that field.

I can't for the life of me figure out how to populate other fields with that field's month, year and day of week.

 

[rubyred77]

Sorry for my ignorance, but what do you mean by VB Help?

I've created the Calendar so you click on a drop down and it populates that field.

I can't for the life of me figure out how to populate other fields with that field's month, year and day of week. I'll keep researching but any help or suggestions would be hugely appreciated.

 

[RuralGuy]

VBA help! <ALT> F11, then press F1, then key whatever you want into the Answer Wizard. If you just strike F1 while looking at the Database window you will get Access help, which is different! The solution to your problem is to add code to the AfterUpdate event of the DateControl and the Current event of the form.