waga's Q&A profile

• Visual Basic VB & Office 2003/2007 References

  This may be the wrong forum to post this in; if so, please let me know where I should ask this question. I'll start by saying I'm new to Visual Studio 2005 and in many ways,VB programming altogether so if I'm way off base here, please let me know. I have designed a program that gathers data from Active Directory and dumps the information into an Excel spreadsheet. The program works fine on my development computer which is running Office 2007 Beta 2 and another system which also has Office 2007 on it. In the program I have referenced the COM object " Microsoft Excel 5.0 Object Library ". When I try to run the application on another computer that is running Office 2003, the program will not run. My understanding of referen ...Show All

• Visual FoxPro How to calculate the data connection time?

  I tried to add 2 fields, time_on, datetime, time_off, datetime to calculate user's log on time in the Users.dbf. How do I calculate the total time between the 2 value Any better way to capture users' activity You may create a clock like: http://support.microsoft.com/kb/139390 and start it when user log on ... ...Show All

• .NET Development How do I remove empty node with attributes ?

  Hi I am using the below xsl to remove all empty nodes . But it is not removing the following node (Node with empty attribute) <LandArea Unit="" /> Also How do I remove empty attributes below <TotalConsideration ChattelsAndMoveables="" Goodwill="yes" Other="" Stock="yes">6</TotalConsideration> XSL Code < xml version="1.0" > <xsl:stylesheet xmlns:xsl=" http://www.w3.org/1999/XSL/Transform " version="1.0"> <xsl:output omit-xml-declaration="yes" indent="yes" /> <xsl:template match="node()|SDLT"> <xsl:if test="count(descendant::text()[string-length ...Show All

• Visual Studio Team System Administration of user-defined error messages

  Hi, I am testing the DBPro (VSTEfDB) and I like it very much. Perhaps I missed it, but I cannot find anything about storing user-defined error messages. We usally store our user-defined TSQL error messages in the databases (for using them in procedures/functions). So we have to ship the messages with the DB and update them with each new version. Is this possible with DBPro If not please add support for user defined error messages. Bye, Thomas The scope of DB Pro is a single database. Since user-defined error messages are outside of a database (they are server-scoped) we have no direct support for them. However, you can create your calls to sp_addmessage in the pre-deployment script C ...Show All

• Internet Explorer Development link target support

  Hi Could someone help me to implement support for link's target attribute in browser hosting application. Like <a href="http://www.host.com" target="framename">link</a> What I've done. I've implemented ITargetFramePriv interface and give it in QueryService(ITargetFrame2, IUnknown) Then mshtml calls my ITargetFramePriv.FindFrameInContext, I give corresponding object which is queried for IWebBrowser2 interface. But then mshtml ignores it and begins creating new window through calling NewWindow3 of the original browser. Any suggestion Regards, Serge. Hi. My question is not about IE7. It's my application which is hosting IWebBrowser2 component. >Here is the link to the Nav ...Show All

• Visual C# webservice from client

  Hi, I have created a webservice on my local machine using .net 2.0. This webservice is referenced from the project that contains forms. At present I reference this webservice using add webreference and point to it which is sitting on my local machine. How is it possible for other developers to access this webservice which is sitting on my machine please Thanks If you're sharing the project/solution you'll have to remove the dependence on "localhost" for the server name. If you're using the "built-in" Visual Studio web server then you're out of luck, that will only get run by Visual Studio and won't be accessible all the time for the other developers. ...Show All

• Visual Basic can't import Excel into Visual Basic

  Hi Hope some body can help with this: - I have just installed Visual Studio 2005 Professional onto my PC and want to write an application that opens an Excel spreadsheet and reads data from a specific range in the sheet. Problem is I cannot seem to import the Excel objects into the program. Looking around on the net I have found some code like this: - Option Strict On Imports System.Windows.Forms Imports Excel = Microsoft.Office.Interop.Excel Imports Office = Microsoft.Office.Core Imports System.Drawing However this just produces an error to the effect that the office and excel lines are not recognised. Can anyone tell me what the correct import would be to enable me to use the excel objects Many th ...Show All

• Visual Studio Visual Studio .NET 2003 Debugger Becomes Very Slow on Stepping through application

  Every day at random times, the debugger in visual studio will slow to an incredible crawl and it will take 3-5 seconds to step from one line in the debugger to the next line, making it almost impossible to debug applications, and causing even more problems because the programs I am debugging have timeouts associated with them on other server side code causing my clients to get disconnected. Is there any known reason as to why the visual studio debugger would take between 3-5 seconds to step from one line to the next I must also make it clear that when I am stepping from one line to the next, I am not referring to function calls necessarily, I am talking about simple variable assignments or getter/setter functions taking 3-5 seconds to exe ...Show All

• .NET Development Regarding IP Address

  I have a client server application, the server application is out side my gateway, after authendication i wish to establish a peer to peer communication between my clients, that are located under two different gate ways. my clients don't have a static ip, i think this is a difficult task, but i know some popular applications are using this technique. Can you please tell me how can i do this using vb.net. Thank you You have a couple choices: 1. Look into IPv6 and its associated transnition technology called Teredo which enables end to end connectivity accross most NATs. IPv6 is the preferred protocol on Windows Vista and an IPv6 stack can be enabled on both Windows XP and Windows Server 2k3 http://w ...Show All

• .NET Development Get WRONG primary key when i use DbDataAdapter.FillSchema or DbDataReader.GetSchemaTable

  Hi All: I have one table at below: Table Name=T_APP Columns: APP_ID IDENTITY(1,1) NOT NULL, NAME nvarchar, LOWERED_APP_NAME nvarchar The table has one pk : CONSTRAINT [C_IC_APP_PK] PRIMARY KEY NONCLUSTERED ( [APP_ID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY], it also has one uk: CONSTRAINT [C_IC_APP_UK1] UNIQUE CLUSTERED ( [LOWERED_APP_NAME] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] But when i use DbDataAdapter.FillSchema or DbDataReader.GetSchemaTable, they return LOWERED_APP_NAME as primary key to me NOT APP_ID. But when i try to make C_IC_APP_UK1 to non-Unique, others still remain, the two methods return me correct column. Is it a bug After all, ...Show All

• Visual C++ Class wizard

  Hello all, How do I go about adding a message handler i.e ON_MESSAGE(...etc) without the class wizard as in VC++6 Thanks in advance. Beside that Nishant already said. ON_MESSAGE macro is generally used to map user-defined message handlers. The handler function prototype is afx_msg LRESULT memberFxn(WPARAM, LPARAM); Here is an example: #define WM_APP_MYMESSAGE (WM_APP+1) // ... // MainFrm.h class CMainFrame : public CFrameWnd { // ... afx_msg LRESULT OnMyMessage(WPARAM wParam, LPARAM lParam); DECLARE_MESSAGE_MAP() }; // MainFrm.cpp // ... //}}AFX_MSG_MAP ON_MESSAGE(WM_APP_MYMESSAGE, OnMyMessage) END_MESSAGE_MAP() // ... LRESULT CMainFrame::OnMyMessage(WPARAM wParam, LPA ...Show All

• Visual FoxPro how could I change the Client's IP address automatically

  Good day to all experts, how could we change the client's IP address automatically from the server . I have a small program running at the workstation and have also a program that monitor the workstation at the server which both works fine. But sometimes the user change the ip address which was manually configure and if i use DHCP they put an IP manually just for fun or just for experimenting or what-ever their motives i don't know. So i am thinking, if why not checking it at the server if one station's IP address has change , why bothering going to the workstation if it can be easily replace automatically from the server Thank you very much for your help regarding this matter. Have a nice day to all "I don't ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Please help me im new, debugging trouble

  is there any way to create an xbox 360 game out of the template, write the code, develop the game, and then debug it on a pc, and the reason for doing this, is that i dont have the money for a creators club memborship right now, some one help No, if it's a 360 game, you have to run it on the 360. You can however create a PC game and run and debug that just fine using XNA. Typically there is very little work that you have to do to get your XNA PC games running on the 360 when you finally do have the money and the opportunity to play it on the 360. I would recommend develop your potential 360 game on your PC, but every now and then make sure it builds as a 360 game so that you know you haven't used something ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Starting work on my GUI system

  Well, I've hit a wall with my game's development, and since there was no GUI with XNA 1.0, I've decided to go ahead and make my own GUI system. I implemented a lot of mechanics for my game, but I need greater interaction to proceed development in a sane manner. So far I've just implemented the text drawing stuff from scratch. It uses only monospace fonts generated with BMFontGenerator without using the generated .xml file. It's decidedly minimal to use only monospace fonts, but keep in mind two things - 1) my particular game doesn't require anything more robust than monospace fonts and 2) a game's engine should be designed around the game's specifc requirements. Otherwise you're scope creepin. I remind myself constantly not to let cool ...Show All

• Visual FoxPro SCATTER/GATHER

  Hou can I "scatter" in a method (valid) and "gather" in other method(click).My vf.7 is forgetting all "m." variables between methods. Thanks, Daniel Visual FoxPro doesn't "forget" these values. Technically they go out of scope which is not the same. You have to understand scope, as explained above. To be in scope the best option is to save (or scatter) them to properties of an object (also shown above). Instead of memory getting released when the method vars go out of scope, they get released when the object gets destroyed. This is an important concept to understand in OOP. ...Show All