Search results for query: *

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

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

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

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

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

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

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

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?

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?

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

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?

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

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

Thanks bjd4jc. Works great!

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

Thank you Dr. Java!!

Thanks Swi!! Another related question. How can I tell whether a particular field within a table exists?

I have written the necessary ALTER TABLE SQL for creating a DB table, but I need to ensure that the table doesn't already exist first. I know that I can just let the routine error out, trap the error, and that way I know it does, but I was wondering if there is an cleaner way to check if a...

I feel like such a dufus. I was trying (and, of course, failing) to do .AddNew Thanks

I can open and manipulate Excel workbooks easily, but I'm not faced with the task of programmatically adding a new worksheet to an existing spreadsheet. How would I do that?