Search results

Hi Jal! Thank you for your continous help! "...unless you have an old version where the query was pulled from the Misc table (I hope you are no longer using that miscellaneous-table)" I am not really sure what do you mean? Which table? I run '? cmd.commandText' in the immediate window and got...

Hi Jal! The query seems to work, but there is a problem I am experiencing. I tried to change the column/field name Important_0 to Cégszám_0. I changed the name in every query and code as well, however when I run the macro I get an error (Parameter Important_0 has no default value) before...

Hi Jal! Thank you so much for the query. I will try to put the code in the original file. Will provide feedback once done. Thank you and have a nice weekend!

Hi Jal! Thank you for your reply and help. First I would like to clear one thing. In case of post 41 we were looking for something else, namely the status of the company (L, S, C and so on). The status of the company is only mentioned in two cases..Important_0 and Important_1. Now we are...

Hi Jal! Sorry for the incomplete post. The columns which contain the company names are these ones: - in casethe codenumber we are searching for is in column/field important_0 then the company name is in: "Detail 0/4-Needed" - in case the codenumber we are searching for is in column/field...

Hi Jal! I tested the database, made many many queries and it seems to be fully functional. Of course my collegues will test further in the coming days...but I really do not think that we will have errors... There's one recent issue though.... can we somehow add a label which shows the name of...

I am testing the database right now...your macro seems to work properly! I will get back to you very soon...if everything worked out fine!

Hi Jal! Maybe you can help with my problem. I am trying to do the show image when the macro is running. Here is the code: Private Sub btnSearch_Click() Call ShowImage 'makes the image25 visible Msgbox "Please press ok" Call Search 'makes the search query Image25.Visible = False...

Hi Jal! Your code it is not slow... The original file I am working with it's almost 1 Gigabyte, so when I do a query it takes around 3 seconds. This is not long for sure...but the users of this file are very computer illiterates... so I would like to have something that shows them, that the code...

Thank you Jal...again! Your solution is working. I am testing now the codes with the original database. Sometimes the code is running a bit long. Not too much...but... Anyway is there a possibility to do the following? I have a picture on the form. The default property is set to: not visible...

Hi Jal! Thank you sooo much for the list search! It is definetelly what I wanted! Thank you for it! I will check the whole application tomorrow with the real database. I will try everything and FULLY test it...and will post the final version for you. I have a question/request though.... how...

Ok, no problem. Just take your time! If you got the solution please post it! Thank you very much and have a nice weekend! Anyway...till you figure out something I think I will do the following. There are alltogether 4 type of codes. In the columns there are maximum two codenames. So I'll make...

Hi Jal! Sorry for being away.. I just tried your provided database and it is working very very good! Thank you so much for that! However there are still 2 (small) problems: 1. How could I decrease the font size of the findings table to Tahoma 8? You see the search box and the column findings...

Hi Jal! We are having visitors for a few days, so I will have very limited time to test your code. Will get back to you till/on weekend!

Hi Jal! Thank you so much for your help! I am really glad that I met someone so helpful. I did not have enough time to check the code, but I think I should mention this... Your code works even if there are more than one codenames in the field? I mean something like: L S (these are two different...

Hello! As I told you I have this file in an excel file and searched for one codenumber, and it returned the same results as this access file. Anyway just to be sure, I will make more searches on different codenumbers, just to be sure that it works properly. Thank you for reminding it! Thank you...

Hello Jal! Thank you very much! It is fully working!!! Very nice work! Thank you! I have a question about one of the columns/fields. In the original file the column 'Detail0/2-Needed' is for storing some codes (like: S, C, L, EO_50VBC). But I would like that instead of these codes meaningfull...

Hi Jal! Thank you for the code! I am trying to get it work with the origianl file, but I am having some problems. I'll try to experience a bit and get back to you soon! Thank you so much!

Hmm... are you sure that the Important_0 and Detail_0 are different?? They should be always the same... Anyway only one record is enough (first one) and for me a table format also is good, or listbox format! It does not really matter because I will need to make a printable report form of the...

You are right. Not whole the records are duplicated, and many records in Important_0 are duplicated. I am not sure what do you mean by discard? :(