Search results

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

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.

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

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

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)

Can controls in a form be made flexibly or auto-generated based on parameters set in another form? Supposed I have a continuous form with 10 textboxes, while at some other time I need to have 12 textboxes or 5 textboxes only. Total textboxes needed would be set from another form. The maximum...

Can we make records grouping in Record Source, e.g. every 25 records - just like page setting in ADODB recordset?

Can we set different colors on specific rows in a continuous form? Suppose the following data entry form (continuous) is to fill in spouse name, while name and marital status is already prepared in a different table. If the marital status is Married, then the spouse name textbox's background...