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: phzero
  • Content: Threads
  • Order by date
  1. phzero

    Sending A Fax Progammatically

    Hi All, Does anyone know how to send a fax programmatically with VB using either CDO, MAPI or TAPI. However, I do not want to print to a fax driver. Any help will be appreciated. Thanks to all who responds.
  2. phzero

    DataEnv And Reporting Issue

    Hi All, I've always been using Crystal to do this, but now I am trying to use VB's Reporting and the DataEnv. I have no problem using these tools, but when I deployed it and tried to install it on another machine, I received errors that it could not register the file called MSDBRPT.DLL. I then...
  3. phzero

    BC45 and Windows 2000

    Hi All, I have BC45 and have upgraded my PC to Win2000, upon which BC45 ceased to work. I upgraded to BC5.02 but now none of my OWL intensive programs want to compile. Is there a patch to make BC45 work on Win2000 or is there a way to have BC502 compile my BC45 source code. Any responses will...
  4. phzero

    Data Report Query

    Hi All, Does anyone know how I can pass a SQL statement as a parameter into the Data Report Designer from my source code. I have seen the Parameters Tab on the Properties Dialog Box but it is disabled
  5. phzero

    Where to find compiler and linker

    Hi All, I have recently downloaded CobEdit and now I'm lokking for a compiler and linker. Does anyone know where I can find an Acucobol compiler and linker since it so nicely integrates with CobEdit. Any help will be appreciated. Thanks a stack.
  6. phzero

    DTS - A Complex Problem

    Hi All, I am importing data from a text file (flatfile) using the text driver which is very easy. However, is it possible to import only part of a text file, like say the first 10000 lines or better, can a criteria be set. Any help in this regard will be appreciated. Thanks a stack.
  7. phzero

    The apostrophe saga in VB and SQL

    Hi all, I have these VB statements: MyProd = "Bread's Butter" rs.Find "ProductName = '" & MyProd & "'" Here's the issue. As you can see, MyProd contains an apostrophe, which wreaks havoc in the next statement. I could strip the apostrophe but then it won't find...
  8. phzero

    Getting a special character

    Hi All, I'm trying to get the position of the tab character in a string. How do you specify the TAB character in a statement like this: TabPos = InStr(SearchString, "\t"). I know that this is the syntax for the tab character in C++, but how is it done in VB. Any help will be...
  9. phzero

    BLOBs, VB and SQL Server

    Hi All, Does anyone know how to get an image column from a SQL Server database into an adodb recordset using vb code. Based on the code's logic, I will try to figure out how to write it to the database. Can't have everything on a silver platter, now can you. Many thanks for all your responses...
  10. phzero

    What's up with ActiveXObject

    Hi all, I've created an ActiveXObject in my asp page. It works on my machine when I locally test the page, but not on any other machine. The error I get is the following: "Automation Error - Unable to create ActiveX Object". Can anybody tell me where to find the distributable for this...
  11. phzero

    new ActiveXObject in ASP

    Hi all, I've created an ActiveXObject in my asp page. It works on my machine when I locally test the page, but not on any other machine. The error I get is the following: "Automation Error - Unable to create ActiveX Object". Can anybody tell me where to find the distributable for this...
  12. phzero

    Remote Scripting Problem

    Hi All, can anybody tell me what it is I'm doing wrong. I've tried everything (to my knowledge) and even this implest example does not work. Can anybody spot the not: <HTML> <HEAD> <TITLE>SIMPLE CLIENT</TITLE> </HEAD> <BODY> <script language=&quot;JavaScript&quot...
  13. phzero

    Dynamic Update of DropDown

    Hi All, I have 2 dropdowns, the second one's contents depend on the selection made in the first one. I can populate them but am unable to dynamically update the second based on the selection in the first. I get my variables from a SQL Server database. Thanks in advance for any replies. Here is...
  14. phzero

    Stored Proc Query

    Hi All, I've written a stored proc that accepts an argument. When I reference the argument in the WHERE section it works. Now, I've tried to write another proc that accepts the name of the table to query, but it does not want to work. How can I pass a string variable to a stored proc and use...
  15. phzero

    Help With Simple ASP Query

    Hi all, below please find my source code for my ASP page. What I'm trying to do is to populate the dropdown box called &quot;ProbCat&quot; in the form. All the code works. If I comment out the document... line and put it in a MsgBox, it displays the names from the database. Could anybody please...
  16. phzero

    Refresh Query

    Hi All, I'm using VBScript and SQL Server 7.0. I have a Submit button on my form in my ASP page, which, once clicked, will update my SQL Database on my Web Server with some information on the form. However, after the action has been performed and I click the Refresh button on my Browser, it...
  17. phzero

    T-SQL Error in Enterprise Manager

    Hi All, I'm using SQL Server 7.0 I'm running the following simple query to get results. I have in the top the SQL View and at the bottom the Results Set. When I try editing any of the columns in the grid, I get the following error: &quot;Key column information is insufficient or incorrect. Too...
  18. phzero

    An unusual T-SQL query

    Hi all, I'm using SQL Server 7.0. I have two identical entries in my SQL table. Does anyone out there have an sql query, or know of a way to delete one of two identical entries. To display only one of the two is OK when using the DISTINCT keyword, but I'd like to remove the second one. Any...
  19. phzero

    Using DTS to import mulitple files simultaneously

    Hi all, I know how to use the DTS service in SQL Server 7.0 However, I'm needing to import quite a few files (flat) into my SQL table. Is there a way to select mulitple files, or better still, all the files in a particular directory and import them all at once using DTS. Any replies will be...
  20. phzero

    T-SQL Error in Enterprise Manager

    Hi all, I'm trying to import a flat file using bulk insert into one of my tables but the following error keeps coming up: &quot;Bulk Insert Data Conversion Error (truncation) for row 1, column 2&quot;. This might seem straight-forward, but, in the file, the specified field is 1 char long while...

Part and Inventory Search

Back
Top