KevinH_MS's Q&A profile

• SQL Server How to add the total balances of previous year into the next year?

  I'm working with a table called SALFLDGAMS where it has two columns that I need to work with. One of the columns is Period which has years from 2000 to 2005 and the other column is called amount which has the balance for that year. Let me explain in a little more detail. There are account codes associated with the years as well so there will be many places where for example the year 2000 will show up with a given value. What I'm trying to do is to create a view which has a BeginBalance column which adds lets say all the values for 2000 and sticks them to 2001. So what I'm saying is all the values from the previous year I want them in the cur ...Show All

• Microsoft ISV Community Center Forums unable to register comsvcs.dll

  Hello, I have a VB application that has been evolving for several years. I have installed and used it on work stations running win95,98,NT,2000 and XP. The developement computer has evolved from a win95 to win2000 machine. Recently, I have begun to experience "an error occured while registering the file ... comsvcs.dll" when installing it on a win98 work station. winxp installs fine. I have always installed dcom98 and mdac prior to the vb setup. I also used the command regsvr32 to attempt to register the dll and received the message "LoadLibrary ("comsvcs.dll") failed. GetLastError returns 0x00000485" I have tri ...Show All

• Microsoft ISV Community Center Forums read-only OLEs ?

  Hello all ! I 'm database administrator and I 've a MSAccess db , which contains a tables with OLE objects (most of them are MSWord documents). I 've also some forms , that prevents they fields from changing (read-only forms). But when OLE object field is "executed" (Word document opens) , user can modify something. Then , when user closes form , he is getting an error with saving OLE object. Question: how to prevent OLE object from changing (better)   OR how to discard all changes before form is closed My Solution: I wrote a Form_Timer() sub , that reads some key states (about 50 times per second) and simply closes ...Show All

• SQL Server are you sql god???

  Hi all, I need the time that a stored procedure was created/altered. In sysobjects table, creation date of the stored procedure is logged. But if the stored procedure is altered this column is not updated. 1. Is last alter date of a stored procedure loged somewhere 2. If not, can I restrict users to "alter procedure" but not "drop/create procedure" so that they will have to drop and re-create procedures so sysobjects.crdate will always be updated.   I hope I will get a positive answer. Ata   Besides the create_date, there is also a modify_date in the objects catalog. T ...Show All

• Software Development for Windows Vista CoCreateInstance Fails When i create a custom Null sink filter

  Hi I have created my own Null sink filter which works on a sample application. But when i do CoCreateInstance on this NUll sink filter in my application it fails. My application is for smart phones win mobile 2005 pocket PC sdk. I call this co createinstance from another DLL. Please help Regards Adil Saleem i get a E_OUTOFMEMORY, but in the null sink filter that i have created we set the error code to E_OUTOFMEMORY when new on the constructor of the constructor fails. The following is the code inside create instance CSampleGrabber *pNewObject = new CSampleFilter(NAME( "SampleGrabber" ),punk,phr ); if ...Show All

• Visual Basic DataGrid/DataTable accessing all selected rows and moving them

  I am trying to take all of the selected rows in the datagrid and move them to another datagrid. What I have is only moving one of the selected rows not all of them. For iRow = dgAvailable.VisibleRowCount - 1 To 0 Step -1 If dgAvailable.IsSelected(iRow) Then drRow = mdtAvailFac.Rows(iRow) mdtSelFac.ImportRow(drRow) mdtAvailFac.Rows.Remove(drRow) End If Next Any suggestions would be helpful Theresa ...Show All

• Visual Basic Remote Registery Access and Windows 2003

  I am trying to write a simple app for connecting to each machine in my domain and pulling particular registery entries. It works fine on Windows 2000 machines but when connecting to windows 2003 machines I am getting   System.UnauthorizedAccessException was unhandled   Message="Attempted to perform an unauthorized operation." All the machines are a member of the same Windows 2003 domain and the app is running as a login that is a domain administrator. Dim reg As Microsoft.Win32.RegistryKey reg = Microsoft.Win32.RegistryKey.OpenRemoteBaseKey(RegistryHive.LocalMachine, dr( "Name" )).OpenSubKey( "SOFTWARE\MyProduct\Product ...Show All

• Smart Device Development OnKeyPress - What windows message (WM_xxx) is this a handler for?

  What does the OnKeyPress function in .NETCF act as a handler for (WM_KEYDOWN ). Thanks! ...Show All

• Windows Forms Control hosted in Web page works in IIS5 but not IIS6

  I have created a control that is hosted in a web page. It works great when deployed from a Windows 2000 server with IIS5. However, when I move the control and web page to a new Windows Server 2003 machine with IIS6. The main control loads but it displays an exception 'one of the dependent dll's can not be found'. I have checked the  ...Show All

• Windows Forms saving a connection string in app.config

  I want a setup project that saves the connection string the user selects via the mdac dialogs into the application configuration file. I managed to get the following code : public override void Install(System.Collections. IDictionary stateSaver) { base .Install(stateSaver); MSDASC. DataLinks udl = new MSDASC. DataLinksClass (); ADODB. Connection conn = (ADODB. Connection )udl.PromptNew(); if (conn != null ) { string ConnectionString = conn.ConnectionString; string [] ConnectionStringParts = ConnectionString.Split( ';' ); SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder ...Show All

• Visual C++ dllexport and function templates specializations

  Let's say I have the following template function:   Template <typename T> void Fun(T t); I'd like to be able to implement some specializations of Fun in a first DLL (DLL_1), some other specializations in a second (DLL_2), and still some other in a third (DLL_3), but DLL_2 and DLL_3 may make use of specializations implemented in DLL_1. So in DLL_2, Fun<T> may be both imported and exported, depending on T. I somehow managed to implement it by always declaring (in the .h file) the template as dllimport:   template <typename T> __declspec(dllimport) void Fun(T t); and always implementing the specializatio ...Show All

• Windows Forms Passing data

  What is the best way to pass data to an running application  I use the args in the sub main on start- but after it is running I need to pass it new data  Thanks, That all depends on how the application is designed, what it does, and what is passing the data... The biggest question is what is supplying the data to your& ...Show All

• Visual C++ WriteString( ) MFC Function

  Hello all, I'm a newbie to this forum and appreciate if anyone of you has seen this problem before regarding the WriteString( ) in hte MFC class and provide some badly needed help. In my app I'm using the CStdioFile::WriteString( ) function. The string being passed into this function for printing into the log file, does have the entire SQL statement. But when the WriteString( ) function writes it into the log, the SQL statement is truncated at the first non-English character. Bunch of developer whom i have spoken to think this should be a problem with either the WriteString( ) function, or with the way it is being used. We are trying t ...Show All

• Visual Studio Tools for Office VSTO MSDN Library

  In MSDN Subscriptions site there is 1 CD for VSTO 2005 Beta 2 and 3 CDs for MSDN Library for VSTO. Can you tell me why there is such huge update for MSDN Library Thanks, Martin Kulov The VSTO CD does not include the documentation. The MSDN Library for Beta 2 is very large (obviously, at 3 CDs), and it contains a lot of content--more than just the VSTO documentation. All of the Visual Studio documentation is in there, as well as all the other articles found on MSDN. It's a separate installation step during Visual Studio installation--it should ask you to insert the media if you want to install the documentation. You can't install only t ...Show All

• Windows Forms Would you help me with the Updater component?

  I would like to add some custom skins.  Anyone know where to get them Thanks PThomas@Corillian.com Consider enabling script access for the folder that holds your update files (e.g. 1.0.0.1) in iis. Most of the times 403 (forbidden) is a result of appupdater trying to download .config file which iis does not allow it to download unless script & ...Show All