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 SkipVought 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: LPlates
  • Order by date
  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
  15. LPlates

    What is the best method to keep dates working

    You could use combo boxes so they select a day of the month, another for the month and finally the year so you eliminate user input
  16. LPlates

    What can be done in DLL's

    Open a new project, select active-x dll. Goto Project->Add Form and add a new form, your dll now has an interface. Yes you can use controls in your dll, anything you like. May I point you in the direction of a tutorial...
  17. LPlates

    How do I check if a DIRECTORY exists, and if it doesn't, create it?

    No you dont... Private Declare Function MakeSureDirectoryPathExists Lib "imagehlp.dll" (ByVal lpPath As String) As Long MakeSureDirectoryPathExists "c:\a\b\c\d\e\f\g\"
  18. LPlates

    Help with creating a User Moveable Control

    >Also, it draws a thin grey border around the frame (the background is white). Is there a way around that? Comment out these lines like so (No Grey Line)... Public Sub SetCtrlMobile(abc As Control) On Error Resume Next 'SetWindowLong abc.hwnd, GWL_STYLE, GetWindowLong(abc.hwnd, GWL_STYLE) Or...
  19. LPlates

    Help with creating a User Moveable Control

    No there's no mouseup event, if you dont move it far enough it moves back to the original position, for the grey border try playing around with or changing the WS_THICKFRAME constant

Part and Inventory Search

Back
Top