The "PLEASE HELP ME" Page
Can't We Just Get Along?!
I believe that, once in a while, everyone needs help in one form or another. If the whole world could just give a little, we could all be just a bunch of happy people.
At this moment, nothing would make me happy than to solve whatever problems I have posted on this board.
My Current Headache
I am trying to design a small database project for school. I have gone over this for about a gazillion time, and it seems to have turned into a challenging maze. This is from the book "Visual Basic 6 How to Program." Anyway, where is the problem:
Define a complete query application for the Biblio.mdb database that comes with Visual Basic compiler. The user should be able to edit existing data and add new data to the database. Provide a series of predefined queries with an appropriate name for each query displayed in a Command Button or List Box. Provide the following predefine Queries:
A. Select ALL authors from the Authors table.
A. Select ALL authors from the Authors table.
B. Select ALL publishers from the Publishers table.
C. Select a specific author and list ALL books published by that publisher. Include the title, year and ISBN number. Order the information alphabetically by title.
D. Select a specific publisher and list ALL books published by that publisher. Include the title, year and ISBN number. Order the information alphabetically by title.
E. Select a publisher and display its address, phone number and fax number.
For each of the preceding queries, the results should be displayed in a GRIDBOX Control.
The queries in both C and D might use both a DataGrid / Hierarchical / FlexGrid and TextBoxes for the for the author or publisher name.
Your program should allow the user to UPDATE fields, DELETE records, FIND records by a given field and ADD records to the database.
I used this file http://richiecomp.freewebspace.com/Original%20Product.rar as a template for my work. It comes on the CD-ROM from the book VISUAL BASIC 6 – HOW TO PROGRAM.
This here, http://richiecomp.freewebspace.com/AlmostFinishedWork.rar , is a work-in-progress. I have been using the original file in order to fill-in the blanks. However, I seem to be logically stuck on joining tables.
This here www.itipnet.com/hayesweb/biblio.mdb is the Access database file to which the Visual Basic projects connect.