Access eMail Newsletter

-----Original Message-----
From: Capital PC User Group Board of Directors Communications
[mailto:CPCUGBOD-L  @CPCUG.ORG] On Behalf Of Peg Ireland
Sent: Monday, May 04, 1998 1:35 PM
To: CPCUGBOD-L  @CPCUG.ORG
Subject: Correction to Minutes & tonight's Agenda


I have added Lynne Sturtz to the list of attendees in the Corrected
Minutes for the April 6, 1998 Meeting.

------------------------

CPCUG BOD Meeting             May 4, 1998        Proposed Agenda

1. Agenda Approval

2. Approval of the Minutes of the prior Meeting (April 6, 1998)

3. Officer's Report (brief reports 3 minutes or less)

4. Installation of Treasurer

5. Facilities Report

6. Unfinished Business

7. New Business

8. Good and Welfare (Matters Arising)

9. Adjournment

From:	NANCY M LANDREVILLE [nancyml  @juno.com]
Sent:	Thursday, April 16, 1998 3:46 AM
To:	Rick @CICorp.com
Subject:	Re: FW: Latest Status on 51 Monroe ST PE2

I spoke with Harold Motin of CPCUG (Training Coordinator).  Training for
and at CPCUG has been "put on hold" until perhaps June.  This means all
the scheduled classes that we see in the Monitor are either cancelled or
the instructor may opt to hold the class elsewhere.  Most are cancelled.

Lillian is working on a new site for SIG mtgs., etc.  I will keep you
updated if I hear anything sooner than you do.  

Thank you for forwarding this message to me.

Nancy L>

_____________________________________________________________________
You don't need to buy Internet access to use free Internet e-mail.
Get completely free e-mail from Juno at http://www.juno.com
Or call Juno at (800) 654-JUNO [654-5866]

From:	Barbara Conn [bconn  @cpcug.org]
Sent:	Tuesday, April 07, 1998 10:44 AM
To:	McGinn, Mike
Cc:	Rick Shaddock
Subject:	RE: APC & Cipher Logics at CPCUG


On Tue, 7 Apr 1998, McGinn, Mike wrote:

> > Barbara:
> > 
> > Your previous message included the Access Sig. Is it also at NIH? In
> > Lipsett, Masur, the cafeteria?
> > 
> > 
> > Monday, April 13, 1998, CPCUG Activities
> > ==========================================
> > 
> > 7:00 pm HOW TO BEAT POWER PROBLEMS; APC
> > 8:00 pm SECUREWIN, Security for Your Computers; Cipher Logics
> > 9:15 pm "Late Night"
> > 9:15 pm Access SIG
> > General Meeting                           NIH      FREE

Yes, Access Sig meets in the cafeteria after the General Meeting.
Occasionally its meetings have been canceled--it's probably a good
idea to check with its SIG chair Rick Shaddock if you are planning on
attending your first meeting of Access SIG.  His phone number is
703-486-2222 (d) and e-mail is rick @cicorp.com.

Barbara Conn * bconn  @cpcug.org * http://www.cpcug.org/user/comm/          
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  Director of Corporate Communications * Capital PC User Group    




From:	NANCY M LANDREVILLE [nancyml  @juno.com]
Sent:	Monday, April 06, 1998 10:25 PM
To:	Rick @CICorp.com
Subject:	Re: FW:      Corrected March Minutes

I could not make this meeting after all tonight.  I do have contact with
members of the Board of Directors however,  so I can relay any info. you
may have.  I'll let you know how the new location is.

Nancy L.
    

_____________________________________________________________________
You don't need to buy Internet access to use free Internet e-mail.
Get completely free e-mail from Juno at http://www.juno.com
Or call Juno at (800) 654-JUNO [654-5866]

From:	NANCY M LANDREVILLE [nancyml  @juno.com]
Sent:	Monday, April 06, 1998 10:20 PM
To:	Rick @CICorp.com
Subject:	Re: FW:      ZD Support Service Conference-Expo Apr.19-24

Where is this located?  I try to attend these conferences to keep up with
the technology.  Can you send me a ticket if its within the metro area?

Nancy L.

_____________________________________________________________________
You don't need to buy Internet access to use free Internet e-mail.
Get completely free e-mail from Juno at http://www.juno.com
Or call Juno at (800) 654-JUNO [654-5866]

From:	NANCY M LANDREVILLE [nancyml  @juno.com]
Sent:	Thursday, March 19, 1998 7:45 PM
To:	RShaddock  @telegroup.com
Subject:	Access SIG and Wire

I will represent us via "being there for the Access SIG on April 6 at
9:15pm.  Is there something you need me to cover for you?  Or...bring to
the SIG....???
Are you still holding your Sunday meetings?  2:00pm Crystal???

Nancy L.

_____________________________________________________________________

From:	Yeargin. Michael, , AFAA/DOVS [yeargin  @af.pentagon.mil]
Sent:	Wednesday, March 18, 1998 8:10 AM
To:	'Rick @cicorp.com'
Subject:	No Headers In Multiple Reports on 2nd Pages

Rick,
	I'm a CPCUG member. I wonder if you can help me with a mild
problem. I have a main report with multiple sub-reports. My problem is
that I cannot get the page headers to print on continuous pages when the
information expands to a second page. When I put the headers in the
Report Header it's OK on the 1st page and not there on page 2. When I
put the headers in the page header they do not show up at all. What am I
doing wrong.

Michael Yeargin
w- 703-696-8161
h- 301-218-8247
From:	gmclennan [gmclennan  @smmg.com]
Sent:	Wednesday, March 18, 1998 8:50 AM
To:	Rick @CICorp.com
Subject:	MAAUG

It looks like MAAUG is having second thoughts about linking up with
another user group. They have decided to stay independent.

-- 
George L. McLennan
Strategic Marketing & Management Group
gmclennan  @smmg.com
703-354-9839 (voice)
703-354-1694 (fax)


Thanks.
RickFrom:	Les Squires [lsquires  @wj.WJI.COM]
Sent:	Monday, March 16, 1998 9:38 AM
To:	Rick @CICorp.com
Subject:	  AC398: Access Email Newsletter

---------------------------------------------------------------
Member:      Rick Shaddock, Crystal City Maryland USA
Subs ON/off: ACCE clip FOXP sqlw it vdb WJI
Jobs ON/off: acce actx c++ clip cobol cfusion cryst dbase delph
             dmodel docmgt domino dware edp fox glob it java
             notes novell nt oracle pb perl sqa sqls sqlw syba
             unix vb vdb vconf warp webd webs y2k

---------------------------------------------------------------
Hi again, Rick!

Have you helped spread the word about Access JobsExpress?
Don't wait til the well is dry . . .

Les

-----------------------------------------------------------------------
-----------------------------------------------------------------------
Access Email Newsletter                                     March, 1998
A Service of the World Wide Developer Network             Vol. 6  No. 2
http://www.wji.com/access/homepage.html              ftp.wji.com/access
-----------------------------------------------------------------------
 1. Editor's Note  
 2. Formatting Number Fields When Using DoCmd.TransferText
 3. Maximizing the Amount of Controls on Reports and Forms
 4. The Access Web
 5. Checking Usage on Back-end Database
 6. Allowing Single Subform to Replace Multiple Layered Subforms
 7. Attaching Tables on The Fly
 8. Access to Visual Basic Object Converter ( Version 8.0 )
 9. Sharing Code Dynamically Among Access 97 Apps
10. Using GetSet Functions in Queries
12. Establishing a 'ToDo' Function for Client Viewing
13. Querying Multiple Items in a List Box
14. From the Publisher
-----------------------------------------------------------------------
 1. Editor's Note  
    -------------------------------------------------------------------
    ReplyTo: Phil Denoncourt III, Senior Editor 

    Hello everyone!

    The smells of spring are in the air.  Time to emerge from our 
    keyboards and experience life again.  Before you abandon your 
    winter's work, don't forget to submit the tips and tricks you 
    discovered!

    We've had a lot of great code submitted over the last month.  We 
    love it!  But we need more.  Does anyone have more tips and tricks 
    about replication, security, ODBC direct or other topics that make 
    Access developers wince?

    For those of us who are always looking for another opportunity, make 
    sure you've visited www.wji.com and signed up for the JobsExpress 
    feature.  Tons of opportunities have been advertised through here.

    Thanks for keeping the good content coming.


 2. Formatting Number Fields When Using DoCmd.TransferText
    -----------------------------------------------------------------------
    ReplyTo: Shamil M. Salakhetdinov  
    URL:     http://www.wji.com/access/w0753.html

    Public Function smsTransferText(ByVal vstrTblName As String, _
                    ByVal vstrTransferToFullPath As String, _
                    Optional ByRef rvarDbs As Variant = Nothing, _
                    Optional ByVal vblnUseODBC As Boolean = False) As Boolean
    '*+
    ' Public domain. Written by Shamil Salakhetdinov. DARTS Ltd.,
    '                           St.Petersburg, Russia
    '                           e-mail: shamil  @marta.darts.spb.ru
    '
    ' Abstract:
    '
    ' It seems that MS Access 97 uses current locale settings to round
    ' Double, Single and Currency numbers when data are exported by
    ' DoCmd.TransferText ...
    '
    ' This function wraps up DoCmd.TransferText.  It formats Double,
    ' Single and Currency numbers using field's DecimalPlaces property
    ' creating temporary format and export queries. Then it uses export
    ' query in DoCmd.TransferText to export data into target delimited
    ' text file.
    '
    ' This function also shows different (advanced) code techniques used
    ' to process DAO objects, ODBC datasources and optional arguments.
    '
    '  Note: Single, Double and Currency numbers exported by this
    '  function are enclosed in Text Qualifier chars (usually double
    '  quotes - Asc("""") = 34) - this isn't a problem for MS Access 97
    '  to export them back correctly.
    '
    ' Arguments:
    '
    '  vstrTblName - table name to export
    '  vstrTransferToFullPath - file path to export
    '  rvarDbs - (optional) database object reference of opened 
    '        database, MS Access .mdb file path or ODBC connect string
    '  vblnUseODBC - use linked ODBC datasource if True. Should be 
    '               always true if rvarDbs is ODBC connect string
    '
    ' Returns:
    '
    '   True - if export is OK
    '   False and error message box if export failed
    '
    ' Examples:
    '
    ' smsTransferText "Table1", "c:\daisy\temp\Table1_Acc97.txt"
    '
    ' smsTransferText "Table1", "c:\daisy\temp\Table1_Acc97.txt",Codedb()
    '
    ' smsTransferText "Table1", "c:\daisy\temp\Table1_Acc97.txt", _ 
    '    CodeDB().name
    '
    ' strODBC = "ODBC;DSN=DAISY;DATABASE=DAISY"
    ' smsTransferText "Table1", "c:\daisy\temp\Table1_SQL.txt", _
    '                 strODBC, True
    '
    ' strODBC = "Excel 5.0;HDR=YES;IMEX=2;" & _
    '           "DATABASE=C:\daisy\Temp\Table1.xls;" & _ 
    '           "TABLE=Table1$"
    '
    ' smsTransferText "Table1", _
    '                 "c:\daisy\temp\Table1_XLS.txt", strODBC, True
    '
    ' strODBC = "dBase 5.0;HDR=NO;IMEX=2;" & _
    '           "DATABASE=C:\daisy\Temp;TABLE=Table1#dbf"
    '
    ' smsTransferText "Table1", "c:\daisy\temp\Table1_dBase.txt", _
    '                  strODBC, True
    '
    ' strODBC = "FoxPro 2.0;HDR=NO;IMEX=2;" & _
    '           "DATABASE=C:\daisy\Temp;TABLE=Table1f#dbf"
    '
    ' smsTransferText "Table1", "c:\daisy\temp\Table1_Fox.txt", strODBC, True
    '
    ' strODBC = "HTML Import;HDR=NO;IMEX=2;" & _
    '           "DATABASE=C:\daisy\Temp\Table1.html;TABLE=Table1"
    '
    ' smsTransferText "Table1", "c:\daisy\temp\Table1_HTML.txt", _
    '                  strODBC, True
    '*-

    On Error GoTo smsTransferText_Err
    
    Dim dbs As Database
    Dim dbsCode As Database
    Dim tdf As TableDef
    Dim qdf As QueryDef
    Dim fld As Field
    Dim strTblName As String
    Dim strFormat As String
    Dim intDecPlaces As Integer
    Dim strSqlFormat As String
    Dim strSqlExport As String
    Dim strFormatQryName As String
    Dim strExportQryName As String
    Dim strInDbs As String
    Dim strLinkedTblName As String
    
    If TypeName(rvarDbs) = "Nothing" Then
        Set dbs = CodeDb()
        strInDbs = ";Database=" & dbs.Name
    ElseIf TypeName(rvarDbs) = "Database" Then
        Set dbs = rvarDbs
        strInDbs = ";Database=" & dbs.Name
    Else
        If vblnUseODBC Then
            'Use temporary linked table instead of directly opened 
            'ODBC source
            Set dbs = DBEngine(0).OpenDatabase("ExportDBS", _
                      dbDriverNoPrompt, True, rvarDbs)
            Set dbs = Nothing
            strInDbs = rvarDbs
        Else
            Set dbs = DBEngine(0).OpenDatabase(rvarDbs, , True)
            strInDbs = ";Database=" & dbs.Name
        End If
    End If
    
    Set dbsCode = CodeDb()
    
    strLinkedTblName = ""
    If vblnUseODBC Then
        strLinkedTblName = "zttbl" & vstrTblName & "_ToExport"
        On Error Resume Next
        dbsCode.TableDefs.Delete strLinkedTblName
        On Error GoTo smsTransferText_Err
        Set tdf = dbsCode.CreateTableDef(strLinkedTblName)
        tdf.Connect = rvarDbs
        tdf.SourceTableName = vstrTblName
        dbsCode.TableDefs.Append tdf
    Else
        Set tdf = dbs.TableDefs(vstrTblName)
    End If
    
    strSqlFormat = " select "
    strSqlExport = " select "
    
    For Each fld In tdf.Fields
       strFormat = ""
       
       Select Case fld.Type
        Case dbDouble, dbSingle, dbCurrency:
            On Error Resume Next
            intDecPlaces = fld.Properties("DecimalPlaces")
            If Err <> 0 Then
               strFormat = "General Number"
            Else
               Select Case fld.Properties("DecimalPlaces")
               Case 255: ' Auto
               Case Else: strFormat = "0." & _
                    String(CLng(fld.Properties("DecimalPlaces")),"0")
               End Select
            End If
            On Error GoTo smsTransferText_Err
        
        Case dbGUID:
            strFormat = "GUID"
        Case Else
        End Select
        
        If strFormat = "" Then
            strSqlFormat = strSqlFormat & "[" & fld.Name & "],"
            strSqlExport = strSqlExport & "[" & fld.Name & "],"
        ElseIf strFormat = "GUID" Then
            strSqlFormat = strSqlFormat & """{guid "" & _
                           CStr([" & fld.Name & "]) & ""}""" & _
                           " as [" & fld.Name & "_Formatted],"
            strSqlExport = strSqlExport & "[" & fld.Name & _
                           "_Formatted] as [" & fld.Name & "],"
        Else
            strSqlFormat = strSqlFormat & "Format([" & _
                           fld.Name & "],""" & strFormat & """) _
                           as [" & fld.Name & "_Formatted],"
            strSqlExport = strSqlExport & "[" & fld.Name & _
                           "_Formatted] as [" & fld.Name & "],"
       End If
       Next
    
       'Use temporary linked table instead of 'in' clause
       'strSqlFormat = Left(strSqlFormat, Len(strSqlFormat) - 1) & _
       '             " from [" & vstrTblName & "] in '' [" & strInDbs & "]"
       If vblnUseODBC Then
            strSqlFormat = Left(strSqlFormat, Len(strSqlFormat) - 1) & _
                      " from [" & strLinkedTblName & "]"
       Else
            strSqlFormat = Left(strSqlFormat, Len(strSqlFormat) - 1) & _
                      " from [" & vstrTblName & "]"
       End If
   
       strSqlExport = Left(strSqlExport, Len(strSqlExport) - 1) & _
                      " from [ztqry" & vstrTblName & "_Formatted]"
   
       On Error Resume Next
       strFormatQryName = "ztqry" & vstrTblName & "_Formatted"
       dbsCode.QueryDefs.Delete strFormatQryName
       Set qdf = dbsCode.CreateQueryDef(strFormatQryName, strSqlFormat)
       
       strExportQryName = "ztqry" & vstrTblName & "_ToExport"
       dbsCode.QueryDefs.Delete strExportQryName
       Set qdf = dbsCode.CreateQueryDef(strExportQryName, strSqlExport)
       On Error GoTo smsTransferText_Err
       
       DoCmd.TransferText acExportDelim, , strExportQryName, 
                          vstrTransferToFullPath, True
       
       On Error Resume Next
       dbsCode.QueryDefs.Delete strFormatQryName
       dbsCode.QueryDefs.Delete strExportQryName
       dbsCode.TableDefs.Delete strLinkedTblName
       On Error GoTo smsTransferText_Err
       smsTransferText = True

    smsTransferText_Exit:
        Set fld = Nothing
        Set tdf = Nothing
        Set qdf = Nothing
        Set dbs = Nothing
        Set dbsCode = Nothing
        
        Exit Function
    smsTransferText_Err:
        MsgBox "smsTransferText: " & Err & _
               " - " & Err.Description, vbOKOnly
        smsTransferText = False
        Resume smsTransferText_Exit
    End Function


 3. Maximizing the Amount of Controls on Reports and Forms
    -----------------------------------------------------------------------
    ReplyTo: Michael M. Myers  
    URL:     http://www.wji.com/access/w0710.html

    A report or form is limited to a maximum amount of 754 controls. My 
    report had 220 visible controls. However, I had created the report 
    by cutting and copying columns of textboxes to a temporary report, 
    using Speed Ferret to rename and update various textbox properties, 
    and copying the changes back into my report. In the process I had 
    cut and copied numerous groups of textboxes in and out of the 
    report.

    Apparently, when you cut an control from a report, it does not 
    reduce the count of controls. So even though the actual count of 
    current controls in the controls collection was 220, the hidden 
    count was much greater -- I had exceeded the 754 control limit!

    To resolve the problem, I copied the controls and code to a new and 
    empty report with a different name, deleted the report, 
    repaired/compacted the database, and renamed the temporary report to 
    the original report name.  The 754 control limit also applies to 
    forms.


 4. The Access Web
    -----------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w0751.html
    URL:     http://home.att.net/~dashish"       //-The Access Web

    The Access Web is a great web site that I often recommend to Access 
    developers.  

    After a long history of responding to questions on Access 
    newsgroups, Dev Ashish, of AT&T's Applied Technology Labs in New 
    Jersey, has put together a website that contains an FAQ for Access.  

    The site is broken into sections dealing with bugs, tables, queries, 
    forms, reports, macros, modules, strings, APIs, date/time routines, 
    and a page of essential downloads.


 5. Checking Usage on Back-end Database
    -----------------------------------------------------------------------
    ReplyTo: Stefan Gotojuch  
    URL:     http://www.wji.com/access/w0747.html
    Access Versions: All

    As administrator of multi-user database applications, you need a way 
    to check if all users are logged out of shared data.  Only then can 
    you exclusively lock data and perform backups or correct an errors 
    in the system.

    I assume that all administrators warn all users about the fact that 
    they should log-off (for instance by hidden startup form method 
    described widely), but still it's necessary to check the usage.

    It's possible to check usage using the .LDB file, which contains 
    locking information for the corresponding .MDB file and is always 
    placed in same folder with .MDB.

    In ACCESS 2.0:

    The .LDB file is created when .MDB is first opened and remains even 
    if the .MDB is closed. If you delete .LDB, it will be recreated by 
    the engine while accessing .MDB the next time. If the front-end 
    application contains attached (linked) tables from a back-end shared 
    database, it's possible to delete .LDB.  It will be recreated only 
    when somebody needs data from the .MDB (in Edit or in Read-only 
    mode). Trying to delete .LDB when .MDB is in use generates error.

    In ACCESS 97:

    The .LDB file is created when .MDB is opened, but it's removed when 
    .MDB is closed. In the case of the front-end application with linked 
    tables, it's possible to delete .LDB file if .MDB is not in use, but 
    the engine recreates it automatically.

    The simple procedure below demonstrates how to get codes which can 
    be interpreted afterwards as: 

        x2=-1   .LDB successfully deleted, therefore .MDB not in use
        x2=53   .LDB doesn't exist, therefore .MDB not in use
        x2=75   sharing violation, therefore .MDB still in use


    ' Procedure works with both Access 2.0 and Access 97
    ' --------------------------------------------------

    Function x2 (mpath As String) As Integer  'mpath=path to .MDB file
      x2 = -1                           'set default value of x2
           
     On Error GoTo err_x2
      Dim lpath As String, x As String  'lpath=path to .LDB file associated
                                        ' with mpath .MDB
      lpath = Left(mpath, InStr(1, mpath, ".")) + "ldb"
        
      x = Dir(lpath)                     'Test for valid file, if not,
                                         ' then err=53
      Kill lpath                         'Test for access, if not,
                                         ' then err=75
     g_o:  On Error GoTo 0
           Exit Function
           
     err_x2: x2 = Err                    'set value of x2 as Err so you
                                         ' will know what happened
             Resume g_o
           
    End Function


    I know that this method is not very elegant, but works properly.  If 
    you need more elegant method to check if .MDB is in use, then look 
    at the WhosOn() Database by Mark Nally mailto:mnally  @hartec.com.au
    published on ATTAC's web page:  
          http://ourworld.compuserve.com/homepages/attac-cg/" 
    

 6. Allowing Single Subform to Replace Multiple Layered Subforms
    -----------------------------------------------------------------------
    ReplyTo: Robert S. Ruder  
    URL:     http://www.wji.com/access/w0696.html

    I developed a dynamic interface that relied on an underlying table 
    to display a subform. 

    As a consultant, my partner keeps a custom built contact manager of 
    information about clients and the activities that surround them 
    including e-mails, tasks, faxes, computer equipment, etc.  When he 
    saw my dynamic form, he asked whether it would be possible to have a 
    dynamic subform which would display record content by type, but in a 
    consistent format so that the same subform could be used no matter 
    what summary records were to be displayed. The reasoning was that 
    this would allow for a single subform to replace the multiple 
    layered subforms or multiple form interface he was currently using.

    I realized that the process was even more simple than my system 
    tables approach. Not only that, but I could offer a reference which 
    would allow the user to double click on a record and jump directly 
    to a detail form which would represent a more complete data record.

    What follows is a description of how that process can be implemented 
    with just one line of line of code per option that you want 
    displayed.

    Step 1: Develop the Subform Concept.

    The subform is going to represent a synopsis of the data record that 
    you want to have linked to a more complete detail form. The key to 
    this synopsis is that it should contain the same number of displayed 
    fields for all the underlying tables that will be used.

    For example, I might decide that all the tables I deal with can 
    display for me the following information: Date, Description, Value. 
    I will create a subform using the following SQL Statement as its 
    RecordSource:

    "Select '' as Date, '' as Description, '' as Value from Table1".  

    This will collect blank record values from Table1 but will give me 
    the field names that I want to use to create the subform.

    Set the properties of the subform to display the subform as a 
    datasheet.


    Step 2: Define the complete SQL Statement.

    The key to this idea is that though the subform may only display 3 
    fields its RecordSource may contain additional useful pieces of 
    information, including a Primary Key value and the name of a subform 
    in which the full detail record can be displayed. Based on this, you 
    simply need to plan the basic outline of the SQL statement that will 
    satisfy the needs of the subform.

    For my example above, I would create a template SQL Statement like 
    the following:

    "Select  as Date,  as Description,  as _ 
    Value,  as PK, '' as DisplayForm From 
    "

    For each table that I want to display summary records for, all I 
    have to do is insert the appropriate field names and table name into 
    my template.


    Step 3: Create Buttons to modify the RecordSource Property of the 
    subform.

    For each possible table that you want to display, you only need to 
    take your template SQL statement and assign the statement to the 
    RecordSource property of the subform control. A sample Button might 
    look like this:

    Sub Btn1_OnClick ( )
      Me![SubfrmCtrl].Forms.RecordSource = "Select [LDate] as Date, _
      [Desc] as Description, [Cost] as Value, [ID] as PK, 'ProdFrm' _
      as DisplayForm From Products"
    End Sub

    For each table that you want displayed in the subform, create a 
    button and copy/modify.


 7. Attaching Tables on The Fly
    -----------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w0697.html
    Access Version: 8.0
    Keywords: ATTACH, UNC
    ftp://ftp.wji.com/access/fsiattac.zip
    Download fsiATTAC.ZIP (12,892)

    Editor's Note.  Steal This Code!!

    Need to programmatically attach and remove tables? Or to attach 
    tables using the Universal Naming Convention (UNC)?

    This routine connects a table to a file server without mapping the 
    drive in Access 2.0. It can be Upsized to any flavor of Access.  Or 
    you can use it to attach locally.

    I use it to "roll through" a Table of Table names and attach them on 
    the fly. Grab the associated file fsiAttach.mdb from the ZIP file 
    available on this page to see it work.

    Function ConnectTable (sMdb, sTableName, sAsName) As Integer
    ' Call using ConnectTable("\\redserver\red-c\data\data.mdb",
    '"tblEmployees","tblEmployees")
        Dim ws As WorkSpace, db As Database
        Dim tDef As TableDef
        Dim i As Integer
        Dim ReturnValue As Integer
           
    ReturnValue = False
    On Error Resume Next
     If isFile(sMdb) Then                  ' the MDB file is here
        Set ws = DBengine.WorkSpaces(0)    ' Get default workspace.
        Set db = ws.Databases(0)           ' Get current database.
        Set tDef = db.CreateTableDef(sAsName)
        tDef.Connect = ";DATABASE=" & sMdb
        tDef.SourceTableName = sTableName
        db.TableDefs.Append tDef           ' Attach table.
        'check to see that it is here. 
        ReturnValue = IsTable(sAsName)
      Else
       MsgBox "File " & sMdb & " not found", 64, "Application Note"
       ReturnValue = False
      End If
      ws.Close
      ConnectTable = ReturnValue
    End Function


 8. Access to Visual Basic Object Converter ( Version 8.0 )
    -----------------------------------------------------------------------
    ReplyTo:  Lennox F. Chambers  
    URL:      http://www.wji.com/access/w7481.html
    Versions: 7.0, 8.0
    Keywords: CONVERTER ACCESS VB
    ftp:      ftp.wji.com/access/objconve.zip //-OBJCONVE.ZIP (138,673)
    ftp:      ftp.wji.com/access/conform.zip" //-CONFORM.ZIP (239,019)

    Object Converter is a Microsoft Access 97/8 Add-In utility that 
    rapidly converts Access Forms and Code, Controls (including a number 
    of ActiveX Custom Controls like the Microsoft Windows Common 
    Controls and the Common Dialog Control), Macros, Code and Class 
    Modules to Visual Basic Forms and Projects.

    Object Converter saves a great deal of time when porting selected 
    Forms, Macros and Code Modules, or entire Access applications to 
    Visual Basic.

    There is no need to copy and paste code from Access to VB and re-
    design Forms from scratch.  Converted Forms and Code will run 
    immediately in either the Visual Basic version 5.0 or 4.0 32-bit 
    environments.  


 9. Sharing Code Dynamically Among Access 97 Apps
    -----------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9443.html

    Want to share code dynamically among Access 97 Applications?

    It's really easy. All you have to do is set a reference to an 
    existing MDB, MDA or MDE file!  Yeah, really that's all there is to 
    it. (It's amazing what you can learn from the help file!)

    Just remember that when you set a reference, Access uses the first 
    referenced item it finds, if two functions or subs have the same 
    name. You can explicitly call a function using the MyMdb.MyFunction.

    If you want to learn how to do it the right way through VB 5.0 
    ActiveX DLLs, drop in at http://www.foursquare.com/dll_demo for my 
    presentation to the Boston Access User Group in February, 1998.


10. Using GetSet Functions in Queries
    -----------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9442.html

    Editor's Note. Steal this code!!

    I had a problem where I had to run a series of reports and forms 
    with a predefined BusinessUnit. I didn't want it to change till I 
    said so.

    The solution was to define a function that allows you to 'Set or 
    Get' the value you need and include that function as criteria in all 
    youR queries that are used for reports or forms. (Use the like 
    operator to get the a wildcard match.)

    It's easy in Access 97, and you can hack out something like it in 
    Access 2.0 if you change the optional parameter to test IfNull()

  
    Function BusinessUnit(Optional Bu) As String

    'Note this is a STATIC so it will remember its value between runs
    Static sBu As String

    On Error Resume Next

       'If you don't assign a new Business Unit you'll get the last one
         If Not IsMissing(Bu) Then
          sBu = Bu
         End If

        If IfNull(sBu) Then
        'This returns a wild card so that all Business Units will match
         sBu = "*"
        End If

         BusinessUnit = sBu  'return the current value.
    End Function


12. Establishing a 'ToDo' Function for Client Viewing
    -----------------------------------------------------------------------
    ReplyTo: Stefan Daxenbichler  
    URL:     http://www.wji.com/access/w9435.html

    If you are a chaotic programmer like me, you will probably know this 
    situation:

    While working on a larger Access project there are situations where 
    some of the code you are writing can't be completed because it 
    relies on things yet to be implemented. (Or you are to lazy at the 
    time).  Then you forget this code because it's not essential, or 
    only called in special situations.

    When the customer tries to use this 'feature' that you forgot to 
    finish, one of the following things will happen (add your favorite 
    to this list):

    o nothing at all
    o the program crashes, or
    o nothing at all except many beeps and weird messages from test
      code you wrote.

    To overcome this, I wrote a VERY simple, but helpful function called 
    'The ToDo function':

    Function ToDo(Optional Description As String)
        MsgBox "Not implemented. @ @" & Description, vbInformation
    End Function

    You can use it in Code or as event handler on forms. This has two 
    advantages:

    o  Your Customers get a proper message
    o  You can search your whole for "ToDo" to find unfinished parts


13. Querying Multiple Items in a List Box
    -----------------------------------------------------------------------
    ReplyTo: Farid Ahmad  
    URL:     http://www.wji.com/access/w9381.html
    Version: 97

    The 'In' clause is used in a SQL query to include records that have 
    a field value matching a list, e.g. suppose you have a Customers 
    data base with a field called City, then the following SQL segment 
    will pull records from three cities:
            
       SELECT * from Customers WHERE city IN ("rome, paris, tokyo").
       
    The trick is to construct a query with the IN clause based on 
    multiple selections in a list box. By setting the multiple-select 
    property of list boxes on the property sheet, it is possible to let 
    the user select multiple items, but getting these selections into a 
    query needs more work. Suppose you are working with the above 
    customers database, and you have a form called Input. On this form, 
    the user can select any number of cities from a list box, and then 
    press a command button to preview or print the resulting report. 

    To achieve this, first create a list box called Cities, and set its 
    Allow Multiple Select property. Now create a text box called 
    CitiesText anywhere on the form and make it invisible. Then include 
    the following code in the ON_UPDATE event of the Cities list box:

    Private Sub Cities_AfterUpdate()
      Dim varitem As Variant
      Dim strList As String
        strList = ""
        With Me!Cities
           For Each varitem In .ItemsSelected
               strList = strList & str(.Column(0, varitem)) & ","
           Next varitem
           If Len(strList) > 0 Then
                strList = Left$(strList, Len(strList) - 1)
           End If
           Me!CitiesText = strList
        End With
    End Sub
           
    This will construct a comma delimited string from the items selected 
    in the Cities listbox, and place it in the CitiesText text box.  
       
    You can now construct a query based on the above string by using the 
    following code:
       
    FUNCTION cityquery
    str = "(" & [Forms]![input].[CitiesText] & ")"
    cityquery = "SELECT * from Customers  WHERE Customers.City In " & str 
    END FUNCTION
       
    Finally make the cityquery( ) function the data source of the your 
    report.  One way to do this is to insert the following into the 
    ON_OPEN event of the report:

    Private Sub Report_Open(Cancel As Integer)
    Me.RecordSource = cityquery()
    End Sub
       

14. From the Publisher
    -------------------------------------------------------------------
    The Access Email Newsletter is created and distributed compliments 
    of the World Wide Developer Network (WWDN) of Boston, Massachusetts, 
    USA.  Come, get involved!  This is the place where developers talk 
    to developers as peers.

    Publisher:
        Les Squires 
        Word Jenny, Inc.
        400 West Cummings Park, Woburn (Boston), Massachusetts USA   
        781-935-1520

    Editors/Content Specialists
        Phil Denoncourt III 
        Pat Tormey          
        Brendan Donovan     

    Website:  http://www.wji.com/access/homepage.html
  
    Address Changes:
        Send an email USING YOUR OLD ADDRESS.
        Indicate New Address.
    
    Adding Subscribers to Mailing List:
        Send Email to access  @WJI.Com.
        Include String ACCESS-YES in Subject: or Body of Message.
    
    Deleting Subscribers:
        Send Email to Access  @WJI.Com.
        Include String ACCESS-NO in Subject: or Body of Message.
    
    Retrieving Back Issues and General Downloads:
         FTP to ftp.wji.com.
         Login as FTP.
         Use your ID as your password.
         cd access
         Copy back issues and downloads as they become available.
    
(c) 1998 World Wide Developer Network (WWDN)
From:	Charles Racoosin [racooscm  @erols.com]
Sent:	Saturday, March 07, 1998 8:46 PM
To:	rick @cicorp.com
Subject:	From: TJ Racoosin - What day does SIG meet?

When is the next meeting for the SIG

9 Mar at 9:15 ?

Thanks!
TJ

From:	Capital PC User Group Board of Directors Communications [CPCUGBOD-L  @CPCUG.ORG] on behalf of Clifford Porter [chp2 @EROLS.COM]
Sent:	Sunday, March 01, 1998 8:29 PM
To:	CPCUGBOD-L @CPCUG.ORG
Subject:	     Feb. 1998 Board Phone List

CAPITAL PC USER GROUP BOARD OF DIRECTORS
February 28th,  1998
Telephone List of Officers and SIG Contacts

* = not for public use
D = Weekdays
? = not confirmed
E/W = Evenings and Weekends

JANE BENSON
RESTON SIG
D (703)715-1032
E/W (703)715-1032
Fax (703)715-8455
jbenson @shirenet.com

MARY BROSNAN
ELECTRONIC PUBLISHING SIG
D /E/W (703)207-0477 or 800-609-2214
Fax (703)207-0479
cameronprs @aol.com

JACK CARLSON
SENIOR SIG
D (301)286-7140
E/W (301)474-7091

ROBERT CLEMENZI
PARADOX SIG
D (703)827-2365
E (703)791-5747
clemenzi @cpcug.org

BARBARA CONN
CORPORATE COMMUNICATIONS DIRECTOR
MONITOR EDITOR/PUBLISHER
D (202)508-1494
E/W (202)452-7484
Fax (202)508-3698
bconn @cpcug.org

BRUCE COTTOM
PROJECT MANAGEMENT SIG
E/W (301)869-5690
bcottom @cpcug.org

BILL DEROCHE
MEDICAL COMPUTING DIRECTOR
D (202)283-5237
E/W (301)530-9699
wderoche @cpcug.org

CHIP DODGE
BUILD OR BUY; BUYING GROUP DIRECTOR
D* (703)767-3619
E/W (703)425-7038
cdodgemd @aol.com

STAN DOORE
PAST PRESIDENT
D (301)572-4939
E/W (301)572-4939
Fax (301)572-9165
stan.doore @mix.cpcug.org

ANN DORSEY
LIBRARY SERVICES DIRECTOR
D (301)320-7984
E/W (301)320-7984
abdorsey @cpcug.org

DAVID DRAZIN
AUTOCAD SIG
D* (202)529-7474
E/W (301)279-7593
Fax (202)529-0332

GEORGE ELY
PUBLIC RELATIONS DIRECTOR
D (301)762-3002
E/W (301)762-3002
gely @cpcug.org

HERB FREDRICKSEN
MARYLAND VICE PRESIDENT; GEOWORKS SIG
D (301)840-2056
E/W (301)840-2056
Fax (301)840-2056 (call first)
herb.fredricksen @mix.cpcug.org

LUIS GARCIA
VIRGINIA VICE PRESIDENT
D (301)457-1451
E/W (703)425-6902
Fax (301)457-3033
lgarcia @census.gov (work)

GABE GOLDBERG
INTERNET SIG
(703)941-1657
Fax (703)941-1791
gabe @acm.org

CHARLES HALLAHAN
STATISTICS SIG
D* (202)694-5051
E/W (703)532-2930
Fax (202)694-5718
hallahan @econ.ag.gov

WALTER HOUSER
SCIENCE FAIR COORDINATOR; HTML SIG
D (202)273-8012
E/W (301)299-0593
Fax (202)273-8159
houser @cpcug.org (At work)

CAROL HYATT
K-12 EDUCATION DIRECTOR
D (301)948-3748
E/W (301)948-3748
chyatt @mindspring.com



PEGGY IRELAND
PROGRAM DIRECTOR
D (301)423-1618
E/W (301)423-1618
Fax (301)423-3488
ireland @cpcug.org

PEGGY KAUDERS
pkauders @erols.com

JERRY LAWSON
TRAINING DIRECTOR
E/W (703)541-0928
virtual @mindspring.com

LES LE VINE
WORDPERFECT SIG / BEGINNERS SIG
D (301)652-2532
E/W (301)652-2532
les.le.vine @mix.cpcug.org

BILL LUTZ
BALTIMORE SIG
D (410)256-9403
E/W (410)256-9403
wllutz @aol.com

PETER MAHER
SALES FORCE AUTOMATION SIG
D/E/W (703)834-3706
Fax (703)834-3707
1stplace @crosslink.net

RICHARD MALEY
DELPHI SIG
D (301)840-1554
E/W (301)840-1554
75127.17 @compuserve.com

LARRY MCGOLDRICK
INTERNET SERVICES DIRECTOR
larrym @cpcug.org

KEVIN MCCRORY
OS/2 SIG
kmccrory @mnsinc.com


PATRICK MCVEIGH
TREASURER; WINDOWS SIG
E/W (301)963-7304
pmcveigh @cpcug.org

LILLIAN MILLINER
PRESIDENT
D (301)933-1717
E/W (301)963-9053
Fax (301)963-9386
milliner @cpcug.org

HENRY NOBLE
CORPORATE INFORMATION SYSTEMS DIRECTOR
D (301)963-3737
E/W (301)963-3737
noble @cpcug.org

ALTA OBEN
MetroMUG SIG
D* (703)613-7581
E/W (703)938-5831
Fax (703)938-5831 (call first)
alta @cpcug.org

CLIFFORD PORTER (MRS.)
INTERIM SECRETARY
D/E/W (301)762-9480
chp2 @erols.com

RICHARD PRICE
OS/2 SIG
D/E/W (202)462-3047
richard_price @compuserve.com



BILL REDISCH
FRAMEWORK SIG
D (301)286-6203
E/W (301)279-7929
bill.redisch @gsfc.nasa.gov

NORMAN RISCH
PEACHTREE SIG
D (301)681-8088
E/W (301)754-0735
norman.risch @mix.cpcug.org

ROY ROSFELD
LEISURE WORLD SIG
D (301)598-2825
E/W (301)598-2825
rosfeld @hot.mail.com

NASEEM F. SAAB
CLIPPER SIG
D (703)860-5022
Fax (703)264-1345
nsaab @ix.netcom.com

RICH SCHINNELL
FIRST VICE PRESIDENT
D (301) 949-9292
E/W (301)949-9292
Fax (301)949-8847
schinnel @cpcug.org

RICK SHADDOCK
ACCESS (MICROSOFT) SIG
D(703)486-2222 or (202)829-4444
rick @cicorp.com

PAUL SHAPIRO
DIRECTOR OF VOLUNTEERS
D (301)770-7899
E/W 9am-9pm (301)770-9512
pauls @cpcug.org  or pauls @capaccess.org

A. GREG SMITH
PAST PRESIDENT
gsmith @mail.thuntek.net



RANDY STEER
CAPITAL AREA VICE PRESIDENT
D (202)395-3164
E/W (202)745-5932
Fax (202)395-3165
r_steer @cpcug.org

PAT STINGLEY
JAVA SIG (Provisional 2/5/98)
D/E/W (301)587-7605
stingley @cpcug.org

RENE THIRION
COMMUNITY SERVICES DIRECTOR / MIX SYSOP
D/E/W (703)256-6764
rene @cpcug.org

ANDY THOMPSON
INVESTMENT SIG
D* (202)529-3330
E/W (301)270-6790
Fax (202)529-0911
pallotti01 @aol.com

HARLEY WILBUR
INVESTMENT SIG
D (301)949-8131
hwilbur @cpcug.org

STEVE WORKINGS
ALPHA SIG
D/E/W (301)933-3832
Fax (301)933-4161
steve @workings.com


RUBEN WORRELL
PROJECT MANAGEMENT AND VISUAL BASIC SIG;
D(703)276-3000
E/W pager (202)490-0166
Fax (703)276-3017
worrellr @cpcug.org

C. PATRICK ZILLIACUS
OS/2 SIG
E/W (301)384-0972
Fax* (301)384-1740
patrick.zilliacus @mix.cpcug.org
From:	Laurie Pollack [laurie @pimusa.com]
Sent:	Friday, February 27, 1998 9:27 AM
To:	rick @cicorp.com
Subject:	MS Access: Philadelphia

I saw your email address on the Washington area Access interest group
page.
I actually am in the Philadelphia area, and was wondering if you know of
any
Access interest groups in my area, or if not, of any Access programmers
or
companies specializing in or using Access, in my area.

I am an Access programmer, and am interested in networking locally.

Sincerely yours,

Laurie Pollack

P.S. my home email address is: lioness1 @prodigy.net

From:	Rick @CICorp.com
Sent:	Thursday, February 26, 1998 12:57 PM
To:	AppAlt @AOL.com
Cc:	C I Corporation
Subject:	CPCUG Access SIG meeting

Thank you for your interest in the Capital PC Users Group and the
Access Special Interest Group (SIG).

The CPCUG Access SIG is now meeting after the main meeting instead of separately.  We are also considering merging with the Mid-Atlantic Access Users Group.  

Here is some information.

Access Special Interest Group
Meets after main meeting of CPCUG
(See above)
The CPCUG Access SIG presently meets for question & answer (& snacks) at the NIH caferia immediately after the main meeting. We also try to answer at least 10 questions as a group from the computer based multiple choice practice test for the Microsoft Access Certified Professional Examination. We discuss why each answer is or is not correct, and always end up learning something new.

Mid-Atlantic Access Users Group (MAAUG)
Meets 3rd Tuesday of each month at 7:00pm
National Association Social Workers
(next to Union Station Metro)
750 1st Street NE
Suite 700
Washington, DC
The Mid-Atlantic Access User Group (MAAUG), has been in operation for about three years. Guest speakers include Luke Chung of FMS and Andrew Coupe of the Microsoft Access development team. The CPCUG and MAAUG have a mix of members ranging from novices to a number of very experienced programmers. 
Contact: Bruce Troutman 800-918-5670From:	NANCY M LANDREVILLE [nancyml @juno.com]
Sent:	Thursday, February 26, 1998 7:20 AM
To:	rick @cicorp.com
Subject:	New Site

Any requests about viewing the new site, handling the April meeting,
etc.?

I will be on travel starting Friday.  Please RSVP EMail's.  Thanks!

Nancy L.

_____________________________________________________________________
You don't need to buy Internet access to use free Internet e-mail.
Get completely free e-mail from Juno at http://www.juno.com
Or call Juno at (800) 654-JUNO [654-5866]

From:	NANCY M LANDREVILLE [nancyml @juno.com]
Sent:	Thursday, February 26, 1998 7:08 AM
To:	Rick @CICorp.com
Subject:	Re: FW:      News from the Office

Twinbrook is walking distance from my home.  I live on Twinbrook Pkwy.
Nancy L.

_____________________________________________________________________
You don't need to buy Internet access to use free Internet e-mail.
Get completely free e-mail from Juno at http://www.juno.com
Or call Juno at (800) 654-JUNO [654-5866]

From:	Rick @CICorp.com
Sent:	Wednesday, February 25, 1998 11:52 AM
To:	gmclennan @smmg.com
Subject:	RE: Access meeting

No problem.  I was also unable to attend.  We'll get cranked up for March 17th.
Feel free to call on Nancy @CICorp.com or Nick @CICorp.com if you need a hand.

Thanks,
Rick

> -----Original Message-----
> From: gmclennan [mailto:gmclennan @smmg.com]
> Sent: February 25, 1998 9:57 AM
> To: Rick @CICorp.com
> Subject: Re: Access meeting
> 
> Unfortunately, after all that preparation and getting everyone involved
> all cranked up, I was not able to attend the meeting. I'm now scheduled
> to do it next month.
> 
> -- 
> George L. McLennan
> Strategic Marketing & Management Group
> gmclennan @smmg.com
> 703-354-9839 (voice)
> 703-354-1694 (fax)
> 
> 
> From:	gmclennan [gmclennan @smmg.com]
Sent:	Wednesday, February 25, 1998 9:57 AM
To:	Rick @CICorp.com
Subject:	Re: Access meeting

Unfortunately, after all that preparation and getting everyone involved
all cranked up, I was not able to attend the meeting. I'm now scheduled
to do it next month.

-- 
George L. McLennan
Strategic Marketing & Management Group
gmclennan @smmg.com
703-354-9839 (voice)
703-354-1694 (fax)


From:	Rick @CICorp.com
Sent:	Wednesday, February 25, 1998 7:31 AM
To:	GMcLennan @SMMG.com
Subject:	Access meeting

How did it go?  What was the response to MAAUG working more closely with CPCUG?

Thanks again for your help and initiative.

Rick
From:	Rick @CICorp.com
Sent:	Monday, February 23, 1998 4:33 PM
To:	C I Corporation
Subject:	FW: Access developer

Nick is pretty busy, now but when does he want to start?
Please call him and get the information.  Maybe Nancy or Alex could do it.
(But Nancy charges too much for her skills.)  Is it something that Gerard could do from here?  I better not take any more on myself.  I have enough to do with Hill Group, WR, and Telegroup.
Thanks.


-----Original Message-----
From: Terry Kades [mailto:tkades @erols.com] 
Sent: February 23, 1998 2:15 PM
To: rick @cicorp.com
Subject: RE: Access developer


Rick

I am looking for a competent Access developer for about a one month
project. Thereafter maintenance and customization on an ad hoc basis.
 
Please could you refer me to someone or vice versa. 

Many thanks.

Terry Kades
Strategic Feasibilities, Inc.
(301) 983-6305
From:	Les Squires [lsquires @wj.WJI.COM]
Sent:	Wednesday, February 18, 1998 4:28 PM
To:	Rick @CICorp.com
Subject:	  JE218: Sample JobsExpress

---------------------------------------------------------------
Member:      Rick Shaddock, Crystal City Maryland USA
Subs ON/off: ACCE clip FOXP sqlw it vdb WJI
Jobs ON/off: acce actx c++ clip cobol cfusion cryst dbase delph
             dmodel docmgt domino dware edp fox glob it java
             notes novell nt oracle pb perl sqa sqls sqlw syba
             unix vb vdb vconf warp webd webs y2k

---------------------------------------------------------------

Rick,

Since you're not currently enrolled in any of WWDN JobsExpresses,
it dawned on me the other day that it might be a good idea to 
show you a sample of the announcements.

Feel free to forward a copy to some company you know that could
benefit from direct email access to the developer communities.
We're mailing 9,500 of these per day on the average and hope that
one of these announcements can help you one of these days--either
as an employer or as a job seeker.

Second. Please notice the new header.  It provides a summary of
all your activity with wji.com.  Subs ON/off indicates newsletters
and special interest groups.  Jobs ON/off indicates current job 
announcements.  Upper case is ON; lower case is off.

Third.  We're open again for additional jobs items you suggest 
for inclusion on http://www.wji.com/wji/w1002779.html .

Les

----------------------- RealTimeJobs(tm) --------------------------
 World Wide Developer Network (WWDN) Les Squires  LSquires @wji.com
 Woburn, Massachusetts (Boston)                       781-935-1520
------------- http://www.wji.com/wji/w1002779.html  ---------------



------------ SAMPLE
------------ Job Opportunity from World Wide Developer Network
------------ Posted from http://www.wji.com/wji/w9235.html

 Contact: John Thornton
   Email: JMTNORRELL @AOL.COM
 Company: Norrell Services, Inc.
     URL: http://www.
 Address: 4401 Connecticut Ave. N.W.
          Suite 604
    City: Washington
   State: DC
 ZipCode: 20008
 Country: USA
   Phone: 202-686-0130
     Fax: 202-363-2464
Telecommuting will not be considered.
'Virtual Contracting' will not be considered.

Job Description
-------------------------------------------------------------

Business Systems Analyst (No Coding)     5 Openings

The successful candidates will assist the project leader in
leading business systems analysts/programmers in the design,
development, implementation and maintenance of business
information systems.  Analyzes only; does not code.

Contract and contract to hire positions available for
Wilkes-Barre, PA area.

Please submit your resume via fax or e-mail to:

Norrell Information Systems, Inc.
(703)917-1616

PCVISION @ATR.COM

---------------------------------------------------------------
IT @WJI.com    //-Use this email ID for writing to WJI.
ITJOBSNL-NO   //-Remove your ID from this jobs list.
ITJOBSNL-YES  //-Reactivate yourself. Add friend to list.
Change Address  //-Use OLD address to send NEW address.
Abuse @wji.com   //-Report anything you consider to be abusive.

IT Professionals JobsExpress http://www.wji.com/wji/w1002779.html
A Service of Word Jenny, Inc. Boston USA  02/18/98 12:06:11EST

-----Original Message-----
From: Les Squires [mailto:lsquires @wj.WJI.COM] 
Sent: February 10, 1998 1:47 AM
To: Rick @CICorp.com
Subject: AC198: Access Email Newsletter


-----------------------------------------------------------------
Member:      Rick Shaddock of Crystal City Maryland USA
Subs ON/off: ACCE clip FOXP sqlw it vdb wji
Jobs ON/off: acce actx c++ clip dbase delphi fox it java oracle
             pb sqlserver sqlwind sybase vb vdb y2k
-----------------------------------------------------------------
Hi again, Rick!

Here's the catch for this month!

Les

-----------------------------------------------------------------------
-----------------------------------------------------------------------
Access Email Newsletter                                   January, 1998
A Service of the World Wide Developer Network             Vol. 6  No. 1
http://www.wji.com/access/homepage.html              ftp.wji.com/access
-----------------------------------------------------------------------
 1. Editor's Note
 2. Access JobsExpress
 3. Finding the Irish in your Database
 4. Auditing the Records in an Access 97 Table
 5. Managing Your Reports with the Data-Driven Paradigm
 6. Printing Reports as a Batch Process
 7. Extracting the Network User ID using 16 Bit API Calls.
 8. Showing System Objects And "Select *" Don't Mix In Replicas
 9. Viewing Logged-on Users Through the .LDB
10. Handling Year 2000 Issues (Y2K)
11. Achieving Automation Goals using Database Documenters Code.
12. Repairing and Compacting with Jet API's
13. Optimizing the Speed of Report Runs.
14. Creating a Flexible User Interface Design with 'System' Tables
15. ODBCDirect Askew Without VB 5.0 Pro Installed
16. Setting Echo On/Off For Debugging
17. Printing Relations from Any Access 97 Database
18. Internet Database in German Access 97
19. Access 8.0 Export Facilities.
20. Customizing Function Keys in Access
21. Comment Block and UnComment Block Builders for Access 97
22. Passing SQL Strings to Access
23. LookIn on Outlook to Speed Up Access and Office
24. From the Publisher
-----------------------------------------------------------------------
 1. Editor's Note  
    -------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9161.html

    Lots of good code this month.  Thanks again to all of you who take 
    the time to enrich our Access developer community!


 2. Access JobsExpress
    -------------------------------------------------------------------
    ReplyTo: Les Squires, Publisher  
    URL:     http://www.wji.com/access/w7413.html

    We've built a new email system to push job announcements immediately 
    to developers who want them.  Please note that we are no longer 
    posting job announcements to web pages.  Use one of the links below 
    to fire up the system!  Let us know what you think!

    Employers:  http://www.wji.com/access/w7412.html
    ---------------------------------------------------------
    Looking for full or part-time employees, consultants, tutors, or the 
    like?  Submit your job announcement ad to us and we will email it to 
    our pool of Access developers.

    Developers:  http://www.wji.com/access/w8495.html
    ---------------------------------------------------------
    Sign up for AccessJobsExpress!  Receive an email of a job 
    announcement within 15 seconds of its being posted!


 3. Finding the Irish in your Database
    -------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9355.html
    ftp://ftp.wji.com/access/fsifind.zip   //-FSIFIND.ZIP  (43,064)
    Access Version: 8.0  (But you could roll it back to version 2.0.)
    Keywords: SQL, FINDIT, QUOTE

    Problem:  SQL engines can choke on a single quote, but they think 
    two single quotes are just one literal quote.

    Solution:  Use the file fsiFind.MDB. It converts O'Brein to O''Brien 
    and all single apostrophes to two apostrophes.

    I got a little help writing this from the Microsoft Systems Journal 
    at http://www.microsoft.com/msj/


 4. Auditing the Records in an Access 97 Table
    -------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9354.html
    ftp://ftp.wji.com/access/fsiaudit.exe //-FSIAUDIT.EXE (190,416)
    ftp://ftp.wji.com/access/fsivideo.exe //-FSIVIDEO.EXE (1,360,643)
    Keywords: AUDIT TRAIL; CLASSES; NETWORK USER NAME
    Access Version: 97

    The file fsiAudit.EXE contains an Access 97 MDB (self extracting 
    PkZip) that demonstrates how to audit the records in an Access 
    table.

    Each record programmatically maintains its origin date/time, 
    date/time of the last edit, and the Network User ID of person logged 
    on at the time.

    The sample code wraps the Network User Id API call in an Access 97 
    Class, which can be used "as is" in VB 4-32 or VB 5.0.  All source 
    code is included and it's free.

    The file fsiVideo.EXE is an instructional overview for the code, 
    made with the MS Camcorder Movie. You will need a sound card to 
    fully appreciate it!


 5. Managing Your Reports with the Data-Driven Paradigm
    -------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9353.html
    ftp://ftp.wji.com/access/ddreport.zip   //-DDREPORT.ZIP (22,024)
    Keywords: 'DATA DRIVEN' REPORTS
    Access Versions: All

    This file Reports.MDB, is a complete 'Data Driven' example of an 
    easy way to manage all the reports in you application, developed in 
    Access 2.0.

    The idea is to store all reports in a table, let the user select the 
    reports they would like, and print them in a batch from a single 
    command button.


 6. Printing Reports as a Batch Process
    -------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9350.html
    Access Versions: All

    Suppose you had a table with all available reports and you wanted to 
    let the user select several for printing.

    All you'd have to do is let them toggle the 'PrintIt' field with a 
    simple form. You can even give the report a user friendly name so 
    they can recognize the report 'Mary's Monthly Report' instead of the 
    less kindly 'rptEmployeeLayoffsAntiPersonalDept'.
           
    Then run this handy routine:
           
    Sub ReportAll ()
    '**************************************************************
    ' Author   : Pat Tormey Tormey @foursquare.com
    ' Date     : 7 April 1996
    ' Comments : Objective is to Select a report from Engine Listing
    '***************************************************************
    On Error GoTo ReportAll_ERR
           
     Dim db As Database
     Dim rs As Recordset
     Dim i As Integer
     Dim Count%
     Dim x As Variant
            
     Set db = DBengine.WorkSpaces(0).Databases(0)
     Set rs = db.OpenRecordset("tblReports", DB_OPEN_SNAPSHOT)
            
     'Count Up the Printit
     Count% = 0
     Do Until rs.EOF  'let's see how many reports are tagged to Print
      If rs.PrintIt Then
       Count% = Count% + 1
      End If
      rs.MoveNext
     Loop
           
     If Count% = 0 Then
     Exit Sub
     End If
       'Set up the system Meter   
      x = SysCmd(SYSCMD_INITMETER, Str$(Count%) & " Reports", Count%)
       rs.MoveFirst
     Do Until rs.EOF
      If rs.PrintIt Then  'Is It Tagged
       x = PrintReport(rs.ReportName)
       x = SysCmd(SYSCMD_UPDATEMETER, i)
      End If
      i = i + 1
      rs.MoveNext
     Loop
     rs.Close
     db.Close
      x = SysCmd(SYSCMD_REMOVEMETER)
           
    ReportAll_EXIT:
        Exit Sub
           
    ReportAll_ERR:
     'Never Say Error .. especially if there is one
      MsgBox "Note:" & Error$, 64, "Application Note" 
        Resume ReportAll_EXIT
           
    End Sub
           
    Function PrintReport (cReport)
    '**********************************************************
    ' Author  : Pat Tormey Tormey @foursquare.com
    ' Date    : 7 April 1996
    '**********************************************************
    On Error GoTo PrintReport_ERR
      DoCmd OpenReport cReport, A_NORMAL
    PrintReport_EXIT:
        Exit Function
           
    PrintReport_ERR:
      MsgBox "Note:" & Error$, 64, "Application Note: There is " & _
                                   "nothing wrong. Go back to sleep"
           
        Resume PrintReport_EXIT
           
    End Function


 7. Extracting the Network User ID using 16 Bit API Calls.
    -------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9347.html
    Access Versions: All

    This file extracts the Network User ID in Access 2.0 using the 16 
    Bit API calls.

    I must admit that I stole this idea from somebody, probably Dan 
    Appleman.  I recommend his books 'Visual Basic Programmer's Guide to 
    the Windows API' for 16 bit calls and  'Visual Basic Programmers 
    Guide to the WIN 32 API' for 32 bit calls.

    Option Compare Database 'Use database order for string comparisons
    Option Explicit
           
    ' Uses WINDOW API to get the Net Users Name from the Local Area
    '  Network
    ' You can use this to see if the users should have write/delete
    '  privileges, or to secretly tag who did what last!

    Declare Function wu_WNetGetUser% Lib "USER.EXE" Alias _
     "WNetGetUser" (ByVal szUser$, lpnBufferSize%)
           
    Function NetworkUserID () As String
    '**********************************************************
    ' Author  : Pat Tormey Tormey @foursquare.com
    ' Date    : 7 April 1996
    '**********************************************************
      On Error GoTo NetworkUserID_ERR
      Dim szUser As String * 255
      Dim lpnBufferSize As Integer
      Dim status As Integer
           
      lpnBufferSize = 255
      status = wu_WNetGetUser(szUser, lpnBufferSize)
      If (status = 3) Then
        NetworkUserID = "WNetGetUser Failed"
      Else
        'Return up to first Null.
        NetworkUserID = Left$(szUser, InStr(szUser, Chr(0)) - 1)
      End If
           
    NetworkUserID_EXIT:
        Exit Function
           
    NetworkUserID_ERR:
      MsgBox "Note:" & Error$, 64, "Application Note"
        Resume NetworkUserID_EXIT
           
    End Function


 8. Showing System Objects And "Select *" Don't Mix In Replicas
    -------------------------------------------------------------------
    ReplyTo: Philip Hurzeler  
    URL:     http://www.wji.com/access/w9341.html
    Access Versions: 97, possibly 95 (Try this in Access 95, and

    If any controls in your replicated Access 97 database have row 
    sources that start with 'SELECT * FROM...', you can create bugs by 
    setting the 'Show System Objects' option on or off.
           
    Setting the option on makes visible the system columns devoted to 
    replication, which can have a ripple effect.  For instance, the 
    ordinal values of the Column property of list or combo boxes all get 
    bumped up by 3 unless the row source property calls out each column 
    by name.

    One way you can prevent this problem is to avoid 'SELECT' in row 
    sources.  Another way is to set the Application's 'Show System 
    Objects' option to False in your Autoexec macro or startup form's 
    Open event.


 9. Viewing Logged-on Users Through the .LDB
    -------------------------------------------------------------------
    ReplyTo: Thom Allen  
    URL:     http://www.wji.com/access/w9322.html
    Access Version: 2.0

    For a very rudimentary view of who is logged in to a database, read 
    the .LDB file.  Remember that the .LDB is not cleared when a user 
    logs out, so this is not 100% accurate, but at least you can get an 
    idea who is in or has been. I run the function from a Macro, and a 
    nice little pop-up box displays the user names in the .LDB file.  

    Have fun, and I would like any feed back.  I also have a version 
    that allows for you to enter an .LDB file name anywhere on the 
    network and display the users in that database as well.
           
    Function WhosInDB ()
           
    Dim varPullID As String
    Dim varUserID As String * 64
    Dim Indx As Long
    Dim varArray() As String
    Dim varDisplay As String
    Dim varLDBName As String
    Dim dbName As Database
    Dim varBackPath As Integer
    Dim Max As Integer
           
    Set dbName = CurrentDB()
    varLDBName = Left(dbName.Name, Len(dbName.Name) - 4) & _
                  ".LDB"   ' Assign .LDB file name
           
    On Error GoTo errFileOpenError
    Open varLDBName For Random Shared As #1 Len = Len(varUserID)
      ' Open to read file.
    Max = LOF(1) / Len(varUserID)
    ReDim varArray(1, Max)          ' Set up Array to hold user names
    For Indx = 1 To Max             ' Loop to cycle through entries.
       On Error GoTo errGatheringUsers
       Get #1, Indx, varUserID            ' Read from file.
       varPullID = Mid(varUserID, 33, 7)  ' Pull User ID from 64 bites
       varArray(1, Indx) = varPullID      ' Assign User ID to Array

    ' Put User ID's in one variable
       varDisplay = varDisplay & varArray(1, Indx) & Chr(13)     
    Next Indx
       ' Display users in MsgBox
       MsgBox "These users are currently" & Chr(13) _
              "logged into the database:" & _
              Chr(13) & Chr(13) & varDisplay               
    Close #1                               ' Close file
    Exit Function
           
    errNoLDBFile:
       MsgBox "There is no LDB file to pull data from"
       Exit Function
           
    errFileOpenError:
       MsgBox "There was an error opening the LDB file for read. " & _
          "Please try again."
       Exit Function
           
    errGatheringUsers:
       MsgBox "There was an error gathering the User names. " & _
               "Please try again."
       Exit Function
           
    End Function
           

10. Handling Year 2000 Issues (Y2K)
    -------------------------------------------------------------------
    ReplyTo: Christopher R. Baker  
    URL:     http://www.wji.com/access/w9268.html
    ftp://ftp.wji.com/access/sagent.zip  //-Download SAgent.ZIP (19,435)
    Keywords: TIPS YEAR 2000
    Access Versions: 2.0 and Up
    
    Editor's Note.  SAgent.mdb comprises of source code and demo files 
    from Chris Baker's January, 1998 presentation to the Access User 
    Group in Boston.

    In the sample below, Chris creates a manageable technique to control 
    Access intrinsic Y2K methods. For details of this and many other 
    handy routines download SAgent.mdb (Access 2.0.)

    Function saCentury (varDate As Variant) As Variant
    On Error GoTo Err_saCentury
    ' Chris Baker cBaker @SpecialAgent.com
    ' Given a date with a two digit year, Access 2.0
    ' ALWAYS ASSUMES THE YEAR IS 19xx
    ' Regardless of the system date.
    '
    ' This routine compensates for 2-digit year ambiguity by creating
    ' 100 year window for valid dates.  The window 'rolls over' at
    ' the year calculated by adding FUTURE_YEARS to the present system
    ' year.
    '
    ' This system does not properly handle all four digit years that
    ' fall outside of the 100 year window.
    '

    Const FUTURE_YEARS = 10

      Dim intDateYear As Integer    'Year part of date to be tested
      Dim intFutureYear As Integer  'Future Year Cutoff for all dates
      Dim intPastYear As Integer    '

      saCentury = varDate
      If IsDate(varDate) Then
        intDateYear = DatePart("yyyy", varDate)
        intFutureYear = DatePart("yyyy", Now) + FUTURE_YEARS
        intPastYear = intFutureYear - 100
        If (intDateYear > intFutureYear) Then
          saCentury = DateAdd("yyyy", -100, varDate)
        ElseIf (intDateYear <= intPastYear) Then
          saCentury = DateAdd("yyyy", 100, varDate)
        End If
      End If

    Exit_saCentury:
      Exit Function

    Err_saCentury:
    '!!  saMsgErr Error$, Err, "zbasUtility.saCentury"
      Resume Exit_saCentury
    End Function


11. Achieving Automation Goals using Database Documenters Code.
    -------------------------------------------------------------------
    ReplyTo: Michael Kaplan  
    ReplyTo: Mark Higham  
    URL:     http://www.wji.com/access/w9260.html
    URL:     http://www.wji.com/access/w9270.html
    RE: Interrogating Macros Using Automation by Mike Swift.

    I have an application which, using Automation and COM does the following 
    things:

    o Starts an Access session
    o Loads a database from a pre-defined list of files
    o Looks through each collection - Forms, Queries, Modules etc.
    o Opens, design view, each item in these collections
    o Prints the properties of the items (or components within the items.)
    o For modules, the application interrogates individual lines of 
      source code (using the Lines property), and searches for certain 
      keywords.

    Now, I want to do the same thing with Macros as I've done with 
    modules - using automation....

    Kaplan replies:  

    Have you considered perhaps looking at the Database Documenter's 
    code in the unlocked wizards and trying to make that work for you?

    There are no guarantees that this will work past Access 97, but 
    you are in undocumented-land already as it is.

    Higham replies: 

    You could try doing something with the Application.SaveAsText 
    procedure.  This procedure is a hidden member of the 'Access 
    Application Object'.  Go to your 'Object Browser' and ensure that 
    'Show Hidden Members' is checked.   The syntax is relatively 
    straightforward

    Application.SaveAsText acMacro, "YOURMACROHERE", "FILENAMEHERE"

    You still have to parse the text file.


12. Repairing and Compacting with Jet API's:  A Question
    -------------------------------------------------------------------
    ReplyTo: Michael Kaplan  
    URL:     http://www.wji.com/access/w9259.html
    RE: Repairing and Compacting Databases Automatically by Holger Rohlfs.

    Is there a possibility to repair and compact a database 
    automatically, AND finding out if an error occurred in Access 2.0? 
    Currently I use the following code:

    Code (and further details) Follow

    There is no fix or anything here that you can do. The only reason 
    that Access is able to warn you of errors is that they use Jet 
    directly, not DAO.

    There is no way that anyone outside of Microsoft can do the Jet APIs 
    to compact or repair, and that is the only way you would be able to 
    do this.


13. Optimizing the Speed of Report Runs.
    -------------------------------------------------------------------
    ReplyTo: Dave Milidonis  
    URL:     http://www.wji.com/access/w9263.html
    Access Version: 7.0

    While working on a client project I stumbled on a neat trick for 
    optimizing the speed of report runs.  Reports tend to run faster off 
    tables, rather than directly off queries, so create a "make table" 
    query for your report data.   Once done, use an Event Procedure on 
    the report's On_Open event and insert the following code:
       
    Private Sub Report_Open(Cancel As Integer)
        DoCmd.OpenQuery "mkqryName",,acReadOnly
        DoCmd.OpenReport "rptName", acViewPreview
    End Sub
           
    Now, run the report.

    The query executes creating the table and bringing up the report. 
    All with the click of a mouse.   I am sure any developer could add 
    more to the event procedure in order to further automate 
    processing. For example: Saving the Report to a file; sending the 
    report; etc.


14. Creating a Flexible User Interface Design with 'System' Tables
    -------------------------------------------------------------------
    ReplyTo: Robert S. Ruder  
    URL:     http://www.wji.com/access/w9224.html
    Access Versions: 97

    It has occurred to me that if you take the concept of databases to 
    a logical conclusion, then the whole process of designing a 
    database is built around sets of data which describe the nature 
    and process of the database. This is in fact what Microsoft 
    employs in their System Tables. What I decided to develop was a 
    database design which would allow me to add functionality to the 
    database by simply adding a record to a table which defined that 
    functionality.

    What I have managed to build is a user interface which is designed 
    around an initial 'database map' form which allows the user to 
    choose a selection of database tasks based on a selected 
    category... in this case I use a department metaphor. However, no 
    matter which department the user selects, the second form you go 
    to is the same, but as it opens, I query my system table to find 
    out how to modify the form for the chosen department.

    My system tables are as follows: 

        Table Name:   Task Categories
        Fields:       TaskCategoryID  AutoNumber
                      CategoryName    Text

        Table Name:   Tasks                                            
        Fields:       TaskID          AutoNumber
                      TaskName        Text
                      TaskCategory    Number-Long Integer
                      TaskSubForm     Text

    When the user clicks on a map item, the following code is 
    executed:

    Function DisplayTasks(Dept As Integer)
      'The Dept value is passed in, i.e. =displayTasks(1)
      Dim tempdb As Database, temprs As Recordset
      Dim SQLst As String

      Set tempdb = CurrentDb
      SQLst = "Select * from TaskCategories where TaskCategoryID = " & _
               Dept Set temprs = tempdb.OpenRecordset(SQLst)

      DoCmd.OpenForm "Unit Form", acNormal
      Forms![Unit Form].Caption = temprs![CategoryName] & "Tasks"
      Forms![Unit Form]![Title] = temprs![CategoryName] & "Options"
      Forms![Unit Form]![TaskCatID] = Dept
    End Function

    The control [TaskCatID] is an unbound Text Box which is the Link 
    Master for a subform control. It displays the appropriate tasks 
    for the department selected. The form [Unit Form] also contains 
    another unbound subform control. Because my Tasks system table 
    contains the field [TaskSubform], I have a location where I can 
    store the name of the appropriate subform for the defined task. In 
    the On Current event for the tasks subform, I execute the 
    following code:

    Parent![SubDisplay].SourceObject = _
           IIf(IsNull([TaskSubForm]),"sfrm_None", [TaskSubForm])

    The result is that which ever record becomes current in the left 
    hand list of tasks, the appropriate subform is displayed in the 
    right hand subform control. As my list of tasks grows, all I must 
    do is create a subform which can perform the task, add the task to 
    the tasks table, categorize it, and add its subform name. The rest 
    is already in place.

    I am currently working on expanding this concept to include 
    information about attached tables and data synchronization 
    information between two attached data sources. My code can simply 
    loop through a set of data and attach and synchronize the data 
    automatically. Overall, I'm pleased with the ability to create 
    dynamic designs by incorporating my own custom system tables.


15. ODBCDirect Askew Without VB 5.0 Pro Installed
    -------------------------------------------------------------------
    ReplyTo: Kevin Bruton  
    URL:     http://www.wji.com/access/w9258.html
    Access Version: 97

    ODBCDirect demonstrates unpredictible behaviour when VB 5.0 
    Professional is not installed on a machine. Sample Code :

    Open RecordSet

    Set rsProduct = gblcnnODBC.OpenRecordset(strSQL, dbOpenDynaset, _
                     0, dbOptimisticValue)

    'Then later on issue a

      With rsProduct
          .Edit
           rsProduct!Fields = Something
          .Update
      End With

    Locking problem encountered:

    Machine A updates the same record Machine B is viewing. Machine B 
    tries to update the record, If VB 5.0 is installed, the record 
    locking error is correctly triggered, if VB 5.0 is not installed, 
    no error is returned, but the record is not updated.

    Error : 0 Assignment error.

        With Recordset
               .Edit
               rsProduct!Fields = Something
               .Update
        End With

    Machine A, tries to Update Record, receives error (VB 5.0 not 
    installed.) Machine B, tries to Update Record, suceeds (VB 5.0 
    installed.)

    The code is identical on the two machines , the only differance is 
    when VB 0.5 Pro is installed. How can this be solved without 
    installing VB 5.0 Pro on each machine?

    Installing the latest DAO (1.5) drivers did not solve this 
    problem.


16. Setting Echo On/Off For Debugging
    -------------------------------------------------------------------
    ReplyTo: Mark Higham  
    URL:     http://www.wji.com/access/w9256.html
    RE:      Speeding Up Your Front End with the Echo Method by Paul Brower.
    Access Versions: 2.0 (?), 7.0, 8.0

    Are you aware that the Echo Method is a great tool for speeding up 
    many processes. When used correctly, the echo method will stop the 
    screen from being updated/repainted.
       
    Let's say that you have a Customer Screen (frmCustomer), and an 
    Invoice Screen (frmInvoice).  You want to be able to allow users 
    to double click an invoice, and go directly to the customer.  Here 
    is the Event you would use:

    Code follows:

    When debugging Access 97 code that has the echo set to off, make 
    sure that you set the debug window to be on top. That way you can 
    always do CTRL+G and get to it.

    In Access 97, I use compiler constants to set echo. For example:

    #If FDEBUG Then
        'continue as normal
    #Else
        Application.Echo False
    #End If


17. Printing Relations from Any Access 97 Database
    -------------------------------------------------------------------
    ReplyTo: Mark Higham  
    URL:     http://www.wji.com/access/w9153.html
    Access Versions: 8.0
    Keywords: PRINT RELATIONS
    ftp://ftp.wji.com/access/daorelat.exe  //-DAORELAT.EXE (219,407)

    I wrote this after downloading the Print Relations Wizard which 
    was patently no use.

    This self extracting zip file allows you to print out relations 
    from any Access 97 database, you can save each separate diagram. 
    Zoom in and out.

    Generally it gives good relational diagrams which you can include 
    in any documentation. 


18. Internet Database in German Access 97
    -------------------------------------------------------------------
    ReplyTo: Karl-Heinz Kristen  
    URL:     http://www.wji.com/access/w9155.html
    URL:     http://193.24.175.164/aspneu/VhsStart.htm //-Online example
    ftp:     ftp.wji.com/access/i_net.zip  //-I-NET.ZIP (199,811)

    Product Ver.: German Access 2.0 and 8.0, German IIS and German NT
    System:       Windows NT / Windows 95 - InternetServer 3.0
    Development:  ASP (ActiveServerPages) from MS must be installed.
    Database:     ACCESS 2.0 or ACCESS 7.0
    Language:     VBScript / VisualBasic (2.0 - 5.0)
    Important:    Use the Permission-Configuration from the 
                  InternetServer and check the Directorys of the InetPub 
                  for Read/Write & Run. 

    Step by Step Prodcedure to run the DB on an Intranet.

    1. Copy all Files to your InetPub-Root. I used the 
       E:\InetPub\wwwroot\aspneu as Directory

    2. Goto the ControlPanel to invoke the ODBC-Manager for a new 
       System-DSN entry.

       i. Check the System-DNS to make a new entry.
      ii. Check the ACCESS-Driver (Version 2.0/7.0)
     iii. Put in name of Database(ASP-File = aspneu), name it: aspneu
      iv. Check the Select-Button from Database and choose the      
          Database-Directory.  I used 
          E:\InetPub\wwwroot\aspneu\kurse2.mdb

     3. Now run IIE or Netscape and call Homepage (VHSSTART.HTM)

     For more Information on ASP.  A very good Book about ASP is 'ASP: 
     Working with ActiveServerPages', available at Carry Book Support 
     at http://www.caryp.com/


19. Access 8.0 Export Facilities.
    -------------------------------------------------------------------
    ReplyTo: Anders H. Madsen  
    URL:     http://www.wji.com/access/w9170.html
    Access Versions: 8.0
    ftp://ftp.wji.com/access/ac8exnl.zip  //-AC8EXNL.ZIP (210,080)

    Abstract

    The attached database includes two top level procedures for 
    exporting which can be used instead of TransferText in certain 
    situations.

    TransferText_nl

    This procedure is similar to TransferText but independent of 
    fields.  What this means is that TransferText_nl can be used with 
    tables and queries even if they have different fields than the 
    table or query, which were used when creating the import/export 
    specification. In other words, TransferText_nl works more like 
    TransferText in the good old Access 2.0.

    Limitations:  Only works for exporting of delimited test files. Can 
    not export to ASCII format.

    Export_nl

    This is an export procedure which in some ways are more flexible 
    than TransferText and TransferText_nl. The procedure is especially 
    valuable when exporting cross tab queries. The most important 
    facilities are:

    o  Uses import export specifications but independent of fields 
       (like Access 2.0)

    o  Also capable of using an other record separator than cariage 
       return line feed.

    o  Capable of sorting columns in complex ways.

    o  Can export two queries to the same file: Typically this is a 
       detail query and a totals query.

    o  Can convert null values to zero.

       Limitations: Only works for exporting of delimited test files.
       Cannot export to ASCII format.

    References to similar pieces of work

    http://www.wji.com/access/w6630.html -- Incompatibility Between 
    Access 2.0 and Access7.0/8.0 Text File Inport/Export by Shamil 
    Salakhetdinov. 

    Mr. Salakhetdinov has overcome the problem with Access 8.0's 
    dependence of fields in an other way. His approach is to create a 
    specification and then use Access's own TransferText. In short his 
    code has the following advantages:

    o  Can both import and export.
    o  Can handle both delimited and fixed width formats.
    o  Also works for ASCII format.
    o  Less code (= less memory footprint).

       
    In short our approach has the following advantages:

    o Several good facilities for handling cross tab queries (see the 
      comments in Export_nl below).

    o Can put together the results of a detail query and a totals 
      query into one export file.

    o Also capable of using an other record separator than cariage 
      return line feed.

    o You do not have to change any code to use other delimiters etc.


20. Customizing Function Keys in Access
    -------------------------------------------------------------------
    ReplyTo: Paul Brower  
    URL:     http://www.wji.com/access/w9172.html
    ftp://ftp.wji.com/access/fkeys.zip  //-FKEYS.ZIP (29,301)
    Access Versions: 8.0

    The file fKeys.mdb consists of 1 macro (AutoKeys), 1 form 
    (frmFKeys) and 1 module (mdlFkeys).

    These items will allow developers to run code by pressing a 
    function key.  The form frmFkeys allows users to customize what 
    function key will perform what action.  The windows registry is 
    used to keep track of the function key assignments.

    For an example, when you download this database, open up the form 
    frmFkeys, select "ScreenName" in the combo box, and click a 
    function key command button.  (i.e. F-5).  "ScreenName" will 
    appear in the text box under the command button.  You must now 
    exit the database and re-open it.  Now you can press function key 
    F-5 (or the one that you assigned), and if you have a form open, a 
    message box will appear with the form name.  By looking at my 
    code, you should be able to see that it will now be very simple 
    for you to create new subroutines and be able to execute them by 
    pressing a function key.

    I have a client that was using a system called TeleMagic, and they 
    were used to being able to print forms, etc, from the use of 
    function keys.  They asked that I provide the same functionality 
    with function keys in the new Access database, and this has worked 
    out very well.

    Important Notes:

    o You must add subroutine names to the combo box on the form 
      "frmFkeys."  i.e.  if you create a sub called "Calculate 
      Commission", you need to add "Calculate Commission" to the value 
      list in the combo box.  

    o I don't have any error code for these examples.  You will need 
      to create your own.

    o Additional key assignments could be made.  For example if you 
      wanted to assign a subroutine to "Ctl-F5", you would need to add 
      ^{F5} in the macro AutoKeys, and provide the necessary controls 
      and code on the form and module.

    o The function key values are stored in the windows registry as 
      "txtF#".  My code requires that a field prefixed with "txtF" be 
      present in order to write the registry information.  Feel free 
      to change this.

    o This code if free and available to all who dare to make their 
      development just a tad bit more user friendly, and cool.


21. Comment Block and UnComment Block Builders for Access 97
    -------------------------------------------------------------------
    ReplyTo: Mehmet Acikgoz  
    URL:     http://www.wji.com/access/w9154.html
    ftp://ftp.wji.com/access/pdncbuil.zip  //-PDNCBuil.ZIP (23,609)
    Keywords: COMMENT BLOCK UNCOMMENT BLOCK BUILDERS ACCESS 97
    Access Versions: 8.0

    In developing an Access application, the developer might 
    frequently need commenting out or un-commenting block of codes in 
    module windows. These are quite tedious processes if the block has 
    several tens of code lines.

    In complex modules, it might be useful to put some sort of signs 
    to mark commented blocks as showing "why they have been commented" 
    or in team work situations; "who commented out the block of code 
    lines and why".  These marks can play some sort of vital role in 
    programming techniques.

    To solve these issues, I present two separate builders in the same 
    file.


22. Passing SQL Strings to Access
    -------------------------------------------------------------------
    ReplyTo:  <>
    URL:     http://www.wji.com/access/w9223.html
    Access Versions: All.

    When passing SQL strings, you have to be careful about embedded 
    apostrophes and quotation marks. For example, this SQL command 
    will fail for the name O'Brien:
        
    strName = "O'Brien"
    DoCmd.RunSQL _
      "DELETE * FROM Customers WHERE Fullname = ' " & strName & " ';"
        
    Because of the embedded apostrophe in O'Brien, the SQL string 
    won't be interpreted properly.

    To solve this problem, I wrote a function called SafeSQLString 
    which surrounds the string in quotation marks. It also replaces 
    any embedded quotations marks with double quotations, which SQL 
    can handle. You use the function like this:
        
    strName = "O'Brien" 
    DoCmd.RunSQL _
     "DELETE * FROM Customers WHERE Fullname = " & _
      SafeSQLString(strName) & ";"         

    Here's the function along with the Replace helper function:

    Public Function SafeSQLString(Text As Variant) As Variant
    On Error GoTo Err_SafeSQLString 
        Const QUOTE = """"      ' That's 4 quotation marks in a row.
          
        If IsNull(Text) Then
            SafeSQLString = QUOTE & QUOTE
        Else
            SafeSQLString = QUOTE & _
                            Replace(Text, QUOTE, QUOTE & QUOTE) & QUOTE
        End If
              
    Exit_SafeSQLString:
        Exit Function
              
    Err_SafeSQLString:
        SafeSQLString = ""
        Resume Exit_SafeSQLString
              
    End Function 
        
    Public Function Replace(ByVal varValue As Variant, _
                            ByVal strFind As String, _
                            ByVal strReplace As String) As Variant
          
        Dim intLenFind As Integer
        Dim intLenReplace As Integer
        Dim intPos As Integer
              
        If IsNull(varValue) Then
            Replace = Null
        Else
            intLenFind = Len(strFind)
            intLenReplace = Len(strReplace)
                  
            intPos = 1
            Do
                intPos = InStr(intPos, varValue, strFind, 0)
                If intPos > 0 Then
                    varValue = 
                       Left(varValue, intPos - 1) & strReplace & _
                       Mid(varValue, intPos + intLenFind)
                    intPos = intPos + intLenReplace
                End If
            Loop Until intPos = 0
        End If
        Replace = varValue
              
    End Function
        
    I intentionally left out the single quotation mark. Since I'm 
    surrounding the string with double quotes, the single quotes are 
    no longer needed.  Here are some examples:

    o "DELETE * FROM Customers WHERE Fullname = " &
    SafeSQLString("O'Brien")

    The SQL engine will see the above string as:

    DELETE * FROM Customers WHERE Fullname = "O'Brien"

    o "DELETE * FROM Customers WHERE Fullname = " & 
      SafeSQLString("O'Brien")

    The SQL engine will see the above string as:

    DELETE * FROM Customers WHERE Fullname = "O'Brien"

    o strName = "An embedded " & """" & " double quote!"
    '  translates to: An embedded " double quote!

    "DELETE * FROM Customers WHERE Fullname = " & _
     SafeSQLString(strName)

    The SQL engine will see the above string as:

    DELETE * FROM Customers WHERE Fullname = "An embedded "" double quote!"


23. LookIn on Outlook to Speed Up Access and Office
    -------------------------------------------------------------------
    ReplyTo: Bharat Ahluwalia  
    URL:     http://www.wji.com/access/w9142.html
    Product Versions: Access 97, Office 97

    If you have MS Outlook installed, your Access 97 and other Office 
    97 applications can be speeded up by changing some of the default 
    values.

    o  Open Outlook
    o  Go to Options under the Tools menu.
    o  Click on the Journal tab.
    o  Uncheck all the boxes from the Also Record files from: listbox.

    If an application is checked, everytime you open the application a 
    journal entry is created, thus slowing you down.


24. From the Publisher
    -------------------------------------------------------------------
    The Access Email Newsletter is created and distributed compliments 
    of the World Wide Developer Network (WWDN) of Boston, Massachusetts, 
    USA.  Come, get involved!  This is the place where developers talk 
    to developers as peers.

    Publisher:
        Les Squires 
        Word Jenny, Inc.
        400 West Cummings Park, Woburn (Boston), Massachusetts USA   
        781-935-1520

    Editors/Content Specialists
        Phil Denoncourt III 
        Pat Tormey          
        Brendan Donovan     

    Website:  http://www.wji.com/access/homepage.html
  
    Address Changes:
        Send an email USING YOUR OLD ADDRESS.
        Indicate New Address.
    
    Adding Subscribers to Mailing List:
        Send Email to access @WJI.Com.
        Include String ACCESS-YES in Subject: or Body of Message.
    
    Deleting Subscribers:
        Send Email to Access @WJI.Com.
        Include String ACCESS-NO in Subject: or Body of Message.
    
    Retrieving Back Issues and General Downloads:
         FTP to ftp.wji.com.
         Login as FTP.
         Use your ID as your password.
         cd access
         Copy back issues and downloads as they become available.
    
(c) 1998 World Wide Developer Network (WWDN)
From:	Les Squires [lsquires @wj.WJI.COM]
Sent:	Tuesday, February 10, 1998 1:47 AM
To:	Rick @CICorp.com
Subject:	  AC198:  Access Email Newsletter

-----------------------------------------------------------------
Member:      Rick Shaddock of Crystal City Maryland USA
Subs ON/off: ACCE clip FOXP sqlw it vdb wji
Jobs ON/off: acce actx c++ clip dbase delphi fox it java oracle
             pb sqlserver sqlwind sybase vb vdb y2k
-----------------------------------------------------------------
Hi again, Rick!

Here's the catch for this month!

Les

-----------------------------------------------------------------------
-----------------------------------------------------------------------
Access Email Newsletter                                   January, 1998
A Service of the World Wide Developer Network             Vol. 6  No. 1
http://www.wji.com/access/homepage.html              ftp.wji.com/access
-----------------------------------------------------------------------
 1. Editor's Note
 2. Access JobsExpress
 3. Finding the Irish in your Database
 4. Auditing the Records in an Access 97 Table
 5. Managing Your Reports with the Data-Driven Paradigm
 6. Printing Reports as a Batch Process
 7. Extracting the Network User ID using 16 Bit API Calls.
 8. Showing System Objects And "Select *" Don't Mix In Replicas
 9. Viewing Logged-on Users Through the .LDB
10. Handling Year 2000 Issues (Y2K)
11. Achieving Automation Goals using Database Documenters Code.
12. Repairing and Compacting with Jet API's
13. Optimizing the Speed of Report Runs.
14. Creating a Flexible User Interface Design with 'System' Tables
15. ODBCDirect Askew Without VB 5.0 Pro Installed
16. Setting Echo On/Off For Debugging
17. Printing Relations from Any Access 97 Database
18. Internet Database in German Access 97
19. Access 8.0 Export Facilities.
20. Customizing Function Keys in Access
21. Comment Block and UnComment Block Builders for Access 97
22. Passing SQL Strings to Access
23. LookIn on Outlook to Speed Up Access and Office
24. From the Publisher
-----------------------------------------------------------------------
 1. Editor's Note  
    -------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9161.html

    Lots of good code this month.  Thanks again to all of you who take 
    the time to enrich our Access developer community!


 2. Access JobsExpress
    -------------------------------------------------------------------
    ReplyTo: Les Squires, Publisher  
    URL:     http://www.wji.com/access/w7413.html

    We've built a new email system to push job announcements immediately 
    to developers who want them.  Please note that we are no longer 
    posting job announcements to web pages.  Use one of the links below 
    to fire up the system!  Let us know what you think!

    Employers:  http://www.wji.com/access/w7412.html
    ---------------------------------------------------------
    Looking for full or part-time employees, consultants, tutors, or the 
    like?  Submit your job announcement ad to us and we will email it to 
    our pool of Access developers.

    Developers:  http://www.wji.com/access/w8495.html
    ---------------------------------------------------------
    Sign up for AccessJobsExpress!  Receive an email of a job 
    announcement within 15 seconds of its being posted!


 3. Finding the Irish in your Database
    -------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9355.html
    ftp://ftp.wji.com/access/fsifind.zip   //-FSIFIND.ZIP  (43,064)
    Access Version: 8.0  (But you could roll it back to version 2.0.)
    Keywords: SQL, FINDIT, QUOTE

    Problem:  SQL engines can choke on a single quote, but they think 
    two single quotes are just one literal quote.

    Solution:  Use the file fsiFind.MDB. It converts O'Brein to O''Brien 
    and all single apostrophes to two apostrophes.

    I got a little help writing this from the Microsoft Systems Journal 
    at http://www.microsoft.com/msj/


 4. Auditing the Records in an Access 97 Table
    -------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9354.html
    ftp://ftp.wji.com/access/fsiaudit.exe //-FSIAUDIT.EXE (190,416)
    ftp://ftp.wji.com/access/fsivideo.exe //-FSIVIDEO.EXE (1,360,643)
    Keywords: AUDIT TRAIL; CLASSES; NETWORK USER NAME
    Access Version: 97

    The file fsiAudit.EXE contains an Access 97 MDB (self extracting 
    PkZip) that demonstrates how to audit the records in an Access 
    table.

    Each record programmatically maintains its origin date/time, 
    date/time of the last edit, and the Network User ID of person logged 
    on at the time.

    The sample code wraps the Network User Id API call in an Access 97 
    Class, which can be used "as is" in VB 4-32 or VB 5.0.  All source 
    code is included and it's free.

    The file fsiVideo.EXE is an instructional overview for the code, 
    made with the MS Camcorder Movie. You will need a sound card to 
    fully appreciate it!


 5. Managing Your Reports with the Data-Driven Paradigm
    -------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9353.html
    ftp://ftp.wji.com/access/ddreport.zip   //-DDREPORT.ZIP (22,024)
    Keywords: 'DATA DRIVEN' REPORTS
    Access Versions: All

    This file Reports.MDB, is a complete 'Data Driven' example of an 
    easy way to manage all the reports in you application, developed in 
    Access 2.0.

    The idea is to store all reports in a table, let the user select the 
    reports they would like, and print them in a batch from a single 
    command button.


 6. Printing Reports as a Batch Process
    -------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9350.html
    Access Versions: All

    Suppose you had a table with all available reports and you wanted to 
    let the user select several for printing.

    All you'd have to do is let them toggle the 'PrintIt' field with a 
    simple form. You can even give the report a user friendly name so 
    they can recognize the report 'Mary's Monthly Report' instead of the 
    less kindly 'rptEmployeeLayoffsAntiPersonalDept'.
           
    Then run this handy routine:
           
    Sub ReportAll ()
    '**************************************************************
    ' Author   : Pat Tormey Tormey @foursquare.com
    ' Date     : 7 April 1996
    ' Comments : Objective is to Select a report from Engine Listing
    '***************************************************************
    On Error GoTo ReportAll_ERR
           
     Dim db As Database
     Dim rs As Recordset
     Dim i As Integer
     Dim Count%
     Dim x As Variant
            
     Set db = DBengine.WorkSpaces(0).Databases(0)
     Set rs = db.OpenRecordset("tblReports", DB_OPEN_SNAPSHOT)
            
     'Count Up the Printit
     Count% = 0
     Do Until rs.EOF  'let's see how many reports are tagged to Print
      If rs.PrintIt Then
       Count% = Count% + 1
      End If
      rs.MoveNext
     Loop
           
     If Count% = 0 Then
     Exit Sub
     End If
       'Set up the system Meter   
      x = SysCmd(SYSCMD_INITMETER, Str$(Count%) & " Reports", Count%)
       rs.MoveFirst
     Do Until rs.EOF
      If rs.PrintIt Then  'Is It Tagged
       x = PrintReport(rs.ReportName)
       x = SysCmd(SYSCMD_UPDATEMETER, i)
      End If
      i = i + 1
      rs.MoveNext
     Loop
     rs.Close
     db.Close
      x = SysCmd(SYSCMD_REMOVEMETER)
           
    ReportAll_EXIT:
        Exit Sub
           
    ReportAll_ERR:
     'Never Say Error .. especially if there is one
      MsgBox "Note:" & Error$, 64, "Application Note" 
        Resume ReportAll_EXIT
           
    End Sub
           
    Function PrintReport (cReport)
    '**********************************************************
    ' Author  : Pat Tormey Tormey @foursquare.com
    ' Date    : 7 April 1996
    '**********************************************************
    On Error GoTo PrintReport_ERR
      DoCmd OpenReport cReport, A_NORMAL
    PrintReport_EXIT:
        Exit Function
           
    PrintReport_ERR:
      MsgBox "Note:" & Error$, 64, "Application Note: There is " & _
                                   "nothing wrong. Go back to sleep"
           
        Resume PrintReport_EXIT
           
    End Function


 7. Extracting the Network User ID using 16 Bit API Calls.
    -------------------------------------------------------------------
    ReplyTo: Pat Tormey  
    URL:     http://www.wji.com/access/w9347.html
    Access Versions: All

    This file extracts the Network User ID in Access 2.0 using the 16 
    Bit API calls.

    I must admit that I stole this idea from somebody, probably Dan 
    Appleman.  I recommend his books 'Visual Basic Programmer's Guide to 
    the Windows API' for 16 bit calls and  'Visual Basic Programmers 
    Guide to the WIN 32 API' for 32 bit calls.

    Option Compare Database 'Use database order for string comparisons
    Option Explicit
           
    ' Uses WINDOW API to get the Net Users Name from the Local Area
    '  Network
    ' You can use this to see if the users should have write/delete
    '  privileges, or to secretly tag who did what last!

    Declare Function wu_WNetGetUser% Lib "USER.EXE" Alias _
     "WNetGetUser" (ByVal szUser$, lpnBufferSize%)
           
    Function NetworkUserID () As String
    '**********************************************************
    ' Author  : Pat Tormey Tormey @foursquare.com
    ' Date    : 7 April 1996
    '**********************************************************
      On Error GoTo NetworkUserID_ERR
      Dim szUser As String * 255
      Dim lpnBufferSize As Integer
      Dim status As Integer
           
      lpnBufferSize = 255
      status = wu_WNetGetUser(szUser, lpnBufferSize)
      If (status = 3) Then
        NetworkUserID = "WNetGetUser Failed"
      Else
        'Return up to first Null.
        NetworkUserID = Left$(szUser, InStr(szUser, Chr(0)) - 1)
      End If
           
    NetworkUserID_EXIT:
        Exit Function
           
    NetworkUserID_ERR:
      MsgBox "Note:" & Error$, 64, "Application Note"
        Resume NetworkUserID_EXIT
           
    End Function


 8. Showing System Objects And "Select *" Don't Mix In Replicas
    -------------------------------------------------------------------
    ReplyTo: Philip Hurzeler  
    URL:     http://www.wji.com/access/w9341.html
    Access Versions: 97, possibly 95 (Try this in Access 95, and

    If any controls in your replicated Access 97 database have row 
    sources that start with 'SELECT * FROM...', you can create bugs by 
    setting the 'Show System Objects' option on or off.
           
    Setting the option on makes visible the system columns devoted to 
    replication, which can have a ripple effect.  For instance, the 
    ordinal values of the Column property of list or combo boxes all get 
    bumped up by 3 unless the row source property calls out each column 
    by name.

    One way you can prevent this problem is to avoid 'SELECT' in row 
    sources.  Another way is to set the Application's 'Show System 
    Objects' option to False in your Autoexec macro or startup form's 
    Open event.


 9. Viewing Logged-on Users Through the .LDB
    -------------------------------------------------------------------
    ReplyTo: Thom Allen  
    URL:     http://www.wji.com/access/w9322.html
    Access Version: 2.0

    For a very rudimentary view of who is logged in to a database, read 
    the .LDB file.  Remember that the .LDB is not cleared when a user 
    logs out, so this is not 100% accurate, but at least you can get an 
    idea who is in or has been. I run the function from a Macro, and a 
    nice little pop-up box displays the user names in the .LDB file.  

    Have fun, and I would like any feed back.  I also have a version 
    that allows for you to enter an .LDB file name anywhere on the 
    network and display the users in that database as well.
           
    Function WhosInDB ()
           
    Dim varPullID As String
    Dim varUserID As String * 64
    Dim Indx As Long
    Dim varArray() As String
    Dim varDisplay As String
    Dim varLDBName As String
    Dim dbName As Database
    Dim varBackPath As Integer
    Dim Max As Integer
           
    Set dbName = CurrentDB()
    varLDBName = Left(dbName.Name, Len(dbName.Name) - 4) & _
                  ".LDB"   ' Assign .LDB file name
           
    On Error GoTo errFileOpenError
    Open varLDBName For Random Shared As #1 Len = Len(varUserID)
      ' Open to read file.
    Max = LOF(1) / Len(varUserID)
    ReDim varArray(1, Max)          ' Set up Array to hold user names
    For Indx = 1 To Max             ' Loop to cycle through entries.
       On Error GoTo errGatheringUsers
       Get #1, Indx, varUserID            ' Read from file.
       varPullID = Mid(varUserID, 33, 7)  ' Pull User ID from 64 bites
       varArray(1, Indx) = varPullID      ' Assign User ID to Array

    ' Put User ID's in one variable
       varDisplay = varDisplay & varArray(1, Indx) & Chr(13)     
    Next Indx
       ' Display users in MsgBox
       MsgBox "These users are currently" & Chr(13) _
              "logged into the database:" & _
              Chr(13) & Chr(13) & varDisplay               
    Close #1                               ' Close file
    Exit Function
           
    errNoLDBFile:
       MsgBox "There is no LDB file to pull data from"
       Exit Function
           
    errFileOpenError:
       MsgBox "There was an error opening the LDB file for read. " & _
          "Please try again."
       Exit Function
           
    errGatheringUsers:
       MsgBox "There was an error gathering the User names. " & _
               "Please try again."
       Exit Function
           
    End Function
           

10. Handling Year 2000 Issues (Y2K)
    -------------------------------------------------------------------
    ReplyTo: Christopher R. Baker  
    URL:     http://www.wji.com/access/w9268.html
    ftp://ftp.wji.com/access/sagent.zip  //-Download SAgent.ZIP (19,435)
    Keywords: TIPS YEAR 2000
    Access Versions: 2.0 and Up
    
    Editor's Note.  SAgent.mdb comprises of source code and demo files 
    from Chris Baker's January, 1998 presentation to the Access User 
    Group in Boston.

    In the sample below, Chris creates a manageable technique to control 
    Access intrinsic Y2K methods. For details of this and many other 
    handy routines download SAgent.mdb (Access 2.0.)

    Function saCentury (varDate As Variant) As Variant
    On Error GoTo Err_saCentury
    ' Chris Baker cBaker @SpecialAgent.com
    ' Given a date with a two digit year, Access 2.0
    ' ALWAYS ASSUMES THE YEAR IS 19xx
    ' Regardless of the system date.
    '
    ' This routine compensates for 2-digit year ambiguity by creating
    ' 100 year window for valid dates.  The window 'rolls over' at
    ' the year calculated by adding FUTURE_YEARS to the present system
    ' year.
    '
    ' This system does not properly handle all four digit years that
    ' fall outside of the 100 year window.
    '

    Const FUTURE_YEARS = 10

      Dim intDateYear As Integer    'Year part of date to be tested
      Dim intFutureYear As Integer  'Future Year Cutoff for all dates
      Dim intPastYear As Integer    '

      saCentury = varDate
      If IsDate(varDate) Then
        intDateYear = DatePart("yyyy", varDate)
        intFutureYear = DatePart("yyyy", Now) + FUTURE_YEARS
        intPastYear = intFutureYear - 100
        If (intDateYear > intFutureYear) Then
          saCentury = DateAdd("yyyy", -100, varDate)
        ElseIf (intDateYear <= intPastYear) Then
          saCentury = DateAdd("yyyy", 100, varDate)
        End If
      End If

    Exit_saCentury:
      Exit Function

    Err_saCentury:
    '!!  saMsgErr Error$, Err, "zbasUtility.saCentury"
      Resume Exit_saCentury
    End Function


11. Achieving Automation Goals using Database Documenters Code.
    -------------------------------------------------------------------
    ReplyTo: Michael Kaplan  
    ReplyTo: Mark Higham  
    URL:     http://www.wji.com/access/w9260.html
    URL:     http://www.wji.com/access/w9270.html
    RE: Interrogating Macros Using Automation by Mike Swift.

    I have an application which, using Automation and COM does the following 
    things:

    o Starts an Access session
    o Loads a database from a pre-defined list of files
    o Looks through each collection - Forms, Queries, Modules etc.
    o Opens, design view, each item in these collections
    o Prints the properties of the items (or components within the items.)
    o For modules, the application interrogates individual lines of 
      source code (using the Lines property), and searches for certain 
      keywords.

    Now, I want to do the same thing with Macros as I've done with 
    modules - using automation....

    Kaplan replies:  

    Have you considered perhaps looking at the Database Documenter's 
    code in the unlocked wizards and trying to make that work for you?

    There are no guarantees that this will work past Access 97, but 
    you are in undocumented-land already as it is.

    Higham replies: 

    You could try doing something with the Application.SaveAsText 
    procedure.  This procedure is a hidden member of the 'Access 
    Application Object'.  Go to your 'Object Browser' and ensure that 
    'Show Hidden Members' is checked.   The syntax is relatively 
    straightforward

    Application.SaveAsText acMacro, "YOURMACROHERE", "FILENAMEHERE"

    You still have to parse the text file.


12. Repairing and Compacting with Jet API's:  A Question
    -------------------------------------------------------------------
    ReplyTo: Michael Kaplan  
    URL:     http://www.wji.com/access/w9259.html
    RE: Repairing and Compacting Databases Automatically by Holger Rohlfs.

    Is there a possibility to repair and compact a database 
    automatically, AND finding out if an error occurred in Access 2.0? 
    Currently I use the following code:

    Code (and further details) Follow

    There is no fix or anything here that you can do. The only reason 
    that Access is able to warn you of errors is that they use Jet 
    directly, not DAO.

    There is no way that anyone outside of Microsoft can do the Jet APIs 
    to compact or repair, and that is the only way you would be able to 
    do this.


13. Optimizing the Speed of Report Runs.
    -------------------------------------------------------------------
    ReplyTo: Dave Milidonis  
    URL:     http://www.wji.com/access/w9263.html
    Access Version: 7.0

    While working on a client project I stumbled on a neat trick for 
    optimizing the speed of report runs.  Reports tend to run faster off 
    tables, rather than directly off queries, so create a "make table" 
    query for your report data.   Once done, use an Event Procedure on 
    the report's On_Open event and insert the following code:
       
    Private Sub Report_Open(Cancel As Integer)
        DoCmd.OpenQuery "mkqryName",,acReadOnly
        DoCmd.OpenReport "rptName", acViewPreview
    End Sub
           
    Now, run the report.

    The query executes creating the table and bringing up the report. 
    All with the click of a mouse.   I am sure any developer could add 
    more to the event procedure in order to further automate 
    processing. For example: Saving the Report to a file; sending the 
    report; etc.


14. Creating a Flexible User Interface Design with 'System' Tables
    -------------------------------------------------------------------
    ReplyTo: Robert S. Ruder  
    URL:     http://www.wji.com/access/w9224.html
    Access Versions: 97

    It has occurred to me that if you take the concept of databases to 
    a logical conclusion, then the whole process of designing a 
    database is built around sets of data which describe the nature 
    and process of the database. This is in fact what Microsoft 
    employs in their System Tables. What I decided to develop was a 
    database design which would allow me to add functionality to the 
    database by simply adding a record to a table which defined that 
    functionality.

    What I have managed to build is a user interface which is designed 
    around an initial 'database map' form which allows the user to 
    choose a selection of database tasks based on a selected 
    category... in this case I use a department metaphor. However, no 
    matter which department the user selects, the second form you go 
    to is the same, but as it opens, I query my system table to find 
    out how to modify the form for the chosen department.

    My system tables are as follows: 

        Table Name:   Task Categories
        Fields:       TaskCategoryID  AutoNumber
                      CategoryName    Text

        Table Name:   Tasks                                            
        Fields:       TaskID          AutoNumber
                      TaskName        Text
                      TaskCategory    Number-Long Integer
                      TaskSubForm     Text

    When the user clicks on a map item, the following code is 
    executed:

    Function DisplayTasks(Dept As Integer)
      'The Dept value is passed in, i.e. =displayTasks(1)
      Dim tempdb As Database, temprs As Recordset
      Dim SQLst As String

      Set tempdb = CurrentDb
      SQLst = "Select * from TaskCategories where TaskCategoryID = " & _
               Dept Set temprs = tempdb.OpenRecordset(SQLst)

      DoCmd.OpenForm "Unit Form", acNormal
      Forms![Unit Form].Caption = temprs![CategoryName] & "Tasks"
      Forms![Unit Form]![Title] = temprs![CategoryName] & "Options"
      Forms![Unit Form]![TaskCatID] = Dept
    End Function

    The control [TaskCatID] is an unbound Text Box which is the Link 
    Master for a subform control. It displays the appropriate tasks 
    for the department selected. The form [Unit Form] also contains 
    another unbound subform control. Because my Tasks system table 
    contains the field [TaskSubform], I have a location where I can 
    store the name of the appropriate subform for the defined task. In 
    the On Current event for the tasks subform, I execute the 
    following code:

    Parent![SubDisplay].SourceObject = _
           IIf(IsNull([TaskSubForm]),"sfrm_None", [TaskSubForm])

    The result is that which ever record becomes current in the left 
    hand list of tasks, the appropriate subform is displayed in the 
    right hand subform control. As my list of tasks grows, all I must 
    do is create a subform which can perform the task, add the task to 
    the tasks table, categorize it, and add its subform name. The rest 
    is already in place.

    I am currently working on expanding this concept to include 
    information about attached tables and data synchronization 
    information between two attached data sources. My code can simply 
    loop through a set of data and attach and synchronize the data 
    automatically. Overall, I'm pleased with the ability to create 
    dynamic designs by incorporating my own custom system tables.


15. ODBCDirect Askew Without VB 5.0 Pro Installed
    -------------------------------------------------------------------
    ReplyTo: Kevin Bruton  
    URL:     http://www.wji.com/access/w9258.html
    Access Version: 97

    ODBCDirect demonstrates unpredictible behaviour when VB 5.0 
    Professional is not installed on a machine. Sample Code :

    Open RecordSet

    Set rsProduct = gblcnnODBC.OpenRecordset(strSQL, dbOpenDynaset, _
                     0, dbOptimisticValue)

    'Then later on issue a

      With rsProduct
          .Edit
           rsProduct!Fields = Something
          .Update
      End With

    Locking problem encountered:

    Machine A updates the same record Machine B is viewing. Machine B 
    tries to update the record, If VB 5.0 is installed, the record 
    locking error is correctly triggered, if VB 5.0 is not installed, 
    no error is returned, but the record is not updated.

    Error : 0 Assignment error.

        With Recordset
               .Edit
               rsProduct!Fields = Something
               .Update
        End With

    Machine A, tries to Update Record, receives error (VB 5.0 not 
    installed.) Machine B, tries to Update Record, suceeds (VB 5.0 
    installed.)

    The code is identical on the two machines , the only differance is 
    when VB 0.5 Pro is installed. How can this be solved without 
    installing VB 5.0 Pro on each machine?

    Installing the latest DAO (1.5) drivers did not solve this 
    problem.


16. Setting Echo On/Off For Debugging
    -------------------------------------------------------------------
    ReplyTo: Mark Higham  
    URL:     http://www.wji.com/access/w9256.html
    RE:      Speeding Up Your Front End with the Echo Method by Paul Brower.
    Access Versions: 2.0 (?), 7.0, 8.0

    Are you aware that the Echo Method is a great tool for speeding up 
    many processes. When used correctly, the echo method will stop the 
    screen from being updated/repainted.
       
    Let's say that you have a Customer Screen (frmCustomer), and an 
    Invoice Screen (frmInvoice).  You want to be able to allow users 
    to double click an invoice, and go directly to the customer.  Here 
    is the Event you would use:

    Code follows:

    When debugging Access 97 code that has the echo set to off, make 
    sure that you set the debug window to be on top. That way you can 
    always do CTRL+G and get to it.

    In Access 97, I use compiler constants to set echo. For example:

    #If FDEBUG Then
        'continue as normal
    #Else
        Application.Echo False
    #End If


17. Printing Relations from Any Access 97 Database
    -------------------------------------------------------------------
    ReplyTo: Mark Higham  
    URL:     http://www.wji.com/access/w9153.html
    Access Versions: 8.0
    Keywords: PRINT RELATIONS
    ftp://ftp.wji.com/access/daorelat.exe  //-DAORELAT.EXE (219,407)

    I wrote this after downloading the Print Relations Wizard which 
    was patently no use.

    This self extracting zip file allows you to print out relations 
    from any Access 97 database, you can save each separate diagram. 
    Zoom in and out.

    Generally it gives good relational diagrams which you can include 
    in any documentation. 


18. Internet Database in German Access 97
    -------------------------------------------------------------------
    ReplyTo: Karl-Heinz Kristen  
    URL:     http://www.wji.com/access/w9155.html
    URL:     http://193.24.175.164/aspneu/VhsStart.htm //-Online example
    ftp:     ftp.wji.com/access/i_net.zip  //-I-NET.ZIP (199,811)

    Product Ver.: German Access 2.0 and 8.0, German IIS and German NT
    System:       Windows NT / Windows 95 - InternetServer 3.0
    Development:  ASP (ActiveServerPages) from MS must be installed.
    Database:     ACCESS 2.0 or ACCESS 7.0
    Language:     VBScript / VisualBasic (2.0 - 5.0)
    Important:    Use the Permission-Configuration from the 
                  InternetServer and check the Directorys of the InetPub 
                  for Read/Write & Run. 

    Step by Step Prodcedure to run the DB on an Intranet.

    1. Copy all Files to your InetPub-Root. I used the 
       E:\InetPub\wwwroot\aspneu as Directory

    2. Goto the ControlPanel to invoke the ODBC-Manager for a new 
       System-DSN entry.

       i. Check the System-DNS to make a new entry.
      ii. Check the ACCESS-Driver (Version 2.0/7.0)
     iii. Put in name of Database(ASP-File = aspneu), name it: aspneu
      iv. Check the Select-Button from Database and choose the      
          Database-Directory.  I used 
          E:\InetPub\wwwroot\aspneu\kurse2.mdb

     3. Now run IIE or Netscape and call Homepage (VHSSTART.HTM)

     For more Information on ASP.  A very good Book about ASP is 'ASP: 
     Working with ActiveServerPages', available at Carry Book Support 
     at http://www.caryp.com/


19. Access 8.0 Export Facilities.
    -------------------------------------------------------------------
    ReplyTo: Anders H. Madsen  
    URL:     http://www.wji.com/access/w9170.html
    Access Versions: 8.0
    ftp://ftp.wji.com/access/ac8exnl.zip  //-AC8EXNL.ZIP (210,080)

    Abstract

    The attached database includes two top level procedures for 
    exporting which can be used instead of TransferText in certain 
    situations.

    TransferText_nl

    This procedure is similar to TransferText but independent of 
    fields.  What this means is that TransferText_nl can be used with 
    tables and queries even if they have different fields than the 
    table or query, which were used when creating the import/export 
    specification. In other words, TransferText_nl works more like 
    TransferText in the good old Access 2.0.

    Limitations:  Only works for exporting of delimited test files. Can 
    not export to ASCII format.

    Export_nl

    This is an export procedure which in some ways are more flexible 
    than TransferText and TransferText_nl. The procedure is especially 
    valuable when exporting cross tab queries. The most important 
    facilities are:

    o  Uses import export specifications but independent of fields 
       (like Access 2.0)

    o  Also capable of using an other record separator than cariage 
       return line feed.

    o  Capable of sorting columns in complex ways.

    o  Can export two queries to the same file: Typically this is a 
       detail query and a totals query.

    o  Can convert null values to zero.

       Limitations: Only works for exporting of delimited test files.
       Cannot export to ASCII format.

    References to similar pieces of work

    http://www.wji.com/access/w6630.html -- Incompatibility Between 
    Access 2.0 and Access7.0/8.0 Text File Inport/Export by Shamil 
    Salakhetdinov. 

    Mr. Salakhetdinov has overcome the problem with Access 8.0's 
    dependence of fields in an other way. His approach is to create a 
    specification and then use Access's own TransferText. In short his 
    code has the following advantages:

    o  Can both import and export.
    o  Can handle both delimited and fixed width formats.
    o  Also works for ASCII format.
    o  Less code (= less memory footprint).

       
    In short our approach has the following advantages:

    o Several good facilities for handling cross tab queries (see the 
      comments in Export_nl below).

    o Can put together the results of a detail query and a totals 
      query into one export file.

    o Also capable of using an other record separator than cariage 
      return line feed.

    o You do not have to change any code to use other delimiters etc.


20. Customizing Function Keys in Access
    -------------------------------------------------------------------
    ReplyTo: Paul Brower  
    URL:     http://www.wji.com/access/w9172.html
    ftp://ftp.wji.com/access/fkeys.zip  //-FKEYS.ZIP (29,301)
    Access Versions: 8.0

    The file fKeys.mdb consists of 1 macro (AutoKeys), 1 form 
    (frmFKeys) and 1 module (mdlFkeys).

    These items will allow developers to run code by pressing a 
    function key.  The form frmFkeys allows users to customize what 
    function key will perform what action.  The windows registry is 
    used to keep track of the function key assignments.

    For an example, when you download this database, open up the form 
    frmFkeys, select "ScreenName" in the combo box, and click a 
    function key command button.  (i.e. F-5).  "ScreenName" will 
    appear in the text box under the command button.  You must now 
    exit the database and re-open it.  Now you can press function key 
    F-5 (or the one that you assigned), and if you have a form open, a 
    message box will appear with the form name.  By looking at my 
    code, you should be able to see that it will now be very simple 
    for you to create new subroutines and be able to execute them by 
    pressing a function key.

    I have a client that was using a system called TeleMagic, and they 
    were used to being able to print forms, etc, from the use of 
    function keys.  They asked that I provide the same functionality 
    with function keys in the new Access database, and this has worked 
    out very well.

    Important Notes:

    o You must add subroutine names to the combo box on the form 
      "frmFkeys."  i.e.  if you create a sub called "Calculate 
      Commission", you need to add "Calculate Commission" to the value 
      list in the combo box.  

    o I don't have any error code for these examples.  You will need 
      to create your own.

    o Additional key assignments could be made.  For example if you 
      wanted to assign a subroutine to "Ctl-F5", you would need to add 
      ^{F5} in the macro AutoKeys, and provide the necessary controls 
      and code on the form and module.

    o The function key values are stored in the windows registry as 
      "txtF#".  My code requires that a field prefixed with "txtF" be 
      present in order to write the registry information.  Feel free 
      to change this.

    o This code if free and available to all who dare to make their 
      development just a tad bit more user friendly, and cool.


21. Comment Block and UnComment Block Builders for Access 97
    -------------------------------------------------------------------
    ReplyTo: Mehmet Acikgoz  
    URL:     http://www.wji.com/access/w9154.html
    ftp://ftp.wji.com/access/pdncbuil.zip  //-PDNCBuil.ZIP (23,609)
    Keywords: COMMENT BLOCK UNCOMMENT BLOCK BUILDERS ACCESS 97
    Access Versions: 8.0

    In developing an Access application, the developer might 
    frequently need commenting out or un-commenting block of codes in 
    module windows. These are quite tedious processes if the block has 
    several tens of code lines.

    In complex modules, it might be useful to put some sort of signs 
    to mark commented blocks as showing "why they have been commented" 
    or in team work situations; "who commented out the block of code 
    lines and why".  These marks can play some sort of vital role in 
    programming techniques.

    To solve these issues, I present two separate builders in the same 
    file.


22. Passing SQL Strings to Access
    -------------------------------------------------------------------
    ReplyTo:  <>
    URL:     http://www.wji.com/access/w9223.html
    Access Versions: All.

    When passing SQL strings, you have to be careful about embedded 
    apostrophes and quotation marks. For example, this SQL command 
    will fail for the name O'Brien:
        
    strName = "O'Brien"
    DoCmd.RunSQL _
      "DELETE * FROM Customers WHERE Fullname = ' " & strName & " ';"
        
    Because of the embedded apostrophe in O'Brien, the SQL string 
    won't be interpreted properly.

    To solve this problem, I wrote a function called SafeSQLString 
    which surrounds the string in quotation marks. It also replaces 
    any embedded quotations marks with double quotations, which SQL 
    can handle. You use the function like this:
        
    strName = "O'Brien" 
    DoCmd.RunSQL _
     "DELETE * FROM Customers WHERE Fullname = " & _
      SafeSQLString(strName) & ";"         

    Here's the function along with the Replace helper function:

    Public Function SafeSQLString(Text As Variant) As Variant
    On Error GoTo Err_SafeSQLString 
        Const QUOTE = """"      ' That's 4 quotation marks in a row.
          
        If IsNull(Text) Then
            SafeSQLString = QUOTE & QUOTE
        Else
            SafeSQLString = QUOTE & _
                            Replace(Text, QUOTE, QUOTE & QUOTE) & QUOTE
        End If
              
    Exit_SafeSQLString:
        Exit Function
              
    Err_SafeSQLString:
        SafeSQLString = ""
        Resume Exit_SafeSQLString
              
    End Function 
        
    Public Function Replace(ByVal varValue As Variant, _
                            ByVal strFind As String, _
                            ByVal strReplace As String) As Variant
          
        Dim intLenFind As Integer
        Dim intLenReplace As Integer
        Dim intPos As Integer
              
        If IsNull(varValue) Then
            Replace = Null
        Else
            intLenFind = Len(strFind)
            intLenReplace = Len(strReplace)
                  
            intPos = 1
            Do
                intPos = InStr(intPos, varValue, strFind, 0)
                If intPos > 0 Then
                    varValue = 
                       Left(varValue, intPos - 1) & strReplace & _
                       Mid(varValue, intPos + intLenFind)
                    intPos = intPos + intLenReplace
                End If
            Loop Until intPos = 0
        End If
        Replace = varValue
              
    End Function
        
    I intentionally left out the single quotation mark. Since I'm 
    surrounding the string with double quotes, the single quotes are 
    no longer needed.  Here are some examples:

    o "DELETE * FROM Customers WHERE Fullname = " &
    SafeSQLString("O'Brien")

    The SQL engine will see the above string as:

    DELETE * FROM Customers WHERE Fullname = "O'Brien"

    o "DELETE * FROM Customers WHERE Fullname = " & 
      SafeSQLString("O'Brien")

    The SQL engine will see the above string as:

    DELETE * FROM Customers WHERE Fullname = "O'Brien"

    o strName = "An embedded " & """" & " double quote!"
    '  translates to: An embedded " double quote!

    "DELETE * FROM Customers WHERE Fullname = " & _
     SafeSQLString(strName)

    The SQL engine will see the above string as:

    DELETE * FROM Customers WHERE Fullname = "An embedded "" double quote!"


23. LookIn on Outlook to Speed Up Access and Office
    -------------------------------------------------------------------
    ReplyTo: Bharat Ahluwalia  
    URL:     http://www.wji.com/access/w9142.html
    Product Versions: Access 97, Office 97

    If you have MS Outlook installed, your Access 97 and other Office 
    97 applications can be speeded up by changing some of the default 
    values.

    o  Open Outlook
    o  Go to Options under the Tools menu.
    o  Click on the Journal tab.
    o  Uncheck all the boxes from the Also Record files from: listbox.

    If an application is checked, everytime you open the application a 
    journal entry is created, thus slowing you down.


24. From the Publisher
    -------------------------------------------------------------------
    The Access Email Newsletter is created and distributed compliments 
    of the World Wide Developer Network (WWDN) of Boston, Massachusetts, 
    USA.  Come, get involved!  This is the place where developers talk 
    to developers as peers.

    Publisher:
        Les Squires 
        Word Jenny, Inc.
        400 West Cummings Park, Woburn (Boston), Massachusetts USA   
        781-935-1520

    Editors/Content Specialists
        Phil Denoncourt III 
        Pat Tormey          
        Brendan Donovan     

    Website:  http://www.wji.com/access/homepage.html
  
    Address Changes:
        Send an email USING YOUR OLD ADDRESS.
        Indicate New Address.
    
    Adding Subscribers to Mailing List:
        Send Email to access @WJI.Com.
        Include String ACCESS-YES in Subject: or Body of Message.
    
    Deleting Subscribers:
        Send Email to Access @WJI.Com.
        Include String ACCESS-NO in Subject: or Body of Message.
    
    Retrieving Back Issues and General Downloads:
         FTP to ftp.wji.com.
         Login as FTP.
         Use your ID as your password.
         cd access
         Copy back issues and downloads as they become available.
    
(c) 1998 World Wide Developer Network (WWDN)
From:	NANCY M LANDREVILLE [nancyml @juno.com]
Sent:	Saturday, February 07, 1998 9:14 AM
To:	Rick @CICorp.com
Subject:	Re: FYI:      Board List - Jan 31st, 1998

Yes I would Rick.  I'm attending conferences on Access in March.  I have
freed my time up so that I can devote more time for Access work.  I
mentioned this to you before that I would "ease" into it.  
Thanks in advance for the CC's.
Nancy L.

_____________________________________________________________________
You don't need to buy Internet access to use free Internet e-mail.
Get completely free e-mail from Juno at http://www.juno.com
Or call Juno at (800) 654-JUNO [654-5866]

From:	Rick @CICorp.com
Sent:	Friday, February 06, 1998 1:39 PM
To:	Barbara Conn
Subject:	RE: next meeting of Access SIG

Yes, that sounds fine.


> -----Original Message-----
> From: Barbara Conn [mailto:bconn @cpcug.org]
> Sent: February 6, 1998 12:03 PM
> To: Rick Shaddock
> Subject: next meeting of Access SIG
> 
> 
> 
> Hi, Rick,
> 
> I assume that the next meeting of Access SIG is March 9?
> Not February 9?
> 
> Thanks,
> 
> 
> Barb
> 
> From:	Barbara Conn [bconn @cpcug.org]
Sent:	Friday, February 06, 1998 12:03 PM
To:	Rick Shaddock
Subject:	next meeting of Access SIG


Hi, Rick,

I assume that the next meeting of Access SIG is March 9?
Not February 9?

Thanks,


Barb

From:	Capital PC User Group Board of Directors Communications [CPCUGBOD-L @CPCUG.ORG] on behalf of Randy Steer [r_steer @CPCUG.ORG]
Sent:	Thursday, February 05, 1998 9:33 PM
To:	CPCUGBOD-L @CPCUG.ORG
Subject:	     Re: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup             (MAAUG)

On Wed, 4 Feb 1998, Gabe Goldberg wrote:

> we get their treasury. Part of any merger is mapping joining group's
> treasury into CPCUG benefits. This is implementation of a merger, not an
> obstacle to it. What's your point about mergers? If the joining group
> thought they'd lose too much benefits, they wouldn't join.

It's not a problem as long as everyone has thought about it.  I'm assuming
that any group that charges $40/year, which was more than we charge until
a few months ago, was providing some concrete benefits that could be
expensive.  If it'a only paying for a few-page flyer to be mailed out,
then the content can be incorporated into the Monitor.  If they're mailing
out 20 pages of specialized articles on that one SIG's interest, we need
to know that they accept the fact that they won't be able to provide that
much coverage in the Monitor.  If they're happy, I'm happy, as long as
their happiness is informed.

Randy.
From:	Rick @CICorp.com
Sent:	Thursday, February 05, 1998 3:13 PM
To:	wbryan @rus.usda.gov
Subject:	Access meetings

Access Special Interest Group
Meets after main meeting of CPCUG
(See above)
The CPCUG Access SIG presently meets for question & answer (& snacks) at the NIH caferia immediately after the main meeting. We also try to answer at least 10 questions as a group from the computer based multiple choice practice test for the Microsoft Access Certified Professional Examination. We discuss why each answer is or is not correct, and always end up learning something new.

Mid-Atlantic Access Users Group (MAAUG)
Meets 3rd Tuesday of each month at 7:00pm
National Association Social Workers
(next to Union Station Metro)
750 1st Street NE
Suite 700
Washington, DC
The Mid-Atlantic Access User Group (MAAUG), has been in operation for about three years. Guest speakers include Luke Chung of FMS and Andrew Coupe of the Microsoft Access development team. The CPCUG and MAAUG have a mix of members ranging from novices to a number of very experienced programmers. 
Contact: Bruce Troutman 800-918-5670


Thank you. This has been corrected in the Monitor and Web site.

> -----Original Message-----
> From: wbryan @rus.usda.gov [mailto:wbryan @rus.usda.gov]
> Sent: February 3, 1998 9:06 AM
> To: rick @cicorp.com
> Subject: ...no subject...
> 
> 
> Hi Rick,
> 
> I was trying to find out when the next Access users group meeting will be. 
> I was at WGAS at 2 on Sunday the 1st but apparently it was a misprint that 
> there would be a meeting then. I'd appreciate any information. Thanks
> 
> Bill Bryan
> From:	Barbara Conn [bconn @cpcug.org]
Sent:	Thursday, February 05, 1998 12:44 PM
To:	Rick @CICorp.com
Subject:	Re: Access SIG meeting after Main meeting

On Thu, 5 Feb 1998 Rick @CICorp.com wrote:

> Just a reminder to put in the Monitor and Web site that the Access SIG now
> meets after the main meeting in the cafeteria.  This will be so for the time
> being.
> 
> Possibly in a couple months we will be listing the Mid Atlantic Access Users
> Group as a SIG, but for now please list us as meeting at the NIH.  Thanks
> 

Will do.  I'll update your Web page as well.

Thanks, Rick,


Barb

From:	Rick @CICorp.com
Sent:	Thursday, February 05, 1998 11:29 AM
To:	Nancy @CICorp.com
Subject:	FYI:      Board List - Jan 31st, 1998

Nancy, 
Would you some day like to be the Chairman of the Access SIG?
Shall I copy you on the emails so you get an idea what goes on?
It could be a good opportunity and resume item.
If they meet in Twinbrook that would be convenient.
It seems I'll be doing so much travelling it will be harder for me to 
do it justice.  But I would say it uses an average of an hour or
two a week. 

-----Original Message-----
From: Capital PC User Group Board of Directors Communications
[mailto:CPCUGBOD-L @CPCUG.ORG] On Behalf Of Clifford Porter
Sent: February 4, 1998 5:14 PM
To: CPCUGBOD-L @CPCUG.ORG
Subject: Board List - Jan 31st, 1998


I am resending this as the first try didn't seem to work.
The only change from December are the numbers for Mary Brosnan.


CAPITAL PC USER GROUP BOARD OF DIRECTORS
January 31st, 1998
Telephone List of Officers and SIG Contacts

* = not for public use
D = Weekdays
? = not confirmed
E/W = Evenings and Weekends

JANE BENSON
RESTON SIG
D (703)715-1032
E/W (703)715-1032
Fax (703)715-8455
jbenson @shirenet.com

MARY BROSNAN
ELECTRONIC PUBLISHING SIG
D /E/W (703)207-0477 or 800-609-2214
Fax (703)207-0479
cameronprs @aol.com

JACK CARLSON
SENIOR SIG
D (301)286-7140
E/W (301)474-7091

ROBERT CLEMENZI
PARADOX SIG
D (703)827-2365
E (703)791-5747
clemenzi @cpcug.org

BARBARA CONN
CORPORATE COMMUNICATIONS DIRECTOR
MONITOR EDITOR/PUBLISHER
D (202)508-1494
E/W (202)452-7484
Fax (202)508-3698
bconn @cpcug.org

BRUCE COTTOM
PROJECT MANAGEMENT SIG
E/W (301)869-5690
bcottom @cpcug.org

BILL DEROCHE
MEDICAL COMPUTING DIRECTOR
D (202)283-5237
E/W (301)530-9699
wderoche @cpcug.org

CHIP DODGE
BUILD OR BUY; BUYING GROUP DIRECTOR
D* (703)767-3619
E/W (703)425-7038
cdodgemd @aol.com

STAN DOORE
PAST PRESIDENT
D (301)572-4939
E/W (301)572-4939
Fax (301)572-9165
stan.doore @mix.cpcug.org

ANN DORSEY
LIBRARY SERVICES DIRECTOR
D (301)320-7984
E/W (301)320-7984
abdorsey @cpcug.org

DAVID DRAZIN
AUTOCAD SIG
D* (202)529-7474
E/W (301)279-7593
Fax (202)529-0332

GEORGE ELY
PUBLIC RELATIONS DIRECTOR
D (301)762-3002
E/W (301)762-3002
gely @cpcug.org

HERB FREDRICKSEN
MARYLAND VICE PRESIDENT; GEOWORKS SIG
D (301)840-2056
E/W (301)840-2056
Fax (301)840-2056 (call first)
herb.fredricksen @mix.cpcug.org

LUIS GARCIA
VIRGINIA VICE PRESIDENT
D (301)457-1451
E/W (703)425-6902
Fax (301)457-3033
lgarcia @census.gov (work)

GABE GOLDBERG
INTERNET SIG
(703)941-1657
Fax (703)941-1791
gabe @acm.org

CHARLES HALLAHAN
STATISTICS SIG
D* (202)694-5051
E/W (703)532-2930
Fax (202)694-5718
hallahan @econ.ag.gov

WALTER HOUSER
SCIENCE FAIR COORDINATOR; HTML SIG
D (202)273-8012
E/W (301)299-0593
Fax (202)273-8159
houser @cpcug.org (At work)

CAROL HYATT
K-12 EDUCATION DIRECTOR
D (301)948-3748
E/W (301)948-3748
chyatt @mindspring.com



PEGGY IRELAND
PROGRAM
D (301)423-1618
E/W (301)423-1618
Fax (301)423-3488
ireland @cpcug.org

PEGGY KAUDERS
pkauders @erols.com

JERRY LAWSON
TRAINING DIRECTOR
E/W (703)541-0928
virtual @mindspring.com

LES LE VINE
WORDPERFECT SIG / BEGINNERS SIG
D (301)652-2532
E/W (301)652-2532
les.le.vine @mix.cpcug.org

BILL LUTZ
BALTIMORE SIG
D (410)256-9403
E/W (410)256-9403
wllutz @aol.com

RICHARD MALEY
DELPHI SIG
D (301)840-1554
E/W (301)840-1554
75127.17 @compuserve.com

LARRY MCGOLDRICK
INTERNET SERVICES DIRECTOR
larrym @cpcug.org

KEVIN MCCRORY
OS/2 SIG
kmccrory @mnsinc.com


PATRICK MCVEIGH
TREASURER; WINDOWS SIG
E/W (301)963-7304
pmcveigh @cpcug.org

LILLIAN MILLINER
PRESIDENT
D (301)933-1717
E/W (301)963-9053
Fax (301)963-9386
milliner @cpcug.org

HENRY NOBLE
CORPORATE INFORMATION SYSTEMS DIRECTOR
D (301)963-3737
E/W (301)963-3737
noble @cpcug.org

ALTA OBEN
MetroMUG SIG
D* (703)613-7581
E/W (703)938-5831
Fax (703)938-5831 (call first)
alta @cpcug.org

CLIFFORD PORTER (MRS.)
INTERIM SECRETARY
D (301)762-9480
E/W (301)762-9480
chp2 @erols.com

BILL REDISCH
FRAMEWORK SIG
D (301)286-6203
E/W (301)279-7929
bill.redisch @gsfc.nasa.gov

NORMAN RISCH
PEACHTREE SIG
D (301)681-8088
E/W (301)754-0735
norman.risch @mix.cpcug.org

ROY ROSFELD
LEISURE WORLD SIG
D (301)598-2825
E/W (301)598-2825
rosfeld @hot.mail.com

NASEEM F. SAAB
CLIPPER SIG
D (703)860-5022
Fax (703)264-1345
nsaab @ix.netcom.com

RICH SCHINNELL
FIRST VICE PRESIDENT
D (301) 949-9292
E/W (301)949-9292
Fax (301)949-8847
schinnel @cpcug.org

RICK SHADDOCK
ACCESS (MICROSOFT) SIG
D(703)486-2222 or (202)829-4444
rick @cicorp.com

PAUL SHAPIRO
DIRECTOR OF VOLUNTEERS
D (301)770-7899
E/W 9am-9pm (301)770-9512
pauls @cpcug.org  or pauls @capaccess.org

A. GREG SMITH
PAST PRESIDENT
gsmith @mail.thuntek.net

RANDY STEER
CAPITAL AREA VICE PRESIDENT
D (202)395-3164
E/W (202)745-5932
Fax (202)395-3165
r_steer @cpcug.org




RENE THIRION
COMMUNITY SERVICES DIRECTOR / MIX SYSOP
D/E/W (703)256-6764
rene @cpcug.org

ANDY THOMPSON
INVESTMENT SIG
D* (202)529-3330
E/W (301)270-6790
Fax (202)529-0911
pallotti01 @aol.com

HARLEY WILBUR
INVESTMENT SIG
D (301)949-8131
hwilbur @cpcug.org

STEVE WORKINGS
ALPHA SIG
D/E/W (301)933-3832
Fax (301)933-4161
steve @workings.com

RUBEN WORRELL
PROJECT MANAGEMENT AND VISUAL BASIC SIG;
(703)276-3000
E/W pager (202)490-0166
Fax (703)276-3017
worrellr @cpcug.org

C. PATRICK ZILLIACUS
OS/2 SIG
E/W (301)384-0972
Fax* (301)384-1740
patrick.zilliacus @mix.cpcug.org
From:	Rick @CICorp.com
Sent:	Thursday, February 05, 1998 11:29 AM
To:	bconn @cpcug.org
Subject:	Access SIG meeting after Main meeting

Just a reminder to put in the Monitor and Web site that the Access SIG now meets after the main meeting in the cafeteria.  This will be so for the time being.  

Possibly in a couple months we will be listing the Mid Atlantic Access Users Group as a SIG, but for now please list us as meeting at the NIH.  ThanksFrom:	Capital PC User Group Board of Directors Communications [CPCUGBOD-L @CPCUG.ORG] on behalf of Gabe Goldberg [gabe @CPCUG.ORG]
Sent:	Wednesday, February 04, 1998 8:50 PM
To:	CPCUGBOD-L @CPCUG.ORG
Subject:	     Re: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup             (MAAUG)

On Wed, 4 Feb 1998, Randy Steer wrote:

> One other question comes to mind re: the $40 dues that MAAUG currently
> charges -- What is it currently paying for, and how will that be paid for
> if the group becomes a CPCUG SIG?  I doubt if we could afford to pay for
> $40 worth of whatever for every member of that SIG out of the dues we
> collect.

We just merged with ACT! User Group. they collected dues, didn't get much
for it. So all their paid members become CPCUG members, get our benefits,
we get their treasury. Part of any merger is mapping joining group's
treasury into CPCUG benefits. This is implementation of a merger, not an
obstacle to it. What's your point about mergers? If the joining group
thought they'd lose too much benefits, they wouldn't join. Once they
decide to join, there's nothing to bargain, they're members like everyone
else. The treasury buys pro-rated CPCUG memberships for whoever they say
are members.
From:	Capital PC User Group Board of Directors Communications [CPCUGBOD-L @CPCUG.ORG] on behalf of Randy Steer [r_steer @CPCUG.ORG]
Sent:	Wednesday, February 04, 1998 6:27 PM
To:	CPCUGBOD-L @CPCUG.ORG
Subject:	     Re: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup             (MAAUG)

One other question comes to mind re: the $40 dues that MAAUG currently
charges -- What is it currently paying for, and how will that be paid for
if the group becomes a CPCUG SIG?  I doubt if we could afford to pay for
$40 worth of whatever for every member of that SIG out of the dues we
collect.

Randy.
From:	Rick @CICorp.com
Sent:	Wednesday, February 04, 1998 4:27 PM
To:	Nancy @CICorp.com
Subject:	FW:      Re: Twinbrook office facility, visit if you wish



-----Original Message-----
From: Capital PC User Group Board of Directors Communications
[mailto:CPCUGBOD-L @CPCUG.ORG] On Behalf Of Gabe Goldberg
Sent: February 4, 1998 7:26 AM
To: CPCUGBOD-L @CPCUG.ORG
Subject: Re: Twinbrook office facility, visit if you wish


On Wed, 4 Feb 1998, Rich Schinnell wrote:

> Wednesday the 4th of Feb between 2:30pm and 3, I will be at the prospective
> new facilities for anyone that wishes to see what is there.

I'd join if given more than a few hours' notice of the field trip --
some days, it's hard to drop everything instantly for CPCUG.
Perhaps negotiate another visit on the weekend -- Saturday
morning, or Sunday afternoon.
From:	Rick @CICorp.com
Sent:	Tuesday, February 03, 1998 11:00 PM
To:	Beverlie Heyman
Subject:	RE: Re[2]: Ok  Looking forward to talking with you.

Please explain the situation to anyone at the office at 202-829-4444 or myself at 800-338-0225 x 2674.


>      From:	Rick @CICorp.com
Sent:	Monday, February 02, 1998 8:16 AM
To:	pave @dgsys.com
Subject:	RE: Access meeting

> From: G.Venediktova 
> Hi, Rick, I would like to know if there will be a meeting tomorrow and do I
> need any code to get inside the  building (Wash Gas, right?)
> 
> Thanks,
> 
> Galina Venediktova
> FSU Internet Consultant,
> Network of East-West Women
> pave @dgs.dgsys.com
> tel. (703)-237-3890 fax (202) 265-3508
> 

Sorry I just got your message.
We are meeting after the main meeting instead of separately.  We are also considering merging with the Mid-Atlantic Access Users Group.  

Here is some information.

Access Special Interest Group
Meets after main meeting of CPCUG
(See above)
The CPCUG Access SIG presently meets for question & answer (& snacks) at the NIH caferia immediately after the main meeting. We also try to answer at least 10 questions as a group from the computer based multiple choice practice test for the Microsoft Access Certified Professional Examination. We discuss why each answer is or is not correct, and always end up learning something new.

Mid-Atlantic Access Users Group (MAAUG)
Meets 3rd Tuesday of each month at 7:00pm
National Association Social Workers
(next to Union Station Metro)
750 1st Street NE
Suite 700
Washington, DC
The Mid-Atlantic Access User Group (MAAUG), has been in operation for about three years. Guest speakers include Luke Chung of FMS and Andrew Coupe of the Microsoft Access development team. The CPCUG and MAAUG have a mix of members ranging from novices to a number of very experienced programmers. 
Contact: Bruce Troutman 800-918-5670


-----Original Message-----
From: Capital PC User Group Board of Directors Communications
[mailto:CPCUGBOD-L @cpcug.org] On Behalf Of Clifford Porter
Sent: January 26, 1998 2:15 PM
To: CPCUGBOD-L @cpcug.org
Subject: Agenda for 2/2/98 BOD Meeting


Please send any additions or corrections to Clifford Porter.


        BOARD OF DIRECTORS MEETING
        February 2nd, 1998
        7:30 p.m.
        Proposed Agenda

1. Agenda Approval

2. Minutes
        Approval of the Minutes of the previous meeting, January 5th, 1998.

3.. Officers Reports
        President - Lillian Milliner
        First Vice President - Rich Schinnell
        Maryland Vice President - Herb Fredricksen
        Virginia Vice President - Luis Garcia
        Capital Area Vice President - Randy Steer
        Treasurer - Pat McVeigh

4.. Project Status Reports
        Location of CPCUG facility.
        Entertainment Books - Alta Oben

5. Unfinished Business

6. New Business
        Affiliation of the ACT! User Group with CPCUG as a provisonal SIG to be
known as the Sales Force Automation SIG.

7. Good and Welfare  (Matters Arising)

8. Adjournment
From:	Rick @CICorp.com
Sent:	Thursday, January 29, 1998 4:35 PM
To:	btroutma @ix.netcom.com
Subject:	FW: Re: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup  (MAAUG)

Importance:	High

Dear Bruce,

The CPCUG Board of Directors welcomes the idea.  One member brought up an administrative question. Do you have a 501(c)(3) - whatever that is?

Rick Shaddock


-----Original Message-----
From: Capital PC User Group Board of Directors Communications
[mailto:CPCUGBOD-L @CPCUG.ORG] Rich "Rich" Schinnell
Sent: January 28, 1998 2:33 PM
Subject: Re: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup (MAAUG)

At 02:05 PM 1/28/98 -0600, Rick @CICORP.COM wrote:

>We hereby propose to the CPCUG Board of Directors, that the Access SIG makes
>a proposal February 17th to the Mid Atlantic Access Users Group (MAAUG) to
>see if they are interested in merging resources and activities with the CPCUG.

Great idea and would be a win-win for cpcug and MAAUG.

>MAAUG charges a $40/year membership fee.  If their meetings were to become
>the CPCUG SIG meeting, there would be some people attending who pay MAAUG
>dues, and some who pay MAAUG and CPCUG dues.  So, we may have issues similar
>to the CPCUG ACT! merger. 

Does MAAUG have their own 501(c)(3)?  if so then they would have to submit their
own 990's and they would just be affiliated with us as a SIG for PR sakes.
If our treasurer has to include any funds by a sig which the treasurer would not
collect and disburse then, that could get us in trouble with our 990.

Probably more of an administrative thing but something to settle out.
From:	Rick @CICorp.com
Sent:	Thursday, January 29, 1998 1:37 PM
To:	btroutma @ix.netcom.com
Subject:	FW: Re: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup  (MAAUG)

Dear Bruce,

The CPCUG Board of Directors welcomes the idea.  One member brought up an administrative question. Do you have a 501(c)(3) - whatever that is?

Rick Shaddock


-----Original Message-----
From: Capital PC User Group Board of Directors Communications
[mailto:CPCUGBOD-L @CPCUG.ORG] Rich "Rich" Schinnell
Sent: January 28, 1998 2:33 PM
Subject: Re: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup (MAAUG)

At 02:05 PM 1/28/98 -0600, Rick @CICORP.COM wrote:

>We hereby propose to the CPCUG Board of Directors, that the Access SIG makes
>a proposal February 17th to the Mid Atlantic Access Users Group (MAAUG) to
>see if they are interested in merging resources and activities with the CPCUG.

Great idea and would be a win-win for cpcug and MAAUG.

>MAAUG charges a $40/year membership fee.  If their meetings were to become
>the CPCUG SIG meeting, there would be some people attending who pay MAAUG
>dues, and some who pay MAAUG and CPCUG dues.  So, we may have issues similar
>to the CPCUG ACT! merger. 

Does MAAUG have their own 501(c)(3)?  if so then they would have to submit their
own 990's and they would just be affiliated with us as a SIG for PR sakes.
If our treasurer has to include any funds by a sig which the treasurer would not
collect and disburse then, that could get us in trouble with our 990.

Probably more of an administrative thing but something to settle out.
From:	Capital PC User Group Board of Directors Communications [CPCUGBOD-L @CPCUG.ORG] on behalf of Gabe Goldberg [gabe @CPCUG.ORG]
Sent:	Wednesday, January 28, 1998 5:19 PM
To:	CPCUGBOD-L @CPCUG.ORG
Subject:	     Re: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup             (MAAUG)

On Wed, 28 Jan 1998 Rick @CICORP.COM wrote:

> There is not much sense in having two Access users groups in Washington.
> Other groups, such as the Washington Area dBase Users Group (WADBUG) and
> ACT! Users Group merged, or soon will, with good results for all.  (Another
> independent group, the MidAtlantic FoxPro Users Group which meets in Tysons
> each 4th Tuesday, might be another beneficial integration we could propose.)

As Rich said, this is a great idea, very positive way for CPCUG to grow.

> MAAUG charges a $40/year membership fee.  If their meetings were to become
> the CPCUG SIG meeting, there would be some people attending who pay MAAUG
> dues, and some who pay MAAUG and CPCUG dues.  So, we may have issues similar
> to the CPCUG ACT! merger.  Citing from Gabe Goldberg's comments regarding
> the ACT group:

We've handled this before, will handle it with ACT! group -- it's a little
burden up front, but once the merger is done, it's just more CPCUG members
to handle and some prospects to recruit, no big deal.

> I suggested to Bruce the possibility of joining CPCUG. He is interested
> but will leave it up to the membership to decide. I think that bringing
> this group into the fold would be a good opportunity for the CPCUG
> Access SIG, as well as CPCUG as a whole. I also think that the MAAUG
> people and CPCUG would have a fair amount of synergy. (Additionally, the
> meeting place and other facilities would continue to be available.)

Rich probably sent you the standard text on SIG formation, which is
procedural rather than an obstacle -- just outlines steps to follow,
and requirements for ongoing SIG existence. No big deals...

Biggest resistance I've heard from groups considering merger has been
related to how independent a SIG can be, how closely CPCUG manages SIGs.
From my experience, I think the answers are "very independent" and "no
central management".
From:	Lynne M Sturtz [lmsturtz @cpcug.org]
Sent:	Wednesday, January 28, 1998 3:51 PM
To:	Rick @CICorp.com
Subject:	Re: Already sent

> Sorry, it already is down the mail chute!  
> Any anything to CPCUG is a gift to ourselves, anyway.

I like your attitude.  :)

Thanks!

Lynne

From:	Capital PC User Group Board of Directors Communications [CPCUGBOD-L @CPCUG.ORG] on behalf of Rich Schinnell [schinnel @CPCUG.ORG]
Sent:	Wednesday, January 28, 1998 2:33 PM
To:	CPCUGBOD-L @CPCUG.ORG
Subject:	     Re: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup             (MAAUG)

At 02:05 PM 1/28/98 -0600, Rick @CICORP.COM wrote:
>We hereby propose to the CPCUG Board of Directors, that the Access SIG makes
>a proposal February 17th to the Mid Atlantic Access Users Group (MAAUG) to
>see if they are interested in merging resources and activities with the
>CPCUG.

Great idea and would be a win-win for cpcug and MAAUG.


>MAAUG charges a $40/year membership fee.  If their meetings were to become
>the CPCUG SIG meeting, there would be some people attending who pay MAAUG
>dues, and some who pay MAAUG and CPCUG dues.  So, we may have issues similar
>to the CPCUG ACT! merger.  Citing from Gabe Goldberg's comments regarding
>the ACT group:

Problems would come up with our IRS and the 990 that we have to submit on all
moneys collected.  As it stands no sig can have a private bank account and
unless
our treasurer was involved, we could get into a sticky wickett.

There isn't any problem if they would drop the dues for MAAUG and instead
pay their
dues to CPCUG.  I see that as a better alternative.

Does MAAUG have their own 501(c)(3)?  if so then they would have to submit their
own 990's and they would just be affiliated with us as a sig for PR sakes.
If our
treasurer has to include any funds by a sig which the treasurer would not
collect
and disburse then that could get us in trouble with our 990.

Probably more of an administrative thing but something to settle out.


Richard "Rich" Schinnell                Capital PC User Group, Inc.
schinnel @cpcug.org                      1st Vice President
http://cpcug.org/user/schinnel          http://www.cpcug.org
(301) 949-9292
From:	Lynne M Sturtz [lmsturtz @cpcug.org]
Sent:	Wednesday, January 28, 1998 2:12 PM
To:	Rick @CICORP.COM
Subject:	Re: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup              (MAAUG)

You really do not need to send any money to me to cover postage.  I think
I can figure out a way for it to not cost an arm and a leg.  I'll let you
know what it comes out to be.

Lynne

From:	Rick @CICorp.com
Sent:	Wednesday, January 28, 1998 2:05 PM
To:	CPCUGBOD-L @CPCUG.ORG
Cc:	GMcLennan @smmmg.com
Subject:	PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup (MAAUG)

We hereby propose to the CPCUG Board of Directors, that the Access SIG makes a proposal February 17th to the Mid Atlantic Access Users Group (MAAUG) to see if they are interested in merging resources and activities with the CPCUG.  

This coincides with Gabe Goldberg's work to integrate the ACT!/Sales Force Automation Users group to mutual benefit.  If MAAUG likes the idea, this could bring in more members for CPCUG.  CPCUG could help popularize the MAAUG by listing it as a SIG and advertising meetings in the Monitor.  In return, many MAAUG members would naturally learn more about CPCUG and hopefully join.  We will ask how many MAAUG members are already CPCUG members.

There is not much sense in having two Access users groups in Washington.  Other groups, such as the Washington Area dBase Users Group (WADBUG) and ACT! Users Group merged, or soon will, with good results for all.  (Another independent group, the MidAtlantic FoxPro Users Group which meets in Tysons each 4th Tuesday, might be another beneficial integration we could propose.)

MAAUG is a well organized group with well attended meetings.  Bruce Troutman does a great job and is receptive to the idea, and will leave it to a group vote.  We will ask him if CPCUG may have access to their membership list.

MAAUG charges a $40/year membership fee.  If their meetings were to become the CPCUG SIG meeting, there would be some people attending who pay MAAUG dues, and some who pay MAAUG and CPCUG dues.  So, we may have issues similar to the CPCUG ACT! merger.  Citing from Gabe Goldberg's comments regarding the ACT group:

	"Regarding "membership is not required to attend SIG meetings" -- please,
	let's not flog this horse again. Our policy on meetings isn't broken, has
	worked for CPCUG's entire life, no-one has suggested how we might enforce
	any membership requirement for participating in activities, so it's not
	related to forming this new SIG."

We could use more attendance at the Access SIG meetings anyway, so we have everything to gain and nothing to lose. 

George, a marketing expert who has been so helpful in finding a good meeting site for the Access SIG, will make the presentation to MAAUG next month.  I have sent $5 to Lynne Sturtz for postage/donation to send about 20 brochures and past issues of the Monitor to pass out, to educate their members about CPCUG.

Any suggestions on making this a success are very welcome.  CPCUG has a lot to offer them, and vice versa, and we want to put our best foot forward.  

Rick Shaddock
George McLennan
Access SIG

Background details on Mid Atlantic Access Users Group (MAAUG):

Meets the 3rd Tuesday of every month:
 National Association of Social Workers
 (Next to Union Station Metro)
 750 1st Street, NW
 Suite 700
 Washington, DC 

Here is more background, written by George McLennan:

There is an organization called the Mid-Atlantic Access User Group
(MAAUG), which has been in operation for about three years and is lead
by Bruce Troutman. About 10 to 20 people attend the meetings and there
is a larger body of people that claim membership by virtue of paying
dues. Some members are sufficiently well connected to have brought in
guest speakers such as Luke Chung of FMS and [Andrew Coupe of Microsoft.]
 
MAAUG has a mix of members ranging from novices to a number of very
experienced programmers. Bruce himself is a very capable programmer and
runs his own business. He also has a gift for teaching and has led a
number of seminars both for novices and the more experienced users as
part of the MAAUG program. 
 
Bruce enjoys leading the group and would like to continue.  However, he
feels that joining with a larger organization would offer the advantages
of a better infrastructure and other support. He has already approached
NT Pro, a fairly large user group based in Washington, DC.
 
I suggested to Bruce the possibility of joining CPCUG. He is interested
but will leave it up to the membership to decide. I think that bringing
this group into the fold would be a good opportunity for the CPCUG
Access SIG, as well as CPCUG as a whole. I also think that the MAAUG
people and CPCUG would have a fair amount of synergy. (Additionally, the
meeting place and other facilities would continue to be available.)

From:	Barbara Conn [bconn @cpcug.org]
Sent:	Wednesday, January 28, 1998 1:45 PM
To:	Rick @CICorp.com
Subject:	Re: FW: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup (MAAUG)

On Wed, 28 Jan 1998 Rick @CICorp.com wrote:

> I sent this to the CPCCUGBOD-L @CPCUG.org, the first time I dared send

It didn't work.

Just a typo--the address is 

	cpcugbod-l @cpcug.org

not cpccugbod-l @cpcug.org
      ^ 

> something to everyone on the board with a click of the mouse.  But did not
> get any response.  So I am wondering if it worked.  Did you receive it?  If
> not, how do I post a message to all the Board members?  If so, what do you
> think?

Sounds good!  Give it another try--I think folks would be very
receptive.

What time does this group meet, by the way?

Might also be more like when MetroMUG joined through Multimedia SIG. 
Alta (alta @cpcug.org) would know the details. As I recall, there was
quite a negotiation--and they wound up contributing some or all of
their treasury to CPCUG, their members became CPCUG members, and
Multimedia SIG became MetroMUG SIG. 


> Rick
> 
> -----Original Message-----
> From: Rick @CICorp.com [mailto:Rick @CICorp.com]
> Sent: January 24, 1998 7:52 PM
> To: CPCCUGBOD-L @CPCUG.ORG
> Cc: Gmclennan @smg.com
> Subject: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup
> (MAAUG)
> 
> 
> The Access SIG hereby proposes to the CPCUG Board of Directors that we make
> a proposal February 17th to the Mid Atlantic Access Users Group (MAAUG) to
> see if they are interested in merging resources and activities with the
> CPCUG.
> 
> This coincides with Gabe Goldberg's work to integrate the ACT!/Sales Force
> Automation Users group to mutual benefit.  If MAAUG likes the idea, this
> could bring in more members for CPCUG.  CPCUG could help popularize the
> MAAUG by listing it as a SIG and advertising meetings in the Monitor.  In
> return, many MAAUG members would naturally learn more about CPCUG and
> hopefully join.  We will ask how many MAAUG members are already CPCUG
> members.
> 
> There is not much sense in having two Access users groups in Washington.
> Other groups, such as the Washington Area dBase Users Group (WADBUG) and
> ACT! Users Group merged, or soon will, with good results for all.  (Another
> independent group, the MidAtlantic FoxPro Users Group which meets in Tysons
> each 4th Tuesday, might be another beneficial integration we could propose.)
> 
> MAAUG is a well organized group with well attended meetings.  Bruce Troutman
> does a great job and is receptive to the idea, and will leave it to a group
> vote.  We will ask him if CPCUG may have access to their membership list.
> 
> MAAUG charges a $40/year membership fee.  If their meetings were to become
> the CPCUG SIG meeting, there would be some people attending who pay MAAUG
> dues, and some who pay MAAUG and CPCUG dues.  So, we may have issues similar
> to the CPCUG ACT! merger.  Citing from Gabe Goldberg's comments regarding
> the ACT group:
> 
> 	"Regarding "membership is not required to attend SIG meetings" -- please,
> 	let's not flog this horse again. Our policy on meetings isn't broken, has
> 	worked for CPCUG's entire life, no-one has suggested how we might enforce
> 	any membership requirement for participating in activities, so it's not
> 	related to forming this new SIG."
> 
> We are getting only a few CPCUG dues-paying members at the Access SIG
> meetings anyway, so we have everything to gain and nothing to lose.
> 
> George, a marketing expert who has been so helpful in finding a good meeting
> site for the Access SIG, will make the presentation to MAAUG next month.
> Could we have about 40 brochures and past issues of the Monitor to pass out?
> 
> Any suggestions on making this a success are very welcome.  CPCUG has a lot
> to offer them, and we want to put our best foot forward.
> 
> Rick Shaddock
> George McLennan
> Access SIG
> 
> Background details on Mid Atlantic Access Users Group (MAAUG):
> 
> Meets the 3rd Tuesday of every month near Union Station at:
>  National Association of Social Workers
>  750 1st Street, NW
>  Suite 700
>  Washington, DC
> 
> Here is more background, written by George McLennan:
> 
> There is an organization called the Mid-Atlantic Access User Group
> (MAAUG), which has been in operation for about three years and is lead
> by Bruce Troutman. About 10 to 20 people attend the meetings and there
> is a larger body of people that claim membership by virtue of paying
> dues. Some members are sufficiently well connected to have brought in
> guest speakers such as Luke Chung of FMS and [Andrew Coupe of Microsoft.]
> 
> MAAUG has a mix of members ranging from novices to a number of very
> experienced programmers. Bruce himself is a very capable programmer and
> runs his own business. He also has a gift for teaching and has led a
> number of seminars both for novices and the more experienced users as
> part of the MAAUG program.
> 
> Bruce enjoys leading the group and would like to continue.  However, he
> feels that joining with a larger organization would offer the advantages
> of a better infrastructure and other support. He has already approached
> NT Pro, a fairly large user group based in Washington, DC.
> 
> I suggested to Bruce the possibility of joining CPCUG. He is interested
> but will leave it up to the membership to decide. I think that bringing
> this group into the fold would be a good opportunity for the CPCUG
> Access SIG, as well as CPCUG as a whole. I also think that the MAAUG
> people and CPCUG would have a fair amount of synergy. (Additionally, the
> meeting place and other facilities would continue to be available.)


Barb

From:	Rick @CICorp.com
Sent:	Wednesday, January 28, 1998 1:27 PM
To:	BConn @CPCUG.org
Subject:	FW: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup (MAAUG)

I sent this to the CPCCUGBOD-L @CPCUG.org, the first time I dared send something to everyone on the board with a click of the mouse.  But did not get any response.  So I am wondering if it worked.  Did you receive it?  If not, how do I post a message to all the Board members?  If so, what do you think?
Rick

-----Original Message-----
From: Rick @CICorp.com [mailto:Rick @CICorp.com] 
Sent: January 24, 1998 7:52 PM
To: CPCCUGBOD-L @CPCUG.ORG
Cc: Gmclennan @smg.com
Subject: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup
(MAAUG)


The Access SIG hereby proposes to the CPCUG Board of Directors that we make a proposal February 17th to the Mid Atlantic Access Users Group (MAAUG) to see if they are interested in merging resources and activities with the CPCUG.  

This coincides with Gabe Goldberg's work to integrate the ACT!/Sales Force Automation Users group to mutual benefit.  If MAAUG likes the idea, this could bring in more members for CPCUG.  CPCUG could help popularize the MAAUG by listing it as a SIG and advertising meetings in the Monitor.  In return, many MAAUG members would naturally learn more about CPCUG and hopefully join.  We will ask how many MAAUG members are already CPCUG members.

There is not much sense in having two Access users groups in Washington.  Other groups, such as the Washington Area dBase Users Group (WADBUG) and ACT! Users Group merged, or soon will, with good results for all.  (Another independent group, the MidAtlantic FoxPro Users Group which meets in Tysons each 4th Tuesday, might be another beneficial integration we could propose.)

MAAUG is a well organized group with well attended meetings.  Bruce Troutman does a great job and is receptive to the idea, and will leave it to a group vote.  We will ask him if CPCUG may have access to their membership list.

MAAUG charges a $40/year membership fee.  If their meetings were to become the CPCUG SIG meeting, there would be some people attending who pay MAAUG dues, and some who pay MAAUG and CPCUG dues.  So, we may have issues similar to the CPCUG ACT! merger.  Citing from Gabe Goldberg's comments regarding the ACT group:

	"Regarding "membership is not required to attend SIG meetings" -- please,
	let's not flog this horse again. Our policy on meetings isn't broken, has
	worked for CPCUG's entire life, no-one has suggested how we might enforce
	any membership requirement for participating in activities, so it's not
	related to forming this new SIG."

We are getting only a few CPCUG dues-paying members at the Access SIG meetings anyway, so we have everything to gain and nothing to lose. 

George, a marketing expert who has been so helpful in finding a good meeting site for the Access SIG, will make the presentation to MAAUG next month.  Could we have about 40 brochures and past issues of the Monitor to pass out?

Any suggestions on making this a success are very welcome.  CPCUG has a lot to offer them, and we want to put our best foot forward.  

Rick Shaddock
George McLennan
Access SIG

Background details on Mid Atlantic Access Users Group (MAAUG):

Meets the 3rd Tuesday of every month near Union Station at:
 National Association of Social Workers
 750 1st Street, NW
 Suite 700
 Washington, DC 

Here is more background, written by George McLennan:

There is an organization called the Mid-Atlantic Access User Group
(MAAUG), which has been in operation for about three years and is lead
by Bruce Troutman. About 10 to 20 people attend the meetings and there
is a larger body of people that claim membership by virtue of paying
dues. Some members are sufficiently well connected to have brought in
guest speakers such as Luke Chung of FMS and [Andrew Coupe of Microsoft.]
 
MAAUG has a mix of members ranging from novices to a number of very
experienced programmers. Bruce himself is a very capable programmer and
runs his own business. He also has a gift for teaching and has led a
number of seminars both for novices and the more experienced users as
part of the MAAUG program. 
 
Bruce enjoys leading the group and would like to continue.  However, he
feels that joining with a larger organization would offer the advantages
of a better infrastructure and other support. He has already approached
NT Pro, a fairly large user group based in Washington, DC.
 
I suggested to Bruce the possibility of joining CPCUG. He is interested
but will leave it up to the membership to decide. I think that bringing
this group into the fold would be a good opportunity for the CPCUG
Access SIG, as well as CPCUG as a whole. I also think that the MAAUG
people and CPCUG would have a fair amount of synergy. (Additionally, the
meeting place and other facilities would continue to be available.)

From:	Lynne M Sturtz [lmsturtz @cpcug.org]
Sent:	Wednesday, January 28, 1998 11:23 AM
To:	Rick @CICorp.com
Subject:	RE: CPCUG Monitors for Access Users Group Meetings

> Of course, I am sending $5 today to CPCUG to cover the postage costs.  Let
> me know if you need anything else.  Thanks.

Do not!  It will go under administrative costs.  I have no idea yet how
much mailing 20 copies of the Monitor will cost.  It definitely isn't
somthing we want to do on a regular basis, of course.  If it became
regular, then we would have to require someone pick them up and deliver
them.  This one time, though, I can figure out a way to do this so that it
won't break the bank.    Maybe a few in each of several Postal Service
Priority Mail envelopes will work.

Thanks for the offer, though.  

Lynne

From:	Rick @CICorp.com
Sent:	Wednesday, January 28, 1998 10:44 AM
To:	GMcLennan @smmg.com
Subject:	FW: CPCUG Monitors for Access Users Group Meetings

From: Rick @CICorp.com [mailto:Rick @CICorp.com] 
Sent: January 28, 1998 10:41 AM
To: Lynne M Sturtz
Subject: RE: CPCUG Monitors for Access Users Group Meetings


Of course, I am sending $5 today to CPCUG to cover the postage costs.  Let me know if you need anything else.  Thanks.

> -----Original Message-----
> From: Lynne M Sturtz [mailto:lmsturtz @cpcug.org]
> Sent: January 28, 1998 10:34 AM
> To: Rick @CICorp.com
> Subject: Re: CPCUG Monitors for Access Users Group Meetings
> 
> 
> > May we please have about 20 Monitors (any fairly recent spares you have
> > around) sent to:
> > 
> > George McLennan
> > Vice Chairman
> > Access SIG
> > 6351 Crosswoods Drive
> > Falls Church, VA  22044
> > 
> > George will pass them out during his proposal to the MAAUG that we integrate
> > Access users groups.
> 
> I'll try.  It will cost a fair amount to mail that many of them--mailing
> one costs us at least $1.50--, so it would be better if someone who would
> be here anyway could deliver them to him (in an ideal world, that is ).
> I'll see what I can do if no one can do the delivery. 
> 
> > Did you get the following message?  It was the first time I tried emailing
> > to CPCCUGBOD-L @CPCUG.ORG, and did not get any response.  So I was beginning
> > to wonder if it went to everyone.  Thank you.
> 
> I never saw that message, so I don't know if it made it or not.  I get the
> messages sent to the list, but occasionally one may go by that doesn't
> register with me for whatever reason.
> 
> Lynne
> 
> From:	Rick @CICorp.com
Sent:	Wednesday, January 28, 1998 10:41 AM
To:	Lynne M Sturtz
Subject:	RE: CPCUG Monitors for Access Users Group Meetings

Of course, I am sending $5 today to CPCUG to cover the postage costs.  Let me know if you need anything else.  Thanks.

> -----Original Message-----
> From: Lynne M Sturtz [mailto:lmsturtz @cpcug.org]
> Sent: January 28, 1998 10:34 AM
> To: Rick @CICorp.com
> Subject: Re: CPCUG Monitors for Access Users Group Meetings
> 
> 
> > May we please have about 20 Monitors (any fairly recent spares you have
> > around) sent to:
> > 
> > George McLennan
> > Vice Chairman
> > Access SIG
> > 6351 Crosswoods Drive
> > Falls Church, VA  22044
> > 
> > George will pass them out during his proposal to the MAAUG that we integrate
> > Access users groups.
> 
> I'll try.  It will cost a fair amount to mail that many of them--mailing
> one costs us at least $1.50--, so it would be better if someone who would
> be here anyway could deliver them to him (in an ideal world, that is ).
> I'll see what I can do if no one can do the delivery. 
> 
> > Did you get the following message?  It was the first time I tried emailing
> > to CPCCUGBOD-L @CPCUG.ORG, and did not get any response.  So I was beginning
> > to wonder if it went to everyone.  Thank you.
> 
> I never saw that message, so I don't know if it made it or not.  I get the
> messages sent to the list, but occasionally one may go by that doesn't
> register with me for whatever reason.
> 
> Lynne
> 
> From:	Lynne M Sturtz [lmsturtz @cpcug.org]
Sent:	Wednesday, January 28, 1998 10:34 AM
To:	Rick @CICorp.com
Subject:	Re: CPCUG Monitors for Access Users Group Meetings

> May we please have about 20 Monitors (any fairly recent spares you have
> around) sent to:
> 
> George McLennan
> Vice Chairman
> Access SIG
> 6351 Crosswoods Drive
> Falls Church, VA  22044
> 
> George will pass them out during his proposal to the MAAUG that we integrate
> Access users groups.

I'll try.  It will cost a fair amount to mail that many of them--mailing
one costs us at least $1.50--, so it would be better if someone who would
be here anyway could deliver them to him (in an ideal world, that is ).
I'll see what I can do if no one can do the delivery. 

> Did you get the following message?  It was the first time I tried emailing
> to CPCCUGBOD-L @CPCUG.ORG, and did not get any response.  So I was beginning
> to wonder if it went to everyone.  Thank you.

I never saw that message, so I don't know if it made it or not.  I get the
messages sent to the list, but occasionally one may go by that doesn't
register with me for whatever reason.

Lynne

From:	Capital PC User Group Board of Directors Communications [CPCUGBOD-L @cpcug.org] on behalf of Clifford Porter [chp2 @EROLS.COM]
Sent:	Monday, January 26, 1998 2:15 PM
To:	CPCUGBOD-L @cpcug.org
Subject:	     Agenda for 2/2/98 BOD Meeting

Please send any additions or corrections to Clifford Porter.


        BOARD OF DIRECTORS MEETING
        February 2nd, 1998
        7:30 p.m.
        Proposed Agenda

1. Agenda Approval

2. Minutes
        Approval of the Minutes of the previous meeting, January 5th, 1998.

3.. Officers Reports
        President - Lillian Milliner
        First Vice President - Rich Schinnell
        Maryland Vice President - Herb Fredricksen
        Virginia Vice President - Luis Garcia
        Capital Area Vice President - Randy Steer
        Treasurer - Pat McVeigh

4.. Project Status Reports
        Location of CPCUG facility.
        Entertainment Books - Alta Oben

5. Unfinished Business

6. New Business
        Affiliation of the ACT! User Group with CPCUG as a provisonal SIG to be
known as the Sales Force Automation SIG.

7. Good and Welfare  (Matters Arising)

8. Adjournment
From:	Rick @CICorp.com
Sent:	Monday, January 26, 1998 1:47 PM
To:	Lynne M Sturtz [lmsturtz @CPCUG.ORG]
Subject:	CPCUG Monitors for Access Users Group Meetings

May we please have about 20 Monitors (any fairly recent spares you have around) sent to:

George McLennan
Vice Chairman
Access SIG
6351 Crosswoods Drive
Falls Church, VA  22044

George will pass them out during his proposal to the MAAUG that we integrate Access users groups.

Did you get the following message?  It was the first time I tried emailing to CPCCUGBOD-L @CPCUG.ORG, and did not get any response.  So I was beginning to wonder if it went to everyone.  Thank you.

Rick Shaddock
Access SIG Chairman


-----Original Message-----
From: Rick @CICorp.com [mailto:Rick @CICorp.com] 
Sent: January 24, 1998 7:52 PM
To: CPCCUGBOD-L @CPCUG.ORG
Cc: Gmclennan @smg.com
Subject: PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup
(MAAUG)

The Access SIG hereby proposes to the CPCUG Board of Directors that we make a proposal February 17th to the Mid Atlantic Access Users Group (MAAUG) to see if they are interested in merging resources and activities with the CPCUG.  

This coincides with Gabe Goldberg's work to integrate the ACT!/Sales Force Automation Users group to mutual benefit.  If MAAUG likes the idea, this could bring in more members for CPCUG.  CPCUG could help popularize the MAAUG by listing it as a SIG and advertising meetings in the Monitor.  In return, many MAAUG members would naturally learn more about CPCUG and hopefully join.  We will ask how many MAAUG members are already CPCUG members.

There is not much sense in having two Access users groups in Washington.  Other groups, such as the Washington Area dBase Users Group (WADBUG) and ACT! Users Group merged, or soon will, with good results for all.  (Another independent group, the MidAtlantic FoxPro Users Group which meets in Tysons each 4th Tuesday, might be another beneficial integration we could propose.)

MAAUG is a well organized group with well attended meetings.  Bruce Troutman does a great job and is receptive to the idea, and will leave it to a group vote.  We will ask him if CPCUG may have access to their membership list.

MAAUG charges a $40/year membership fee.  If their meetings were to become the CPCUG SIG meeting, there would be some people attending who pay MAAUG dues, and some who pay MAAUG and CPCUG dues.  So, we may have issues similar to the CPCUG ACT! merger.  Citing from Gabe Goldberg's comments regarding the ACT group:

	"Regarding "membership is not required to attend SIG meetings" -- please,
	let's not flog this horse again. Our policy on meetings isn't broken, has
	worked for CPCUG's entire life, no-one has suggested how we might enforce
	any membership requirement for participating in activities, so it's not
	related to forming this new SIG."

We are getting only a few CPCUG dues-paying members at the Access SIG meetings anyway, so we have everything to gain and nothing to lose. 

George, a marketing expert who has been so helpful in finding a good meeting site for the Access SIG, will make the presentation to MAAUG next month.  Could we have about 40 brochures and past issues of the Monitor to pass out?

Any suggestions on making this a success are very welcome.  CPCUG has a lot to offer them, and we want to put our best foot forward.  

Rick Shaddock
George McLennan
Access SIG

Background details on Mid Atlantic Access Users Group (MAAUG):

Meets the 3rd Tuesday of every month near Union Station at:
 National Association of Social Workers
 750 1st Street, NW
 Suite 700
 Washington, DC 

Here is more background, written by George McLennan:

There is an organization called the Mid-Atlantic Access User Group
(MAAUG), which has been in operation for about three years and is lead
by Bruce Troutman. About 10 to 20 people attend the meetings and there
is a larger body of people that claim membership by virtue of paying
dues. Some members are sufficiently well connected to have brought in
guest speakers such as Luke Chung of FMS and [Andrew Coupe of Microsoft.]
 
MAAUG has a mix of members ranging from novices to a number of very
experienced programmers. Bruce himself is a very capable programmer and
runs his own business. He also has a gift for teaching and has led a
number of seminars both for novices and the more experienced users as
part of the MAAUG program. 
 
Bruce enjoys leading the group and would like to continue.  However, he
feels that joining with a larger organization would offer the advantages
of a better infrastructure and other support. He has already approached
NT Pro, a fairly large user group based in Washington, DC.
 
I suggested to Bruce the possibility of joining CPCUG. He is interested
but will leave it up to the membership to decide. I think that bringing
this group into the fold would be a good opportunity for the CPCUG
Access SIG, as well as CPCUG as a whole. I also think that the MAAUG
people and CPCUG would have a fair amount of synergy. (Additionally, the
meeting place and other facilities would continue to be available.)

From:	Rick @CICorp.com
Sent:	Monday, January 26, 1998 1:34 PM
To:	Pallotti01
Cc:	Bruce Troutman [btroutma @ix.netcom.com]; gmclennan @smmg.com
Subject:	RE: Access

> -----Original Message-----
> From: Sarah Coggins [mailto:Pallotti01 @aol.com]
> Sent: January 26, 1998 9:54 AM
> To: rick @cicorp.com
> Subject: Access Group
> 
> Rick-- 
> I was wondering if you could please send me information on the Access SIG:
> when you all meet, times, etc.  
> Thanks, 
> Sarah Coggins
 
Dear Sarah:

Thank you for your interest in the Access Special Interest Group of the Capital PC Users Group (CPGUC),
and the Mid Atlantic Access Users Group (MAAUG).

1) The CPCUG Access SIG presently meets for question & answer (& snacks) at the NIH caferia immediately after the main meeting.  We also try to answer at least 10 questions as a group from the computer based multiple choice practice test for the Microsoft Access Certified Professional Examination.  We discuss why each answer is or is not correct, and always end up learning something new.  This is the 2nd Monday of each month at:
	National Institutes of Health
	Masur Auditorium 
	(west on Center Drive from Rockville Pike [Wisconsin Avenue], at West Drive)
	Clinical Center, Building 10
	9000 Rockville Pike
	Bethesda, Maryland 
	(Map: http://www.cpcug.org/user/comm/nihmap.gif) More info: http://www.cpcug.org  

Cost
FREE and open to the public 

2) The Mid-Atlantic Access User Group (MAAUG), has been in operation for about three years and is lead by Bruce Troutman.  About 10 to 20 people attend the meetings and there is a larger body of people that claim membership by virtue of paying dues. Some members are sufficiently well connected to have brought in guest speakers such as Luke Chung of FMS and Andrew Coupe of the Microsoft Access development team.  The CPCUG and MAAUG have a mix of members ranging from novices to a number of very experienced programmers. 

The MAAUG the 3rd Tuesday of every month:
	National Association of Social Workers
	(next to Union Station Metro)
	750 1st Street, NW
	Suite 700
	Washington, DC 

Hope to see you at either meeting - or both!

Rick
From:	Pallotti01 [Pallotti01 @aol.com]
Sent:	Monday, January 26, 1998 9:54 AM
To:	rick @cicorp.com
Subject:	Access

Rick-- 
I was wondering if you could please send me information on the Access SIG:
when you all meet, times, etc.  Thanks, Sarah Coggins
From:	Rick Shaddock [RShaddock @Telegroup.com]
Sent:	Monday, January 26, 1998 6:58 AM
To:	jcnova1 @erols.com
Cc:	Bruce Troutman [btroutma @ix.netcom.com]
Subject:	RE: MS ACCESS 

I have copied you message to Bruce Troutman, who does this kind of thing, and could probably help or knows someone who can.

He is also head of the Mid Atlantic Access Users Group.  The MAAUG the 3rd Tuesday of every month near Union Station at:
 National Association of Social Workers
 750 1st Street, NW
 Suite 700
 Washington, DC 

The CPCUG Access SIG presently meets for Q&A at the NIH caferia immediately after the main meeting.  Hope to see you at either meeting.

Rick

> -----Original Message-----
> From: jcnova1 @erols.com [mailto:jcnova1 @erols.com]
> Sent: Friday, January 23, 1998 7:06 PM
> To: rick @cicorp.com
> Subject: MS ACCESS 
> 
> I am a member of CPCUG and I obtained your e-mail address from the
> CPCUG web site. I am interested in creating a maintained database of
> approx 100,000 records. I would like to have the database available for 
> search queries on the web by passworded customers. Is access the best 
> tool for this. How do I determine the cost feasiblilty of establishing
> such a databse on the web relating to web space....design... 
> 
> Do you have Access classes? How much are they? What time is the Access
> sig? 
> 
> Thanks for your assistance. 
> 
> jcnova1 @erols.com
> From:	Bruce Troutman [btroutma @ix.netcom.com]
Sent:	Sunday, January 25, 1998 5:50 PM
To:	Rick Shaddock (E-mail)
Subject:	Thanks for the call

Sounds like a great idea. Anything I can do is ok with me. 

I have a busy day tomorrow, but I'll try and call you.

B

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Bruce Troutman 	80/20 Data Company
E-mail:  		btroutma @ix.netcom.com
Phone: 		800-918-5670
Resume/Rates:  	http://www.8020data.com/bruce.htm
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

From:	gmclennan [gmclennan @prodigy.net]
Sent:	Sunday, January 25, 1998 1:39 PM
To:	Rick @CICorp.com
Subject:	Re: MAAUG -> CPCUG - Excellent idea!

> Would you like about 40 CPCUG brochures sent to you?  How about
> a few Monitors to pass out? Where would you like them sent?

I have quite a few brochures now, but it wouldn't hurt to have more. The
Monitors are a good idea, too. Send everything to:

6351 Crosswoods Drive
Falls Church, VA  22044

-- 
George L. McLennan
Strategic Marketing & Management Group
gmclennan @smmg.com
703-354-9839 (voice)
703-354-1694 (fax)

From:	Rick @CICorp.com
Sent:	Saturday, January 24, 1998 7:52 PM
To:	CPCCUGBOD-L @CPCUG.ORG
Cc:	Gmclennan @smg.com
Subject:	PROPOSAL: CPCUG seek merger with MidAtlanticAccessUsersGroup (MAAUG)

The Access SIG hereby proposes to the CPCUG Board of Directors that we make a proposal February 17th to the Mid Atlantic Access Users Group (MAAUG) to see if they are interested in merging resources and activities with the CPCUG.  

This coincides with Gabe Goldberg's work to integrate the ACT!/Sales Force Automation Users group to mutual benefit.  If MAAUG likes the idea, this could bring in more members for CPCUG.  CPCUG could help popularize the MAAUG by listing it as a SIG and advertising meetings in the Monitor.  In return, many MAAUG members would naturally learn more about CPCUG and hopefully join.  We will ask how many MAAUG members are already CPCUG members.

There is not much sense in having two Access users groups in Washington.  Other groups, such as the Washington Area dBase Users Group (WADBUG) and ACT! Users Group merged, or soon will, with good results for all.  (Another independent group, the MidAtlantic FoxPro Users Group which meets in Tysons each 4th Tuesday, might be another beneficial integration we could propose.)

MAAUG is a well organized group with well attended meetings.  Bruce Troutman does a great job and is receptive to the idea, and will leave it to a group vote.  We will ask him if CPCUG may have access to their membership list.

MAAUG charges a $40/year membership fee.  If their meetings were to become the CPCUG SIG meeting, there would be some people attending who pay MAAUG dues, and some who pay MAAUG and CPCUG dues.  So, we may have issues similar to the CPCUG ACT! merger.  Citing from Gabe Goldberg's comments regarding the ACT group:

	"Regarding "membership is not required to attend SIG meetings" -- please,
	let's not flog this horse again. Our policy on meetings isn't broken, has
	worked for CPCUG's entire life, no-one has suggested how we might enforce
	any membership requirement for participating in activities, so it's not
	related to forming this new SIG."

We are getting only a few CPCUG dues-paying members at the Access SIG meetings anyway, so we have everything to gain and nothing to lose. 

George, a marketing expert who has been so helpful in finding a good meeting site for the Access SIG, will make the presentation to MAAUG next month.  Could we have about 40 brochures and past issues of the Monitor to pass out?

Any suggestions on making this a success are very welcome.  CPCUG has a lot to offer them, and we want to put our best foot forward.  

Rick Shaddock
George McLennan
Access SIG

Background details on Mid Atlantic Access Users Group (MAAUG):

Meets the 3rd Tuesday of every month near Union Station at:
 National Association of Social Workers
 750 1st Street, NW
 Suite 700
 Washington, DC 

Here is more background, written by George McLennan:

There is an organization called the Mid-Atlantic Access User Group
(MAAUG), which has been in operation for about three years and is lead
by Bruce Troutman. About 10 to 20 people attend the meetings and there
is a larger body of people that claim membership by virtue of paying
dues. Some members are sufficiently well connected to have brought in
guest speakers such as Luke Chung of FMS and [Andrew Coupe of Microsoft.]
 
MAAUG has a mix of members ranging from novices to a number of very
experienced programmers. Bruce himself is a very capable programmer and
runs his own business. He also has a gift for teaching and has led a
number of seminars both for novices and the more experienced users as
part of the MAAUG program. 
 
Bruce enjoys leading the group and would like to continue.  However, he
feels that joining with a larger organization would offer the advantages
of a better infrastructure and other support. He has already approached
NT Pro, a fairly large user group based in Washington, DC.
 
I suggested to Bruce the possibility of joining CPCUG. He is interested
but will leave it up to the membership to decide. I think that bringing
this group into the fold would be a good opportunity for the CPCUG
Access SIG, as well as CPCUG as a whole. I also think that the MAAUG
people and CPCUG would have a fair amount of synergy. (Additionally, the
meeting place and other facilities would continue to be available.)

From:	Rick @CICorp.com
Sent:	Saturday, January 24, 1998 7:47 PM
To:	gmclennan @smmg.com
Subject:	RE: MAAUG -> CPCUG - Excellent idea!

I will notify the Board that we have a POTENTIAL merger here and ask for suggestions to make it a success.

Sounds like you have this under control, and you know I support the idea fully.  And having a marketing expert make the presentation is very fortunate.  Would you like about 40 CPCUG brochures sent to you?  How about a few Monitors to pass out? Where would you like them sent?  

The CPCUG is currently merging with the ACT Users Group - I will try to find out any lessons learned from the guy handling it so we can put our best foot forward with MAAUG.

Yes, it was Bruce Troutman I left a message with.  His brother George taught a dBase networking course for my company years ago at GSA, with excellent results. 


> -----Original Message-----
> From: gmclennan [mailto:gmclennan @prodigy.net]
> Sent: January 24, 1998 7:12 PM
> To: Rick @CICorp.com
> Subject: Re: MAAUG -> CPCUG - Excellent idea!
> 
> 
> > I called Bruce, told him of your idea, and asked
> > him to give me a call or email.
> 
> I  presume that you mean mean Bruce Troutman with whom I have had an
> on-going dialog. As I said, he is open to the idea, but I am not sure
> that CPCUG would be his first choice. I am hoping that my pitch to the
> MAAUG group will tip the balance.
> 
> -- 
> George L. McLennan
> Strategic Marketing & Management Group
> gmclennan @smmg.com
> 703-354-9839 (voice)
> 703-354-1694 (fax)
> 
> From:	gmclennan [gmclennan @prodigy.net]
Sent:	Saturday, January 24, 1998 7:12 PM
To:	Rick @CICorp.com
Subject:	Re: MAAUG -> CPCUG - Excellent idea!

> I called Bruce, told him of your idea, and asked
> him to give me a call or email.

I  presume that you mean mean Bruce Troutman with whom I have had an
on-going dialog. As I said, he is open to the idea, but I am not sure
that CPCUG would be his first choice. I am hoping that my pitch to the
MAAUG group will tip the balance.

-- 
George L. McLennan
Strategic Marketing & Management Group
gmclennan @smmg.com
703-354-9839 (voice)
703-354-1694 (fax)

From:	Rick @CICorp.com
Sent:	Saturday, January 24, 1998 5:43 PM
To:	gmclennan @smmg.com
Cc:	Nick @CICorp.com; Nancy @CICorp.com
Subject:	MAAUG -> CPCUG - Excellent idea!

I think that is an absolutely excellent idea.  There is no sense in having two users groups in Washington.  Other groups, such as the dBase and ACT Users groups have merged, or are in the process of merging with CPCUG.  That would be the best possible solution!  

MAAUG is a well organized group and I enjoyed attending some of their meetings.  For me, Tuesday evenings (3rd Tuesday of each month) often collided with some on-site project.  But, I wholeheartedly agree that this is what we should try to do for the Access SIG.

This would also benefit the CPCUG which is actively seeking members.  I will forward your message to the CPCUG Board of Directors and let them know you will be making the pitch.  I called Bruce, told him of your idea, and asked him to give me a call or email.  

You mentioned the APA, I have the address as:
 National Association of Social Workers
 750 1st Street, NW
 Suite 700
 Washington, DC 

And the dues are $40.  Is this still correct?  Thanks!

Rick

> -----Original Message-----
> From: gmclennan [mailto:gmclennan @prodigy.net]
> Sent: January 23, 1998 7:53 PM
> To: Rick @CICorp.com
> Subject: Re: Access SIG 
> 
> There is an organization called the Mid-Atlantic Access User Group
> (MAAUG), which has been in operation for about three years and is lead
> by Bruce Troutman. About 10 to 20 people attend the meetings and there
> is a larger body of people that claim membership by virtue of paying
> dues. Some members are sufficiently well connected to have brought in
> guest speakers such as Luke Chung of FMS and the guy who leads the MS
> Access development team. (His name escapes me at the moment.)
> 
> MAAUG has a mix of members ranging from novices to a number of very
> experienced programmers. Bruce himself is a very capable programmer and
> runs his own business. He also has a gift for teaching and has led a
> number of seminars both for novices and the more experienced users as
> part of the MAAUG program. The group also has a very nice place to meet
> in the APA building next to the Union Station Metro station.
> 
> Bruce enjoys leading the group and would like to continue. However, he
> feels that joining with a larger organization would offer the advantages
> of a better infrastructure and other support. He has already approached
> NT Pro, a fairly large user group based in Washington, DC.
> 
> I suggested to Bruce the possibility of joining CPCUG. He is interested
> but will leave it up to the membership to decide. I think that bringing
> this group into the fold would be a good opportunity for the CPCUG
> Access SIG, as well as CPCUG as a whole. I also think that the MAAUG
> people and CPCUG would have a fair amount of synergy. (Additionally, the
> meeting place and other facilities would continue to be available.)
> 
> If you agree with this concept in principle, I will make a pitch to the
> MAAUG members at the next meeting, which I think is the third week in
> February. 
From:	gmclennan [gmclennan @prodigy.net]
Sent:	Friday, January 23, 1998 7:53 PM
To:	Rick @CICorp.com
Subject:	Re: Access SIG Leader

Regarding the Access SIG, you indicated that you would be interested in
finding someone to lead the group. I may have found such a person and
much, much more.

There is an organization called the Mid-Atlantic Access User Group
(MAAUG), which has been in operation for about three years and is lead
by Bruce Troutman. About 10 to 20 people attend the meetings and there
is a larger body of people that claim membership by virtue of paying
dues. Some members are sufficiently well connected to have brought in
guest speakers such as Luke Chung of FMS and the guy who leads the MS
Access development team. (His name escapes me at the moment.)

MAAUG has a mix of members ranging from novices to a number of very
experienced programmers. Bruce himself is a very capable programmer and
runs his own business. He also has a gift for teaching and has led a
number of seminars both for novices and the more experienced users as
part of the MAAUG program. The group also has a very nice place to meet
in the APA building next to the Union Station Metro station.

Bruce enjoys leading the group and would like to continue. However, he
feels that joining with a larger organization would offer the advantages
of a better infrastructure and other support. He has already approached
NT Pro, a fairly large user group based in Washington, DC.

I suggested to Bruce the possibility of joining CPCUG. He is interested
but will leave it up to the membership to decide. I think that bringing
this group into the fold would be a good opportunity for the CPCUG
Access SIG, as well as CPCUG as a whole. I also think that the MAAUG
people and CPCUG would have a fair amount of synergy. (Additionally, the
meeting place and other facilities would continue to be available.)

If you agree with this concept in principle, I will make a pitch to the
MAAUG members at the next meeting, which I think is the third week in
February. If they go for it, I would also be willing to run interference
with the CPCUG board of directors and take care of any administrative
requirements.

-- 
George L. McLennan
Strategic Marketing & Management Group
gmclennan @smmg.com
703-354-9839 (voice)
703-354-1694 (fax)

From:	jcnova1 @erols.com
Sent:	Friday, January 23, 1998 7:06 PM
To:	rick @cicorp.com
Subject:	MS ACCESS 

I am a member of CPCUG and I obtained your e-mail address from the
CPCUG web site. I am interested in creating a maintained database of
approx 100,000 records. I would like to have the database available for 
search queries on the web by passworded customers. Is access the best 
tool for this. How do I determine the cost feasiblilty of establishing
such a databse on the web relating to web space....design... 

Do you have Access classes? How much are they? What time is the Access
sig? 

Thanks for your assistance. 

jcnova1 @erols.com
From:	NANCY M LANDREVILLE [nancyml @juno.com]
Sent:	Friday, January 23, 1998 5:35 PM
To:	Rick @CICorp.com
Subject:	Re: Access SIG Leader

If this SIG is held at NIH I could make these very easily.  And...perhaps
chair a few ...also remember I will be attending the Microsoft
Certification for Access in March.  As of March 13, I will be 
"Access" guru.  Schedule me for work in anything you need after that.

Nancy L.
From:	Rick @CICorp.com
Sent:	Friday, January 23, 1998 5:21 PM
To:	Beverlie Heyman
Subject:	RE: Ok  Looking forward to talking with you.

>      It looks as if I am going to be on this present call for another 45 
>      minutes and then I need to leave for the evening. Can we set up a 
>      scheduled time to speak on Monday? I will be out of my office, but 
>      should be back around 4:30.

OK.  Could you give me just a little clue as to what this is all about?  Was it a customer,
or another ACC who made a complaint, or what?  Do I need to take the re-certification
test?  It is very agonizing to be left in the dark like this.  Each day, I am losing 
ACT! business I have worked hard for the past 5 years to build a company to support.

Thank you.From:	Rick @CICorp.com
Sent:	Friday, January 23, 1998 11:12 AM
To:	gmclennan @smmg.com
Cc:	Nick @CICorp.com; Nancy @CICorp.com
Subject:	RE: Access SIG Leader

You got me about dat Winmail.dat file.  I am using Outlook 98 Beta 2.  What email package are you using?  I would like to submit Microsoft a bug or two.

> What is the WINMAIL.DAT file that you attached to your message?

In regards to what we should do for the Access SIG.  That's fine if you don't have time to be the SIG leader.  I appreciate your help to get things rolling.  Please send me the email of the fellow or gal who was willing to take the helm.

Sorry I am so swamped from work.  We are converting a telecommunications company's billing system to accommodate increased customer volume, and a new FCC ruling requiring long distance providers to compute and reimburse pay phone providers 30 cents a call for customers using 800 access numbers.  With tax considerations, discounts and special offers, it gets complicated.  They use SQL with an Access front end.  It is fascinating, but I am working so many hours the night shift guards are starting to talk about that weird guy who never sleeps.

Nick or Nancy said they could make it much more to meetings if they are held after the main meeting at NIH because they both live in Maryland, and it is on the metro.  Feel free to call them at 703-486-2222 or 301-231-7831 respectively.  Thanks.From:	gmclennan [gmclennan @prodigy.net]
Sent:	Friday, January 23, 1998 6:20 AM
To:	Rick @CICorp.com
Subject:	Re: Access SIG Leader

What is the WINMAIL.DAT file that you attached to your message?

-- 
George L. McLennan
Strategic Marketing & Management Group
gmclennan @smmg.com
703-354-9839 (voice)
703-354-1694 (fax)

From:	gmclennan [gmclennan @prodigy.net]
Sent:	Thursday, January 22, 1998 2:49 PM
To:	Rick @CICorp.com
Subject:	Re: Access SIG Leader

There is more than "who" to the answer to your question and it's more
than I can easily put into a short e-mail message. I also want to know
where you stand with the SIG.

Why don't you five me a call when you get a chance. Evening is ok if
that works better for you.

-- 
George L. McLennan
Strategic Marketing & Management Group
gmclennan @smmg.com
703-354-9839 (voice)
703-354-1694 (fax)

From:	Rick @CICorp.com
Sent:	Thursday, January 22, 1998 12:14 PM
To:	gmclennan
Subject:	 Re: Access SIG Leader

Thanks for your message.  Yes I would be interested in knowing who would like to help.
Rick
From:	Rick @CICorp.com
Sent:	Tuesday, January 20, 1998 11:42 AM
To:	MaryAnnHong
Subject:	Access User's Group Meetings 

>I am interested in attending the Access User's Group meetings. Please
send me a schedule of upcoming meetings with meeting locations. I
currently work at Covington & Burling as a Programmer Analyst,
developing databases in MS Access. My telephone number here is (202)
662-6517. Thank you. MaryAnn Hong

We are meeting just after the main CPCUG meeting in the NIH cafeteria.
http://www.cpcug.org  See you there.  Rick
To:	gmclennan @smmg.com
Subject:	 Re: Access 

Received: from mail1y-int.prodigy.net (mail1y-ext.prodigy.net [198.83.19.113]) by mail1.mnsinc.com (8.8.5/8.7.3) with ESMTP id GAA07259 for ; Fri, 9 Jan 1998 06:33:15 -0500 (EST) 
Received: from georgemc (port92.burk3.prodigy.net [204.237.146.92]) 
 by mail1y-int.prodigy.net (8.8.5/8.8.5) with SMTP id GAA55266 
 for ; Fri, 9 Jan 1998 06:32:07 -0500 
Message-ID: <34B60AB8.4F58 @prodigy.net> 
Date: Fri, 09 Jan 1998 06:32:08 -0500 
From: gmclennan  
Reply-To: gmclennan @smmg.com 
Organization: SMMG 
X-Mailer: Mozilla 3.0 (Win95; I) 
MIME-Version: 1.0 
To: Rick @CICorp.com 
Subject: Re: Access 
References: <199801080816.CAA24867 @radius.telegroup.com> 
Content-Type: text/plain; charset=us-ascii 
Content-Transfer-Encoding: 7bit 
Content-Length: 1096 

Rick @CICorp.com wrote:
> 
> I am very sorry to hear that Nancy did not show up and that Nick was
late,
> even though I offered to pay them.  Nick had car trouble, but Nancy
left
> me a voice mail that she had to go to a client's.

I don't know anything about Nick. Three people showed up at WGas at
about 2:00 and they and I left after 30 minutes when no one came to lead
the meeting.
 
> As you see, I could use some good help on keeping the Access SIG. 
Did you
> show the Microsoft CPASMT?

I did not show CPASMT. You told me about it only a couple of hours
before the meeting was to start and I didn't have enough time to
prepare.

> I hope that the meeting was of at least some
> value to those who attended.  Nick told me there were 5 - which is
actually
> not a bad turnout for some SIGs.

Nick must have been on another planet.
 
> Would you like to be the 1998 Chairman?

I don't think so. I was merely offering to help you (or someone else)
with the logistics.

-- 
George L. McLennan
Strategic Marketing & Management Group
gmclennan @smmg.com
703-354-9839 (voice)
703-354-1694 (fax)



Subject:	Access SIG List

Gallina of the Access Users Group wants to attend tis Sunday.  Also,
Jarvis wanted to attend.  Galina's number is 703-237-3890.  From:	Rick @CICorp.com
Sent:	Thursday, January 08, 1998 2:16 AM
To:	gmclennan @smmg.com
Subject:	Access

I am very sorry to hear that Nancy did not show up and that Nick was late,
even though I offered to pay them.  Nick had car trouble, but Nancy left 
me a voice mail that she had to go to a client's.

As you see, I could use some good help on keeping the Access SIG.  Did you
show the Microsoft CPASMT?  I hope that the meeting was of at least some 
value to those who attended.  Nick told me there were 5 - which is actually
not a bad turnout for some SIGs.

Thank you again so much for your help.  I may be on this project for months.
We are using Access along with SQL Server on million-record phone bill
databases.  Would you like to be the 1998 Chairman?

Rick
From:	NANCY M LANDREVILLE [nancyml @juno.com]
Sent:	Friday, January 02, 1998 1:04 PM
To:	Rick @CICorp.com
Subject:	Re: CPCUG Board meeting

Is the location at the HQ on Monroe?  Is there anything a person would
need to know in order to attend (ie: agenda items to addres)?

Nancy L.

From:	David L. Crooks [dcrooks @zzapp.org]
Sent:	Thursday, January 01, 1998 2:01 PM
To:	Rick @CICorp.com
Subject:	Re: Access SIG - New meeting place directions

I thought you might be interested in this document.  Maybe I will make it
to one of your meetings.  Happy New Year!
----------