vb123.com.au                                                          

  Welcome To Access Unlimited - Edition 16
See all newsletters

Access Unlimited is an email newsletter that provides free tips,  help and information for skilled Microsoft Access users and related software disciplines.

Produced by Garry Robinson from Sydney, Australia.

-------------------------------------------------------
In this edition

DAYLIGHT SAVINGS CHANGES IN AUSTRALIA
TINY TRAINERS FOR BEGINNER ACCESS AND EXCEL USERS
A SELECTION OF SENDKEYS VB's
MOVING AROUND A BUSY ACCESS FORM - A QUICK WIZARD
AND LOTS LOTS MORE


-------------------------------------------------------
LINKING TABLES  WITH 1 LINE OF CODE

Splitting the database into a Front-end software database and a backend data only database is just about lesson 1 if you want to be a successful offsite Access programmer.  Once you have done that, you need to teach the users how to use the Link table manager or even use large linking routines that comes with the Northwind database or other reputable Access programming books.   But here is 1 line of VB that will achieve the same thing.

Setup a button on a form and insert the following code under the button to fire up the Link Table Manager.  
' Fire up the Linked Table Manager in Access 97
' Tools ... add-Ins ... Linked table manager
SendKeys "%TIL"

' Fire up the Linked Table Manager in Access 2000
' Tools ... Database Utilities ... Linked Table
SendKeys "%TDL"

Read more at the following address
http://vb123.com/Toolbox/99/linkingtables.htm


-------------------------------------------------------
COPY THE CONTENTS OF AN ACCESS FIELD TO THE CLIPBOARD

Me!FieldName.SetFocus
SendKeys "%EC"
DoEvents

-------------------------------------------------------
OPEN THE RELATIONSHIPS WINDOW FROM AN ACCESS FORM

Create a command button.
Place this code in the OnClick event

  SendKeys "%W1%TR"

This is useful in early testing to give the client an idea of how the data is organized.

-------------------------------------------------------
REMOVE THE FILTER FROM A FORM

SendKeys "%RR"

-------------------------------------------------------
TO OPEN A NEW HYPERLINK IN AN ACCESS FIELD

  On Error Resume Next
  DoCmd.RunCommand acCmdInsertHyperlink
  On Error GoTo 0

-------------------------------------------------------
RESOLVING THE WORLDS 2ND LONGEST UPGRADE TO WINDOWS 98

I recently had the old motherboard crash problem.  Sent the computer into the shop for a new one and on return Windows 95 wouldn't run Explorer properly.  No re-installs fixed it.   So I upgraded to Windows 98 and the computer went into a endless loop of upgrades during this installation problem.  Left the computer alone for a few weeks and then someone mentioned the MSCONFIG program for windows 98.  This program allowed me to remove a few unwanted programs from my startup sequence and hey presto Windows 98 now boots.  I think the 6 week install for Windows 98 must be close to a record.  To run the marvelous msconfig program

Click on Start and choose Run.
Type   MSCONFIG    in the open line. 

Please do not ask me for instructions or backup if you destroy your computer but lets just say that removing rubbish from the Startup tab did my Win98 computers the world of good.

-------------------------------------------------------
MOVING AROUND A BUSY ACCESS FORM - A QUICK WIZARD

First insert a page break on the form using The Toolbox.
Now add a command button called cmdMore in the form header or footer.
Copy the following code beneath the button.  Now you can jump around the form

Private Sub cmdMore_Click()

' Jump between pages on a busy form
' Use the toolbox to insert a page break
Static nextPageNum As Integer
  If nextPageNum = 2 Then
    nextPageNum = 1
  Else
    nextPageNum = 2
  End If
  DoCmd.GoToPage nextPageNum
 
End Sub

I use a similar method to build wizards on a single Access form.  Just start page 2 of the wizard at 5 inches down the page using a page break and add Back Next and Finish buttons.

---------------------------------------------
GETTING A LOT OF WEB SITE HITS

vb123.com was featured at vbwire.com  This is real good place to announce your site as our site had over 500 vistors in the week that followed.   Check out their archives page at

http://vbwire.com/archive.asp

---------------------------------------------
In June,  Microsoft will bring out Windows CE version 3.0.  This will include eMbedded Visual Tools that will be free for a limited period.  Just letting you know

http://www.microsoft.com/windows/embedded/ce/

An example of this new technology is a Palm like handheld with inbuilt scanner
http://www.symbol.com/products/mobile_computers/mobile_ppc_ppt2700.html


-------------------------------------------------------
ONLINE SOFTWARE AND BOOK PURCHASES FROM AMAZON.COM

Try out the new electronics section at Amazon.
Click here to enter the store at places suited to
the readership of this magazine
http://vb123.com#software


-------------------------------------------------------
GOOD READING AND USEFUL SITES

A great way of generating a new Access database

Code to write visual basic to generate a completely new database by looking at your existing one.  Check this out
http://www.smithvoice.com/jet.htm

User Interface Guide

Microsoft tips page
http://officeupdate.microsoft.com/2000/articlelist/AccessTips.asp


Handling XML Online
http://www.4guysfromrolla.com/webtech/060700-2.shtml

Excel And Speech Output
http://vb.oreilly.com/news/speech_0400.html

All about queries
http://www.fmsinc.com/tpapers/queries/index.html

A free text editor.  Owen from http://www.healthbase.com.au gives it a rave.
http://www.notetab.com

A review of a book on programming office 2000 web components
http://www.msOfficePRO.com/bookreviews/073560794X_b/073560794X_b.asp


-- OUR SOFTWARE AND RESOURCES -----------------------
Explore your data visually using our popular Access
data mining shareware
---> http://www.vb123.com/explore

View our web site on your computer rather than the slow
old web and have access to all the software discussed in
the articles and information pages at  vb123.com
---> http://www.vb123.com/Toolbox/


So thanks for reading our popular newsletter.
Feel free to make comments, copy the email to a friend
or maybe even contribute to the next edition.

Garry Robinson - Software Consultant


Click on this button to read the previous edition of Access Unlimited 

Published  2000-07