Question Dynamically populating a form...

[Villarreal68]

Hello everyone,

I've been seaching this site for some direction on previous posts, but I have not found what I'm looking for. I figure someone might be able to point me in the right direction.

I posted in the General Forum because I'm not sure where to post it.

I'm working on a scheduling db for security guards. This requires to have shifts, posts, dates, track sick calls, vacations, etc for the scheduling... what I want to do is make it as graphical as possible for the UI.

So what I want to do is create a dynamic form that they can click to add/remove/mark as absent/etc.

This is where I need some direction.
The dynamic form will be populated by selecting a date.
When this date is selected, I would like the form to be populated with all posts for that date. It will have fields to add the eployee next to the post that pertains to that date.
Also if the employee calls in sick, it will have an option to cross him out, but not delete him from that assiged post and date, but it will give me an extra field to enter the "newly" assigned employee to that post to that date.
It will be very GUI and color coded to show what is going on.

I visualize having multiple similar forms, but one would be focused on the posts for a specific employee, another where the focus is on the posts for a specific shift.

As I mentioned, I've never created such form, but I know it's possible. Where do you recommend I do some reading to understand how to create such form. I know it will need some VBA and that is where my weakness is. I'm familiar with the default tools that Access offers, but I have not ventured into the VBA much.

So I would really appreciate it if someone directed me to a sample db in this site with a form that somewhat fits the description or to another site that has a form like that or a site that describes how to create such a form.

I would be so greatfull. Thank you in advance.

René

 

[spikepl]

Not to discourage you as such, but there are sites offering webbased roster/schedule, with mobile access, swapping shifts, tracking sickies & holidays, emails/SMS in/out.... etc etc ...any particular reason why you wish to roll you own?

As to examples, there is a whole section on this forum with samples. Also, google "Access templates" -Microsoft houses many.

 

[Villarreal68]

Hello Spike and Pat,

First thank you for respondig.

Spike,

The reason I was given the task was due to budgeting. Some research was done on some applications, but either cost or "not what we want" was the factor. One big issue with online apps is the fact that the network were this will be used has no Internet link.
I'll do some googling. Thanks!

Pat,
I had not thought/research on doing this with continuous forms and conditional formating. Could you elaborate on this? Thanks!

René

 

[Villarreal68]

Pat,

Thanks for responding. Interesting suggestion. I'm currently looking into that. I think it will work! Thank you!