Creating scheduling form

Posted on 2013-09-09
Medium Priority
Last Modified: 2013-09-11
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.
Question by:TSUS MIS
  • 5
  • 3
LVL 21
ID: 39478169
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.

Author Comment

ID: 39478212
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.

LVL 21
ID: 39478241
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?
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.


Author Comment

ID: 39478352
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.
LVL 21
ID: 39478426

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
LVL 21

Accepted Solution

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 2000 total points
ID: 39478454
I put together a little example based on your form that may be what you want or at least give you some ideas

Author Comment

ID: 39485094
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.
LVL 21
ID: 39485768
Glad we could assist.

Good luck with your project.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question