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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by LPlates

  1. LPlates

    Newbie question, Where is best to store a couple of text strings?

    GetSetting(txtAppName, txtSection, txtKey, "No Setting Found") Where the final parameter is a default value that is set if no setting is found
  2. LPlates

    How Do I Work with Variable Content Documents?

    You can store the text in the database, as far as the graphics go, you can store the path to the graphic's file(s) in the database and load the picture(s) from the path(s) Answer your question?
  3. LPlates

    How to Disable Internet Connection Firewall on Windows XP

    Ok, so Im presuming there will be a registry key that stores the value of the checkbox (mentioned above). Search the registry for the key and change it through VB
  4. LPlates

    How to Disable Internet Connection Firewall on Windows XP

    Go to Start Bar Click [Start] then [Settings] then Click Mouse on [Network Conection] and a Window will open Now you should be able to see an ICON under Dial-up, this is the settings for your ISP right click on the ICON and a menu will appears Click on [Properties] and a widow will open at...
  5. LPlates

    SStab Caption from previostab

    Private Sub SSTab1_MouseDown(Button As Integer, _ Shift As Integer, _ x As Single, _ y As Single) Debug.Print "Current Tab " & SSTab1.Tab End Sub Private Sub SSTab1_MouseUp(Button As Integer, _...
  6. LPlates

    Excel opens worksheets HIDDEN

    I was refering to the windowstate and the 3 lines of code that follow the line referencing the windowstate, but was not very clear
  7. LPlates

    Excel opens worksheets HIDDEN

    Actually leave it as it is and the following 3 lines of code will solve your issue (without the error of course)
  8. LPlates

    Excel opens worksheets HIDDEN

    No I am, lol I left out two declares... Option Explicit Dim Excel As Object Dim ExcelSheet As Object try setting the windowstate to 0
  9. LPlates

    Get my function in module to spit out values - HOW?

    Here's a pointless example... Option Explicit Private Sub Command1_Click() Dim i As Integer Dim arr() As String arr = SplitLetters("a|b|c|d|e|f|g", "|") For i = 0 To UBound(arr) Me.Print arr(i) Next i End Sub Public Function SplitLetters(strArr As String, Delim...
  10. LPlates

    Excel opens worksheets HIDDEN

    Try this.. Private Sub Command1_Click() Dim Name As String Set Excel = CreateObject("Excel.Application") Excel.Visible = True Excel.WindowState = 2 Excel.Workbooks.Open "Drive\Path\Filename.xls" Name = Excel.ActiveWorkbook.Sheets(1).Name Set ExcelSheet =...
  11. LPlates

    What can be done in DLL's

    Here you go, nice and simple and by a quality programmer too... http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=46245&lngWId=1
  12. LPlates

    What can be done in DLL's

    The example is not the one I had in mind, anyway check out the tutorial and I'll see if I can find a good example
  13. LPlates

    What can be done in DLL's

    You will see, and as already explained above the dll is accessed by referencing procedures in a class file within the dll, have a look at the project and understand how it works and yes, you could add a procedure that simply displays a form with the code... frmWhatEver.show (After you add...
  14. LPlates

    What is the best method to keep dates working

    That applies for any kind of input be it date or whatever but the DTPicker control would work nicely too as already suggested

Part and Inventory Search

Back
Top