Creating scheduling form

I am trying to create a form in Access that incorporates, let's say, 50 stations in our plant. They are stored in a table called Stations. I would like for the user to be able to assign employees to each station, then save, and write all data to another table called Review.

The Stations data displayed on the form is not editable nor does it change from save to save, but it is written to the Review table each time. The employee information comes from an Employees table and consists of combo boxes to write the data into the Review table, along with the correspond Stations record.

I am having trouble wrapping my head around this. I cannot use a sub form as the main form needs to be a continuous-looking form. I cannot use a list box for the Stations as it ends up being too bulky and things can get overlooked easily.
In essence, the main form needs to look like an Excel spreadsheet workbook, more or less: everything on one page, but each record separately editable on the page.

Any ideas would be extremely helpful. I've been looking at this for way too long, and nothing's making sense...lol.
TSUS MISAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
I have an example that may get you started.

Schedule Grid - DesGrid

The company that originally deployed this product no longer supports it. The product has since given it to public domain  soley as an "as is" device. Their information has been stripped out of the attachments and manual. This tool is what it is and is considered "skilled" to "advanced" for level of developer skills to manipulate successfully.

Basically, you're on your own with this one. But it is an excellent portrayal of Access' capabitlies.

 
The download includes both  Access 97 and Access 2000 formats of these two files:

1) Orchid (the demo)

2) DesGrid (the un-altered components)

Each contains a Month-Grid and an Hour-Grid. Also included is a PDF of the Manual.
0
TSUS MISAuthor Commented:
Thanks for the prompt response, but the linked example is overkill for what I'm trying to do.

I simply want to list one table on a form with another table in combo boxes associated with each record of the first table.

Basically, in the attached pic,

Area, Zone, ProcNum, and ProcFunc are all fields in the Station table. Associate is the field in the Employees table. Each line will be written to the Review table with the respective data inserted into the respective data field with an auto-number.
Each line is treated as a separate data entry, but viewed together on the initial data entry form.



Form
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
When you said like a spreadsheet, I took that are you might need something like the grid.

Can you use a form set up like the image you posted?
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

TSUS MISAuthor Commented:
The image is the form that I set up. I just can't get the form to save each line separately with a different Associate choice for each separate line.
I don't want to hardcode the fields to the left, as I want them to be able to change them in the tables if they ever change Processes, Stations, etc.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:

I would like for the user to be able to assign employees to each station, then save, and write all data to another table called Review.

...

I simply want to list one table on a form with another table in combo boxes associated with each record of the first table.

In that case your form will be based on a junction table table that linkes employees and stations.

Station Assignments table:
- StattionAssignmentID - auto number primary key
-StationID - foreign key to link to the Stations table
-EmployeeID - foreign key to link to the Employees table
-DateAssigned - date/time
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
I put together a little example based on your form that may be what you want or at least give you some ideas
Stations.accdb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TSUS MISAuthor Commented:
Thanks, Coach.

What I am trying to do in the format I was trying to do it, got way too complex, so I've switched gears and am scrapping my initial design.
Thanks for all of your help, and I'm giving you the points as your suggestions definitely were helpful.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Glad we could assist.

Good luck with your project.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.