Search results for query: *

Thanks Ben. I'm so appreciated your helps! Have a nice day! Jacky

By the way. Did any boys and gals know my question itself, read ans write other registry area? In VBA, we just can use SaveSetting(), GetSetting() to visit the HKEY_CURRENT_USER/Software/VB and VBA Program Settings/... And such as the RegOpenEx() functions is NOT available in VBA. So what can...

I reference the ODBC but I indeed cannot find those function in your program, such as SQLDataSources() and SQLAllocENV(). But, I resolve my problem by using .OpenConnection() statement. Because .OpenDatabase() change the engine automatically. It always believes that Access is a ISAM DB and must...

No, I just want read the local registry. In VBA, we just can use SaveSetting(), GetSetting() to visit the HKEY_CURRENT_USER/Software/VB and VBA Program Settings/... And such as the RegOpenEx() functions is NOT available. So what can I do?

Dear All: Did anybody know how to read the registry except "VB and VBA Program Settings". I want read ODBC user DSN information. My point is what kind of database customer using in the runtime. So I can write 2 DIFFERENT statements to link Access or SQL Server by DAO.

Dear All: Did anybody know how to read the registry except "VB and VBA Program Settings". I want read ODBC user DSN information. My point is what kind of database customer using in the runtime. So I can write 2 DIFFERENT statements to link Access or SQL Server by DAO.

Thanks. I can use AccessDB by DAO. But I must use 2 .OpenDatabase() statements to link Access or other ODBC driver. Did anyone know how to use one statement open different databases, like Access2000 and SQL Server2000? Thanks again.

We know that we can use ListView control in VC. It have a label head and can be sorted. But in VBA2000, we just have a ListBox control. It seems too simply. I cannot add anything to the Header. Did any boys or gals know how to stretch one column in runtime, like ListView in VC product. And...

I connect database by DAO. It works well in SQL Server, local or remote. But, when I change the MSN to a local access database. There is a system error : "You cannot use ODBC to import from,export to, or link an external Microsoft Jet or ISAM database table to your data" Did...