Search results for query: *

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

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

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

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?

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

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

What is the difference in Scaleheight and Height? (And why does the difference always seem to be 60 pixels?)

I know who to check to see if a folder exists, but how do I check to see if an existing folder is empty? I don't need to know what files are in it, I just need to know whether it has any files or no files. Thanks.

I have a form in my app which allows the user to dynamically create up to 10 command buttons. This is working spendidly, including the coding for the dynamic buttons. The possible choices are listed in a checked Listbox, and they simply select which command button(s) they want at the moment...

I have the following code: Private Sub Command3_Click() Dim oWord As Word.Application Dim oDoc As Word.Document Set oWord = GetObject(, "Word.Application") If oWord Is Nothing Then Set oWord = CreateObject("Word.Application") End If oWord.Documents.Open...

I know how to tell whether a table within an Access database exists or not (using VB and ADO). My question is, using VB and ADO, how can I tell whether or not a specific field within a specific table exists?

I know who to open up a command window from my app using Shell. Once in DOS, I know how to navigate to whatever folder I want. What I don't know how to do is open up a command window, from my app, that opens in a specified folder. I would like my customers to click a button in my app and...

How can I programmaticly reset a SQL Server IDENTITY_SEED? I've been looking through the help and searching online SQL Server web sites and haven't come up with anything. The only way I've been able to get reset it is to delete all the records, modify the table so that it doesn't have an...

I've just spent the better part of an hour and a half roaming through MSDN and am more confused now than when I started. In plain english, can someone explain what an SQL Construct is, and what it is used for?

Primarily I use Oracle, but for this particular project, I'm using SQL Server. When I want to copy an Oracle table through code, I say create table tablename_bak as select * from tablename;But, SQL Server gives me a syntax error. How do you do this in SQL Server language?

Why are there no rows selected when clearly there is a class with a start date that equals sysdate + 3? SQL> select sysdate + 3 from dual; SYSDATE+3 --------- 18-OCT-04 SQL> select class_no from tpt_classes where start_date = sysdate + 3; no rows selected SQL> select start_date from...