Recent content by agust

Hi Wayne, Thanks for the reply. I am testing on a standalone computer and using SQL command for ADO recordset. I used nested LEFT JOIN before and now I reduce it to a single LEFT JOIN. It is faster now - but not as I expect yet. It seems that this join makes the query slow. In fact some of the...

I am developing a database and testing it with dummy data. With 50,000 records, the query process using SQL command is just OK. But if I double the total records, the query process takes longer time. The query is to make recapitulation using SUM of SQL command based on certain criteria. Any idea...

Thanks Wayne. But then I need to use API to read the registry?

I need to search whether a specific application is installed under Windows XP, e.g. whether Excel is installed or not. How do I do this? Is there a quick way to do it? I was trying a FileSearch method, but sometimes it does not work on other version of Access. If I search on C:\Program...

Supposed I have the following tables: TableMonthlyReport consists of the following fields: *IDStore *Year *Month *IDCatalog *IDItem Quantity TableGoods: *IDCatalog *IDItem ItemName IDSupplier The asterisks indicates the index keys. While TableMonthlyReport has 2 links of relationship with the...

Is it possible (VBA programmatically) to set color automatically on each textbox in a continuous form based on field value? It means the fields / textboxes on the same column will have different colors based on their different values on different rows/records.

Actually I sort using SQL and I just want to use 'ORDER BY OrderItem' - the problem is the order for each month (or period) might be different time to time. That's whay I use a "help table" to manage these different order lists.

Supposed I have the following tables: TableMonthlyReport consists of the following fields: *IDStore *Year *Month *IDCatalog *IDItem Quantity TableGoods: *IDCatalog *IDItem ItemName IDSupplier The asterisks indicates the index keys. While TableMonthlyReport has 2 links of relationship with the...

Actually I don't use ODBC. I set Record Source of every forms to the linked tables. So, if the network connection is disconnected for a few seconds, then all fields will show Errors indication. Even if the connection is re-connected, it seems that the database can not re-establish the connection...

I have a backend database in a shared folder in one computer in a LAN and some frontend files in several computers. If the LAN connection is lost (e.g. caused by unplugged cables), then the database will lose the connection as well and there is a message of disk or network error. How should I...

Thanks Rural Guy! The codes from Lebans works great - just like what I expect.

How do I make running numbers in a continuous form and independent from record ID, each time starting from 1, 2, 3 and so on? :confused:

With VBA, I want to open database with password. How should I do that? I tried the following lines and the response is "Not a valid password" Dim theDb As Database DbFile = CurrentProject.Path & "\MyDatabase.mdb" Set theDb = OpenDatabase(DbFile)

Hi Allan! Thanks for the hints! Actually I have not tried it yet, but I already checked the CreateForm and CreateControl function. So I am convinced that it is possible to create dynamic form and controls on the fly. I should have digged deeper in the Access documentation, because it is there!

I am developing a database with monthly records of aggregated data of diagnosed cases handled in health center by age group (not individual). So the table defined by ID of Health Center, month, year, ID of diagnose, ID of age group and number of cases found. Age group is developed with ID to...