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: *

  1. CGehlhausen

    Trouble writing quotes " to file with WRITELINE

    By the way, I did try using double quotes "" and also tried substituting parenthesis () and brackets [] in place of the ones around the text, but neither one worked. I even tried putting an ampersand & in front of the middle quotes, but that didn't work either. There's got to be a little VBA...
  2. CGehlhausen

    Trouble writing quotes " to file with WRITELINE

    I seem to have stumbled upon a problem creating an html file programatically with Excel VBA. I'm taking information filled out in Excel sheets and using it to create an html text file, mainly using WRITE and WRITELINE. Unfortunately the context requires using quotes around the text being...
  3. CGehlhausen

    Disable Zoom? Or Escape current field without F2?

    Thank You! Thank You! Thank You! Much obliged. All's well that Ends!
  4. CGehlhausen

    Disable Zoom? Or Escape current field without F2?

    This script runs OnChange, so that as the user types, the filter is run - saving them from hitting "Enter". To do this I need to get back into the field and place the cursor at the end so they can keep typing. I tried ESC, Right Arrow, everything I could think of, then happened upon F2. Works...
  5. CGehlhausen

    Disable Zoom? Or Escape current field without F2?

    I have a series of search fields across the top of a form, with detail rows below them - allowing the user to search a large database by several fields at once. Unfortunately when they type * for a wildcard, the sendkeys F2 (escape) is read as a SHIFT +F2 which brings up the zoom window. Does...
  6. CGehlhausen

    Focus / Foreground

    If they get it solved, please post it here. I need to do something along the same lines.
  7. CGehlhausen

    Prevent form taking focus

    I have the opposite problem - I can't get my form to take focus over the other windows. I have tried: form.ZOrder 0 and form.SetFocus Both are supposed to work, but neither did. I think the other program that I'm dealing with might be taking over. If either of these commands are in your...
  8. CGehlhausen

    ANYONE? HOW DO I STOP AN APP?

    I'm back on this project, see what we can do today. Thanks for all the input. When an operator prints from their database, it creates a file, either in a manual or auto folder. My main program then opens it and sends it to this proprietary Linx 6800 printer. If they choose Manual, there is...
  9. CGehlhausen

    ANYONE? HOW DO I STOP AN APP?

    How do I stop my own executable? I have a small app running constantly - then when something happens, it opens another app using shell. I do something, then I need to close the second app. I have the Do Loop using a While x and y, so it exits the loop, but the app still runs. I've tried...
  10. CGehlhausen

    Stop my own EXE?

    How do I stop my own executable? I have a small app running constantly - then when something happens, it opens another app using shell. I do something, then I need to close the app. I have the Do Loop using a While x and y, so it exits the loop, but the app is still running. I've tried...
  11. CGehlhausen

    Convert Date "24-Jan-04" to "1/24/2004"

    Thanks, That does the trick!
  12. CGehlhausen

    Convert Date "24-Jan-04" to "1/24/2004"

    I've researched the Date Convert function, so I know that the output that I need is 101 for "1/24/2004". But what do I use to pick an input in the form of "24-Jan-04"? This is SQL 7.0, so that may be the problem, but it seems like it should be possible. Here's what I found: Without With...
  13. CGehlhausen

    Restore SQL "data" folder for testing

    I was given a backup of a database - actually I was given the "data" folder - is that the same as a backup?. I need to know how to take that backup and load it up into SQL Server 7, so that I can write import code for this DB. I don't need the database for any other purpose than testing. I...
  14. CGehlhausen

    Restore SQL "data" folder for testing

    I was given a backup of a database - actually I was given the "data" folder - is that the same as a backup?. I need to know how to take that backup and load it up into SQL Server 7, so that I can write import code for this DB. I don't need the database for any other purpose than testing. I...

Part and Inventory Search

Back
Top