Search results

Hi all, I made some progress. The only thing that now is making it not work for 100% (only 90%) is one tiny part. It has to do with a Chinese name. on one table it is as "Meiguang" and on the other table as "Mei". both have the same date of birth. The below SQL finds all that I need, but not...

Hi all, @Mark we get every month from 2 different systems excel files. We need to compare them both to see if we have in one excel file the same person listed as in the other excel. of course, there could be a typo in one of the files and we would not be able to catch this. When I use on the...

Hi all, I needed to create a query that will check in 2 different tables for the first name and surname if there is a match. The trouble is that there could be a typo and a first name or surname would be missing or having to much letters. for example McCanna vs McCana or with the first name...

Hi all, I have been trying to play with the attachments in the table. in a table where there are some records, there a few attached pdf files. I can add it to the main form and it will show me this field that when I click on it, it will show the attachments, and then I can add, delete, view...

BIG thanks, it works :-)

Hi, I don't get it to work. no clue why. I should copy this to a new module and then run it by using the call of the function like this: CompanyName = GetPartSTR. I'm simply lost wit this, kind of over my head. Greetings.

Hi all, I need to fix a part of a function that takes a piece of text from html page. The current function will only take the first string of numbers that come after a 0 href=javascript:LinkCase(0,123456,'Daltonia Limited',0,654321) so I will get only 123456. I'm trying to get now the company...

hi, that one worked out :-) but, the date I still get as 20/01/2015, any clue about that? Greetings.

one detail after I added to show the date too, it passes the wrong date format to it: the 20/01/2015 will come out instead all of the <=#2/1/2015# the date in the database I query (Teradata) is set as 2015.01.02 maybe that could be the trouble. Maybe passing it with formatting it will work...

Hi Minty, Using DISTINCT will show me still to many records as there are other dates to. I corrected the ANS to AND, this should not give me errors. I guess that access can't handle the <= in a date. Greetings.

Hi Arnelgp, If I remove the "top 1" I get all the records, like 30 something rows. I only need to get the top one to paste it to a excel sheet. Greetings.

yes, it is :-) a silly typo in the code I paste it here. the regular code I use, is without the typo. Greetings.

Hi all, I'm going nuts on this one. I use a query to get a balance ledger that is less or equal to the day passed and only interested in the TOP 1 ORDER BY set to DESC. SELECT TOP 1 BALANCE_LED FROM CUSTACCT WHERE ACCOUNT_MVT_DATE <=#2/1/2015# ANS BRANCH_NO =12345 AND ACCOUNT =123456789 ORDER BY...

I'm actually the only one having it open with the first part of the code works. Just want to continue with it without opening it again :-) Greetings.

Hi all, Today I have a voodoo day where all is hard to fix or find answer. at the beginning I had only code to open one excel workbook and do something with it. Now because of new process, I have to do something more to it, so if the workbook is open, use it and don't open another. I can't...

Hi all, I started to work with this: If Lrs.RecordCount > 0 Then LGST = Lrs("SumOfCountOfORDERING_INST_NAME") End If and at the end I clean up the LGST and it goes fine. for me this kind of voodoo still. Greetings.

Hi all, I have some code to get the sum results from a table that I want to pass as a variable in the rest of the code. I have the trouble that when there is a 0 because the query can't sum null values. 'run query to get the results to sum up later DoCmd.SetWarnings False...

Hi, I did not manage to get it work, but I managed to get the query working to get the sum of the count. Maybe not an elegant solution, but it works :-)

hi all, I don't get it to work. Seems the initial query got messed up and does not make any sense now. I made one of the queries a make table query where I have my results now. so I get my result as below: HK AE 18 HK CN 1 HK TR 1 HK VC 1 I called the table: tbl_scnr2_1 Any idea how to...

Hi all, I have a query that will give me the results from how many countries come from a criteria. HK AE 18 HK CN 1 HK TR 1 HK VC 1 I try to get the sum from all inside a separate query that will give me simply: 21 I use the below query but I don't get it :-( SELECT COUNT(*)...