Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sjulian
  • Content: Threads
  • Order by date
  1. sjulian

    dll error

    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...
  2. sjulian

    Completion of Leave event sub closes form

    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...
  3. sjulian

    max prepared statements error

    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...
  4. sjulian

    Problem sending text message through email

    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...
  5. sjulian

    Loop through registry subkey

    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...
  6. sjulian

    Adding items to comboboxes added at runtime

    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...
  7. sjulian

    Program closes, no error

    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...
  8. sjulian

    Browser Based Reports & Crystal

    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...
  9. sjulian

    Refreshing window

    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...
  10. sjulian

    Return Identity Col value thru code

    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...
  11. sjulian

    Crystal 9 Paramater & Stored Procedure

    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...
  12. sjulian

    Page Total in Group Header

    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.
  13. sjulian

    Using VB6 to change DB location of subreport

    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...
  14. sjulian

    Invalid Bookmark

    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...
  15. sjulian

    Which is faster?

    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?
  16. sjulian

    Using Seek to find a range

    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?
  17. sjulian

    ADO, Btrieve, and Indices

    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 =...
  18. sjulian

    Saving toolbox

    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.
  19. sjulian

    Creating a Form Letter

    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?
  20. sjulian

    Centering any font on page

    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...

Part and Inventory Search

Back
Top