scjconsulting's Q&A profile

• Microsoft ISV Community Center Forums Macros - Excel

  Hi, I have made a macro for a project which i am working on. I have to run this macro every week on different files. These files have names which include the date of the data. Now without overwriting this file i want to run the macro but want the date of this file to be included in the final file which i have made. Is there anyway to do this for eg: Data file : Name : ABC 10-3-06 i want the final output files name to be : XYZ 10-3-06 Can somebody please help me. Aziz. Hi Aziz, This will be no problem. Look at the FileSystemObject in the help file, it contains objects like file ...Show All

• Visual Studio 2008 (Pre-release) Cursor from Geometry

  Hello, is it possible to convert Mouse Cursor from Geometry I have a bit of UI on my screen, which I'd like to turn to a Mouse Cursor. Thanks. I guess you could hide the mouse cursor and RenderTransform/Translate a DrawingBrush or Image in response to the MouseMove event... Not what you'd wish for, but doable... ...Show All

• .NET Development Exception Handling DO NOT WORK!! Help Please!@!

  Hi. I want that you think with me... When i put a try-catch exception handler block in an application what i expect from it i expect that it will handle the error and begin the normal flow of the application. Now, you aswer me, why it doesn’t work in this scenary : I have one Form1 (Project > Add New > Form, nothing different), and another Form2 and one Form3. i’m proud of my creativity for names. Form1 : private void Form1_Load( object sender, EventArgs e ) { try { new Form2().Show(); } catch (Exception ex) { MessageBox.Show("Error calling form 2" + ex.Message ...Show All

• Windows Forms How do i pass control to another form in a button click event

  Hi I am new to windows forms. How do I pass control to anohter from in a buttons click event.  eg  When you click on a button located on form 1. It then shows form 2.  how do you do this.  Thanks  OOPS I thought you wanted something else.  I thought you wanted to pass "A" cotrol not control.  :)  ...Show All

• Software Development for Windows Vista Where do I get WCF Activities

  We keep being teased about prototype WCF Activities in various demos and webcasts to inetgrate WWF with WCF. (SendMessage,ReceiveMessage, SendReceiveMessage,ReceiveSendMessage) Does anyone know where we can obtain these -even if only prototype/Beta it would be useful to get up and running. NB When I add a Indigo Service, via an 'Add Web Service' it does not add a reference to System.ServiceModel.  Contary to James Conard demo. Thanks Jules    JulesW wrote: Sorry memory of a goldfish I believe the general advice is that in the absence of these Activities being released, there are three options, of which the first t ...Show All

• Smart Device Development connection issue

  Hi, i'm trying to access MSDE from smart device apps. but connection  failed.Actually i tried this before few months. spent more than a week. but failed. so i just used SQL 2000. Now it's a time to change from SQL 2000 to MSDE. So again trying my best. but still I couldn't make the connection. if i test the connection from Server Explorer -> database connection, connection succeeded. but when i try to establish it via pgm(VB.NET), failed to open the connection. As u said,I enabled TCP/IP. Firewall - off anti virus - unloaded. OS -windows xp pro SP2 Dev.Env :VS2003 still getting error like "Server not found - "CMP1\MSDE1" ...Show All

• Visual Studio Team System Major Pain point with Pending Changes Dialog

  There is no select all/invert/deselect all  option.  I have been working on moving artifacts into VSTFS Source Control (Hatteras) all weekend and not having that feature has cost me at least 2 hours of checking or unchecking checkboxes. Shift-Select then check/uncheck seems to work fine for me :-) Sorry! ...Show All

• Visual Basic delegate question

  delegate question I'm learning about delegates on page 129 of Wrox Professional.VB 2005. The authors propose the code below. Two things confuse me. 1. In the line Public Sub DoSort(ByVal theData() As Object, ByVal greaterThan As Compare) why don't I have to include the parameters v1 and v2 2. Since Public Delegate Function is a function, why don't I need the statement End Function dennist685 Module Sort     Public Delegate Function Compare(ByVal v1 As Object, ByVal v2 As Object) As Boolean     Public Sub DoSort(ByVal theData() As Object, ByVal greaterThan As Compare)     &nb ...Show All

• Visual Studio Team System Cannot insert duplicate key in object 'dbo.tbl_tmp_security_identities'.

  Every hour I get Event ID 3017 with an detailed error message of Violation of PRIMARY KEY constraint 'PK_tbl_tmp_security_identities'. Cannot insert duplicate key in object 'dbo.tbl_tmp_security_identities'. and 3058 with detailed message of: Detailed Message: TF50642: A problem occurred updating the Identity Administrators (with SID S-1-5-32-544) What is causing this Hi Joel, What version is this. There was a bug fixed for RTM that took care of this problem possibly. Thanks, Brad ...Show All

• Visual C++ add class - cannot add mfc and atl items

  Hello, the add-class wizard does not allow me to create atl or mfc entries, such as "ATL Simple Object" etc., i.e. the edit fields Name and Location are grayed out and Add does not work. This is even true in a new project, what could be wrong, any ideas thx Alex Hi David, Could you send me a small sample project that exhibits this behavior You can email it to borisj at microsoft dot com. Thanks, ...Show All

• SQL Server what version of ODBC does sqlserver/.net use?

  Hi Guys, Does anyone know the version of ODBC that is used in .NET 1.1. with SqlServer 8 Is it 3 I can't find much information on this. Thanks! http://msdn.microsoft.com/data/sqlnative/default.aspx 3.x complaint. Thanks ...Show All

• Visual Studio Express Editions Office Development

  Hi, having had a look at the Visual Studio Express, I'm rather thrilled, especially as code developed with it can be distributed commercially. However, I am wondering about teh implications of one point on the comparison site. Does the fact that Office Development is not supported mean that the "new" (I'm used to VB6) Office Tools of .Net are not supported, or that even the basic office objects as available in VB6 are not offered Can I still open a connection to, say, Powerpoint, and run some VBA macro code on it Thanks for the help! Microsoft Office development using .NET is supported thro ...Show All

• Visual Studio Tools for Office Find() and Autofit() issues

  I have 2 questions related to the Find() and Autofit() methods: I have a VSTO application that opens an Excel.Workbook wb, goes through all the worksheets via "wsCurrent = wb.Sheets as Excel.Worksheet", and then uses the Find() method on a specific column ("rngFoo = wsCurrent.Columns["A",missing] as Excel.Range") to find a value. I have applied the same logic to different type of columns successfully, except with one because the Find() function is not able to find a result. The only difference with other columns is that the values in this column represent a number with 9 digits. The worksheet was exported from a text file. Th ...Show All

• Windows Forms you can't add or change arecord because a related record required in parent table !!

  hi i have 2 relational tables in the dataset when i save sometimes it gives me this exception sometimes not !!!!!! although the parent record is not deleted or modified !!!!!! the exception is "you can't add or change arecord because a related record required in parent table " how an isolve this problem can any one help me thanks in advance. ...Show All

• Visual Studio Team System Status of the 28100 error?

  I have installed the TFS B3 Refresh on a blank box following the instrauctions in TFSInstall-v51020.chm *exactly*. Adding the tfsservice and tfsreports to the local admin group works - but the error ever resolved or is it just a B3 Resfresh bug (I can live with that) - B3 installation worked fine. Jorgen Others have reported that the problem is that the service accounts don't have write access to the %windir%\temp directory, necessary for ASP.NET temporary assembly creation.  Making those accounts administrators gives them write access. ...Show All