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

[DD]

From: "Doug Robbins - Word MVP" <[email protected]>
Subject: Re: 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

 

[Martin Fishlock]

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.