Words lookup

[hendrikbez]

Hi

I want to know if this is possible in access with vb.

If I have one word like (this is an example) “Hi” as my first column im my table with the name “Word”
Then I may have 1 to 33 words that has the same meaning of this word, “hallo”, “hey”, howdy”, wassup” eg.
So I want to make a form and put any of these words in and it must give me. The rest of the words with the same meaning.
In my table I have columns 1 to 33, on each row I have the first words, and from column 2 I have the rest of the words till 33.
Is there a sample of this to look at.

[CJ_London]

you need a table to store your words something like

tblSynonyms
WordPK
Word
GroupFK

WordPK...Word...GroupFK
1............Hi.......1
2............Hello...1
3............howdy..1
4............big......4
5............large...4

etc

then when you have your word, find all the records with the same groupFK. Typically GroupFK will be the WordPK for the first record of the group

SELECT S.Word
FROM tblSynonyms F INNER JOIN tblSynonyms S ON F.GroupFK=S.GroupFK
WHERE F.Word="Hello"

[hendrikbez]

Ajax, thank you, but I have a table with about 34 columns and about 990 rows, I must try to put all the words in row in a column and make groupFk with same number to each of them .
Going to take time to do this, is there a easy way to do this.

[orange]

Hendrik,

If I understand your requirement correctly, then your structure is incorrect.
A structure such as Ajax suggested is a normalized approach and will serve you well.

Database tables tend to be narrow ( a few fields) and long (many records).

A database table with 34 fields is somewhat rare (not unheard of).

If you work through 1 or 2 of the tutorials from RogersAccessLibrary in this link, you will learn and experience a procedure for identifying entities, attributes and relationships.

Tell us about the table you envision that has 34 fields. A clear description in simple terms.
Good luck.

[hendrikbez]

My thinking was to show all the words that has the same meaning (so I search for hello) and it should show all the words (if there is 33 of them) on the form or table, I have done thios so far


But only use the first word to search, but to put 33 of them in to search will be to big, so I am trying to find a better way to do this.

[orange]

Be cautious, you are referring to table and form seemingly interchangeably. A table is where data is stored. A table is designed (normalized) to reduce duplication. Normalization is a methodology for removing redundant data from a database WITHOUT losing information.

A form is for the presentation of data to the user. The format of the data on the form can be, and often is, very different from the table(s) in which it resides. Your example shows a horizontal arrangement, but a vertical arrangement, or varied colors or varied fonts or other could also be used. There may be many ways to "present" the data o the user.

Identifying all words with similar meaning is achieved through a query as Ajax showed in #2.

You are now addressing synonyms, but in future you may want to deal with antonyms. For assistance with the concepts involved you may want to research "thesaurus design" and Broader Term, Narrower term....


Here's a link on thesaurus concepts/ideas that may be useful.

Good luck.

[hendrikbez]

you need a table to store your words something like

tblSynonyms
WordPK
Word
GroupFK

WordPK...Word...GroupFK
1............Hi.......1
2............Hello...1
3............howdy..1
4............big......4
5............large...4

etc

then when you have your word, find all the records with the same groupFK. Typically GroupFK will be the WordPK for the first record of the group

SELECT S.Word
FROM tblSynonyms F INNER JOIN tblSynonyms S ON F.GroupFK=S.GroupFK
WHERE F.Word="Hello"

Ajax, I have got the xcel to work, to give me the information and is now in the access database, but I an not sure how to use it on a form, to search for any word, if I search word a word, what must I sue to show info on form, and how do I do it.
A

[CJ_London]

I really can't answer that question - it all depends on how you want your form to work.

[orange]

Hendrik,

Please give a few examples of how you would use this info. We need clarification on the purpose and usage of the database.
Just give a scenario of
-user wants to know QQQ
-what would the user enter into the system
-what do you expect the system response to be.

I'm sure readers can help if they understand the underlying issue(s).

Post a copy of your database and instructions to show the problem. You can use Google translate to help with any (English is not my native language) issues.

[hendrikbez]

Hendrik,

Please give a few examples of how you would use this info. We need clarification on the purpose and usage of the database.
Just give a scenario of
-user wants to know QQQ
-what would the user enter into the system
-what do you expect the system response to be.

I'm sure readers can help if they understand the underlying issue(s).

Post a copy of your database and instructions to show the problem. You can use Google translate to help with any (English is not my native language) issues.

Morning orange

Ok user want to search for a word like "hello" then when pressing search button it must a lst or table ,were it should show the results like "hi",yea", morning" eg.
User will search for word with button
User can also add new word to that list.
The response of server must be, when search fo word, it should show you the output of the same meaning of words, and you can add words to it,
I have done what Ajax have ask me to do. for my table
I have made 3 columns in the table " WordPK, Word,GroupFK and then the Id column is also in.

I have zip the file

[orange]

Suggest you give a simple example that you can try with your form. I looked at your database, but do not understand the form or logic. It is not intuitive (to me at least).

Using your form, can you list/pick a word to be searched, then tell us each step you must take to get the result?

Where did you get the vba for the event code?

[CJ_London]

Like Orange, struggling to understand how the form is supposed to work

Best I can suggest is the code required for your filter button would just be

dim vID as long
vID= nz(dlookup("GroupFK","Sinonieme","Word='" & TXTSinonieme & "'")
if vID<>0 then
    me.filter="GroupFK=" & vID
    me.filteron=true
else
    msgbox "word not found
end if

probably needs more - but not clear on the actual requirement

[hendrikbez]

orange, here is a sample of a form that I have done, it is not the correct table and stuff, I just make one, see screenshot.

The vb code I know will not work on this one.

[hendrikbez]

Sorry for replying only now, did have a death in my family.

Here is my databse and form

1. Button to search word
2. Textbox to put in word to search
3. List results for the word.
4. Data table with info on the bottom

a. I need help, that it user put in first word that is on the first row first column ,it must give all the words that is in that row intot the list results, and if user put any one of the words in thar row
it must still give all the words in that row.

b I do not have code for it, as I am bussy with learning access from videos at the moment, after that, going to do VBA in access (going to take a while to do them). I have programing in access + VBA for 2013
will it still work in 2016 without any problems.

5. If getting this to work, I want to take out the data table from the form.

[orange]

Hendrik,
I am not following what you are trying to describe.
Why would you have fields named 1,2,3.... etc? Use meaningful names. People should not have to guess the subject matter.
I have taken 1 record and put it through Google translate and have attached a png.
Please focus on WHAT you want to achieve rather than HOW to do it with Access.

Can you try again to tell us what these translations are meant to represent?

put vs sharpening down vs vessel I guess something critical is lost in "translation".

Please focus on what you are trying to accomplish. Tell us who will use this material/form for what purpose.
Your English is more than adequate for communication so perhaps you could include a few English examples to help clarify your data/intentions for the English speaking audience.
Good luck.