Recent content by ozdemirozgur

Hi, I would like to get the off_recno and 8 exactly the same but just the year information should be less. thanks, ozgur

Hi, Is it possible to use the seek method to find the values smaller. eg. With DIRS_FTSE_AIC_Raw .Index = "FindFinanceUnique" .Seek "=", APPO_Comb!Off_RecNo, 2000, 8 If .NoMatch Then Else thsi method finds the record equal to the 2000 but I...

Hi, i have two tables both of which has company codes and names and would like to match the records. However, one of the table used some abbreviations for the first name therefore cannot directly match. I need a code to match the company codes and then the first two letters of the name...

Hi, I have a table which has some sale data such as Table1!a, Table1!b, Table1!c etc. I would like to get the minimum of a, b, and c for the same record and also the multiplication - however some fields are empty and in case of having an empty field it should not be part of the...

Hi, i have the following procedure but do not know why it does not work. please can you help. Do While Not DupNoIs1DuplicatesToBeCleaned.EOF If (DupNoIs1DuplicatesToBeCleaned!Hems_Year = 2000) And DupNoIs1DuplicatesToBeCleaned!SHRHLDRID <> "" Then Coy_Id =...

Hi, as you see I am displaying the counter SAYI on the screen. It does not progress at all even I wait more than 1 hour atfer 10000ish data. The data is not garbage. It is a professional database and the data structure is very simple. Just two tables with a couple of fields. Any idea why it...

Hi, I attached the file, will be gald if I can get help. thanks. Ozgur

Hi, I have thge file which is 24 Mb, the forum here allows max 2 mb after zipping but does not accept zipx files. so, I am not sure how I can send the file/ thanks, Ozgur

Hi, there is no relation between the tables but a common field. the table has more than 150, 000 records and it stopps at different records at different times. What does stop mean? it means, the code is not progressing, keep waiting and waiting, nothing happens. I tried something different...

I have the following code which go through the first 5000 records and then stops and does not progress. please can you help /code/ Do While Not Rem_Pos_Summary04_2000.EOF Do While Not REM10_2000_Combined_Annualized.EOF If ((REM10_2000_Combined_Annualized!coy_id =...

Hi, it seems, SysCmd is used to show the progress and a bit complicated. I just need to dislay the employee number when it is progressed. Because i have a do while loop, then it will be a quick flowing of numbers on the screen. is there any easy way of doing it ? thanks

Hi, I have a Do While loop, and i want to show the line number of the current record. Something like this Do While not employees.eof msgbox employees.!inenumber employees.movenext loop however, in the code abiove, system stops and ask user to clisk the ok button. I rather prefer to show...

Hi, I have two table and I need to find the records from the secodn table.I have the Coy_Id field common but need to find the Role fiels which includes ch in the field. I have the following code but does not work. please can you help? /code Do While Not Main10_2000_Combined.EOF With...

Hi, I htink, it works but my transaction table has a couple of million recordss, it is taking too long. any idea how I can change the entire logic of the code?

Hi, I have two tables with 1-n relation. Each table has a field called Coy_Id which is a company code. I need to find the records from the second table with the same Coy_Id and another field called HLDR_DESC which is not empty. then I need to update the main table if there is a record on the...