add to databse

[hendrikbez]

I did put this on https://www.mrexcel.com/forum/microsoft-access/, but dit not get any response on it.

I have a access database that have table (with info).



I have make a form that shows all the columns that is on the table.
On the form I have a textbox(to search word) and a button(Search for word) on the form.

Now how can I make it that when I put a word in the textbox (that is in the table) and press the search button, it must give me all the info of that word on the vorm (columns in table), and when I press the save button it must add the words that I have added in to the database.

[CJ_London]

your requirement is not clear which is why perhaps you did not get a response. Tho' your link does not work (i.e. go to your post) so cannot verify that.

what does 'all the info' mean

what does 'add the words I have added' mean?

For your first question, suggest provide some example data, the result expected when you press the search button as an illustration

For your second question, again provide some examples

[hendrikbez]

Sorry, in my head it makes sense, english is not my first language, so I will give a screenshot to show you .



Here you can see my form. When I open the form ,it is like this, when the form starts, I want it not to show any info(data) in it.
1. When I add a word in a texbox(search word), and press button (Search)it must search for that word, and show all the info in the texboxes on the form, not all of them will have a word in.
2. If a mountain word does not exist, i want to put in all the info(words) on the form and then and I press button (add button)(not on the form yet) to save it to the table.

Hope this help with explaning.

[CJ_London]

OK - leads to more questions - you say a word but you are showing multiple words - so are you looking for that complete phrase or anything that has 19th or Party or conference or Peak in it?

And do you need to search every field? or just one?

and are you looking for a partial match - e.g. if the word was 'conf' do you want to find 'conference'?

Again, would be helpful to see some example data and outcomes

Also need to know roughly how many records (100's? 100,000's? millions?) - there are different ways of doing this and you use more complex methods for large volumes

[hendrikbez]

OK - leads to more questions - you say a word but you are showing multiple words - so are you looking for that complete phrase or anything that has 19th or Party or conference or Peak in it?

And do you need to search every field? or just one?

and are you looking for a partial match - e.g. if the word was 'conf' do you want to find 'conference'?

Again, would be helpful to see some example data and outcomes

Also need to know roughly how many records (100's? 100,000's? millions?) - there are different ways of doing this and you use more complex methods for large volumes

if I put in a word in the textbox to search, it must give me all the info (table have 5 column in it( I took one out) so if there is info in this columns for the word, let use (19th Party Conference Peak) I will search for 19th Party
and when I press the search button it will only give me data (Kyrgyzstan), because only those two are in the table for that word.

just the one field, if it found the word, it must give the rest of the words like (Kyrgyzstan) if they are in the table)

Yes if I only put in 19th p, it must give me (19th Party Conference Peak)

See screenshot of the table


About 6000 records

[CJ_London]

still no example outcomes. Please understand there are many ways of doing this, I'm not going to go through all of them because you are not clearly defining your requirement.

what if your word is 'ac' - do you want nothing returned? or do you want Acatenango, Acotango etc?

what if your word is 'na' do you want records associated with Argentina returned ? Acatenango? both?

[hendrikbez]

what if your word is 'ac' - do you want nothing returned? or do you want Acatenango, Acotango etc?

what if your word is 'na' do you want records associated with Argentina returned ? Acatenango? both?

Alax ,sorry i am not yet so good with access, you are right both of these will work.

I think to maybe put a database in the form so show the result, will that work and leave the textboxes to add new words to table

[GinaWhipp]

Hmm, I think what you are looking for is this...
http://allenbrowne.com/ser-62.html

[hendrikbez]

Hmm, I think what you are looking for is this...
http://allenbrowne.com/ser-62.html

Thank you GinaWhipp, will look at this.