Exit with button only HOT!
392 Downloads
There is no need to disable all the title bar control box buttons. Don]t have to trap the shortcut keys to close the active window (ctrl-F4 or Ctrl-w). No need to hide the Access shell or Menu bar/Ribbon
With this simple technique the only way to exit the form is to use the command button to close the form or Task Manager to End Task on MSAccess.exe. Even trying to shut down or reboot Windows will not close it.
[BONUS] It also shows how to hide a button when the front end is compiled (mde/accde).
It is all done with a few lines of simple VBA code.
| Category: | Example Forms |
| Version: | 1.1 |
| File Size: | 16.77 KB |
| File Type: | application/zip |
| Hits: | 15912 Hits |
| Download: | 392 times |
| Created Date: | 03-08-2017 |
| Last Updated Date: | 03-08-2017 |
Related documents
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.
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.
By Candace Tripp (utter:angel) Access 2000 format
This demo shows how to create nice "wipe" effects on a form event (such as form_close) using the Win APIs MoveWindow and GetWindowRect. Effects include: resizing, wipe up/down left/right, shrink/move, and shiver.
By Candace Tripp (utter:angel) Access 2000 format
Demonstrates a method of displaying a picture/image file in a database/formwithout storing the image in a table.