Joe Hatfield's Q&A profile
Visual Studio Express Editions Clipboard Help
Hello all, good morning :) need some help with this one please: I have 6 textboxes on my form. I need to assign each textbox with a shorcut key (eg. alt + 1, atl+2 etc..) and then copy the contents to the clipboard. I take it that I would have to put the code in a timer event & would the shorcut keys still work even if the form is not displayed on the screen Thanks, Stuart Tb=sender.text should be Tb=sender ( I apologize for that !!!!!) What this really does is to establish TB as a pointer to a textbox e is a small class of event specific arguments. Your welcome.... ...Show All
Software Development for Windows Vista Actions missing in VisualStudio Toolbox
Hi, I'm totaly newbe on workflow. I have coded some events on a SharePoint list that I now would like to convert to Workflow Fundation. I have loaded and installed "Visual Studio 2005 Extensions for Windows Workflow Foundation Beta 2_2(EN).exe". but then I try to build a Workflow it seems like I'm missing a lott of 'Actions' in 'Windows Workflow' tab in the Toolbox of Visual Studio, i have only 8 actions. What have i done wrong /MatsL Problem solved, I installed 'Visual Studio 2005 Extensions for Windows Workflow Foundation RC5(EN).exe' in stead of 'Visual Studio 2005 Extensions for Windows Workflow Foundation RC5(EN).exe'. Worked much better. /MatsL ...Show All
SQL Server Create Percentage Calculated Measure... Getting the current Dimension
Hello, I created a cube for surveys and would like to create a measure for the percentage of people (surveys) that answered Q1, Q2, Q3, etc. I have the following calculated member: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ CREATE MEMBER CURRENTCUBE .[MEASURES].[Percentage Answered Q2] AS Case // Test to avoid division by zero. When IsEmpty ( [Measures].[Surveys Count] ) Then Null Else ( [Q2].[Units]. CurrentMember , [Measures].[Surveys Count]) / ( // The Root function returns the (All) value for the target dimension. Root (), [Mea ...Show All
SQL Server Granting UPDATE for only certain columns in a table
I have tried using the SQL statement shown below to grant UPDATE permissions for a single column in a single table to a user with db_datareader privileges. grant update (col_1 ) on trs . dbo.table_1 to calc When I then run a SQL script that has an UPDATE for col_1 on trs.dbo.table_1, I get an error message Msg 230, Level 14, State 1, Line 2100 UPDATE permission denied on column 'col_2' of object 'table_1', database 'TRS', schema 'dbo'. Why is the error message referring to "col_2" when my SQL statement is trying to update "col_1" When I performed the "grant" I did it with an account that has db_owner, db_securityadmin, and db_ddladmin privileges. This worked in SQL Server 20 ...Show All
SQL Server ODBC Connection failure
Hello there! This is my issue: I do have a database which back end is in SQL Server 2005 and front end is in ACCESS 2003. When one of the forms is trying to write duplicate information in any of the tables, there is a message coming "ODBC -- call failure", I wrote code trying to avoid that situation, but is keeps on coming. Does anybody have any idea about how to handle this exception I would really appreciate a help on this subject. Thanks; Luisofo One approach is to add an On Error handler to the Access Form. http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbaac11/html/achowRuntimeErrorHandling_HV05186924.asp In the On Error handler you can use the Err object to determine the source of the erro ...Show All
Architecture Load Balancing MSMQ
Hi, Currently I'm using Microsoft Cluster with MSMQ for high availability. I have two machines configured under Microsoft Cluster and share a virtual address. All my queues reside in these machines. Both sending applications and recieving applications using the virtual adrress of the clustered machined to communucate with queues. The major downside I see in this kind of configuration is the downtime upon failure in the active node, when the cluster switch to the other node it takes up to several minutes for all the resources to come online again on the other node. It seems to me that load balancing solution will have no downtime in case of a node failure. What will be the best practice to load balanced MSMQ Does someone has an ...Show All
SQL Server Delete sys.Transmission_Queue
I have seen this buried deep with the questions on Service Broker, but I am looking for it again. How do you delete all records from your sys.Transmission_Queue. This is on a test server and I want to clean it before some more test. ...Show All
Windows Forms simple reinstall
I am just beginning with Setup projects. I created a setup project that works fine for my app. I as develop the app and release new versions, I would like to be able to install the new version directly over the old of by having the installer simply overwrite the files it installed in a previous version. As of now, it says another version is already installed and to use Add/Remove programs to remove it first. Is there a simple way around this Thanks. I was changing that property along with the product code when prompted with the RemovePreviousVersion set to true and it wasn't removing the old version's entry in the add/remove program (ARP) window. Once I rebooted it seemed to have fixed something on my PC a ...Show All
Visual Studio 2008 (Pre-release) UserControl
I am building a custom user control containing a grid that contains a label I want to be able to set via a property ShowHeader to set the visibility of the first row of the grid. Can anybody point me where to look or help me out I have named the Grid using the name attribute (in .xaml) but I dont see any of the controls in .xaml.cs .... .XAML < UserControl x:Class = " Sharp.Base.CookBook.Forms.Controls.WPF.ucIngredient " xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x = " http://schemas.microsoft.com/winfx/2006/xaml " > < Grid Name = " grdMain " VerticalAlignment = " Top " HorizontalAlignment = " Left " > ...Show All
SQL Server Output Varchar column
Hi, I am dumping varchar(40) column from a OLE DB Source to Excel file but it is failing due this error [Excel Destination [239]] Error: Column "ItemDescription" cannot convert between unicode and non-unicode string data types. How can I resolve this issue Thanks On my package, I'm importing a text file to a table. I also have to export to excel, to check the data later. I have 50 columns of many data types and when i export to excel, i have to convert all this columns to Unicode_String. Is there some way to convert a lot of columns to a same data type If i could in the Data_Conversion component select all the columns and change the data type, the problem already would be solved, but i can't. If you knows a ...Show All
.NET Development Control Telnet Client from Process Object
Has anyone been successful in controlling the XP telnet.exe or Putty's plink.exe from a Process object I can run DOS commands and other applications with redirected input/output, but simply get a hung application when trying to run a telnet client. Does anyone have a simple example they could share, or another way of doing a simple Telnet connection Thanks. Exactly which formatting codes are you talking about I can't find anything about them in rfc854... ...Show All
.NET Development interop with events
Could someone help me out on this For brevity I will try and keep this initial post short - cut right to the problem. Further detail will be added as requested. The problem I figure is a simple one, but one i cannot seem to crack....yet. I have a simple .NET control, the code is given below, and is self-explanatory. Simply cut and paste it into a new VS2005 Visual C# Windows Control Library project - call it ...say... XDotNetControl To make this control COM-accessible go to the project's property --> Application tab, click Assembly Information and check "Make assembly COM-Visible". Then on the Buid tab, scroll to the bottom and check "Register for COM interop". Now build it - it will have entered all the ...Show All
Visual C# how to load datatable with xml
<tables> <row> <table_name>ticket</table_name> <record_key>68</record_key> </row> <row> <table_name>sales</table_name> <record_key>3001</record_key> </row> </tables> how can i load a datatable with above xml string How do we put the xml < a loan = " 1 " > < b Payee = " A " amt = " 300 " /> < b Payee = " B " amt = " 409 " /> < b Payee = " C " amt = " 390 " /> </ a > < a loan = " 2 " > < b Payee = " A " amt = " 200 " /> ...Show All
Software Development for Windows Vista LoadLibrary - AppVerifier error
Hi, I'm using LoadLibrary function in my project and on some conditions it causes an AppVerifier error. Here is the code sample: #include "stdafx.h" #include <atlstr.h> int _tmain( int argc, _TCHAR* argv[]) { CString strLib( "test.dll"); // test.dll is a sample empty dll library LPCTSTR lpcszLib = strLib; // to make sure LoadLibrary receives LPCTSTR argument // LPCTSTR lpcszLib = "test.dll"; // this works fine ( here lpcszLib is being placed in different memory location ) HMODULE hModule = LoadLibrary( lpcszLib ); return 0; } And the error is: < xml version="1.0" encoding="UTF-8" standalone="no" > ...Show All
Visual FoxPro GetFile
The statement lcFile = GETFILE([PDF],[Scanned doc],[Select document]) causes some machines to totally freeze up. Seems to affect Win2k machines and not XP or 2003. Statement is in a command button in a container in my vcx classlib. Used to work fine till I started building exe's on my 2003 server Any ideas AndyKr wrote: I think that Alex means that GetFile() is merely a wrapper around the Windows API call that opens Windows Explorer. Therefore the issue is nothing to do with VFP, but more likely to do with the WIndows system. Andy That's exactly what I meant. Maybe I did not make it clear. In re-reading, I should've said wrapper around the API. It is not Windows Explorer per se. I' ...Show All