Blueforce's Q&A profile

• Microsoft ISV Community Center Forums "Bizzare" Sendkey Code in Excel

  Following is my code... Range("A1").Select 'Select cell A1 Application.SendKeys "BIZZARE{ENTER}", True 'Enters BIZZARE in A1 and focus goes to B2 Application.Wait (Now + TimeValue("0:00:02")) Application.SendKeys "{UP}", True 'Again focus on A1 Application.Wait (Now + TimeValue("0:00:02")) 'Range("A1").Select 'Just in case {UP} doesnt work Selection.Copy 'Path 1 Range("B2").Select 'Path 1 ActiveSheet.Paste 'Path 1 Application.SendKeys ("^C") 'Path 2 Range("B2").Select 'Path 2 Application.SendKeys ("^V") 'Path 2 My code wanted ...Show All

• Visual C# How to use RectangleConverter?

  I am constantly converting rectangles back and forth from int based to float based rectangle. I have noticed the RectangleConverter class, but there are no samples (that I can find). Does anyone have any experience with this class Right now I am constantly writing this code to convert from a RectF to a Rect Rectangle r = new Rectangle((int)rF.X, (int)rF.Y, (int)rF.Width. (int)rF.Height); And it is a big pain! I have even written a class that creates 2 rectangle objects and keeps them in sync. But there must be a better way. Any help would be much appreciated! Thanks, Bob The RectangleConverter class is used to convert string repretations to a Rectangle and versa vista. What you ...Show All

• Visual Studio Tools for Office How to search for GlobalAppointmentID?

  Hi All, How do I search for AppointmentItem using GlobalAppointmentID There's not much info in MSDN docs on that. How global this ID Is it unique accross of all Calendars in the Exchange or just inside of a particular Calendar Thx... Alex Hello, How about adapting the code sample at http://msdn2.microsoft.com/en-us/library/ms269108(vs.80).aspx and doing something like the following: private void FindAppointmentItemByGlobalAppointmentID(string appointmentID) { Outlook.NameSpace outlookNameSpace = this.Application.GetNamespace("MAPI"); Outlook.MAPIFolder calendarFolder = outlookNameSpace.GetDefaultFolder(Microsoft.Office.Interop.Outlook.OlDefaultFolde ...Show All

• Software Development for Windows Vista Is the method "WorkflowInstance.Load" required?

  Hello, Do I need to call the method " Load " of the WorkflowInstance class myself, or will it automatically be called when I use the method " RunWorkflow(instanceID) " of the ManualWorkflowSchedulerService I tried both possibilities and did not see any difference in result... Also, I cannot find any documentation about this topic. The only information I found was WHAT the method " Load " does, but not WHEN it's needed. Thank you for you time! Okay, I understand your example. But in my case, I use the following (VB.NET) code: 'get workflow instance Dim MyWorkflowInstance As WorkflowInstance = MyWorkflowRuntime.GetWorkflow(MyDocument.WorkflowInstanceID) ...Show All

• Visual C# Process Module

  Hi, I have an application which lists all the running processes of the machine and i need to get the full path from which the process is running. I am trying to use the following methods : Process.MainModule.Filename Process.MainModule.ModuleName The above code doesn't work it throws an exception "Unable to enumerate the process modules" any thoughts Regards Alan thx for the replies. I am running .Net v2.0 on WinXp prof serv pack 2 and i am also on the admin account i also tried to catch exceptions but still a messagebox popped up with the same message. If anyone finds a solution please reply in my thread. thx very much :) Rega ...Show All

• Visual Studio Tools for Office Question: VSTO2005 + ASP.NET + Excel XP

  I have a question about VSTO 2005 + ASP.NET(C#) + Excel Actually I just want to: 1. Get data from DB 2. Put (better like "CopyFromRecordSet" back in ADODB) the resulted DataTable to Excel 3. (If no Excel automation needed) Change something like Excel Column width, borders... 4. Save the file on server 5. Allow download by user 6. Users open the Excel file by EXCEL 2000, XP I want to use VSTO's ability to change the data directly without touching Excel (no need to install Excel on server) , that way I can't have Step 3 As I know...(maybe wrong)...the VSTO approach needs Excel 2003 to bind the Data Island and the View when the user opens the document, but I want user to open the file using Excel 2000 or XP, (this is my ma ...Show All

• Windows Forms Windows 98/.Net Framework Problem

  Hi, I have a ClickOnce, VB Express application that is working fine on many clients, except for a client who is stuck in the world of Windows 98. I have uninstalled, rebooted and re-installed .Net Framework 2 several times. The reboots seem clean, but when I attempt to Run the application, the file is downloaded and then Windows asks if I want to Run or Save the file. In either case, Windows attempts to open the file, Prize%20Money[1], but of course there is no application associated for this file. I assume that there is a problem with either Windows 98 or .Net Framework 2, but I don't have clue where to begin. Although, I'd like to tell the client to upgrade his old iron and get Windows XP this is not an option. Thanks for your sugg ...Show All

• Windows Forms Show data from ms access in a textBox

  Hi there, I need your help with something you may find easy but it isn't for me, sadly. I need to show data from my MS Access database into several textBox-es just showing no modifing. I have a sample from my program : OleDbCommand nameCmnd = new OleDbCommand("SELECT name from Customer WHERE customerID = "+ enteredID, myConn); OleDbDataAdapter nameAdapter = new OleDbDataAdapter(nameCmnd); DataSet dsName = new DataSet(); nameAdapter.SelectCommmand = nameCmnd; nameAdapter.Fill(dsName); I try this: nameTextBox.Text = dsName.ToString(); but its wrong! And I have to do the above for every customer details such as name, mobile number, home number ..etc So you can see I need a solution plzz. ...Show All

• Windows Forms Kernel32.dll, GetPrivateProfileString error.

  I have imported the GetPrivateProfileString() function from Kernel32.dll. However, I am really confused on how to use it to get the data of a key. For instance: [MySection] MyKey=MyKeyData How do I use it to get "MyKeyData" and store it in a string The problem I am having is one of the function arguements. It gives me an error. "Trying to write to protected memory, blah blah blah". DWORD GetPrivateProfileString( LPCTSTR lpAppName , LPCTSTR lpKeyName , LPCTSTR lpDefault , LPTSTR lpReturnedString , DWORD nSize , LPCTSTR lpFileName ); Which I have made: int GetPrivateProfileString( string lpAppName , string lpKeyName , string lpDefault , string lpReturnedString , ...Show All

• Visual C++ ODBC/OLEDB Connection

  Hello Sir, i am working on answering matchine project in visual c++ 6.0. The entire sample code is in C and files are with .C Extension. i have to do database connectivity with C. i don't know how to do it. i know how to get database connectivity in VC and Code in .CPP Extensions. but when i use the same dll and header files in C, it gives an error in importing 'ADO Dll' in 'STDAFX.h' from program files and says that C compiler does not support import directive. if i convert all files to .CPP extension. it gives a lot of errors in calling some window functions. Pls guide me what should i do now. Thanks and regards Munish Gupta If the language doesn't support the database connectivity, ...Show All

• .NET Development VbCode Why doesn't it work.2

  This is the Exception that I recieved. An unhandled exception of type 'System.Xml.XmlException' occurred in system.xml.dll Additional information: System error. is the err that I am getting ...Show All

• Visual Studio ReportViewer with BindingSource, table help

  Can anyone help me with this report. I can bind the datatable with a datagridview and I see data, however when I try and see it in the viewer I see no data, only a formatted report. Thanks. Dim params() As ReportParameter = New ReportParameter(1) {} params(0) = New ReportParameter( "YearIn" , "2006" , Visible) params(1) = New ReportParameter( "WeekIn" , "23" , Visible) ReportViewer1.LocalReport.SetParameters(params) Dim rds As ReportDataSource = New ReportDataSource Dim mystr As String=...... Dim mycon As SqlConnection = New SqlConnection(mystr) Dim mycmd As SqlCommand = New SqlCommand( "spsWeeklySalesReport" , mycon) mycmd. ...Show All

• Visual Studio Express Editions How to determine when IE page is fully loaded

  In a web page with frames the check wb.ReadyState < SHDocVw.tagREADYSTATE.READYSTATE_COMPLETE is not sufficient, because any frame can trigger it before the page been fully loaded. The following Microsoft article explains how to do it in pages with frames: http://support.microsoft.com/kb/q180366/ In particular, it seems to say that for Visual Basic the code required is simply: Private Sub WebBrowser1_DocumentComplete(ByVal pDisp As Object, URL As Variant) If (pDisp Is WebBrowser1.Object) Then Debug.Print "Web document is finished downloading" End If End Sub I have tried it and it does not seem to work. I do not understand the code: pDisp Is WebBrowser1.Object WebBros ...Show All

• Visual Basic searching for & highlighting text

  hi, i am trying to make my application search for text (in a combobox called "comboboxfind") in a listbox ("showbox") when i click on a button (called "findnow") can someone help me Private Sub FindNext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FindNext.Click Dim loc As New List(Of Integer) Dim index As Integer = 0 If loc.Count = index + 1 Then FindNext.Enabled = False End If ListBox1.SetSelected(CInt(Val(loc(index))), True) index += 1 FindPrevious.Visible = True CommandsFindPrevious.Enabled = True End Sub ...Show All

• SQL Server Security Part 2

  I think I'm having problems because I don't really understand "Windows Authentication". I've looked on the web and haven't seen any real explinations. As an example, If I have 3 computers 1.ServerBox (xp pro) with SQL express (using Workgroups not Domains) 2 Laptop1 3 Laptop2 ServerBox and Laptop1 connected with cat5 or Wirless..Works fine. Laptop2 connected with wirless. I see laptop2 in the serverbox "Network Places-Workgroup" on the serverbox Laptop 1 has xp pro and uses sql authentication for "instance, db, usernane and password". Logging in is no problem (I use SQL authentication in connection string) Laptop 2 has xp home edition and dosn't have to log in. I have the machine nam ...Show All