Extract data to browser with search form

[giardap]

Hello,

I did some searching here but can't find anything about my specific issue, so I'm starting a new thread. Apologies if I missed the info elsewhere.

I find lots of ways to use an HTML form to add data to a database, but I don't need to add; I need to access. I have a database of my media collection for which I want to create an HTML look-up form to access the data in a web browser. Basically, I want friends who come over for a music or movie night to be able to query my local database - this is not an internet-based database, it's just located on my backup computer, for a song or show to watch. For example, if they want to watch a "screwball comedy" they could enter that in the search form, click Run, and all the screwball comedies in the database would show. Or, they could pick a song or film directly, or search for an artist, an actor or director, etc., or they could enter a combination of search terms (more than one artist - for example, if they did duet recordings or something - or search for actors who appeared together (ex: Myrna Loy and William Powell in the Thin Man films), or search for all the films in a specific film series (007 films, Thin Man, Pink Panther, etc).

I am not super tech-savvy, so am looking for the easiest (and, hopefully, a free) plug-in solution to my problem! :)). Some 25 to 30 years ago I was involved in database management using SQL, but it was a sideline to my main job (which was not computer related, I just got tasked with helping the IT people because we were a small company just beginning to computerize our operations and I knew a little about databases). What advice would you give to someone trying to do this? Is there a simple plug-in type of form I can use for this (hopefully!), using simple SQL to populate the form, or am I going to have to use a WAMP server or something?

Any help anyone can provide would be most appreciated.

Thank you so much!

Padraig

[UnklDonald418]

Look at this Tutorial devoted to Filtering data in a database
Filter/Search with Forms (leveraging SubForms)
Scroll down and near the end of the Tutorial you can download an example database LIKE_user_input_filter.odb
That example demonstrates what is possible with forms using up to 4 parameters but can be expanded by adding more fields to the table named Filter. The example uses all Text Fields but other data types can also be used.
For more specific help you would need to provide us with a sample of your database
How to attach a document here

[giardap]

Thanks. I'll give that a try and report back.