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

 

Stuff I Like to Share
Jan -June 1997

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.

  1. Make two copies of the database you want to split.
  2. Go to the table database and delete everything except the tables in there.
  3. Go to the program database and delete all the tables in there.
  4. 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? 14 June 97

Solution:   Then get Query Analyzer. Main function of QA is displaying query hierarchy, i.e. which query uses which tables/queries. Other functionality (such as navigation, invoking query builder etc.) is built around this feature

TOP

Problem: Relationship Printer Add-In 21 June 97

Solution:   I download the Relationship Printer Add-In for Microsoft Access which is also available in Software Wizardry. This Add-In is designed to be used in conjunction with the Relationship Printer. So make sure you have the Relationship Printer before installing this Add-In. Check it out.

TOP

Problem: Creating Database for 3 version of Access 28 June 97

Solution:   If you really want to do that, then start with Access 2. Once it is finished, convert it into Access 95 or Access 97. After conversion then make any changes need to run such as API from 16bit to 32bit and others. If you make the database in Access 97 first, then convert it to Access 2 or Access 95. You are out of luck because you have to make all the new forms, reports, queries and other in the Access 2 and Access 95. Only table can be convert into lower version.

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