Recent content by pokasick

Sideman, Thanks for your reply. The query in the example has a where clause of Stor_ID like '7%. The filter is "Stor_ID like '70%'" to show only stores that have an ID starting with 70. I thought that by using the filter property on the current recordset, I could save some server...

Yes, sorry I didn't make that clear. Paul

I have a recordset that I use to load a grid on a form. I added a filter option to the grid. The filter works, but when I set the filter command, it is running the same query as the first time then applying the filter. I'm using the SQL profiler to optimize the program. I've been trying the...

I discovered by right-clicking on the field in Query Analyzer, and selecting Extended Properties that the property that I want it called MS_Description. Using MS_Description in fn_listextendedproperty, I'm able to retrieve what I'm looking for. Declare @TableName varchar(50) Declare...

Thanks for the reply. I'm digging through the BOL and working on figuring out how to use fn_listextendedproperty. This is supposed to show me all of the Extended Properties, but it returns nothing. SELECT * FROM ::fn_listextendedproperty(NULL, NULL, NULL, NULL, NULL, NULL, NULL) I'm...

I have a query that I use to display TableName, FieldName, etc for analysis when developing programs. The query pulls the information from the system tables: sysObjects, sysColumns and sysTypes. I want to also pull the description for the field, but I cannot find it in any of the system...

Hi, I’ve got a VB6 program that logs on to Outlook under a certain profile, checks that the username is correct, sends an email, then logs off and quits the application. The profiles are local on the machine. I have a reference set to the Microsoft Outlook 9.0 Object Library. When the 2nd...

Thanks, I'll look into installing it. Paul

Thanks! I didn't know that there was an ODBC.Net. Do you know of any issues with this being installed on a Win2000 machine running VB6 apps with an older version of ODBC? Thanks again, Paul

I was trying to do something similar recently. I found a post that gave another option. You can declare a variable in a module to hold a reference to the form and set it when the form is created. Then you can use that variable to access the components on a form. You should also kill the...

Thanks for replying. Here's a method that I put together just to keep all of the related code together to make it easier to read. If I use the connection string that I created using a SQLConnection object, it works just fine. The connection string is stored in an INI file. Any ideas...

Is it possible to use an ODBC DSN with a VB.NET/ADO.NET program? I get an error when trying to use a DSN that we use with our VB.old/ado programs. The database is an SQLServer database. Here is the error: Expected '=' delimiter while parsing connection value pair. Thanks, Paul

Hi, I'm using the FileSystemWatcher.Created event to let me know when a file has been written to a directory. Then I can encrypt it and move to to where it needs to be. The created event fires immediately upon the creation of the file. The problem is that on a large file, the encryption...

What a bummer! Thanks for the reply. Paul

I worked on something similar to this recently. In VB6, all you had to do is iterate throught the component collection of the form. Doing the same in VB.NET will not find components that are in a container component such as a panel. I used a recursive method that will find all of the...