Spreadsheet-like Entry Data Form Demo
2269 Downloads
If you are new to database modeling or looking for a way to make Access act like Excel, this demo may not be for you. This demo represents a special case of data entry and is in no way a substitution for proper normalization, single form presentation among other things and in all probability will have limited use, if any, for several business models out there.
This database demonstrate how to create a entry form that provides a spreadsheet-like view and live form that can be updated real-time using a bound datasheet form. While this form uses checkboxes, there is no reason why it can't use textboxes or comboboxes, as long as this is a matrix of where each combination of a given row and a given column can only have exactly one value. In other words, no aggregating are actually done. This is useful for users who want to have a 'bird's eye view' and editing multiple records in a junction table representing a many-many relationship in a single form.
The demo is a class attendance record where it is assumed that new classes are created, and attendees registered for a given class are done in a separate forms (not included). The default form will display a selected class with attendees within the registration roster and dates specified for class meetings. All checkboxes are updateable, and new columns can be added for additional sessions. Attendee names are locked and the form will not allow additions, as per the assumptions.
| Category: | Example Forms |
| File Size: | 82 KB |
| File Type: | application/zip |
| Hits: | 8034 Hits |
| Download: | 2269 times |
| Created Date: | 03-12-2016 |
| Last Updated Date: | 03-12-2016 |
Related documents
Author: weAscend Technologies
Link to any MDB or MDE file and view/edit data in tables with an added search feature. (Access 97).
This show how to have a dynamic grid that adjust to the number of fields in the query
It can be updated to Newer vrsions.
This example shows how to use tables to store the all the parts of a document. An exmaple web be for creating contracts.
This example also shows how to use cascading sub forms. This is where two sub forms on hte parent for are linked. The first sub form shows records related to the Parent form's current record.. The second sub fom (on the parent form) shows related records to the current record in the other sub form.
This example shows how to prevent a form from closing except by using a command button. The example is the main menu/switchboard form. Note that this technique can be easily used on any form.
Author: Peter Schroeder
This example (A2K format) contains a module that can be used to reliably center (both horizontally and vertically) a form in the Access Window. There is a very simple demo of how it works, as well. The module itself uses Windows API calls to determine the Access application client area and the dimensions of the form in question, and calculates what the TOP and LEFT settings of the form should be to be centered in the Access window.
To use, simply insert the entire modCenterForm into your own database. It is called as follows:
Code:
Call gfncCenterForm([form])
This demonstration database shows various methods of using the Flex Grid
ActiveX control in an Access 2000 (or later) database. Flex Grid controls can be
used to show data from a table or query on a form in a format which is not possible
using standard Access controls.