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!

  • Congratulations TouchToneTommy 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: *

  1. phzero

    Sending A Fax Progammatically

    I need to know whether the line was busy and whether the fax was successful or not. Can a fax driver provide this kind of flexibility and if so, which do you use or recommend, if any.
  2. 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.
  3. 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...
  4. phzero

    BC45 and Windows 2000

    Hi 2ffat Thanks for the feedback. It is much appreciated.
  5. 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...
  6. phzero

    Data Report Query

    Hi Johnwm, After browsing the MSDN site extensively, I have found my answer. Actually, instead of putting "input1" in the query, I replaced it with a question mark "?" upon which param1 showed up on my Parameters Tab. Thanks for all the help though, I really do appreciate...
  7. phzero

    Data Report Query

    johnwm, Thanks for the feedback. Could you tell me, why do you use "input1" in the SQL statement. Is it a reserved word in this instance?
  8. phzero

    Deleting record using number in textbox

    Colin, Drop the single quotes from the query. This leads me to believe that the column EntryID is of type numeric. Just so you know, putting a search criteria in single quotes means that you're querying a value of type string in the database. Do this and let me know of the results.
  9. phzero

    Deleting record using number in textbox

    Colin, Your code is defintely incorrect. For starters, I assume that for each textbox you have a corresponding command button with the same index, since that's what your code is saying, since the Index in your code actually refers to the Index of the command button and not the Index of the...
  10. phzero

    Data Report Query

    Hi johnwm, Thank you so much for the reply, but it does not work for me. I am using a DataEnv. My command is called cmdMembers with this SQL statement: select * from members where (memid = input1), but when I go to the Parameters Tab, input1 does not show up there. Am I missing something...
  11. 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
  12. 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.
  13. phzero

    Create DSN as installation?

    Add the reference Microsoft Remote Data Object 2.0 to your project and then write code like this: strAttribs = "Description=aaBopTemp" _ & Chr$(13) & "User ID=dba" _ & Chr$(13) & "Password=sql" _ & Chr$(13) &...
  14. 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.
  15. phzero

    The apostrophe saga in VB and SQL

    CCLINT, I see your point. I guess the best thing would be to monitor the specified textbox for consecutive single quotes and programmatically remove the second one. I cannot think of a word in English where this situation occurs. Can you? Thanks anyway for the information.
  16. phzero

    The apostrophe saga in VB and SQL

    In any event, the user is selecting this straight from a readonly listbox. If the string has to be input by the user, then you could always check and validate the value of the texbox at runtime using the Change event. I really don't see the harm in doing this. But thanks anyway for the warning...
  17. phzero

    The apostrophe saga in VB and SQL

    Hi All, I could not see the text so nicely on the blue background of the site. I thought it was a double-quote. However MarkSweetland, I need to thank you all for shedding light in my hour of darkness. IT WORKED!!! IT WORKED!!! IT WORKED!!! Have a great day. I know I will. Here's a star for...
  18. phzero

    The apostrophe saga in VB and SQL

    Hi CCLINT / strongm, Maybe I should elaborate on the story. I need not be the one to put the data into the database (SQL Server 7.0). I have tried your method but it won't find the entry since the column in the database has the apostrophes in place. Here is my scenario: I read the ProductName...
  19. phzero

    Getting a special character

    Hi CCLINT, It worked. Thanks very much for the code you gave me. Please accept the Star that I have given you. Have a good day.
  20. 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...

Part and Inventory Search

Back
Top