How I may help
LinkedIn Profile Email me!
Call me using Skype client on your machine


Reload this page Microsoft Access Programming

Here are my notes and links on using the Access database product from Microsoft.

Take the Brainbench certification test on Microsoft Access

 

Topics:

  • Products
  • Run Time Environment
  • Development Environment
  • Data Access
  • Free Advice Online
  • Fee Based Offerings
  • Programmer Certification
  • User Groups
  • Utilities
  • Jobs
  • Consultants
  •  

    Site Map List all pages on this site 
    About this site About this site 
    Go to first topic Go to Bottom of this page


    Set this at top of window. Product History

     


    Go to Top of this page.
    Previous topic this page
    Next topic this page

    Set this at top of window. Run Time Environment

      To number each detail record in a report:
      Add a calculated text box to the detail section.
      Set the ControlSource property of the text box to =1.
      Set the RunningSum property of the text box to Over All.

     
    Go to Top of this page.
    Previous topic this page
    Next topic this page

    Set this at top of window. Development Environment

    • The Watch Window
    • The Object Browser Window
    • The Call Stack Window
    • The Immediate Window

      To display the current system date and time in the immediate window:

        ?Now()

       

    Sites for Tips and Tricks

    A website external to this site microsoft-accesssolutions.co.uk


    Go to Top of this page.
    Previous topic this page
    Next topic this page

    Set this at top of window. Data Access VBA Programming

      When a form is first opened, the following sequence of events occurs: Open (form) - Load (form) - Resize (form) - Activate (form) - Current (form) - Enter (control) - GotFocus (control)

      Field names are encased in brackets: [FieldName]

      A new class instance (cXX) is created by declaring an object variable based on the class. The Set command with New keyword creates an instance of a user-defined object:

        Dim objXX as cXX
        Set objXX = New cXX

      To print the value result to the debug window:

        Debug.Print rslt

      When variables are initialized, a numeric variable is initialized to 0, a variable-length string is initialized to a zero-length string (""), and a fixed-length string is filled with zeros. Variant variables are initialized to Empty.

      DAO (Directory Access Objects)

      The AddNew Method adds a new row to the recordset.


    Go to Top of this page.
    Previous topic this page
    Next topic this page

    Set this at top of window. Between Processes

       
    Go to Top of this page.
    Previous topic this page
    Next topic this page

    Set this at top of window. Free Online Advice: Tips and Techniques

       


    Go to Top of this page.
    Previous topic this page
    Next topic this page

    Set this at top of window. Fee Based Component Offerings

       
    VB6 For sale

    Go to Top of this page.
    Previous topic this page
    Next topic this page
    ...

    Set this at top of window. Programmer Certification

    • Microsoft's
     
    Go to Top of this page.
    Previous topic this page
    Next topic this page

    Set this at top of window. User Groups

         
    Go to Top of this page.
    Previous topic this page
    Next topic this page

    Set this at top of window. Utilities/Products

    • Configuration Management: Intersolv's PVCS (Program Version Control System)
    • Database Design: Logic Works'
      • ERwin (Entity Relation diagramming) for Microsoft Access designs data models. “ERwin Server FRE (forward-and reverse-engineers) applications, generates triggers and quickly builds Watcom SQL databases. ERwin's open dictionary allows for bi-directional synchronization of Microsoft Access Extended Attributes and domains throughout an application development efforts.
      • (Business Process) BPwin version 2 “a powerful modeling tool for analyzing, documenting and improving complex business processes.”
      • Model Mart to facilitate sharing and collaboration of data models.
    • Modeling:
    • Web application development system Haht HahtSite and Haht SDK
    • Generators:
    • Testing Tools:
    • SQL Databases:
    • SQL editors:
      • SQL-builder from CASTsoftware
      • DBArtisan 4.0 by embarcedero.com supports Microsoft, Oracle, and Microsoft.
    • Robohelp for developing help files.
    • XcelleNetTM for data synchronization of remote and mobile field force applications.
    • Application Packages:
    • Security: Migration for discontinued PADLock release 6.X tool which provided client-side, object-level security for Microsoft Access applications. It secures access to windows, custom controls, DataWindows, DataWindow columns, menu items, etc.
       
    Go to Top of this page.
    Previous topic this page
    Next topic this page

    Set this at top of window. Job Boards

       
    Go to Top of this page.
    Previous topic this page
    Next topic this page

    Set this at top of window. Consultants

    • Microsoft's Certified Solution Partners

       
    Go to Top of this page.
    Previous topic this page
    Next topic this page

    Portions ©Copyright 1996-2014 Wilson Mar. All rights reserved. | Privacy Policy |

    Search


    How I may help

    Send a message with your email client program


    Your rating of this page:
    Low High




    Your first name:

    Your family name:

    Your location (city, country):

    Your Email address: 



      Top of Page Go to top of page

    Thank you!