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
|