white2grey's Q&A profile

• Microsoft ISV Community Center Forums MS Access VBA: How to solve the problem, when i using the ADO [Error 3021]?

  When i using MS Access ADO recordset to retrieve the Field Name that prompt the error message (Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. 3021. Who can help me to solve this problem '****************************Code Start************************************ Sub Export_Excel_Report(ByVal cnndb As ADODB.Connection, _ ByVal rs As ADODB.Recordset) Dim objXls As New Excel.Application Dim rst As New ADODB.Recordset Dim str As String Dim strSQL As String Dim strSQLTemp As String Dim i As Integer, z As Integer Dim intRcd As Long str = rs.Fields(0).Value strSQLTemp = "SELECT [F1], [F2], [F3], [F4], [F5], " strSQLTemp = strSQLTemp & "[F ...Show All

• Software Development for Windows Vista Calling CreateProcessAsUser() from service

  According to some MS documents (e.g. http://www.microsoft.com/whdc/system/vista/services.mspx), it should be possible to use CreateProcessAsUser() API in a Vista service to create a process in user session. I am trying to achive this, but the function returns error code 1307 (ERROR_INVALID_OWNER) = "This security ID may not be assigned as the owner of this object." Does it work for somebody Many thanks in advance. The TS session in which the process is started will be based on the session id of the token passed to CreateProcessAsUser. If the token is for an interactive logged on user, it should already have the correct session id. The windowstation/desktop can be specified in the STARTUPINFO ...Show All

• SQL Server xslt filters on xml output. cdata-section-elements and omit-xml-declaration problems.

  Hi All, I'm using some xslt documents to transform the xml output of my Reports but have come across two curiosities where the xslt filter seems to behave unusually. Firstly, I need the final saved file to have an xml declaration, which I believe it should do by default. Even if I put omit-xml-declaration="no" in the xsl:output tag I don't get an xml declaration. At present we have a custom job that writes these declarations back into the xml after SRS has saved it. Secondly and more importantly, I need to have some of my output tags wrapped in CDATA sections. I've tried using the cdata-section-elements attribute, again with no luck. my XSLT looks something like this (simplified for space) < xml v ...Show All

• Visual FoxPro Problem trying to create an Encryption Library

  I have followed the example for creating a C# Encryption Libary, but receive numerous errors with regard to no overload method ' ' requires 2 arguments, I have verified that my code is exactly as the example provided by microsoft and found no difference. Has anyone ever tried this code and had problems. Is there any other code to create an encryptoin library in C#. I would appreciate any and all assistance. I am responsible for figuring out how to encrypt the connection string for our web config files in Asp.net page. (we dont' have the .net 2.o framework, we are using Visual Studio 2003 with 1.x framework Thanks Heather In Console application Main method, you have to replace cipherText = enc.Encrypt(plainText, ...Show All

• Visual C# Input Message Box in C#?

  Is there any control like an Input Message Box (users of VB would recognize this) I need a pop-up in the same form (pop-up not being a seperate form or a MDI child) for the Login Id and password Any Suggestions thx in advance, HI, U can try out this thing......... Response.Write( "<script>alert('Enter Your Message Here')</script>" ); ...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

• Microsoft ISV Community Center Forums How to fill worksheets with HTML

  Hi guys, I have a workbook which holds approx 5 worksheets, every sheet is a result from a transformations (XSLT). I've written a vba code that turns this transformations in html outpurs, now I'm desperally wondering to distribute every html result in each different sheet. Maybe I'm probably clutching at straws but, if you don't ask you don't get. In my VBA this string (sHTML) gets the transformation XSLT in an HTML format sHTML = xmlDoc.transformNode(xslDoc) I already tried this Application.Goto Plan1 ActiveCell.Value = sHTML ...and this Plan1.Range("A1", "E10") = sHTML But nothing fills this HTML output in one of my worksheet. Will be this impossible to do I just ha ...Show All

• .NET Development How do I control Windows service application from external program?

  Hello, I hav a task of creating Windows service which has some GUI for configuration data used by service. So I plan to have 2 projects in solution - Windows service itself and frontend manipulation program. How do I attach from within a program to Windows service and how do I call events inside Windows service to reread configuration file once changes are made Thanks, G You need to work with ServiceController class to do this, SQL agent of SQL Server is the best example at hand for service manager, So you need to create a Service Manager using Service Controller class who may sit in the System Tray etc... Best Regards, ...Show All

• Visual C# Make Line as object

  The line I have drawn does not behave like a object. Can anyone suggest me the procedure to make lines to behave like a object   theblueeyz wrote: Or even easier, just use a label 3 pixels high with border set to Fixed3D and no text.  You can move it around and use it as an object but you won't have to write your own. That's the solution for making separator lines, as seen on many dialogs. To mimick these, 2 pixels height and additional AutoSize=False is a way to go. However, drawing colorful, diagonal, etc.. lines, calls for alternative approach. Also, using a custom control seems a bit more lightweight solution... Andrej ...Show All

• Windows Forms Treeview dragdrop event ignores exceptions! HELP

  Hi, I have a windows.forms application in C# using a treeview with dragdrop capability, however I have found when an exception occurs in the DragDrop event and is unhandled, .Net ignores it (instead of showing the exception dialog) Attached I have some test code where I explicitly throw an exception in the DragDrop event, nothing happens! Any ideas thanks Brian public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void treeView1_DragDrop( object sender, DragEventArgs e) { throw new ArgumentException (); } private void treeView1_ItemDrag( object sender, ItemDragEventArgs e) { DoDragDrop( "!" , DragDropEffec ...Show All

• SQL Server Hw can the cube be modified after deployment?

  Hi, We used cube in our project. And the project is released to production environment. Now we need to modify the cube. Can anyone have any idea what are the ways we can handle this Appreciate any suggestion. Sachin! We have deployed product at many client locations. Now we need to add few things to the cube But it is not feasible to go and change manually at all locations and same time client may not want that. We are looking after creating an update for the product. Now the question is how to update cube One option is delete existing cube and create again with new xmla script and process cube. Can you please suggest any other way to do so ...Show All

• SharePoint Products and Technologies unable to define Content Source Type --> Business Data

  Hi! I am trying to add new content source of type Business data. Followed MSDN article http://msdn2.microsoft.com/en-us/library/ms499640.aspx Business Data option is not listed in Share point 2007 central admin page "Add Content Source" Shared Services Administration: SharedServices1 > Search Settings > Content Sources > Add Content Source What am I missing Thanks Never mind. I have "sharepoint server 2007 for search". I guess what I need is "Sharepoint Server 2007" http://msdn2.microsoft.com/en-us/library/aa981559.aspx Thanks ...Show All

• Smart Device Development Question on DRK

  I am currently using Visual Studio 2005 Professional Edition. I looked at the link for Windows Mobile 5.0 Developer Resource Kit and ordered the free copy but have not installed it. I was wondering, do I need to install the Windows Mobile 5.0 Developer Resource Kit if I already have the Visual Studio 2005 Professional Edition NETCF V2 SDK (which doubles as end user redist) will be installed by VS (unless you choose not to include device project support). PPC 2003 and SP 2003 would also be installed. AS and WM 5.0 SP/PPC SDKs are up to you to install. If you planning to create NETCF V1 projects you’d need to install .Net Framework 1.1 and .Net SDK 1.1. ...Show All

• Smart Device Development VS2005, CF2.0, C++, Platform selection

  My development environment is Visual Studio 2005 Enterprise. I have a C++ application containing both managed and unmanaged code. I've successfully compiled it for the Win32 platform. It executes correctly in that environment. The next step is to install it on a CE 5.0 using the Compact Framework (2.0, sp1 installed.) I cannot figure out how to switch VS from the Win32 platform to any other platform without losing the C compiler switches that enable it to use managed code. My process: 1. Using wizard, create a new solution/project for C++, Console Application (which is the model I want to use.) 2. I immediately "Build". All is well. It says "Hello world." 3. I select Configuration Manager, and choos ...Show All

• Visual Basic How to open a CSV text file and import that data to a database?

  I work for a medical billing and accounting firm and we get these massive medical reports that are not sorted. What I am trying to do is write a program to add these reports to an Access database so that i can recreate the reports using crystal reports. I already have a system in place to sort add these reports to csv files and importing those files into a database and then refreshing a Crystal Report I already have setup with the new data. My goal for this program is to be able to open the program select a csv file, import that file to a access database, then generate a crystal off the updated database. Where I am having trouble is getting that csv data into the database. Any help will be greatly appreciated. ...Show All