Please advise on the production of a frontend, to view selected record(s) of a completed worksheet

[DD]

I have created an excel worksheet containing details of building surveys -
each survey on a different row. The columns list the locations and provide
records which detail whether the site has been visited, the survey checked
and provides comments on the non-completion of any construction work. In
addition, two of the columns list hyperlinks to a jpeg photograph of the
site and to an external survey report (also in excel format). The columns
are headed as follows:

Location
Address
City
Council
Visited by
Checked
Comments
Photo Files
Reports

I have done some preliminary research and have found various userforms which
allow users to input information into worksheets. My database is for viewing
information only, as all the data has already been entered. I need a
frontend which allows the user to filter to the site (possibly using a
cascading combobox to select location then site) and then select okay, to
view the results. I would like excel to then display the details of the
selected suvey as per the list above, including the photograph and external
survey report.

Dylan Dawson
Scotland

 

[Doug Robbins - Word MVP]

As your data is in Excel, I would suggest that it would be better to do the
whole thing in Excel and that you should post your question to the
microsoft.public.excel.programming newsgroup. This one is for Word.

If it were me however, I would import all of the data into Access and use a
form in that application.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP