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: 554
  • Last Modified:

MS Access employee shift registration

Hello experts!

Using Access 2007, I'm trying to make a shiftregistration software.

As you can see underneath, I have a many to many relation between employees and dates. On each shift/date, I register any amount of employees as well as some time variables. Also on each shift I register some shift-specific notes.
Table viewI already made a form including a subform for this purpose - working well as of now. But I have a few concerns...

Here you can see the form containing subform wich displays the current employees registered on the choosen date. In the subform I am able to add and remove employees as well as register different time variables.
Form with subformEach time I have a new shift, I will first have to go to the shifts list and create a new shift/date in order to be able to register employees or notes on that shift. I would much rather like to embed a calendar control, where I can click any date, even if it has been created in the shifts table or not - and when I add my first employee or start writing a note on that date, the shift is automatically added to the shifts table.

How is that possible?

Please let me know, if you need any additional information.

Best regards

/Raahaugen
0
Raahaugen
Asked:
Raahaugen
  • 4
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try this,

add a textbox to your form
set the Format property to Short Date or whatever date format you have
on the same Format tab
set the Show date Picker property to  For Dates

when the textbox got the focus, you will see a calendar control in the right side of the textbox, click on it and it will display the calendar
0
 
RaahaugenAuthor Commented:
Hi capricorn1,

Thanks for your input. Unfortunately it is not what I would like... I would like to use a calendarcontrol that stays on screen.

Also this is not my biggest concern - that is how I can pick any date and start adding employees - without having to go to the shifts table and manually add the date first.

Hopefully you are able to understand what I would like?

Best regards

/Rahaugen
0
 
Rey Obrero (Capricorn1)Commented:
ok.. see if this helps

http://allenbrowne.com/ser-51.html
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
RaahaugenAuthor Commented:
I'm afraid not. The calendar control you are referring to was an addition to access 97 and 2003 - and not really relevant in the 2007 and above versions due to the pop-up calendar you mentioned at first.

I think I will just try making the form from the beginning. I think I messed it up somehow in the process...

If anyone have any additional comments - maybe some good guidance on how to make this subform thing work really good. I can't imagine, no-one has made anything similar before?

Best regards,

Raahaugen
0
 
RaahaugenAuthor Commented:
Hi,

I made up a solution myself. I used VBA to lookup the shifts table to check if the shift already exists - and if not create the shift - before attaching employees to the shift.

Also I used the build in calendar control in MS Access 2007, which did the job.

But thanks anyway!

/Raahaugen
0
 
RaahaugenAuthor Commented:
I figured out the solution myself.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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