ComboBox trick like on web pages

2660 Downloads

Here is an example of how to make a combo box display text like "Find a Customer" and then when you click the drop down arrow, the text goes away. This is similar to what you see on web pages.

The attached is in 2000 format.  

 

Category: Example Forms
File Size: 34.45 KB
File Type: application/zip
Hits: 18134 Hits
Download: 2660 times
Created Date: 03-12-2016
Last Updated Date: 03-12-2016

Related documents

Schedule Grid - DesGrid
Schedule Grid - DesGrid

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.

Fancy Sort in Continuous Forms
Fancy Sort in Continuous Forms

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 = ""

Peter Hibbs' Flex Grid Demo
Peter Hibbs' Flex Grid Demo

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.

25 Cool Control Tricks
25 Cool Control Tricks

Author: database Creations

 

 

Spreadsheet-like Entry Data Form Demo
Spreadsheet-like Entry Data Form Demo
**** Disclaimer ***

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.
Audit Trail
Audit Trail

By Candace Trip (utter:angel) - Access 2000 format

 

This db demonstrates how to set up an audit trail of changes to the data including ID, Field Name, the field value before it was changed, the field valueafter it was changed, the user who did the change, and the date/time the changewas made.