![]() ![]() The articles themselves can be accessed by the paying subscribers in the relevant issues of Advisor. The following files are the accompanying example MDBs to articles printed in DataBased Advisor publication. Simply a utility form to demonstrate / prove the effectiveness of different methods of retrieving a new Autonumber value in code. Re-establishing a datasheet form's column widths as previously set.Ī slightly convoluted method of keeping two forms displayed records in synchronisation using Class module event sinking.Īnd a simplified variation ( FormsInSyncSub.zip) to sync a detail form and subform for selecting record to display. Maintaining a parent form set of labels above the movable columns of a datasheet subform. Though not very widely applicable, they use concepts which may be of interest.Īn example file showing how to emulate a BeforeCurrent event (when leaving a record) using a bound ADO recordset.Īn example file showing how to include a standard Properties collection in your own custom classes.Īn example use of the MS ActiveX Slider control to select RGB colour. The following files are quite specific implementations of a particular technique. ![]() Unbound or Disconnected data.Ī small example of an unbound form for those unaccustomed to While not comprehensive or clean - it shows the basics of how to achieve it.įor full such control consider a combination of other techniques, e.g. (See also SubformReuse.zip for a more direct example of subform data use.)Ī test bed showing how ADO and DAO recordsets can wrap bound form functionality. Storing Signatures ( Download SigStore.zip)įollowing on from above - adding Stephen Lebans' brilliant Image Class to allow signing/drawing and saving those.ĭemonstration of using a subform's already loaded data to extract values from its rows rather than hitting the database again for information which can be worked out. This is entirely different to OLE format images and doesn't result in db size bloat.Īn example of loading and storing image data using Access internal PictureData format.Īnother way to avoid bloat and allow easy image re-use. (For parsing out multiple criteria with wildcards see SearchParse.zip.)Ī core example of loading and showing files stored as BLOB (Binary Large OBject) data. Some of which are easier to add new search fields as they useĪn iterative method of criteria building. ![]() It includes different ways of making reports fill a pageĪn example report which shows two methods of displaying page total calculations.ĭon't get excited, much of the usual power of reports (grouping, subreports etc) isn't going to happen.įor a simple display list printouts then you can use an unbound report to display data from a recordset.Įxamples of making basic search forms from standard query driven to those using Selections adaptable based upon the current form.Įxample of nav buttons implemented as a subform you can place on any form to acquire the functionality without adding any code.Īn example which extends some methods of report filling provided ![]() Including subform selections with checkboxes, listboxes andĪ very simple little example of how to make your menu or toolbar Shows bound and unbound dialog methods of creating and then displaying a new record.Ī quite comprehensive listing of different methods of selecting Showing three different methods of persisting those multiple instances. The core simple concept of creating multiple instances of a single form. Outlook Email Class ( Download EmailSend.zip)Įxample of creating an Outlook email and sinking an Automation event to determine if it is sent or cancelled. Handles clicking appearance - and you can assign functions toĪ few variations on the theme of allowing combo's in continuousįorms to maintain different rowsources on each row. Application Examples User Interface ExamplesĪ few examples of methods of controlling exiting andĪ single form example of three related methods to limit the rows in combo based on initial characters.Ī quickly implementable class method for using labels as command ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |