HELLO,
You may freely modify, use bdGuide to make your own directory listing system as long as you keep my copyright information. Freely distribute / post this code and Contact me if you need anything more...asp, vb, com projects :)

Good LuCk.

	mokarrabin@mail.com


--------------------------------------
database Password: guide

--------------------------------------
DESCRIPTION: bdGuide
CD-ROM Directory listing system developed using visual basic 6. This may be used to run a Commercial-Industrial-Consumer guide. Or any other CD-Rom based database system. There are many twisting code modules here. But the thing is well documented, you may contact me to clarify if something goes wrong.

--------------------------------------
BUGS:
There might be many when you try to open, compile and create .exe -debepending upon your configuration. 
Dont hope that this thing would run as it is! You have to tune it up first.
1. In order to view the company details report, you should install MS Access and the data access tools.

2. Error: 'User defined type not defined' or Comctl error during loading, just disable the  subroutine : tbToolBar_ButtonClick(ByVal Button As Button) of the frmBrowser. This happends because comctl is not installed on your machine properly.

--------------------------------------
FUNCTIONALITY:

Like any other similar system, its main job is to retreive the products / company table and show it on the 2nd page. The 3rd page is used to show detailed information.

The interesting part is the advertisement section. Here the the ads can be initially set for the 1st page & 2nd page 4*x .Any other Ad which are not initially set is randomly choosen from the complete set. 

If the user goes to the 3rd page to view products then there can be (4*number of products) ads set on that page. Otherwise if  the user choose to view a company then 4 of the companies ads shall be shown. If the company has additional ads then the user  can choose the 'ADVERTISEMENT' link to show those. 

There can be a maximum of 4 ads for each product/category. 

A company can choose to give an ad for a product, which shall be shown on the products list or give an ad without a category hoping that it shall be randomly choosen or some one might find that company and view all their ads.

It currently supports these type of ads:

     Small picture + Big picture
     Small picture + Video
     Small picture + Audio
     Small picture + MIDI Music

You should:
     Insert some ad pics, as jpg file and link it on the database.
		-small pic should be 30-50 k and big pic high resolution, between 200-300 k
     Insert midi music files for random choice.
     Insert some Gallery pics, as jpg file and link it on the database for beautifucation.
Carefully notice how the ads are placed in the DB. A misplaced ad would crash the program. You must mentain the way that ads are being placed. there is a differance between ad pic and gallery pic.