Snick's Q&A profile

• Microsoft ISV Community Center Forums xlDialogPasteSpecial

  Hi friends, I can open PasteSpecial Dialog box with the Help of Following Code. Application.Dialogs(xlDialogPasteSpecial).Show. This will show the Dialog Box. But I want to Know what User Options does User selects in the PasteSpecial Box. Is there any Way Thanks The dialogs in Excel are not particularly interactive with VBA. The xlDialogSaveAs returns true if the file is actually saved and false if not, but in general you don't get much information returned from the dialogs. You might have to create your own userform styled after the Paste Special dialog, which then returns the user selections to the code, and then your code applies the appropriate paste special option itself. - Jon ------- Jon Peltier, Microso ...Show All

• SQL Server Multiple selects on PArameter drop down

  I have a parameter dropdown as USERID. I want a functionality that the user can selct multiple userid's to show more than one record as output for comparison purpose. How can i achieve this multiple select (i.e cntrl+click) within parameter dropdown. Thanks, Kiran. Sorry, I had assumed that you were running RS 2005. In Reporting Services 2000, a report parameter can only be defined to allow the user to enter a single value. Jarret ...Show All

• SQL Server SqlCeResultSet - Problem After Deleting First Record

  Hi, I've noticed that after the first record from a ResultSet is deleted, HasRows property throws an exception like "The current row was deleted." Method ReadFirst() throws similar exception as well. More details: 1. Create a ResultSet: ExecuteResultSet( ResultSetOptions .Updatable | ResultSetOptions .Scrollable | ResultSetOptions .Sensitive) 2. Let's say, there is no records in the resultset. Insert two new ones. Then call: ReadAbsolute(0); Delete(); HasRows; and the exception is thrown. 3. Then you can call ReadFirst() or Read with the same result. 4. Now call ReadAbsolute(0). It returns true. Call HasRows, ReadFirst() or Read() and you will get the exception each time. I tried to explain th ...Show All

• Software Development for Windows Vista Protected Registry key access under Vista.

  I have code which works on 2k and XP, which, when run under an administrators account, changes the permissions on a hardware/enum key in the registry so that we can make changes to a value for our device. Normally the local administrator does not have this access but creating a new DACL for the account, then opening the key with WRITE_DAC access and setting the new access allows opening the final key with write permissions. This has stopped working in Vista. Everything about the procedure including AllocateAndInitializeSid, InitializeAcl, AddAccessAllowedAce, InitializeSecurityDescriptor, SetSecurityDescriptorDacl goes off without a hitch just like under 2k and XP but then RegOpenKeyEx with WRITE_DAC access fails with Error 5 (Acess Den ...Show All

• .NET Development IPC Remoting Server and async events

  I have windows service that hosts a .NET Remoting IPC server. This server has several events that clients (a trayapp monitoring application) can subscribe to. I am using begin/endinvoke with a callback to execute these events so my service doesn't have to block while the clients are executing. The problem I am having is when my client application terminates improperly (crash etc), the event stays registered in the remoting server. When this event gets firied it will continue to call BeginInvoke on the delegate even though the client is no longer connected. It throws no exception and gives no indication that the client is down. How can I fix this aside from kicking up a thread of my own and calling the syncronous invoke and catch the excep ...Show All

• .NET Development only for server.transfer

  Hi, It is better not to make a control as public , instead create a read only property which returns the value of the control. This can be achieved only if you use server.transfer , In case of Response.redirect the thread will be closed so we can't get the data. The Code below is how to take the value. WebForm4 requestForm; requestForm = (WebForm4)(Context.Handler); Response.Write(requestForm.getName); ...Show All

• Visual Studio Team System Label does not pick file under the root directory !!!!

  Hi all, Here is the directory ProjA structure. ProjA -----folder1 -----folder3 -----folder3 -----folder4 -----file1.sln -----file2.doc -----file3.txt When I'm trying label $/Root/ProjA. for example, ProjA_1.0.0.0, from source control explore find label, open label by press edit. All I can see are folder1, folder2, folder3, folder4. File1.sln, file2.doc, file3.txt are not included in label ProjA_1.0.0.0. Did I do something wrong or missing some important step Best Regards, Are you sure that all files/folders in this folder structure are correctly mapped Try to make sure by opening file->source control->workspaces and check the mappings of your current workspace. ...Show All

• Visual C# Debugging a process which won't shut down

  Hi there DotNetters Forgive me for the vague description, but here is my situation: I have a third party component I'm calling into which causes my application to hang once its shut down. Basically when I call into this component at a certain point in my code and then shut down my app later the app "appears" to shut down but actually hangs around in memory running in the background. (Killing the process from the process explorer does work). The tricky part is that if I call into the third party component from other sections in my code I don't have the issue (of course other problems permit me from calling it from the "safe" areas). So here's my question, realizing that it's difficult to get a handle on this without actu ...Show All

• Windows Live Developer Forums Robot Invaders Contest - Who did you vote for?

  The robot invaders contest ( www.robotinvaders.com ) is closed for new entries, so all bots are in. A total of 51. With $40.000 in prizes, everybody of course wants to win. But which bot do you think will make a good chance The prizes: Grand prize (1): AlienwareR MJ-12 7550 Workstation First Prize (1): BoseR LifestyleR 48 DVD Home Entertainment System Second prize (5): AlienwareR Sentia M3200 System Third prize (10): GarminR nuvi 360 User's choice: 80 GB USB Portable Drive / DX1 Input System / LED Binary Watch The bot with the most votes on September 15th gets the user's choice award. It looks like that would be " samplebot@hotmail.com " with a total of 412855 votes! Amazing. Last time I talked to that bot though it could ...Show All

• SQL Server Server options are not being executed from local programatically code??

  Dear all, For example, executing a DTSX stored in a server, execution is fine and successfully but the log file attached to that DTSX is not created at all after the execution. Otherwise if I'm going to execute from the server everything is fine: log file is created and gathering the usual information. Let me know if exists any option for to enable this from the own DTSX. If I run local packages log files are created without problems. Thanks in advance, No. What is the path to the file I'm trying to determine if its a UNC: \\MyServer\Myfilelocation\Myfile.log or a local path: c:\Myfilelocation\Myfile.log -Jamie ...Show All

• .NET Development Primary key collision

  I am rather new to the web development but is currently working on a small project that would store the data on the production office output. As the part of it, the system will provide a form to insert the order placed. 1.The order is intended to have a unique OrderID key and would store several items with their respective qtys under the same OrderID. 2.This means that there will be two tables in the DB - Order and Order_Item in order to tie the order items to the orderID. I would be using a stored procedure to insert the data in the DB. 3. There is a need to identify repetitve orders within a certain period of time (i.e. 2 weeks) in order to avoid the duplicates. THEREFORE ------------------------------------------------------ ...Show All

• Visual Studio Tools for Office Word 2003 template document running exception "This action is not valid outside of a block-level XML" when used in Word 2007

  Hi I created a solution for authors to publish content on a website I created based on Word 2003 templates and VSTO 2005. You might download it here: http://www.codeplex.com/THBAuthoring Now I try to have it running on Word 2007 and get the following error when a user click on the save button or when I do in code document.Save: This action is not valid outside of a block-level XML Looking at the stack trace I have seen that it happens in Microsoft.Office.Interop.Word.DocumentClass.Save(), saying object reference not set to an instance of an object. I would appreciate any help. Thanks I was able to track down the source code part that is causing the issue. In the event handler ThisDocument_New I would like to inse ...Show All

• Windows Forms DataGridViewRadioButton Cell, Column

  Hi, i'm trying to use the DataGridViewRadioButton Cell, Column, but I need to show an Image instead of a string. Is there a way to do that Thanks Hi gqlu, I used this ImageandTextColumn stuff sometime back, this column first puts the image and then text can follow i.e. image appears on left of the cell, can you tell me a way by which I can shift the image to right. Urgently need an answer for this. ...Show All

• Visual Studio 2008 (Pre-release) LINE Preview for C# missing - during Visual Studio 2005 Project creation !

  Hi - I installed LINQ Preview (May CTP) on my machine today (LINQ Preview show-up in the Start-Program Files) and when I try to create a project in the New Project dialog, I don't see the 'LINQ Preview' entry at all. Is there something I am missing Do I need to have .NET Framework 3.0 Runtime for this (I tried this but for some strange reason this installation failed!) This is what I have on my machine Visual studio 2005 Team System, Windows XP (SP2), .NET Framework 2.0. I have only installed the C# components in my Visual Studio 2005. I am confused! Any help would be greatly appreciated. Thanks, Sanjeev Thanks keith for your response! I also tried that but still the LINQ Project is not ...Show All

• Smart Device Development Home screen plugin in Motorola Q

  I have compiled and successfully deployed the Smartphone Home Screen pluing memplug sample that comes with the Smartphone 5.0 SDK. Unfortunately on the Motorola Q this plugin does not work. I get an error "The layout that you have selected cannot be Installed ... " I can't read the rest of the message as it goes off screen and I can't scroll. The plugin was successfully signed and I run sdkcerts.cab on the device. I don't see any new certificates under Settings->Security->Certificates->Personal. Are these certificates supposed to be stored under personal or root Not sure if this is the problem. Has anyone been successful getting a Home screen plugin to work on the Motorola Q Thanks in advance ...Show All