Search results

I've an application which extracts to Excel then opens a mailmerge template to print documents using that information. I had it working for both Word 2000 and Word 2007 specifying different ways of opening Word depending on the version. I used Shell to open the 2000 version Shell...

I have an Access front end to a SQL Server db one function of which is to provide an export to Excel using a query and the OutputTo method of DoCmd. This works perfectly in my development environment (WinXP, Access2003) but, when I implement it on my clients computers on the same corporate...

We have a SQL Server 2000 box which supports a number of SQL Server databases. To administer these databases we have been using both the local Enterprise Manager on the server (via Terminal Services) and PC-installed copies of Enterprise Manager accessing them the server as a remote server. The...

I've migrated an Access application to Access/SQL server using ODBC System DSNs and it's worked, however I now need to add a column to the main table. I've added the column to the data definition in the test copy of the database using the Enterprise manager and, if I open the table using the...

I have Access 2003 and the Developer Extensions which allow me to package solutions and distribute them with the toll-free run-time set. When I run my applications on the development PC with the "/runtime" switch the applications work fine but when they are installed on a PC without Access 2003...

I've been using recordsets in Access 97 and Access 2000 and now I have been trying to use them in Access 2003. If I use this code (which appears to me to be correct according to the online help in Access) then Access complains at runtime that ADODB.recordset is an undefined user-defined type...