Search results

Hi my code is below. Do While Not a.EOF Coy_Id = a!Coy_Id DoCmd.SetWarnings False If (a!OO_DUBNo = 1) Then If (a!Key > 1) Then DoCmd.RunSQL "INSERT INTO b value (Coy_Id)" End If

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 o not know why but it did not clean all of them. Because the size of data is huge, I did not manage to find why it did not work and when it is not working. any idea? thanks, ozgur

Hi, I have a the lsit of fields to find the dublicates such as name, fname, dob, dateofplace. I would like have another field (age) in addition to the 4 fields above again to find the dublicates. and it is a field with type double and format 0.00000. thanks, ozgur

Hi, thansk a lot. It is still running, I do not know how long it might take. meanwhile, if I want to add another field -which is a field with typoe double and format 0.000000. Please ca nyou tell me how i should add a new line ? thanks, ozgur

Hi, I understood some parts of the code but some of them are difficult for me -as a beginner. I have attached the file and will be glad if you can have a look. I am getting a different error now. thanks ozgut

Hi, thanks for your reply, but I got a type mismatch error on the line Set rs2 = CurrentDb.OpenRecordset("SELECT * FROM Employees WHERE Name = " & Chr(34) & .Fields thanks, ozgur

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 Bob, it does not allow me to import data from it. DO you have any idea to get at least 1 table from the database then it can be less than 2 GB

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 really like this forum. It is becoming real fun but still not helping. Hopefully I am not a doctor and not a fisher man. I need only one fish and will never fish again so do not need to learn the best methods of finishing. Please can someone help? thanks, ozgur

Hi all, Thanks for your email, I do understand why I should not store the total in the main table. It is a data which has the salary details of companies back to 2003-2008 which will never change. I am not a professional programmer but just doing my masters degree. Some of the salary data...

Hi Paul, thanks, but I do not need a query on Access. I need an update routine which will update my master table after getting the calculations. thanks, ozgur

Hi, it is not the same information, I need to have the total of salaries for each company. I need a update statement which will read the company master table then go to the salaries table, find the salaries for each company and then get total by year. thanks

Hi both, yes, I am trying to get the totals from the second table. I do not have how to write an update statement here/. Basically table one ahs Company Id, and Table 2 has Company Id, Year and Salary. I will be glad if you can write me a short update statement? thanks, ozgur

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

thanks, I have to use recordsets because there will be some other code if the date is not year end. I will also need to chose the other years. Any idea why myu code is not working? any suggestions?