detailed question regarding special search form for access 2003

[Absolute_Beginner]

Hi everybody,

First of all, a word of warning, my knowledge of MS Access is severely limited, please bear with me.

I’m working for a company during my university summer break. I have been tasked with creating a database (thank god my boss doesn’t want anything fancy) for storing the minutes of management meetings, which should also include a comfortable search engine.

So far, I have created two tables:

The first is the master table (tblSitzung) which contains the following columns with information regarding the meetings itself (I’ll write down the original German titles of the columns and provide a translation in brackets)

sitzung_id (the meeting-ID, which is the primary key)
sitzung_datum (the date of the meeting)
sitzung_art (management level involved)
sitzung_teilnehmer (participants)


The second table (tblThemen) contains the minutes and has the following columns

themen_id (the ID of the respective item on the agenda, the primary key)
sitzung_id_f (the key with which the table “tblThemen” is linked to the master table)
sitzung_fragestellung (the question raised in this particular item on the agenda)
sitzung_input (well, the input from the participants
sitzung_ergebnis (the course of action that has been agreed upon)

Now, the tricky part is creating a search form. Since I lack any understanding for VBA code or queries, I have spent days looking for a solution in various forums. I do realize that there are plenty of examples of how to create a search form out there, but none of them seems to be suitable for my particular requirements. Well, maybe they are, but since I don’t really understand VBA, I haven’t really been able to figure out how to customize sample codes so that they fit my database.

What I want to do is create a form that basically consists of a simple text field and a “search” button. The database user should be able to enter a word into the text field and then click on the search button. The search should be performed within the columns sitzung_fragestellung, sitzung_input and sitzung_ergebnis in the table “tblThemen”. Then, a new form should pop up which includes the respective item (or items) of the agenda that include the word entered in the search field plus the date, the participants and the kind of the meeting. So, if a keyword is found in the column “themen_fragestellung”, the search result form should also include the respective fields of “themen_input”, “themen_ergebnis” plus the “sitzung_datum”, “sitzung_art” and “sitzung_teilnehmer” that belong to it. It would also be great if the keyword was somehow highlighted in the field it was found in.

I don’t know if what I have envisioned is easy to accomplish or not. I do hope that it is easy, so that anybody of you who is willing to help me out won’t be busy for too long.

I will upload a sample database filled with some junk data, which consists of the tables I have explained above.

I would be greatly indebted to anybody who has a look at it and could perhaps include the search form as outlined above. Just coming up with a VBA code for the search form would be great as well (I guess I could take it from there once I have the code

Any other input, hints or ideas would be greatly appreciated as well!

I apologize in advance if I have misjudged the scope of the problem and asked something of you that would require too much input on your part.

I hope to receive feedback soon! If I need to clarify something, please let me know!

Best regards,

Ian

 

[John Big Booty]

Welcome to the forum.

Perhaps the sample here will give you some pointers.

 

[Absolute_Beginner]

Thank you very much, I will have a look at it and try if I can make it work.