Search results

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 =...

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, 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 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...

i have a table which has company codes. It is a text field but actually company codes are numbers with zeros in the beginning like 00020, 00021, 00153 etc. When I move these values to another table which also has the company codes and also a text type field, it removes the zeros in the beginning...

Hi, I have a table of employees. It has 5 fields which are name, fname, dob, dateofplace, numberofdays (holidays taken since beginning of the year.) Table has more than 50,000 records and most of them are dublicates. Dublicates are all the fields except the numberofdays. I would like to...

Hi, I imported a large data set into my access database and it was fine. However, after closing it i cannot open it again. it gives the following message Cannot open database. It may not be a database that your application recognizes or file might be corrupted. the size of the database is...

My Dsum function is not working but seems nothing wrong with the null data. DSum("[NumofRoom]", "RoomDetails", "[RoomId] = 'Main!Id' and [Pos] = 'D' and [Year] = 2000"))

Hi, I am very new to access and eed some help. I need to update one table from another and there is one to many relations. i have the following code which works but because the second table has 700,000 records, it is extremely slow. Is there any way to improve the code. Do While Not...

Hi, I am very new to access and eed some help. I need to update one table from another and there is one to many relations. i have the following code which works but because the second table has 700,000 records, it is extremely slow. Is there any way to improve the code. Do While Not...

Hi, I am very new to access and eed some help. I need to update one table from another and there is one to many relations. i have the following code which works but because the second table has 700,000 records, it is extremely slow. Is there any way to improve the code. Do While Not...

I have the following code which moves records from one table to another one based on a if condiction. However, my isnert statement does not work and when I run the code it is aksing for the value of the fields which is supposed to come from the do while selected record on the first table...

Hi, I am geeting "loop without do" error message for the code below which looks like right. please can you help Dim myDb As Database, MySet As Recordset, MySet1 As Recordset Set myDb = CurrentDb() Set MySet = myDb.OpenRecordset("Table1", dbOpenTable) Set MySet1 = myDb.OpenRecordset("Table2"...

Hi, I have two tables Table1 and Table 2 which have a common field called "CompanyId". In addition, table 1 has also a field called sector. I would like to deleted the records from Table2, if their corresponding sector in Table1 is Finance. How I can write a simple delete query? thanks, ozgur

Hi, I am new with queries and need some hlpe. I have tow tables. Companies and Salaries. The salaries table has the following fields. Salaries.CompanyId, Salaries.EmployeeId, Salaries.Position (can be manager, supervisor and officer) Salaries.Year, Salaries.Salary, Salaries.Bonus...