Access Problems and Solutions
Problem: Need something to
backup, repair and compact your database? 4 Jan 97
Solution: If you want
to look for a program to repair, compact and backup your database, you should take a look
at this great program from Alex Dybenko. The program is called REPAIR! Point. Get it from
Winsite Archive. Just click here.
Using this utility you can easy keep safety of your MS Access files. It can Repair and
Compact your files and backup them to any folder. Backup is also available for files in
use, which are not opened exclusively. Utility can be scheduled by any Schedule program
(e.g. System Agent) to run tasks automatically.
TOP
Problem: Assigning Recordsource of
subform after main form is open. 11
Jan 97
Solution: Usually, the
recordsource of subform is put into the property and is execute when the main form is
open. You can also use Access Basic to update the recordsource of your subform after the
main form is open. In this case, the subform is execute if the information in the main
form is correct.
TOP
Problem: Assigning Recordsource
of reports after QBF form is entered. 18
Jan 97
Solution: First, create
a QBF form with some fields to search, then create listbox and a FIND button. Behind the
FIND button will create the SQL statement base on the fields to search a.k.a. Query by
Form. Another button will be the PRINT button that open the report, assign the
recordsource with the SQL statement create and save the report. Finally, it is open either
in print mode or preview.
TOP
Problem: Back to HTML Generator for Access 25 Jan 97
Solution: The other, I
found another program that can generate HTML table from Access. The name of this program
is Access2HTML. You can have the choice of
looking at the example, download the program, read the readme file or send a e-mail to the
author of this program.
TOP
Problem: Tired of creating switchboard?
1 Feb 97
Solution: If you are
tired of creating switchboard when you have a lot of option for your system, why don't you
try Infinite Menu System
that used to be from AdaptaSoft. The infinite Menu System allows you to search and select
from an unlimited number of menu items with incredible speed. Each menu item when selected
can open a form, query, table, report or run any VBA function. You can specify command
line options for these functions such as: View, Window Mode, Data Mode, Filter Name, Where
Clause, and/or Open Arguments. Users can also specify if they want the menu to remain open
after a select, to close, or to be minimized
TOP
Problem: Having problem figuring out
which version of Access? 15 Feb 97
Solution: This program
solves the annoying problem of trying to figure out what version of Access an .mdb file
has been created in. With VersionCheck
program, when a user double-clicks on an .mdb file, VersionCheck opens the file in the
version of Access that the file was created in.
TOP
Problem: Another
database browsing utility.... for Windows 95 or NT 1 Mar 97
Solution: ODBC Reporter is a
database browsing utility for Windows 95 or NT users who have ODBC installed and
configured, with datasources defined on their desktops.
It is designed for users who are familiar with SQL, and the construction of SELECT
statements. It's features include allowing users to create, execute and save SQL SELECT
statements through a dialog, and to print the results of the queries or to save the
results to a text file.
TOP
Problem: Multi-select function in Access 2 8 Mar 97
Solution: Since the
last few project, I have been using multiselect function. Instead of using the OCX
available, which give me problem because OCX need to be installed for all the user. The
method is using two list box, one for all the records that can be selected and another one
for the selected record. between this two list box will have four button which is the
"Add All", "Add One", "Remove One" and "Remove
All". With this button, I can move the record from the left listbox to the right
listbox, either all or one by one and move back from right to left when the selected is
not needed. Other features included is double clicking on the left listbox will stimulate
the "Add One" and double clicking on the right listbox will stimulate the
"Remove One". A table is use to put in the record id for the selected record on
the right listbox.
TOP
Problem: Looking for a better Attachment Manager?
15 Mar 97
Solution: Get FMS Power Pack for Access 2.0. It has my
favorite Enhanced Attachment Manager - Manage attached tables with ease. Other utilities
include Database Complexity Meter - Measures number of objects and their complexity for
comparison to other databases , DAO Structure Dumper - Dump the entire DAO structure of
your database to a text file, DAO Browser - View the entire DAO hierarchy of your database
with our cool browser.
TOP
Problem: Want to know who is currently on line? 22 Mar 97
Solution: Then get ICQ from Mirabilis LTD. ICQ is a revolutionary,
user-friendly Internet program that tells you who's online at all times and enables you to
contact them at your wish. No longer will you search in vain for friends or associates on
the 'net. ICQ does the searching for you, alerting you in real time when they sign on. In
addition, ICQ continually tells you who of your friends and associates are online.
TOP
Problem: Convert Data from Access 97 to Access 2.0
29 Mar 97
Solution: All you have
to do is create a new Access 2 database, and export your current Access 97 database to the
new Access 2.0 database.
TOP
Problem: Lookup in Table Design 5 Apr 97
Solution: Do you know
that you can create lookup when you design the table??? With the function, you can create
the field control for the form by just dropping the field into the form. The control
created is a combo box instead of the standard text box. Everything you have maintain
early in the table is included in the property of this combobox field.
TOP
Problem: Converting Access 2 to Access 97 12 Apr 97
Solution: Instead of
opening an Access database that you want to convert in Access 97 and Access asking whether
you want to enable or convert. What I do is open a new Access 97 database and import all
the stuff... e.g. tables, queries, report, forms, macro and code into the new Access 97
database. If you old database used API and DLL, you might need to find the equivalent in
32bit instead of 16bit.
TOP
Problem: Splitting Database 19 Apr 97
Solution: If you are
using Access 2.0 and you want to split the database to two database which is the program
and table database, just the following instruction.
- Make two copies of the database you want to split.
- Go to the table database and delete everything except the tables in there.
- Go to the program database and delete all the tables in there.
- Use attach table in the menu to attach all the table to the table database.
TOP
Problem: Replace Autoexec Macro with Startup
Wizard 26 Apr 97
Solution: If you are
using Access 97, replace your autoexec macro with the startup wizard will let you remove
the toolbar, hide the database window, open the first form and also a few more things.
TOP
Problem: Documenting Database 3 May 97
Solution: I am check out the
Data Reviewer. You can get it from Winsite. The file name is DAT_RVW2.ZIP. The two
utilities are Database Camera and Data Normalizer.
Database Camera is a utility to give you a snapshot of your database. It will tell you
how many entries in each field. What are the 6 most common entries in each field and how
many times they occur. This should give you an idea of the quality of your data. The time
this takes will depend on the size of your tables, speed of your drives, and platform of
the tables.
TOP
Problem: Looking for
"Query By Form"? 10 May
97
Solution: It includes a
form and modules that allow you to create a query-by-form for any form in your own
database. The purpose of this sample database is to provide you a filter-by-form
substitute in run-time applications.
Click Query by Form
.
TOP
Problem: Do you want to explore
and develop query structures?