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

    Password Code

    For a textbox, use PasswordChar property.
  2. SteveBausch

    Excel not printing Duplex?

    Which driver is residing on their system? Is that the correct driver?
  3. SteveBausch

    Is there a way to control MsgBox font?

    Questions like this are the reason that .Net will not support MsgBox. Forces people to think.
  4. SteveBausch

    opening a seperate window

    Create a UserForm, leave the name as "UserForm1" On that form, create a large TextBox, leave the name as "TextBox1" Change the following TextBox properties: EnterKeyBehavior to True. MultiLine to True. Add this code to userform: Option Explicit Private Sub...
  5. SteveBausch

    opening a seperate window

    I take that as a "no", since it would be extremely difficult.
  6. SteveBausch

    opening a seperate window

    Does the window have to be "always on top"?
  7. SteveBausch

    opening a seperate window

    The need to minimize Excel and still have a small (child) window present, and always on top (always on top, right?) might be doable. I run two monitors, so that situation never occurs. I just park Excel on one monitor, let it do what it wants to do, and proceed with another application located...
  8. SteveBausch

    Excel vs Access

    Are you currently serving the Excel? Meet the guy halfway, scrounge up some older system and dedicate it to Access. Actually, the skeptic should allow a short-term test to see if anyone can truly perceive the difference.
  9. SteveBausch

    How do I instantiate a Visual FoxPro object in Excel VBA code

    From Excel VBA, take a look at References, see what shows up. If you don't have the proper References, you won't have access to the object.
  10. SteveBausch

    Hyperlink closes my Workbook in Excel

    Try the workbook on another machine.
  11. SteveBausch

    Reset form ?

    Have all the field names obey a naming convention, perhaps the textboxes all start with "Text", all the listboxes start with "List", etc. For my example I use the first four characters of each name. If you don't want to clear the field, then don't name it according to your...
  12. SteveBausch

    Excel Data Markers

    http://www.lacher.com/toc.htm Take a look at that page, if you need more help, I will continue Googling. Steve
  13. SteveBausch

    opening a seperate window

    Yes I do. Provide more detail (which application?), any restrictions (is a userform with large textbox OK?), what has failed, etc. I will respond. Steve
  14. SteveBausch

    Error when trying to open an Excel file with macro

    More detail, please. Have you Googled the exact phrase? What comes back? What exactly is the code doing? It works on other machines, right? What are the differences between the problem machine and the good machines? What are the additional references, if any, the project requires?
  15. SteveBausch

    Restore Protect Sheet... menu command (MS Excel)

    If that's the only modification, reset the menu.
  16. SteveBausch

    Call a String Value from another Module - PLEASE HELP!!

    They are both in the same project, correct? If so, and the variable is module-level and declared Public, you shouldn't be having any trouble. Show the code, if you think you did all of the above.
  17. SteveBausch

    Check for Open File in Excel VBA Application

    You can do a For Each loop, test for a specific name. You can test Workbooks.Count for the desired value. Sub IsThisWorkbookOpen(LookingForThisWorkbook As String) Dim OfTheWorkbooks As Workbook Dim Hits As Integer For Each OfTheWorkbooks In Application.Workbooks If InStr(1...
  18. SteveBausch

    Prevent Excel 97 save as newer version

    I think you are out of luck, in reality. Please explain the exact situation, and why this is a problem. You can put code in Workbook_BeforeSave, checking Application.Version. You can prevent the save or allow the save. But saving to a specific Excel 97 version? Not exactly sure about that...
  19. SteveBausch

    Prevent Excel 97 save as newer version

    Intercept the save, save as you desire, set Cancel to True.
  20. SteveBausch

    Can't Install Office 2000 on Win XP Pro

    So, this is a fresh install, and you are having problems? Since this is XP, and XP wants to call home, do you have your internet connection available for the program? I had some issues, they went away when the cable modem was connected. So, if you have a modem in the system, or a network card...

Part and Inventory Search

Back
Top