Search results

Hi Jal! Please find attached the new database file. As for the query you made last, there should be some additional data displayed. Lets take for example the first row. The display of a codenumber should look like this (i write the name of columns): Important_0 Detail0/4-Needed...

Hi Jal! Thank you so much! This is definitely what I wanted. Thank you so so much! :) There should be one more last thing before it is perfect. Displaying only the codenumber is not enough, so there are a few fields which are in the same row as the codenumbers and should be also displayed. But...

Sorry, for the misleading suggestion. What I was trying to say is that: the "third request to replace the second one". So I do not need the second one! :) Sorry!

Hi Jal! Thank you for your help! Sure, you can reuse the query, and there is no need, for a third textbox. You can output it to the second one (latest). Thank you!

HI Jal! Thank you very much for the code! This is exactly what I wanted! I run the code and it works perfectly. Answering your question: this is a sample file. I made this file by altering the original file. (I am not allowed to show the original file because of privacy issues). I changed a few...

Hi Jal! Thank you very much for your help and support! The code you have provided... I have to paste it in SQL view, is that right?

Hi Jal! Thank you very much for your help! This is what I wanted!!! Thank you very much! Is there a possibility to make the frame of txtResult box invisible? I tried in the properties menu but could not find the solution. I also have another question if you can help.... I would like to have...

Hi Jal! Thank you very much for your help! This is EXACTLY what I wanted. Uhmm...however can I ask you about a small modification. What should I do if I would like the columns in the search was found to be displayed on the main form? Like for example if I search for number 7 (you have added to...

Hi HiTechCoach! Thank you for your provided links and guidance. My first problem is that I knew that I have to normalize this table (which was imported from Excel) but I really do not know how to do it. Why? There are two reasons. 1) The table provided shows connections. Actually it is a...

Hi there Everyone! This is my first post on this forum, and I just started learning MS Access for a few days. I know a little (very little) VBA Excel programming, I thought Access will be easy to handle but I was soooo wrong. :( Anyway I would like to learn, and already have an ongoing access...