New Downloads

Highlights:

• The Articles Table for the Access Knowledge Base Browser has been updated. The number of article references has been increased by over 1,000 to nearly 2,000 article titles.

• Version 2.0 of the Alternate Access Switchboards Demo Database featuring six unique Switchboard paradigms: sdi, mdi, outlook-style sidebar, and explorer-like tree, with v2.0 adding, URL Style MDI, and Strict SDI with Report Previews in a Form. Each implementation uses the native Switchboard Items table created by the Access Switchboard Manager. You can use the demo as a Contacts Manager or buy the source code for only US$15.

Determine the Caption of an Attached Label in Code Use this simple VBA code to find the caption of a label attached to a control on a form or report: Dim ctl As Control Set ctl = Me.txtOrderID Debug.Print ctl.Controls.Item(0).Caption An Easy Way to Register a .dll Using Regsvr32.exe Open two Windows Explorer windows - one window displaying the .dll and the other Regsvr32.exe. Now drag Regsvr32.exe over the .dll, and presto the .dll is registered! Get more tips, samples, articles, and code from the FreeAccess Access Utilties CD Keyboard Shortcuts for Running and Debugging Code To display the Debug window CTL+G To run a parameterless subprocedure containing the insertion point, from the Module window F5 To switch between the upper and lower panes F6 To step into a procedure (single step) F8 To step over a procedure SHIFT+F8 To step out of a procedure CTL+SHIFT+F8 To run code to the current insertion point and halt execution CTL+F8 To create an instant watch for a selected expression SHIFT+F9 To toggle a breakpoint at the selected line F9 To clear all breakpoints CTL+SHIFT+F9 To set the next statement CTL+F9 To continue the execution of code or a macro F5 To halt execution of code or macro CTL+BREAK To reset execution of code or macro F5 To reset execution of code or macro SHIFT+F5 To toggle between breaking and not breaking on unhandled errors and then step to the next statement ALT+F5 To toggle between breaking and not breaking in class modules and then continue execution ALT+F8

 

Microsoft Office Product Updates

 

Welcome To Roger's Access Library

 

4TOPS Add-ins and Applications for Microsoft Access and Office

 

Corporate Technologies of Eau Claire Downloads

Welcome to WinSite! The place for shareware, demoware, trialware, tips, and utilities for your computer

 

overLIB - Homepage

 

VB2theMax MB ActiveX Gallery

 

Computer training courseware, computer training curriculum, & computer lesson plans & cheat sheets

 

Endless Productions - Database

 

Run A Word MailMerge from Access

Copy and paste into a new Access module:

Option Compare Database Option Explicit Function MergeIt(stFilePath As String, stQuery As String) Paramaters: stFilePath As String - Full path to merge letter template stQuery As String - SQL String for merge fields data from the CurrentDB Dim stDBName As String Dim objWord As Word.Document Dim stSQL As String stSQL = "Select * from " & stQuery & "" stQuery = "QUERY " & stQuery stDBName = CurrentDb.Name Set objWord = GetObject(stFilePath, "Word.Document") ' Make Word visible. objWord.Application.Visible = True ' Set the mail merge data source as the Northwind database objWord.MailMerge.OpenDataSource _ Name:=stDBName, _ LinkToSource:=True, _ Connection:=stQuery, _ SQLStatement:=stSQL ' Execute the mail merge. objWord.MailMerge.Execute End Function

 

OfficeZealot.com - Home of the Office Enthusiast

Conquer Access RunCommand Constants

Microsoft Access 2000 Building Applications with Forms and Reports

Office Solutions Development

 

Scott Cybak - Access

 

Making the Most of the VB TreeView Control

 

Ms Access Freak - Main Page

Google Advanced Search - support.microsoft.com

VB Only...

 

TechTutorials Computer Reference Directory Applications-
Microsoft_Office-MS_Access

A new version of the Project Management database
Incorporating daily time management

Updates of FreeAccess AddIns

Also on the drawingboard:
Instant Invoicer Wizard
Consolidation Query Wizard
Currency Exposure Manager Database

 

No 13 October 2002

Download a Searchable Compendium of Issues 1-12  

Other Access Newsletters:

Access Unlimited by Garry Robinson http://www.vb123.com

Access Developer News by Mike Gunderloy http://www.larkware.com

Top

Subscription to this newsletter is free.

This newsletter may contain links to sites on the Internet which are owned and operated by third parties. AAD CONSULTING is not responsible for the content of any such third-party site.

Any files are provided "as is", without warranty of any kind. AAD CONSULTING does not assume any liability for use or the consequences of use.

To unsubscribe from this mailing list, enter your email address and click OK:

Unsubscribe

Have questions or comments?
Send them to us.

Access is a trademark of Microsoft Corporation.

©2001-2002
Anthony D'Ambra.
All rights reserved.

Top