🚀 go-pugleaf

I just started a new job and am taking over from a previous programmer.
I am using VB4 because they are concerned with some problems arising
with the present program if they convert to VB6 (which the other
programmer here is starting to use (a C programmer). I have 3 areas that
I need advice on.

1.  In the present setup of their programs they prefer to use an ini
file to reference the database including variables

 [SETUP]
 DB Path=C:\NCRS\DATA\
 DB Name=TRACKING.MDB
 Tracking Table=NCRS_TRACK
 Station Table=Station Numbers
 DataType Table=Data Types

they prefer this because then they can go into the ini file and change
where the database is stored. Is there a simpler way to to do this (eg.
just have the database path in the ini and code to populate a
datacontrol or is there a way to do it from within the application so
the user can set or change it without doing an ini.)?

2.  I need to search a particular table to retrieve 1 or a few records
to and get the values from from one column to retrieve those values
(later used to get images). To narrow down the records I plan to use
combo boxes to select the 1 to 5 values for other fields in the table to
enter in a query and bring back the results. Is there a way to use this
to update the datacontrol and inturn the vbSpread control that contains
all the records that are initially populated with all records on
startup?

3.  With the multiple combo boxes on the form is there a way to have the
vbSpread control display the results depending on which value is
selected in the combo box (do I update the datacontrol that populates
the vbSpread or is there a better approach)? I know this is a really
dumb question but where do you generally put SQL statements ?

Sorry for making this so long and perhaps senseless but I am new to this
position. Any advice would be greatly appreciated (either simple or
super detailed)

Thanks alot!

Jeff P. Morgan
jeffpmorgan@netscape.net