Solved

Display contents of a table on a form - MS Access

Posted on 2016-10-24
5
27 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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.

840 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