Solved

Display contents of a table on a form - MS Access

Posted on 2016-10-24
5
22 Views
Last Modified: 2016-11-13
I have an Access database wherein, through a Form with numerous textboxes, “Employee A” enters records that get saved to a table (Employee A’s credentials are also saved to the table to be able to identify who entered the records). In the table, I have a Batch Number field. Let’s say on a given day, in one sitting ‘Employee A’ enters a bunch of records and then finalizes that particular batch by either pressing a “completed” button or by exiting the database.

Eventually, “Employee B” will have to do something with the information contained in the batch records. What (s)he will have to do is independent of anything I’m asking the database to handle.

All I’m looking for the database to do (unless someone has a better idea, which on here seems to always be the case) is to have a form for “Employee B’s” use to display records in a batch or batches (that Employee A entered) and to have a checkbox (or some similar boolean functionality) next to each record that allows “Employee B” to mark or “check-off” the records that (s)he has taken care of so far.  Employee B’s credentials as well as the checkbox information would be the only fields in the original record that could be updated by Employee B.  Employee B cannot tamper with any other fields in the record. Employee B’s only function is to mark or “check-off” the records (originally entered by Employee A) that (s)he has taken care of.

So, the question is:

How do I display the contents of a table in a list format that allows a user to “check-off” any unchecked records and when (s)he does, have the table updated with the “check-off” value and Employee B’s credentials (let’s say UserID and name).

I mentioned ‘display the contents of a table’ directly above because I’m trying to keep my question as short and simple as possible. Ideally on the form for Employee B’s use, I’d like to have a combobox or the like that will list the “open” batches (i.e. batches where all records have not been checked-off yet…meaning Employee B has not addressed all batch records yet).  Employee B would then select the batch (s)he wants to work with from the list and that batch’s contents would be displayed on the form (as opposed to the ENTIRE table’s contents).

Thank you.
0
Comment
Question by:dbfromnewjersey
  • 3
5 Comments
 
LVL 7

Expert Comment

by:COACHMAN99
ID: 41857772
There is a lot going on here but:
1. A tabular (vs columnar)  form will look like a table but provide programmability
2. if you have fields to store check-off value and user in the table then the 'before update' event can assign values to these fields.
3. there are also table macro options to automatically assign values to fields based on table-events
0
 
LVL 19

Expert Comment

by:Eric Sherman
ID: 41857795
I agree with Coachman99 ... Your question is more of a Gig to be honest.  I had to do something similar for a client that needed the ability for users to resolve Time Clock entries that posted to a Suspense table within the Access database from a satellite vehicle resource management system for any one of several reasons.  Each Dispatcher could select the suspense entries that they were resolving and delete it once it was determined the entry was erroneous or if it needed to be added to the Time Clock module for that work day.

Here is the form similar to what you are asking.  Again, you would really need to post this as a Gig so I can get involve with it and customize the concept to fit your needs.  It is not just a one straightforward answer.

ET

Sample1
0
 

Author Comment

by:dbfromnewjersey
ID: 41858592
OK. I'll try to send over a simplified version of what I have so far in a little while and it'll probably be much easier to see what I'm trying to accomplish.  All I'm really trying to do is have 'User A' be the one who enters records.  Then 'User B'  does something outside of the database with those records but uses the database to 'mark' the records (s)he's already taken care of.

So, basically, User B is using the records entered but User A as a 'check-off' list.  Marking the records as they are taken of so (s)he can know which records (that require action) have been 'closed' and which are still open items.  

The concept is simple but I'm sure the programming isn't.
0
 
LVL 7

Accepted Solution

by:
COACHMAN99 earned 500 total points (awarded by participants)
ID: 41858979
Use a 'closed' checkbox (database field) that is disabled unless user-B is logged on (either by a login system or using X=CreateObject("wscript.network").UserName ' returns User Name.
or
UserName = Environ("USERNAME")
0
 
LVL 7

Expert Comment

by:COACHMAN99
ID: 41885212
dormant
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

705 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now