vb123.com.au                                                          

  Welcome To Access Unlimited - Edition 17
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

ACCESS FORM AND REPORT TOOLBAR TUNEUP
HYPERLINKS IN ACCESS - NO MORE ANNOYING WEB TOOLBAR
ACCESS 2000 KEYBOARD LOCKING BUG
ACCESS 2000 - WHY DOES IT HAVE TO HAPPEN TO ME
SWITCHING TO LANDSCAPE MODE IN ACCESS 2000 REPORTS
and the ever popular 
GOOD READING AND USEFUL SITES SECTION

-------------------------------------------------------
FEATURE ONLINE ARTICLE

One of the most productive things that you can do to improve your Access development efficiency is to add some essential controls to the Toolbars that you use for Form and Report design.  The following page shows you some really useful buttons you can add to your Toolbox toolbar and your shortcut (right mouse click menus).
 
http://www.vb123.com/Toolbox/00_access/toolbartuneup.htm


-------------------------------------------------------
What is "The Toolbox" ?  Maybe this picture will explain.

http://www.vb123.com/Toolbox/images/Toolboxdemo.gif

OR in 25 words or less

The Toolbox is an eBook with 20+ programming articles,
downloads and all the back issues of this email magazine.
Have a lôôk !! ..      http://vb123.com/Toolbox/

-------------------------------------------------------
HYPERLINKS IN ACCESS - NO MORE ANNOYING WEB TOOLBAR

Have you added a hyperlink to an Access form and then wish that web toolbar would go away after you click on the hyperlink.  This visual basic will hide the toolbar and you place it under the Click event of your hyperlink label.  You can do this in a Macro as well.


Private Sub lblOpenEbook_Click()
    DoCmd.ShowToolbar "Web", acToolbarNo
End Sub


-------------------------------------------------------
ACCESS 2000 KEYBOARD LOCKING BUG

Every now and again, Access 2000 will not allow me to type anywhere in the program when I am developing on a Windows 98 computer.  This generally seems to be a function of Access 2000 using more and more system resources.    Solution for resolving the typing problem is to hit the Control and Break keys together. 

Occasionally I run completely out of System resources which I have now isolated down to running Word 2000 and Access 2000 together.   If Word 2000 isn't running, then I never seem to have these locking issues or having the computer die a slow death.  I now run Word 97 when programming in Access 2000.  Great !!!!

-------------------------------------------------------
A WORD FROM OUR SPONSER

Need a Web Host ?
Want to see how your web host compares to others
Search the web's LARGEST hosting directory by clicking below

http://vb123.com/sponsor


-------------------------------------------------------
ACCESS 2000 - WHY DOES IT HAVE TO HAPPEN TO ME

1 Sub form used on 3 separate forms and then suddenly a funny close message.  I refuse the close option and when I go to open the 3 forms.  Nothing.  Finito.  Caramba.  Oh dear $%#%#%#%

Solution.  Not even importing the forms into another database and many of the other rename and save as tricks that I have mentioned at vb123.com work.   Luckily though I could open a module that was OK and then I used the Project explorer in the vb project part of access.  Now I could find the code that I had written under the form and swap it with the code in my backup copy of the database.   All was not lost.   Comments on Access 2000, this giant blob stuff is pretty slow nonsense that makes life for the programmer harder than it used to be in Access 97.  Guess I will have to buy that 1 gigahertz computer after all.   Also I made a new copy of the database and imported all but the corrupt forms into it.  This way I have less chance of continuing my life with some dodgy objects.   The problem this created was that I lost all my object groups which do not transfer.  Should I go on...

Yours truly, one unhappy Ed.


-------------------------------------------------------
SWITCHING TO LANDSCAPE MODE IN ACCESS 2000 REPORTS

The following code will allow a user to switch to landscape mode when displaying a report

Dim RepNameStr As String
RepNameStr = "FXR_VendorList"
If chkLandscape Then
   Call SwitchOrient(RepNameStr)
End if
DoCmd.OpenReport RepNameStr, acViewPreview


For more on switching to Landscape Automatically, search for PrtDevMode in Access help


-------------------------------------------------------
SWITCHING BETWEEN DATASHEET MODE AND FORM VIEW
WITHOUT USING THE TOOLBAR

Add a text field to the query behind the form and call it Switch_View

 e.g. SELECT "Click to switch" AS [Switch View], Purchases.* FROM Purchases;

Add the data field to the form

Now add the following subroutine under the click event of the new field.


Private Sub switch_View_Click()
 
 
  If Me.CurrentView = 1 Then
    ' Switch to datasheet view
    SendKeys "%VS"
  Else
    ' Switch to form view
    SendKeys "%VF"
  End If
 
End Sub


-------------------------------------------------------
HOW TO AUTOMATICALLY ADD AN ENTRY TO A LOOKUP TABLE

Under a combo box is a not in list event.  This event fires up
when the data entry does not occur in the combo box list.

If this code doesn't make sense, skip 20 lines ...

Private Sub DestinationPort_NotInList(NewData As String, _
   Response As Integer)

Dim AddDP As Integer

 AddDP = MsgBox(NewData, vbOKCancel, _
   "Add this new destination port")

 If AddDP = vbOK Then

   DoCmd.SetWarnings False
   DoCmd.RunSQL "INSERT INTO tlkp_DestinationPort " &
    _ ( DestinationPort ) values ('" & NewData & "');"
   DoCmd.SetWarnings True
  
   Response = acDataErrAdded
   DestinationPort.RowSource = DestinationPort.RowSource
 Else
   Response = acDataErrContinue
 End If

End Sub

--------------------------------
SOMETHING TO THINK ABOUT IF THOSE CHECKS AREN'T COMING IN

If you think nobody cares about you, try missing a couple of payments.

Bills travel through the mail at twice the speed of checks.

Borrow money from pessimists-they don't expect it back.

--------------------------------
HTML TRICKERY

Show your current page for a while and then bounce to a new one.

<HTML><HEAD><TITLE>Garry's Goo </TITLE>
<META HTTP-EQUIV="Refresh" CONTENT="15; URL=http://vb123.com/">
</HEAD>

-------------------------------------------------------
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

XML and Visual Basic.   Here is a good article
http://www.xml.com/pub/2000/07/12/vbasic/vb_and_xml.html

Bill Hatfield from Active Web Developer guesses that Visual Studio and Visual Basic will be the next interface for Active Server Pages.  Read about it at
http://www.pinnaclepublishing.com/AW/AWMag.nsf/0/77F1DE70564BA5FF8525690B005910BA

Interface Design - Read the first chapter from one of the gurus
http://www.cooper.com/design.html

Looking for lots of simple office tricks from Bill's buddies
http://www.microsoft.com/office/using/tipstricks/default.htm

Down to earth reviews of web site architecture.
http://www.argus-inc.com/features/webarch.shtml

A good list of Access links
http://www.geocities.com/waddly/accory.html

Check the legitimacy of Australian Companies or your company might be wearing the GST instead.   This site is run by Dun and Bradstreet.
http://www.abnsearch.com.au/

Check your mail using your own vb program.  Good for mail headers but Mime reading is an issue. 
http://www.vbip.com/winsock/winsock_mail_checker_01.asp

File System Object Wrapper
http://www.zarr.net/vb/download/codedetail.asp?code=103

Great Little VB Project to show you how to manage multiple renames and copies.  Just useful as a tool for multiple renames.
http://www.vbcode.com/code/file_manip.zip

Lots of Access links with an emphasis on translation issues.
http://www.microbusnet.com/Poly2000/Market2000/PolyE_Links.htm

Is WAP right for your business?
http://www.cmq.com.au/commun/displaybody.asp?type=feature&articleid=1540

A good site for web developers.
http://www.webdeveloper.com/

Including a good page on boosting your html with meta tags
http://www.webdeveloper.com/html/html_metatags.html

Building an online Table of Contents with XML
http://msdn.microsoft.com/voices/MSDNTOC.asp

A good description of the In's and Out's of HTML email
http://www.email-designs.com/HTMLworld.html


-- 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.gr-fx.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-09