From: "Doug Robbins - Word MVP"
Subject: Please advise on the production of a frontend, to view selected record(s) of a completed worksheet
Date: 27 November 2006 18:08

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

"DD" wrote in message
...
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

Dylon,

The advise given by Doug is probably best and I would recommend the use of
access. or more realistically an HTML front end to an access or mysql
database or possiblly a VB application.

This could then be accessed easily over the internet provided you have the
correct security to protect the data and access.

It really depends on the following:

what you need it for
the business critical nature of the project
the value of the database
where it is needed (on the road/at home/in office)

the project could be simple with little singing and dancing but would rely
on the acceptance of the system short comings by the users and these days
users are not very resiliant.

but the project is quite details and would take some hours to develop. It is
not really just here is a bit of code and it works.

You need to develop some selection criterial that would allow data filtering
ie auto filter or database selection.

You then need to develop a userform to show the pictures and the information.

and you also need to protect your data and ensure that the data does not get
into competitors hands if that is a concern.

Anyway I hope I have given you some pointers for completing the project.



--
Hope this helps
Martin Fishlock


"DD" wrote:

From: "Doug Robbins - Word MVP"
Subject: Please advise on the production of a frontend, to view selected record(s) of a completed worksheet
Date: 27 November 2006 18:08

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

"DD" wrote in message
...
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