Search results for query: *

I have been given a dll by a trusted business partner and am trying to use it in a vb 2010 application I am writing. When I run the app in the IDE debug mode I get the error: “Unable to find an entry point named 'OpenDBConnection' in DLL 'c:\ims\mtcomponents\mtexecutedbchanges.dll'" I get the...

My program calls a form with frmAddLocation.ShowDialog() Form has a couple of combo boxes and a some text boxes. On the leave event of the zipcode combo box I check the user entered zipcode against a master table and if it is not found, allow the user to add the zip after prompting for the...

I am programming in Visual Basic 2010 and a Sybase database, using ADO. I have received errors from the database "max prepared statements count exceeded". I discovered how to raise the max count allowed, but my concern is that I am possibly leaving something "out there" that I should be closing...

My Visual Basic 2010 application needs to send a text message to three phones under certain conditions. Written and tested on a Win7 machine it works fine. After installing on the production machine, a Win Server 2003, the following error occurs: "5 Mailbox unavailable. The server response was...

I am working in VB2010 and have spent the morning searching for this and have had no luck. I need to loop through HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services and check the names of the subkeys for a particular pattern, then when the subkey(s) I'm looking for are located, read some of the...

I want to add comboboxes to a form based on the number of records in a db table. Each combo box is to be populated with the same choices. I found code for adding the comboboxes, but have been unable to determine how to add items to them. I am adding the comboboxes with the code below: Private...

Using VB6 SP6 This was working fine until this morning. If I step through it in the IDE, it works, but if I just run it in the IDE or run the .exe it closes without displaying the report. When running the exe on a customer's server it closes. No errors are displayed in any case. The only thing...

I currently use CR9 to build reports that users access through an application that we resell. We have shifted to a new browser based product and I need for users to be able to run their reports via a browser. What CR product do I need? I will have to build the GUI for the users to select the...

My code has a form that I show using "frmConversionStatus.Show vbModeless" It has a progress bar, a label and a listbox. At the bottom of each loop in a module, I update the progress bar value and the label caption. At various points during execution, the window will stop refreshing. When...

I am using VB6 ADO to add a record to a MSSQL 2000 table that has an Identity field. Once the record is added I need to know the value of that Identity to add a record to another table. This is a multi-user db and I have found instances where the time stamp is the same on two records. I have...

I am using Crystal 9 on a MSSQL 2000 db. I have written a stored procedure that uses @ to request parameter from report. Now I need to add a new parameter to the stored procedure. So far the only way I have been able to get the report to update with the new parameter is to de-select the store...

I have a report that must conform to a pre-printed form. The total of one field must print at the bottom of the page and I have accomplished that with help from faq 149-1295. What I need now is to print that same page total at the top of the page within the group header. Thus far, no luck.

I have a VB6 app that allows user to select, view and print Crystal Reports developed in 8.5. My app worked fine until I put together a report with a subreport. I used the code below which I found in Crystal's knowledgebase, but when I step through the lines, I find that the .DataFiles are...

I'm using ADO to access a Pervasive 2000i database. I have this database installed at work on a Win98 machine and the same database at home on a WinXP Home machine. Using the exact same code, I get an Invalid Bookmark error, and can find no help on Pervasive's website...

I am accessing a SQL2000i database using VB6 code with an ADO control. I can get my recordset using 2 methods, seek on an index, or opening the recordset with a SQL statement. All other things being equal, which is the fastest method?

I am working in VB6 on a SQL2000i database. The date field is indexed. I know how to get a recordset of all records with a certain date in the date field. Can I return a recordset based on a date range?

I am trying to use seek on a Btrieve table with a two column index. The code I am using follows: (PPMDSN is a string containing the DSN name, Patient is the table name. key0 is the name of the Btrieve index and it has two columns.) Set cnnPPM = New ADODB.Connection strcnnPPM =...

Is there a way to save the toolbox from project to project after adding a component? There are several components that are not in the default toolbox but I use them frequently.

I am using the wizard to create a form letter and it looks pretty good except that I do not get a page break between records. What am I missing?

I am using the following code to print a string on the center of a page. However, it comes out somewhat off center to the right. (I have encountered other problems when using the textwidth property) The code is as follows: With Printer .Font = "Arial&quot...