Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Auric
Yak Posting Veteran
70 Posts |
 Posted - 2004-12-04 : 19:46:34
|
| Hey Guys...I am doing a bit of research into creating a Calendar in MS Access to schedule staff. We have 10 employee's, we schedule 2 per/day with an extra as backup. Trying to think of an easy way to use ActiveX Calendar control, and two tables. one table with a list of all employee's and one with the date/who is scheduled. Any hints or idea's would be great. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-04 : 19:50:39
|
| Access has a number of template databases for common functions like this. You might get some ideas from them even if you don't use them outright.You can embed the ActiveX calendar control on the form, but I don't know if you can bind it directly to a field. Access 2003 lets you do it, but earlier versions may not. If not, you'll just have to write a little bit of VB code to do the work. |
 |
|
|
|
|
|
Creating a Calendar/Staff Schedule