RickShaw888's Q&A profile

• Microsoft ISV Community Center Forums Macro in Excel that will look at current worksheet column and select a specific string and...

  I need to create a macro or VBA project in Excel 2003 that will look at the current worksheet column and select a specific alphanumeric or numeric text string that matches this format (V#####, or #####, or V########) than cut and paste just that string to a different empty column to the right on the same row and do this for all rows in the worksheet. Example of current data: The highlighted strings would be cut and placed into a separate column to the right of this column but in the same row. BUFFALO, NY 142072504 GARBEN, TIM (9992) x 9992 2311 ERNEST STREET x (Alternate) (Corporate) J ...Show All

• .NET Development specify odbc connection

  I cant beleive i havent found an answer to this, but here goes. I am using visual studio c++ 2005 express edition and have made an application with a specified data source using an access file. Can I instead setup the odbc connection in Windows and connect to the name of that connection instead All connection strings I have found have forced you to specify the mdb location in the project which is very inflexible and visual studio doesnt seem to let me do it any other way. Thanks in advance. that sounds like it could work, i guess it would tie in with another problem i am having in regards to emulating a partial class in c++, so i can ...Show All

• .NET Development OPC Automation

  Hello, I'want to create an OPC Client for any OPC Server in VB.NET. I use Visual Basic 2005 Express Edition. So, I add a reference to my OPCDAAUTO.dll. And at this time, there is just this part of Code : Public Class Form1 Dim WithEvents g_OpcServer As OPCAutomation.OPCServer Dim WithEvents g_OpcGroups As OPCAutomation.OPCGroups Private Sub Form1_Load( ByVal sender As System. Object , ByVal e As System.EventArgs) Handles MyBase .Load g_OpcServer = New OPCAutomation.OPCServer g_OpcServer.Connect("KEPware.KEPServerEx.V4") g_OpcGroups = g_OpcServer.OPCGroups.Add("Grp") End ...Show All

• Visual Basic Problems with converting VB6 to VBNet handling of Fortran strings

  I am having trouble with strings returned from a fortran DLL to a Visual Basic program.  It works in VB6, but I can not seem to get it to work in VB.NET In VB6 I get the full character string, in VB.Net I get only the first character. The simplified VB6 code was as follows Declare Sub ABUT_DLL Lib "ABUT.DLL" (  ByVal vbMsgbox As Long) Sub vbMsgbox1(s1 As String)  debug.print (s1) end sub Call ABUT_DLL( AddressOf vbMsgbox1) The change that I made to get VB.Net code to compile was Delegate Sub BraddErrorboxDelegate( ByRef s1 As String ) Declare Sub ABUT_DLL Lib "ABUT.DLL" ...Show All

• .NET Development The name 'Profile' does not exist in the current context

  So, I'm using the .NET 2.0 Profile object to manage custom user data on an internal site for my company. Everything seems to be working flawlessly until I realized I was going to have to add a redundant block of code to every aspx page in order to take advantage of the Profile. At this point I decided to create a custom base page that could be inherited by all of my aspx pages. Seemed like the right idea, until I got the above error: The name 'Profile' does not exist in the current context I might be missing out on how/when the Profile object is getting built but I was wondering if anyone had any suggestions on how to acces ...Show All

• Windows Forms Designer Fails to Show From after VS 2003 Port - Problem Fixed!!!!!

  Original Problem: After porting a project to VS 2005, the designer fails to show the forms in my project.  When I try to view the designer, I get Object reference not set to an instance of an object How do I fix this Is it possible that the resx files are corrupt  Can I regenerate them ------------------------------------------------------------ Solution The problem was solved.  It turns out that one of the project wide language resx files (we have four) had a slightly different format than the other project wide language resx files.  When we made the resx files consistent, the ...Show All

• SQL Server extended connection managers for data flow destinations?

  It looks like you can only extended connection managers for data flow sources. Is there anyway to develop a custom connection manager for the SQL destination in the data flow destinations I can’t use hardcoded connection strings. I can’t use configurations because they are not encrypted. I already have managed code that will give the corrected connection string. I already have a custom connection manager that I use from the data flow sources. I just need one for data flow destinations but I can’t see a way to extend into the OLE DB The OLEDB Destination is just l ...Show All

• Visual Studio Team System Installing VSTS Beta 2 over Professional

  Hi there, Is it possible to install VSTS over Professional version (supported scenario ) Or is it better to uninstall pro and install VSTS after Hello Miha, I think it would be possible to install any of the Team System Editions (Architect, Developer, and Tester) over VS 2005 Professional. As you may already know the Team Systems Editions are just supersets of VS2005 Professional (i.e they contain all the functionality of Professional edition plus extra features) in terms of functionality.  I believe what would happen when you install on top is, the installer will recognise the installed components (i.e Microsoft V ...Show All

• Visual C# Design Question

  Wondering what my best bet is, control-wise, for the following. Need to dislpay the full path of many exe's...with associated icon. Getiing this info is complete. There will be hundreds of exe paths, meaning hundreds of 16 X 16 icons. Thanks I think listviews will be good, as you can place the icon in the ListItem image and any details about the file can be categorized in the columns.. ...Show All

• Visual C# Please help to Irregular Forms Transperancy.

  I have a form with an BacKgroudImage and I have set the TransperancyKey property to Black. And MY Image has its Black portion but still it wont get transperent these portions transpert how do I get it done hi, i hope this is what you asking form http://www.bobpowell.net/transcontrols.htm ...Show All

• Visual C# Windows Service - multiple instances

  I want to run multiple instances of the same service on one machine. So I wrote a service installer that looks for three parameters which can be passed in via the installutil.exe. So far so good, I can install multiple instances, but of course it makes no sense that they all do the same and use the same configuration. So I thought I could use the service name (property ServiceName) in the service itself to e.g. look for a configuration section in the machine.config or under a key in the registry, but if I do not set this name inside the service it is unset. Does anybody has an idea how I can get the service name from inside the servi ...Show All

• Smart Device Development Change Target WM5.0 Says Device Not Connected

  I have an applicaiton that currently runs on PPC 2003 that I need to also run on WM 5.0 This application is written with VB .NET 2005 I am trying to change the target platform to WM 5.0. I have Activesync 4.1 and the WM 5.0 SDK installed. When I try to deploy or debug on the device, I get the error "The device is not connected". Ironically, if I click the connect to device button from the IDE toolbar, I get a message that says connected to the device successfully.... I am at a loss. Has anyone come across this and know a solution Hello, To understand your problem bette ...Show All

• Windows Forms Need to build a listbox containing a checkbox and image

  I need to build a control that looks like a checked listbox but with an image between the checkbox and the label. I don't need any databinding support.  I tried to 'OwnerDraw' the CheckedListbox but it will not support owner drawing.  I tried to create a user control 'container' that  contains a checkbox, picturebox and label.  This 'row' con ...Show All

• Microsoft ISV Community Center Forums unloading a function

  I have a question i am writing a program in Outlook. I have a button on a userform that when I click it I want to unload a function in a module from memory. I thought I could just put this in the click event: Unload Project1.Module_Name.Function_Name However, that just runs the function again. Also, I would like to know, is there any way in vba to say "unload all functions and subroutines" Anyone got any ideas thanks, Dudeman Hi Dudeman, I think the only way you can maybe do this is if the code is part of a class module but even then I'm not sure. You'd unload the class then. Still not su ...Show All

• Visual Studio Team System Can not add new Work ITem

  I am trying (for the first time) to add new Working Item in VSTS 2005 Beta 2. IDE crashes immediately after Working Item type selection. Anyone experience something like this Any ideas Leon, It's great to hear that you got it working without having to invest a lot of effort into trouble-shooting.  Thank you for getting back to us. tony ...Show All