Search results for query: *

I have a VB6 application that calls Excel to read and write data. It worked absolutely fine on Windows 2000 machine. Now I got Windows XP and every time VB tries to call Excel I get the message "Error -2147417851; Description: Automation error. The server threw an exception." I tried everything...

I have a VB6 application that calls Excel to read and write data. It worked absolutely fine on Windows 2000 machine. Now I got Windows XP and every time VB tries to call Excel I get the message "Error -2147417851; Description: Automation error. The server threw an exception." I tried everything...

Does somebody know if there is any way except CE Query Builder to pull information out of CE database? VB code may be? We need to store information about all our CE reports in another database so we could read it and create reports out of it. We have CE 10.

I get this message when coping or moving file. I tried different kind of files and different directories. Still the same message. Can somebody help? Here is the code: *********************** Dim fso As New FileSystemObject, file1, file2, fldr As Folder Set file1 =...

I need to add and delete data in oracle table from VB app. Here is my code: ************************************* Dim cnn As ADODB.Connection Dim rsIhdaDoc1 As ADODB.Recordset Set cnn = New ADODB.Connection cnn = "Provider=MSDAORA;Password=password;User ID=userid;Data Source=test;Persist...

I have 2 Oracle 9i databases. One is test & one is production. I'd like to write a script that will let me to update production table with data from test table. Not all fields have to be updated. Is it possible in one script?

I need to export crystal report to fixed length format. None of the suggested formats in Crystal exporting is doing it. Does anybody have an idea?

Here is the problem I am having. We have a SQL database on the server. Through VB app I connect to the server (OLE DB) and can create new users for the server (and users database) by running sp_addlogin. It all happens programaticaly in VB. Now we copied the data to another server. Create a...

Every time I close an VB development environment I get the message "The instruction at 0x004581f1 referenced memory at 0x00000000. The memory could not be read. Clik OK to terminate the program. Click Cancel to debug the program." I created a test project with just a form and one...

Does somebody know how to make Datetime Picker control to display nothing instead of Current date as a default value?

Can somebody tell me why if I specify a server name in Data Environment property for SQL server I get a message "Connection failed...." If I specify IP address I get the connection. What should I look at to use server name?

I am trying to connect to remote SQL server from VB (developer environment) using DataEnvironment designer and OLE DB for SQL provider. For some reason I get a message "Connection Failed.SQLState:"01000"SQL Server Error: 1326 [DBNMPNTW]ConnectionOpen (CreateFile()),Connection...

I am trying to connect to remote SQL server from VB (developer environment) using DataEnvironment designer and OLE DB for SQL provider. For some reason I get a message "Connection Failed.SQLState:"01000"SQL Server Error: 1326 [DBNMPNTW]ConnectionOpen (CreateFile()),Connection...

I have a VB6 project created on Windows98 machine and worked just fine. Using VB Package and Deployment Wizard I created an installation program and strated testing it on Win2K. I installed it on Win2K with no problem,but when running the application got the following error...

The code compiles just fine on Windows95 and 98 machines, but Windows 2000 gives me this message. This is where it happens: Set BudgetDset = gAssetdb.OpenRecordset(sqlstmt, dbOpenDynaset) ... frmMonthly!grid3.Refresh BudgetDset.MoveLast ReDim Stmtlinexref(BudgetDset.RecordCount *...

I can't solve this problem for a few days now. I packaged my application and test it installing on a few different machines. Only one Windows 95 machine gives me the error message" Object variable or with block variable is not set" when running application. There was no error during...

I packaged my application on Windows 98 machine. Now try to install it on diferent machines and one of the Windows95 machine gives me this message. I checked all ocx and dll files. They all are installed in c:\windows\system directory. What else should I check? Why is it happening on only one...

When installing VB application (VB6) in Windows 95 I get the following message: "An error occured trying to update the Windows registration database." on a few dll files, dao360.dll for example. I continue installation and test application after it and so far didn't find a problem...

I have VBE application and need to look at some data at Access database. I tried to use ADO, but didn't succeed. The text box control doesn't even have a datasource property in VBA. Does anybody have any ideas? I need to check the value of one of the field in Access and depending on its value my...

I work on VBA Excell application. I don't get this error message on my Windows 95 machine, but I do get it on Windows 98 machine. The debug points to the simple VBA code with Left() function highlited: If Not Left(MyControl.Name, 3) = "txt" . If I comment this line, I get this...