Limit to List Combo Box
Posted On 28 Jun 2010 By a.p.r.pillai. Under Combo Boxes.
Combo Boxes on Tables/Forms are for inserting frequently used common values quickly and easily into Data Fields. The Source Data Values of the Combo Box comes from Table or Query. ... Continue Reading
3 Comments
Menus with Option Group Control
We can create cascading Menus with Tab Control and Option Group Controls on Form. Several Menus can be arranged neatly one behind the other and allow the User to make ... Continue Reading
2 Comments
Microsoft Date Time Picker Control
Posted On 14 Feb 2010 By a.p.r.pillai. Under Forms.
We have learned how to use Calendar Control for easy entry of Date Values into Fields on Form through the earlier Article: Animated Floating Calendar. We have used a single Calendar Control for several Date Fields by moving the Calendar Control automatically near the selected Date Field with unfolding animation.
1 Comments
Web Browsing within Access Form
Posted On 28 Dec 2009 By a.p.r.pillai. Under Forms.
Browsing the World Wide Web is nothing new to us. But, how about organizing the Web Addresses of frequently visiting Websites in a Table and browse the Web from within an Access Form?
2 Comments
Form Bookmarks And Data Editing-3
Posted On 08 Nov 2009 By a.p.r.pillai. Under Forms.
This is the continuation of our discussion on the usage of Form Bookmarks to revisit the records which we have already visited earlier. The links to the earlier Articles are given below:
No Comments
Form Bookmarks And Data Editing-2
Posted On 01 Nov 2009 By a.p.r.pillai. Under Forms.
In the first part of this Article, we were using the saved Bookmarks to revisit the earlier visited records one by one to take a second look, if it became necessary, to ascertain the accuracy of edited information.
No Comments
Form Bookmarks and Data Editing
Posted On 25 Oct 2009 By a.p.r.pillai. Under Forms.
You want to edit information on 25 records on the Form randomly. You will open the main data editing Form. Search for the record by entering the Key Value to find (say Employee Code or OrderID Value) in the Find (Ctrl+F) control and edit the record when found on the Form. This procedure is repeated for all 25 records for the first time because you don't have any other choice to find and edit the information.
1 Comments
Filter Function Output In Listbox-2
Last week we have seen the usage of Filter() Function with a simple example and I hope you understood how it works. We have assigned constant values to the Source Array elements directly to keep the VBA Code as simple as possible.
2 Comments
Filter Function output in ListBox
This FILTER is not related to a Query or WHERE clause in SQL or Filter settings on a Form. It is a built-in Function. Its usage is very interesting and it is useful to quickly filter out data from an Array of information through text matching. We will use this Function to search for values across more than one field of data from a Table, extract matched items or mismatch items, as the case may be, and display them in a List Box.
No Comments
Dynamic ListBox ComboBox Contents
How about displaying different Set of un-related Values in a List Box; Values in different column layouts interchangeably? Perhaps, the change over can be with the click of a Button or based on some other action from the User.
No Comments
Microsoft Excel Power in MS-Access
Posted On 07 Aug 2009 By a.p.r.pillai. Under How Tos.
There are times that Microsoft Access Application Users ask for Report Data exported into Excel so that they can work on it and do their own customized analysis. In this case we can create a Macro with the Macro Command OutputTo or Visual Basic Docmd to export the Data from a Table or Query and open the Data in Excel automatically.
3 Comments
Filter by Character and Sort
Search, Find, Filter and Sort operations are necessary to organize data into manageable form so that finding required information becomes easy. We have seen some of these actions through the following earlier Posts Titled:
Find or Filter Data on Form
Filtering Data for different Users
Animating Label on Search Success
2 Comments
MS-Access and Reference Library
Posted On 27 Mar 2009 By a.p.r.pillai. Under Utilities.
We are using several Object Libraries besides the default References Library during the course of developing an Access Database. Microsoft Data Access Objects (DAO), Microsoft ActiveX Data Objects (ADODB), Visual Basic for Application (VBA) and so on. These are essential to create Data Processing Routines in VBA.
No Comments
Inputbox and Simple Menus
Posted On 20 Mar 2009 By a.p.r.pillai. Under Menus and Toolbars.
We have already learned how to create Menus and Toolbars through the following Articles:
Calendar and Toolbars
Custom Menus and Toolbars
Custom Menus and Toolbars-2
1 Comments
Change Form Modes on User Profile
Posted On 13 Mar 2009 By a.p.r.pillai. Under Forms.
We have seen how to define a Pop up Form and how it can be made to appear on a particular position on the Application window, when it is opened. ... Continue Reading
1 Comments
Positioning Pop Up Forms
Posted On 06 Mar 2009 By a.p.r.pillai. Under Forms.
We have seen the Pop up form in action last week in an Article with the Title: Synchronized Floating Pop up Form and I hope you have downloaded the Demo Database as well.
No Comments
Synchronized Floating popup Form
Posted On 27 Feb 2009 By a.p.r.pillai. Under Forms.
This Form is designed specifically for inquiry purposes (not for Data Entry). The Source Data Table has several fields and the information in them can be categorized into different groups for viewing.
1 Comments
Forms and Custom Properties
Posted On 20 Feb 2009 By a.p.r.pillai. Under Forms.
Searching and finding a record in a Form is easy with Edit � -> Find (Ctrl + F) Option on a particular field value. But, this will fetch only the first record even if there are more records matching the same search text. Most of the time we need to find records that matches values in more than one field, like records of Sales Representatives of Northwind Traders located in the City of London.
No Comments
ControlTip Text and Time Delay
Posted On 13 Feb 2009 By a.p.r.pillai. Under Forms.
Most of the Controls on a Form like Command Buttons, Labels, Text-Boxes and others have the Property ControlTip Text. This can be set with a Value of up to a maximum length of 255 characters, either manually during design time or through Visual Basic. The text is displayed when the Mouse Pointer rests on the Control for a few seconds. This is useful to inform the User to do certain action, like Click or Double-Click, on the Control to run a Program or Macro attached to it.
No Comments
External Files List in Hyperlinks
Posted On 06 Feb 2009 By a.p.r.pillai. Under External Links.
Is it possible to display a directory listing of External Files on a Form and open them in their parent applications? Several queries of different kind received through E-mails pointing towards this objective, from Readers of the earlier Article; File Brower in MS-Access (Common Dialog Control).
6 Comments
Combo-Box Column Values
Posted On 30 Jan 2009 By a.p.r.pillai. Under Combo Boxes.
Command Buttons are the most commonly used control on a Form. We have seen them in action in different ways and with different designs. Those who have not come across those Articles before then links to them are given below; you may take a look at them.
2 Comments
