PLechner's Q&A profile

• Visual Studio Tools for Office Shared Excel Worksheet on Sharepoint

  I am contemplating the purchse of VSTO to replace some vba on an excel spreadsheet. This vba connects to 2 datasources (SQL), enables a user to enter their name and retrieve only their data, make changes and save the changes (only change the spreadsheet data, not underlying data source). The idea is to put this in a shared workspace on SP Portal and have all 6 of the people update their data and combine for viewing by the VP. I have working but with vba it's megaslow...10 minutes or more to upload. Will VSTO solve this problem Can I use VSTO to write shared excel sheets and put them up on Sharepoint THANKS I have a deadline....:( ...Show All

• Visual Studio Express Editions Inheriting Form Issue in VB2005

  Hello All, As usual, I think I'm doing something that's not "Kosher" in trying to inherit a form to a new Item. I get a ton of errors including data connection, etc. The solution works and builds, publishes and all that, but there seems to be settins somewhere that are pointing the inherit function somewhere else. Please Help...I don't want to redo all of those controls and buttons again on the new pages. Thanks, Elgee... PS...Any ideas on how to map the numeric keypad to a masked textbox I can't figure out how to advance the digit after a mouse click...I can only get one digit to enter ...Show All

• Smart Device Development Keyboard Buffer

  I am developing an application using VB.Net for a Windows CE.Net v4.2 device. The device scans a barcode which my application parses. So far so good. What a want to do now is send the parsed barcode string to the keyboard buffer as if I'd typed the code using the keyboard. Does anybody know how I can achieve this You can use the OpenNETCF.Windows.Forms. SendKeys from SDF: http://www.opennetcf.org/sdf ...Show All

• SQL Server XML Search issue

  Hi, I have a table with a column as XML datatype. Pl find here the script below create table books( bookid int, bookdets xml) insert into books values (1, '<book><title>First Book</title><author>DSKC</author><publyear>2005</publyear></book>') insert into books values (2, '<book><title>Second Book</title><author>DVSK</author><publyear>2006</publyear></book>') insert into books values (3, '<book><title>Third Book</title><author>DSK</author><publyear>2005</publyear></book>') insert into books values ...Show All

• Visual Studio Express Editions How to you Abort a "Delete"

  I'm trying to figure out how to abort "Delete" in the BindingNavigator Delete Event Have spent hours getting nowhere. Please help! Here's some code I've been working with: Private Sub BindingNavigatorDeleteItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorDeleteItem.Click Dim ruSure As DialogResult ruSure = MessageBox.Show( "Are you sure you want to delete this item " , "Delete" , MessageBoxButtons.YesNo, MessageBoxIcon.Question) If ruSure = Windows.Forms.DialogResult.Yes Then What to put here Else What to put here ...Show All

• Visual Basic Seek Internet for Emails?

  Hello, Is it possible to seek / search the internet for emails and making code that can collect this ... Have been trying to search google for some help... Spiders / Bots ect would like some simple direction on coding this. This will also help to create an seach engine for topics that are needed in my database ect. searching key words online... Thanks to whom has  ago at explaining this to me. Binary ...Show All

• Visual FoxPro VFP8 Report Incrementing variable

  I need to create a variable that shows the current page number within a data group. it will need to reset to 1 with the rest of the data group. I tried doing this with the _PAGENO system variable, but this number is used somewhere else on the report for a 'Cumulative Page Count' and will also get reset. How can I accomplish this Thanks -Frank This is ugly but works: -For groups set "reset page number to 1 for each group" -Create a prg named 'IncTotPage' with code: If Recno()=1   totPage = 1 Else   totPage = totPage + 1 endif -Page header On entry add expression: IncTotPage() Run your report: totPage ...Show All

• Visual Basic Question about moving an app from vb.net 2003 to vs 2005

  I'll be getting my copy of vs 2005 this week and had a question about EnableVisualStyles and how that will work. I just recently learned about enablevisualstyles and have started to apply this to my app. However, vs 2005 has this turned on by defualt and draws the controls to correctly include this be default. Does anyone know what happens to visual styles when bringing an app from vb.net 2003 into vs 2005 I'm hoping that it will apply the correct visual style settings automatically, however I'm a bit optimistic about this. I have a copy of my app that does not have any of the visual style stuff turned on so maybe this one would work bett ...Show All

• SQL Server SQL Server Reporting Services Installation - Urgent

  Hi all, Wondering even any can help out with the problem below - I am getting an error when I am installing Sql Reporting Services on my web server. The error it gives is 'The domain account that you specified cannot be validated. Verify that the user name and password are correct, and that the account has permission to log on to this computer' Some Back ground Information -  -  The machine am installing it on is outside my network.  -  The sql server is inside my network which is using AD (Active Directory).  -  They both can see each other just fine.  -  They both are running wi ...Show All

• SQL Server MSSQL Server connectivity

  Hi, I have two Windows machines in the Local Area Network. One of the machines has MSSQL Enterprise Server 8.0 installed whereas the other has MSSQL Server 2005 installed. When I try to establish the connectivity between these two servers, I can not do so. When I try to look up Network servers, the two machines can't see each other. How can I make them talk to each other Is there some type of driver or some such thing to be installed which can help the matter Please let me know. This is certainly suspicious. I'm not expert on tempdb so I recommend you post this issue to http://forums.microsoft.com/ ...Show All

• SQL Server Is Metadata Report Tool Ready for SSIS

  We were promissed a tool to view, report, export or save metada information such as tranformation properties -- tables and columns used or mapped. Names of transformations, tasks control objects, etc. Is this tool available and why is Microsoft taking so long to deliver such a critical tool.  Keep cool... Google before complaining! It was delivered even before cristmas... http://www.microsoft.com/downloads/details.aspx FamilyID=11DAA4D1-196D-4F2A-B18F-891579C364F4&displaylang=en ...Show All

• Windows Forms How to display Child Form besides a tree-view column.

  Hello: I have a question of present tree-view control and a tree-node correspondent Child Form side by side in an MDI Form. I tried to use Split-Container with tree-view on the left side and wish the Child Form Window correspondent to the selected tree-node on the right panel. However, the Child Form can not be shown in the Split-Container panel. Would there be a way to design this User Interface Thank you very much for your possible ideas/suggestions/information James Yes, if you're setting this up on run-time. You can compose your Form containing three contr ...Show All

• Visual C# Export mail to outlook ?

  Hi - I've googled and I've asked before, but I've not found any clear examples. I want to send mail using .NET, but then place a copy of the mail into Outlook ( and as many versions of outlook as possible ), in the sent items. I want this to happen silently, with no user interaction. any help is greatly appreciated. You would likely be able to do it via COM interop (using the Outlook PIA) to drive Outlook to send the email. Another tactic would be to write an Outlook add-in that opens a .NET Remoting channel and listens. Your application could then determine if your Outlook add-in was listening and send email via the add-in, res ...Show All

• .NET Development DataTable's question in class ?

  Please tell me why I received errors when doing this: class MyClass : DataTable { public MyClass():base() { DataTable dt = new DataTable(); this = dt;// errors occur here, what can I do to let dt to "this" } } Thank you for your help. you cant reassign "this" if MyClass inherits DataTable this is already a DataTable, and Calling Base initializes it as a DataTable: class MyClass : DataTable { public MyClass():base() { Debug.Assert(this is DataTable); } } ...Show All

• SQL Server SQL Server 2005 Timeout expired exception

  Hi, I have a program in C# that I used to run on Visual Studio 2000 and SQL Server 2000 without any problem. Now I upgrade to VS2005 and SQL Server 2005 and get and exception while insert via SqlCommand.ExecuteNonQuery(). the insert is after many inserts to the same table by that program. the CommandTimeout is set to 600 (in the 2000 version I never had to change the default value of 30 seconds). the insert is through a connection that is kept open throughout the program for more than 30 minutes the exception message is: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not re ...Show All