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!

Recent content by Hackster

  1. Hackster

    Checking Optional Parameter

    This worked. ThanksPrivate Sub SetTheFocus(Optional ByRef oTextBox As TextBox) If IsMissing(oTextBox) Then Exit Sub Else oTextBox.SetFocus End If End Sub
  2. Hackster

    Checking Optional Parameter

    In a sub I have an optional parameter declared As TextBox. How can I check to see if anything was passed to this parameter? I've tried IsEmpty, IsNull and others and nothing has worked. If a textbox name is passed, then I want to SetFocus to that textbox (which works when I do pass it a valid...
  3. Hackster

    Editing A DataGrid

    AllowUpDate is set to True, and I still can't edit the darn thing.
  4. Hackster

    Editing A DataGrid

    I did a forum search on DataGrid and found 80 posts. None of them had any replies, so I'm not real confident about this one, but what the heck. Is it possible to edit data displayed in a datagrid on the grid itself? I can click on a cell, display the text portion in a textbox, write the...
  5. Hackster

    Hightlight All Instances Of A Word In Richtextbox

    Well, I am overwhelmed with the responses to this, and yes, each and every example has been useful. Thanks to one and all.
  6. Hackster

    Hightlight All Instances Of A Word In Richtextbox

    I've managed to put together the code to find and hightlight a word in a richtextbox, but it will only do it once. I need to find, and highlight, all instances of the word, and I'm getting nowhere fast. What modifications do I need to make to this?Dim strWord As String Dim lPos As Long...
  7. Hackster

    Is ByRef Necessary

    Thank you both. That clarifies, at least in my mind, my question.
  8. Hackster

    Is ByRef Necessary

    Thank you for your response. It probably is a good habit to get into. However, my question remains: If you are going to pass a parameter byref, then you don't have to do anything but create the parameter, right? You do not explicitly need to type in ByRef, correct?
  9. Hackster

    Is ByRef Necessary

    Is it my understanding that parameters are, by default, passed ByRef. So, with that in mind, why do some people actually type in ByRef? Example:Private Sub Whatever(ByRef strString As String) 'is exactly the same as Private Sub Whatever(strString As String)Correct?
  10. Hackster

    On Local Error vs On Error

    What is the difference between using On Local Error Goto and On Error Goto?
  11. Hackster

    Run Program On Remote Console

    I can programmatically connect to a server, or another PC in my LAN, and run a program located on that machine. However, it will display on my console. Is it possible to programmatically execute a program on a remote machine and have the screens for that program appear on the remote console?
  12. Hackster

    ADO Data Control Delete Error

    When doing Adodc1.Recordset.Delete I get the following error: "Multiple-steps operations generated errors. Check each status value." What does that mean?
  13. Hackster

    Listview Scroll event.

    Try: Private Sub List1_Scroll() Text1.Visible = False End Sub
  14. Hackster

    Rename A Table

    Thanks bjd4jc. Works great!
  15. Hackster

    Rename A Table

    I need to rename a table in an Access database (this is an import database that gets shipped to us once a week, and for reasons too lenghty to go into, I have to rename one of the tables before I can process that data in it.) Here is what I have:Dim ADOCn As ADODB.Connection Dim ConnString As...
See more

Part and Inventory Search

Back
Top