General Information Access
Applications
Vacation
Page
Casio
QV-300
Exhibition
Page

 

Stuff I Like to Share
July - Dec 1997

Access Problems and Solutions

 

Problem: Need utility to view and export your database without the database program? 5 July 97

Solution:   Check out QueryWiz. QueryWiz is an easy to use utility which allows queries of several ODBC formats including Access, Excel, dBase, FoxPro, and Paradox without the native software. Define field selection and display order, sorts, and filters on text, date (ranges) and numerical values. Preview in a resizable grid, and then export to Excel or delimited text.

TOP

Problem: Looking for Advanced Access book? 12 July 97

Solution:   I have been using the "Access 97 Secret" from IDG Books. The authors consist of Cary Prague, William Amo and James Foxall. This is book is great..... other then the Access 97 Developer Handbook from Ken Gentz and friends. It has tips, secret and notes. It actually tell you when and what to be careful of.... like bugs and things like that. Check out my homepage under Access 97 Book.

TOP

Problem: Wondering how to use Active X in Access 97? 19 July 97

Solution:   Go get  Sample Active X . This file have some sample on how to used the Active X available in the Office 97 Developer Edition.

TOP

Problem: Looking for a Code Librarian? 26 July 97

Solution:   Then get AllCode Collector V2.0. You can store and retrieve your code, the topics, name and purpose. Searching facility using Topics and Name is provided. Print function is available to print the codes.

TOP

Problem: Want some samples for Reports? 2 Aug 97

Solution:   Go to Sample Reports . This file have some sample on creating reports like drawing vertical line,convert number to description and others.

TOP

Problem: Import HTML tables into Access 97 9 Aug 97

Solution:   You do so by select "File" from the menu, then select "Get External Data". You will presented with 2 option and since you want to import, then select "Import". A file dialog will be displayed. Select "HTML Documents" from the "Files of Type" dropdown box. Next select the filename from the list of files and press "Import". Next you will see the wizard so continue until the wizard reach the last page and finally select "Finish". After awhile you will a new file created.

TOP

Problem: Are you a Access Developer? 16 Aug 97

Solution:   If you are, then get the "Access 97 Expert Solution" by Stan Leszynski. This book tell you want to do as an Access Developer starting from the creating specification up to the deployment of the completed application.

You might think that Leszynski sound familiar to you.... yes... he is the one half of the L/R naming convention. The other half is Reddick.

TOP

Problem: Need some sample forms? 23 Aug 97

Solution:   Go to Sample Forms . This file have some sample on creating forms with drag and drop capabilities, display line number in subform and a few others.

TOP

Problem: Training text for Access 2? 30 Aug 97

Solution:   Need some text on Access for your student??? Then get it from http://www.wji.com/access/w8491.html. This text is prepare by a teacher in Brisbane Institute of TAFE.

TOP

Problem: Revision of DBViewer 6 Sep 97

Solution:   Since my last recommendation of this wonderful program in 21 December 96, changes has been made to program which include adding filter tools that can have 6 logical ANDed condition and generated the SQL statement for final tweaking before execution. Other feature include sorting and finding record based on a field and the search criteria can be exact match, contains and begin with. Get it from Brighton Beach Software.

TOP

Problem: How to separate "New York NY" to "New York" in City and "NY" in state field. 13 Sep 97

Solution:   Let assume "New York NY" is in CityState field. To get "New York" in city field, use Mid$([CityState],1,len([CityState]-2). As for the "NY" in state field, use right$([CityState],2) since the state code is a two character field.

TOP

Problem: Convert 5.5 to 5 1/2 20 Sep 97

Solution:   Save the file trisha.txt. Just give a variable eg 5.5 and you will get 5 1/2.

TOP

Problem: Want to Chat with someone? 27 Sept 97

Solution:   Go to Access Chat in Cobb web site. The editor of IMA (Inside Ms Access) Susan Harkin is there.

TOP

Problem: Creating Initial from Long Name 4 Oct 97

Solution:   Let say you have a field call "ChatName" and the person's name is "Pierre-Andre Stanton". In the query, create three item as follows:-

FirstName: Left$([ChatName],1)
LastName: Mid$([ChatName],InStr([Chatname]," ")+1,1)
Initial: [FirstName] & [LastName]

You will see "PS" at "Initial" field.

TOP

Problem: Sample Forms and Reports 11 Oct 97

Solution:   Go to Sample Reports and Sample Forms for Access 97.

TOP

Problem: Want to Convert Access97 to VB 18 Oct 97

Solution:   Check out the GFM Inc Web Site.

TOP

Problem: ChatLog for Access Chat 25 Oct 97

Solution:   Get the chatlog right here. I am sure you will find some interesting stuff in there.

TOP

Problem: Label Printing 1 Nov 97

Solution:   Want to print a few labels for a few customers?? Here is the solution. Download af2-001.ZIP

TOP

 

 


The Ms Access Freak
Written by Trisha Phoon
Copyright © 1996, 1997, 1998  by Trisha Phoon
E-mail: csphoon@pc.jaring.my

This site re-designed courtesy of Lond's Web Services