Portland Access User Group
Portland Access User Group Conference September 28-30, 2019
The PAUG Database Designer International conference brings together a wide range of Access developers, consultants, power users and Access enthusiasts. This marks the 21st anniversary of the conference. We will once again be returning to the peaceful and natural surroundings of the Conference Center at Silver Falls State Park, which lends itself to a climate that fosters learning, creativity, and socializing.
Thursday, November 20, 2008
Tuesday, November 18, 2008
Author: A.D. Tejpal
This sample db demonstrates handling of form controls in distinct groups in such a way that actions meant for a given group get performed across all controls belonging to that group, without having to process any loop for tackling individual controls. This functionality is achieved via class module named C_ControlGrps. Grouped controls get assigned to a collection, as instances of this class.
Following styles of grouping are shown - covering two distinct groups in each case:
(a) Permanent grouping via control's tag value assigned at design stage.
(b) Dynamic grouping allowing the user to add / remove controls to any of the groups as desired, at run time.
For current illustration, following actions performed on the groups at run time, are demonstrated:
(a) Manipulation of default values group-wise.
(b) Locking / unlocking of controls group-wise.
(c) Restricting tabbing to a particular group as desired.
(d) Hiding / un-hiding of groups as desired.
(e) Manipulation of back colors group-wise, via slider bars for R/G/B color components.
(f) Special effects - This involves a continuous cycle of smooth transition of shades for the back color, interspersed with periodic swapping of back colors between the two groups.
You can find this sample here: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=438
Monday, November 17, 2008
Author: A.D. Tejpal
This sample db demonstrates an appointments planner featuring audiovisual alarm for events becoming due.
The Planner opens with appointment grid pre-selected for today's date and the cursor moves to current time slot.
If any other date (not older than yesterday) is selected in the Date Picker control, fresh appointment grid for that date is presented (if not already existing).
When put into standby mode, the utility goes into minimized state and keeps scanning the status of scheduled appointments at specified time intervals.
As & when an event becomes due, an audio alarm is sounded accompanied by a pop-up form displaying the current status of various appointments.
The time in advance of an event for sounding the alarm, as well as the frequency of scanning is amenable to customization by the user.
Audio alarm is governed by the *.wav file located in the same folder as that containing the sample db. If it is desired to use a different sound, simply replace this file by the one desired.
The zip file contains two versions (Access 2000 file format), developed as follows -
(a) Access 2002 installed on Windows XP
(b) Access 2000 installed on Windows 98
(a) An activex control named 'Microsoft Date And Time Picker Control' has been used in this database. This control is required to be registered in the access installation on user's computer, before attempting to open & use the sample db.
(b) For registration - file mscomct2.ocx should be available in System32 folder of windows operating system. Open any access database other than this db (even a blank one will do), click Tools -> Activex Controls -> Register. Navigate to the location of above .ocx file and click OK.
Versions - XP & 2K (both in Access 2000 file format)
(a) XP Version -
Visual Basic For Applications
Microsoft Access 10.0 Object Library
Microsoft Office 10.0 Object Library DAO 3.6
(a) 2K Version -
Visual Basic For Applications
Microsoft Access 9.0 Object Library
Microsoft Office 9.0 Object Library DAO 3.6
You can find it here: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=141
Thursday, November 13, 2008
Wednesday, November 12, 2008
Author: Peter Hibbs
This utility program allows you to convert an Excel spreadsheet file which contains 'flat-file' data into one or more tables in an Access database.
The program creates primary and foreign keys in the tables so that 'One to Many' or even 'Many to Many' related tables can be created automatically. You just import the Excel file into the program, create a template which tells the program which columns in the spreadsheet should be copied to which fields in which tables, click a button and the program will extract the data into a series of separate tables which can then be exported to a new database via .csv files.
The program can also be used to create properly 'normalised' tables from data in MS Works or any other database by first exporting the data to an Excel spreadsheet (or .csv file which can then be imported into Excel). Full instructions are included.
This version runs under Access 2000 and Access XP (2002).
You can find the sample here: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=182
Monday, November 10, 2008
Private Sub Form_Error(DataErr As Integer, Response As Integer)
Other errors you can trap:
Limit to List: 2237