home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
DP Tool Club 26
/
CD_ASCQ_26_1295.iso
/
vrac
/
genlog.zip
/
READ.ME
< prev
Wrap
Text File
|
1995-09-23
|
3KB
|
72 lines
A Genealogy Research Log for use with Microsoft Access 2.0
Important Note
You must have a copy of Microsoft Access 2.0 installed on your
machine. Create a directory named \dbfiles and place these files
in that directory. If you place these files in a different
directory, you will need to re-attach tables between the two
databases included here.
File Structure
The four files included in this zip file (genlog.ldb, genlog.mdb,
gendata.ldb, gendata.mdb) are simply two MS Access databases. One
database (genlog) contains forms, queries, reports, etc. The
other database (gendata) contains the actual tables of data. The
reason for the split is that it simplifies the process of copying
data files from notebook to desktop (and vice versa), while
allowing input forms for differing screen resolutions on each
machine. The data tables in "gendata" are attached to the
"genlog" database.
Screen Resolution
To use this log, simply open the "genlog" database from within MS
Access. An "autoexec" macro opens the input form of your choice.
The default form is for a screen resolution of 640x480. If your
Windows screen resolution is set to 800x600, you will want to
modify the autoexec macro to use the 800x600 form. This is very
simple to do.
Using the Fields
The fields in the log are largely self-explanatory. The method I
use is to number each entry with the date and a sequential number
(eg: "950218-01" for the first entry on 18 Feb 1995, and so
forth). I use the "line" field to separate the research on
families (eg: "VREELAND" or "CARTER").
Reporting
When you click on the "Print Report" button, it will prompt you
for the line you want to report. Just type in the name for the
line, and the report will print. If you organize your research
differently, you can just modify the report query to remove the
prompt line, and it will include the entire table in the report.
Searching
If you want to search the "Notes" field for a particular name or
phrase, you can use the query entitled "Search Notes For". This
will prompt you for the text string--just be sure to begin and
end the string with an asterisk (*). The results will be dumped
into the table named "Search Results" for your browsing pleasure.
This can also be manually printed, using the "Search Results"
report.
If you want to print a report including only a subset of your
research, you can use the query titled "Excerpt Recent Research
for Report". To do this, edit the query to insert the criterion
that will include the appropriate data, and run the query. The
results will again be dumped into the "Search Results" table, and
can be printed with the "Search Results" report.
Summary
That's all there is. It's simple, but it has met my research log
needs for a while. I used a log of the same design in Foxpro
before MS Access was released.
Disclaimers
This is freeware; there is no charge for its use. It obviously
can be modified as you see fit for your own use. It is not for
resale. Use at your own risk; I hereby perform the ritual
hand-washing to absolve myself of any liability from your use of
this database.
⌐ Copyright 1995 Steve Carter