Steve Hale - MSFT's Q&A profile

• Visual Basic Atlering data in an Access 97 database

  I have heard that VB 6 can only access MS Access 97.  I have no problem accessing the database; however, I cannot change any of the data in the database since it was a MS Access 2003 database originally.  Can anyone offer suggestions on how I can access an MS Access database WITH VB 6 and change the data in the database   I would like to use MS Access 2003 if at all possible; however, if not I would like to know how I can manipulate data with the current setup. Thank you greatly in advance! As these forums are really for VB.NET and not vb Classic - you may find more success in these other VB ...Show All

• Visual Studio Team System Assigned To field is deleted

  Hi, In RC, when changing the state of the State field to "Closed", the assigned to field is deleted. When changing back to active or proposed the name appears again. Is it a known bug Thanks, Michael This does not seem like a known bug. Which methodology and work item type are you using Could you please import the work item type using witimport.exe in "<install drive>:\Program Files\Microsoft Visual Studio 8\Common7\IDE" and send us the rule on State field ...Show All

• Windows Forms "adding" two icons

  Hey all- I basically have a ListView which will always be in LargeIcon mode.  I am displaying certain things (using thier icons) but I have an overlay I would like to put on the icon specifying certain properties of what I am displaying.  So, lets say I have a 32x32 icon and my overlay is 16x16.  What is the correct way to overlay&n ...Show All

• Visual J# Shuffle

  Is there a shuffle-method for System.Collections.Generic.List like the java.util.Collections.shuffle() I have never seen it for the .NET. But you can probably write your own. It should only be a few lines. http://msdn2.microsoft.com/en-us/library/d9hw1as6(VS.80).aspx ...Show All

• SQL Server Single record per page

  Hi All, I am new to RS2000 but have made a report that i need to have 1 record shown per page. the paper i am going to print to is 254mm x 178mm. I cant seem to figure this one out so any help or advise is most welcome You can a grouping to your data region, use RowNumber() function to control how many records belong to each group, and add a pagebreak on the group. This page contains a sample of how to do this http://msdn2.microsoft.com/en-us/library/ms157328.aspx (scroll to the page breaks section). ...Show All

• Visual Studio Team System Code Analysis

  Is it possible to magage the code analysis rules that are excluded through the Process Template Manager For example, we'd like to disable a consistent set of code analysis rules across all our projects. How can this be done Thanks in advance. Mark Are you talking about not having the code analysis rules selected when you create a new project, removing the code analysis rules altogether so they can't be selected, or just configuring a process template to create the team project with the specific code analysis rules checked ...Show All

• Windows Forms IntelliSense Descriptions for Types and Members

  With my own types, members, parameters, etc. I want to provide descriptions that could be read in IntelliSense without me having to use a 3rd party component to gain that functionality. This is a really nice feature that MS has included with its own objects and I want to create objects that are just as professional as MS. Obviously, the best place  ...Show All

• SQL Server Iteration within Stored Procedure

  A Stored Procedure inserts a record in a base table. I want to add n records (n=1 to 5) into a related table. Another SP (tdAuthorityInsert) is already set up to insert one record into the related table. So, two questions 1. What is the form of an iterative loop in a Stored Procedure 2. How do you call a Stored Procedure from inside another Thanks, td Is this what you trying to do declare @ NumReviewers int -- Initialize the @ NumReviewers select @ NumReviewers = 1 WHILE @NumReviewers <= 5 BEGIN -- execute your SP and pass in the @ NumReviewers exec your_sp_name @ N ...Show All

• .NET Development system.objectdisposedexception

  Hi, I have a multithreaded application that crashes with the following msg in event log ... EventType clr20r3, P1 smartserver2005.exe, P2 1.0.0.0, P3 43f6cc52, P4 system, P5 2.0.0.0, P6 4333ae87, P7 3ad8, P8 a5, P9 system.objectdisposedexception, P10 NIL. I have provided try catch block in all routines in the code & still the appl crashes with the above msg. Note that crash is not consistent for a particular sequence of events. Any suggestions -S.Malathi I check MSDN about SerialPort. Here what I found there: 1. events called on worker thread, so you can't call MessageBox() and for ...Show All

• Visual Basic RegEx Question: Match whole word from substring

  Hello, I want to search a buffer using a search pattern and return whole words that contain the search pattern . Here's a sample Buffer: "CADLOG cat red green NAR_LOG bus stay logroll house mouse fur log crutch" Here's my search string: log I would like this to return matches: CADLOG, NAR_LOG, logroll, log Using System.Text.RegularExpressions I can match the substring within words, but I can't seem to return a whole word. Can someone help me with formatting what I'm sure is a basic regular expression Thanks!! One simple way would be to split the string into words and then look for the pattern i ...Show All

• .NET Development How to get a list of all assembly dependencies and their complete file paths ?

  I have an assembly that depends on other assemblies, and these other assemblies have their own dependencies etc.. Is there an easy way to get a list of file paths to all the depended assemblies files Offcourse I can program some clunky probing algo, but isn't there a method in the framework that does that for me and does that very good Something like the ResolveAssemblyReference task of the MSBUILD api (more info about that here: http://blog.dreamprojections.com/archive/2005/05/01/846.aspx) Thank you, Ward You can use Junfeng's tool that calculates the binding closure of an assembly.  He's got the so ...Show All

• Software Development for Windows Vista Cannot show icon of Start Menu and other Installer issues

  Hi there, We are try to develop our program onto VISTA. Recently, we got some minor issues: 1. Before, we relied on Msiexec calls CreateShortcuts action and extract icons from programs, and then it stores to "%SystemRoot%\Installer\<GUID>\target_file.exe". Nevertheless, when we work on VISTA these files in Start Menu do not have icon. Is there something wrong in Msiexec on VISTA Or, what kind of alternatives we can try 2. We write some keys to Windows Regitry during installation. Some key writing are okay, such as: HKEY_CLASSES_ROOT\*\shellex\ContextMenuHandlers\<GUID> HKEY_CLASSES_ROOT\ DocShor ...Show All

• Windows Forms DataFormatString in GridView

  I wonder if someone else is suffering the same problem. I found DataFormatString in GridView not work very well when I try to display currency. In VS 2005 Beta version, it works fine, but after I use stardard version, it never display correct. For example: integer 3 always display like 3.0000 but in the beta version, it display like $3.00 which is what I would like. By the way, I assigned datasource, dataadapter and sqlcommand manually, everything else is good, even date format string works, but currency format just NOT work. Not sure if this is a bug DataFormatString  {0:c2} Yes, I, too, have encountered the same thing.  ...Show All

• Windows Forms Using Win32API to check scroll information from text box

  I am trying to get the scroll information from a text box particularly the page size.Using VB6. As anyone got a sample code for vb6 or can point me in the right direction or recommend any books on code for Accessing the API in VB6. Many Thanks Becki This forum is dedicated to supporting Windows Forms in the .NET environment. Please vi ...Show All

• Visual Studio Team System Location Link Problem Analysing a Team's Work

  I'm not a .NET programmer (more C and C++), but I am responsible for ensuring that my programming team is complying with our requirement that they follow the Framework Guidelines. I just found FXCop and have started to use it. The analysis itself appears to work fine, but the Location link shows the programmer's directory structure and, of course, won't work on my machine (different user name). This makes it difficult to check the source to see if there is a valid reason for the programmer choosing to code the way they did. I don't really understand assemblies and manifests, so I was surprised to find that a build contains machine-spec ...Show All