Recent content by seosamh

I am using VB 6, SQL 7 and Crystal 5 on W2k. Developed a stored procedure and built report accordingly, however, when I try to pass parameters to report from the VB 6 application the report relies on the default values I used when I developed the report and ignores the parameters sent over. I...

I am running an application which imports data from an excel spreadsheet. This is not a problem with W95 but with W2k I get this error. Some of the MS help indicates that various dlls need to be renamed and Office reinstalled but this hasn't helped. Is this a problem with mdac/jet. One thing...

Hi I need to temporarily disable and then reenable some triggers. This is not a problem when done through the MSSQL 7 query analyzer. However, when I attempt to disable these through an application written in VB6 I am presented with run-time error '-2147217900 (80040e14)'... Only the owner...

Hi I need to temporarily disable and then reenable some triggers. This is not a problem when done through the MSSQL 7 query analyzer. However, when I attempt to disable these through an application written in VB6 I am presented with run-time error '-2147217900 (80040e14)'... Only the owner...

Hello! I am trying to load a project but get this error. If I continue I am unable to use the reports functionality and cannot create an exe. What is causing this error and what is the solution. As far as I can ascertain, the problem occurs when the main form is loaded. In the error log I...

I am running two stored procedures through a VB application (the first takes 2.30 minutes, the second about 8 minutes when run in SQL server 7). When I run the first through the application the memory usage shoots up to 250 mb and when completed (about 8 minutes later) the memory usage does not...

I am trying to run an application where I import data from an excel spreadsheet. While this works fine in the uncompiled version, when I make an exe I am given the above error and told that the application can't find the worksheet. The offending excel worksheet is called 'HiddenResults', and...

I have done a VB 5 routine which creates a letter in Word. However, while creating the letter and filling the various bookmarks I have placed on the document is no problem, when I try to run a batch of these letters (I run a Word macro to make whatever number of letters) each book mark on each...

I need to create a batch of word documents, taking the same document and filling the bookmarks with different information a few hundred times. Does anybody know how I can get VB 5 to do this as a single document? Thanks Seosamh

I am using vb5(sp3) with sql6.5 and excel 2000 (as well as access 2000, etc). I have created an excel spreadsheet via vb and manually entered data onto the spreadsheet (this is the idea) but when I try to read from the updated spreadsheet I get this error: "Couldn't Find Installable ISAM...

I am getting an "Error 429 (active X component can't create object or return reference to this object)" I know this is a licensing issue but I can't find the correct download on the microsoft site to overcome the problem. Thanks Seosamh

I am trying to run some VB5 code (sqlserver 6.5), however I am unable to connect to the database through the code, getting 'ActiveX component can't create object/return reference' error. I am using the following: Option Explicit Const ccCDataObjects = "CDataObjects.CLS" Private...

The application is in vb6, I am trying to work on the code, not simply install the application for a customer, perhaps I was not clear in my original question. Registering/unregistering the ocx has no effect. I am not sure if the problem relates to my using of source safe.

I am trying to install an application however, I get an error telling me that comct232.ocx could not be loaded. I went into components etc but was told that the application was read only, I checked it out the application and then checked the comct232 box and checked it back it - that didn't...

Using VB 5, SQL server 6.5, windows 95, trying to load form in application (compiled exe), while this works when using exe under Windows 98, and when simply running it in a uncompiled form, with Windows 95 I get an error no 50003, error description 'unexpected error', and am told that key...