Universal Search on many text with details
3172 Downloads
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/
| Category: | Example Forms |
| File Size: | 42.95 KB |
| File Type: | application/zip |
| Hits: | 36407 Hits |
| Download: | 3172 times |
| Created Date: | 03-12-2016 |
| Last Updated Date: | 03-12-2016 |
Related documents
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.
Here's an interesting method of sorting columns in a continuous form. In this case, a subform is used, but the same can be applied to a main form. All the code is behind the form, so there is no need for a regular module.
In the attached Access 97 demo, all this code is in the "sfrmVST" form (a subform).
The first thing to do is to set up each column's title label with a consistant naming convention; "lblxxxxx". Then, each label has a "Tag" property value that contains the name of the 'field' it represents.
There is also another label that is set far to the left of the form. This particular label is special in a couple of ways. First, it's font is set to Marlett and it's visible property is set to "No". The caption of this label is the number "5". It is also important that the label be named: "lblSortIndicator". The "OnClick" event of this label should contain the following code:
Me.lblSortIndicator.Visible = False
Me.OrderBy = ""
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: 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.
The Orders and Developer Solutions sample databases that are included with earlier versions of Microsoft Access were not included with Access 2000.
The Orders and Developer Solutions sample databases for Access 2000 are now available
Orders The Orders sample application is a sample order entry and invoicing system. Its features include the ShowEvents form, which helps you see the order in which events occur when you are working with forms and controls, and custom data filtering capabilities that you can use in addition to the filtering functionality provided by Access. The initial chapters of Microsoft Access 2000: Building Applications with Forms and Reports explain how to build the features shown in the sample application.
Developer Solutions The Developer Solutions sample application contains examples of the forms, reports, and interface elements you most commonly use to create applications. From changing a form’s toolbars in response to events to creating a crosstab report with dynamic column headings, the objects in Developer Solutions illustrate the main areas of application design. This sample application also includes procedures that you might find useful as you develop your own applications—for example, you will find procedures that link tables at startup, close all objects when the user exits the application, and capitalize the first letter of every word in a field.
For more details see: Microsoft Access 2000: Building Applications with Forms and Reports