Document Links 2
6954 Downloads
This is an update to the basic example of how to store the path to a file and also be able to view the file. You can browse using the standards windows common dialog to select the file. You can view the file using the application defined with the Windows File Associations. It uses the ShelExec API to open the file. It does not use the .Followhyperlink method.
This example is a continuous form that could easily be used as a sub form to attach multiple documents to a record.
***** Because it doesn't use the hyperlink data type, this new version stores the path in a way that allows the folder to be easily moved.
| Category: | Example Forms |
| File Size: | 39.29 KB |
| File Type: | application/zip |
| Hits: | 19436 Hits |
| Download: | 6954 times |
| Created Date: | 03-12-2016 |
| Last Updated Date: | 03-12-2016 |
Related documents
This is a demo of how to create shortcut menu bars from table data.
Unlike the shortcuts on normal shortcut menu bars all the shortcuts in the demo are driven by VBA. This allows altering the normal behaviour of the shortcut or creating your own.
In this demo the shortcut menu bar is generated in the On Current even of a continious sub-form. The shortcut menu bar could also be generated in the On Open event but the On Current event would allow modifing the shortcuts on the fly depending on current data in the record.
The shortcut data in the table can be flagged as required or not on a Form by Form basis.
Some of the examples given are: -
Spell check.
Sort ascending.
Sort descending.
Filter by selection.
Remove filter.
Call a public function with control data.
Call a public function with the primary key.
Export the current Sort/Filter selection to Excel, Word, etc.
Call public functions.
Execute hyperlinks.
Basically what this means is that if we can write code to do something then that code can be called from a shortcut.
The attached demo, in Access 2003, has been tested with many regional settings and requires no references.
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.
This is a revision of the Universal Search demo that shows how to search for a list of string values in ALL non-system tables in ALL fields for the current database.
To search for more than one string, enter the values in the text box in comma-delimited format.
These matching records are displayed in a list box. Double click an item in the list box brings up the detail view of the first 11 fields of that table.
Author: Candace Tripp http://www.utterangel.com/