Jones Christopher's Q&A profile
Microsoft ISV Community Center Forums Validation with List drop down?
Hi I want to add some simple validation to my Excel sheet but can not for the life of me remember how to do it! Basically i have a drop down list as in the image below and want so that when 'No' is selected, the user is forced to enter the reason in the next cell http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_list.jpg I can remember doing this before and used some VBA code but can not remember how i did it :( Please put me out of my misery! Thanks... Hi Below is from the macro recorder. I picked data form the menu then validation then selected list, and typed my two options separated by a comma Range("K8").Select With Selection.Validation .Delete .Add Typ ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Getting my application to run on someone elses computer
I just tried to get my version of my program to run on another computer. The application fails to start up because it fails to find d3dx9_30.dll. The person has on there computer direct X 9c runtime installed. So my question is how do I make my application so it can run on anyones pc who already has direct X 9 installed Will I need an installation program to ensure the person has this file Or can i get by with changing the compile settings. Or can i include d3dx9_30.dll in with the application Using Visual Studio 2005 and direct X 9c I have direct X 9.0c(4.09.0000.0904) installed and the SDK i'm using is the June 2006 edition. I could upgrade both using the Febuary 2007 release of the direct X SDK ...Show All
Gadgets using webservices in a gadget
Hi, Has anyone have an example of using a web service in a gadget Thanks in advance, rudgr Hi, you can use wbservice bahavior http://msdn.microsoft.com/workshop/author/webservice/using.asp which is old news but it works in simple cases or you can use XMLHttpRequest object or just use some already made soap client library like this one: http://www.codeplex.com/Wiki/View.aspx ProjectName=JavaScriptSoapClient Niko ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Viewport depth buffer / draw order issue?
Apologies in advance if this question has been covered elsewhere. I've searched through literally hundreds of posts here, but couldn't find anything relevant to my issue. I'm working on some code to simultaneously display a 3d model from several different camera angles in several different viewports. Unfortunately, I've run into a rendering problem whenever I draw the model in a viewport. For reference, here is a perspective rendering in 3DS Max of what the model looks like: http://www.hph-tech.com/modelPerspective.jpg This is a screenshot of the model (as seen from above) when I render it normally (i.e. not in a viewport): http://www.hph-tech.com/modelNormal.jpg And this is a screenshot of the model from the same angle, but when rendered ...Show All
Visual Studio Add Reference Dialog does not show all assemblies of the GAC
Hi! I have installed .NET Framework 3.0 Redistributable Package. The framework installed successfully and I am able to see the assemblies (e.g. PresentationCore) in the GAC. Visual Studio 2005 Professional does not show the new installed assemblies in the "Add Reference" dialog. What do I have to do that I am able to use the new assemblies thx, Juergen P.S. I thought the "Add Reference" dialog should show all assemblies of the GAC. juergen.b wrote: P.S. I thought the "Add Reference" dialog should show all assemblies of the GAC. A common misconception. See http://support.microsoft.com/kb/306149 ...Show All
Windows Forms Setting Currency format on a DataGridView
Hi, This question might seem very basic to most of you. Not for me it seems... How can I set the following currency format "$9,999,999.99" for one of my DataGridView column I would also like this same column to be right justified. By the same way, how can I set a TextBox control to handle currency number format I already tried the MaskedTextBox control but really don't like the "$ ________.__" allways showing because of the mask. I would rather expect an empty textbox from start and then the number showing with the "$" at it's left as the user is typing it. Am I dreaming Any good trick or article on the subject Thanks in advanc ...Show All
SQL Server User initiated backups
During the month end close the accontants want to have their SQL2000 databases backed up before they run certain processes. We (IT) run the backups using the SQL management console when they call. Is there a way we can allow the users to start a backup without giving them access to the SQL management console We already have end of day backups scheduled automatically. The requirement here is to backup the database whenever the accountants have completed certain procedures during the close so I can't have them run on a seet schedule. ...Show All
Visual Basic What Language to Use
I was wondering if you guys could give me your advice on something. I want to create a few applications for Windows (maybe even add some special Vista only things). Problem is I'm not sure where to start with Windows development. The only applications with GUIs that I've ever created involved Java (3 years experience), C, and a bunch of web based languages. When it comes to Microsoft Windows I'm not sure where to start. I'm more than willing to learn a new language to develop Microsoft apps, just not sure which is the best one. Any suggestions Thanks, **I do have a full (legal) copy of Visual Studio 2005 && 2003 BlueMikey wrote: Though VB is fun to learn after already being an ...Show All
Visual C# I have a question in nested structures
I I have a question in nested structures: struct s1{ i nt x; i nt y; }; struct s2 { struct s1 var[10]; i nt p; i nt q; }; struct s2 nested[100]; Is "struct s1 var[10]" is a correct construct Thank you. This is a C# forum which is very different from C. You are in the wrong forum if you want help on C. ...Show All
SQL Server doctors' appointments - please advise
i am developing a clinci software and i guess i reached to the most difficult part of it which is the appointment module.. I have made it as explaied below but not sure if i am doing it the right way or if i need to redesign my tables' structure.. please advise.. i have create doctors' duty table: USE [shefa] GO /****** Object: Table [dbo].[staff_duty] Script Date: 11/16/2006 02:25:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[staff_duty]( [duty_id] [int] IDENTITY(1,1) NOT NULL, [staff_file_no] [int] NULL, [staff_name] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [duty_from] [datetime] NULL, [duty_to] [datetime] NULL, [record_locked] [varchar](50) COLLATE ...Show All
Visual Studio Express Editions audio question
My .Computer.Audio.Play( My .Resources.mantovani, _ AudioPlayMode.Background) the above works fine but I am trying to open this file with the embedded Me .AxWindowsMediaPlayer1 control I have tried everything......can u help See my last post at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1070124&SiteID=1 (And be sure to fix the long lines that the forum wrapped!) ...Show All
Visual Studio 2008 (Pre-release) namescope and resources
when the xaml is parsed and the namescope is built I can access the names directly using c# without the need to traverse the element tree as they are part of the root element. However I cannot access the names of objects that are part of a resource element, such as viewport.resources or grid.resources. Instead I have to set up a variable and 'Find' the name in the resource before assigning it to the c# variable. I have looked at the documentation for this but not found anywhere that explains why resource objects are treated differently than non-resource objects. My only guess is that although the resources are named and have been parsed they are effectively outside of the namescope as they are not considered 'active' until called ...Show All
Visual Studio 2008 (Pre-release) Z-order
Is z-order (relative to canvas) something I should set explicitly in this version of FW as well Tamir, By default the child elements in a panel will be rendered in the order they exist in the Children collection. If all of the child elements visually overlap (i.e. occupy the same space) then the last child in the collection will appear "on top" of the others. You can use the attached ZOrder property of Panel to affect the order in which the child elements are drawn. For example, if you set the ZOrder for the first child element in a Children collection, it will appear on top of the other children. This does not move the element in the Children collection, it just modifies when the element is rendered. The WPF does not se ...Show All
Windows Forms using this code i am opening ms outlook but in place of body i need to
If ComboBox1.SelectedItem = "Outlook E mail" Then Dim theStringBuilder As New StringBuilder() theStringBuilder.Append( "mailto:someone@somewhere.com" ) theStringBuilder.Append( "&subject=my subject" ) theStringBuilder.Append( "&body=my body message" ) theStringBuilder.Append( "&attach= C:\myfile.ext" ) System.Diagnostics.Process.Start(theStringBuilder.ToString()) End If using this code i am opening ms outlook but in place of body i need to give an .doc file can any one help me how to do Rajesh batchu wrote: If ComboBox1.SelectedItem = "Outlook E mail" Then Dim theStringBuilder As New StringBuilder ...Show All
SQL Server Package changes made and saved revert to prior state when package closed and re-opened
I copied and added an existing package as a new package to a project and have been having trouble with settings reverting to those for the original package after I modify and save the changes for the new package. Sometimes happens with the save itself, other times it happens when I close and re-open the package. Most cases are with connections that revert back to the original file reference, but there are also control flow and data flow elements that keep reverting back to either settings from the original package or defaults that result in the re-opened package being in error. Not sure how to get around this issue short of developing the new package from scratch which I'd rather not do since it is fairly complex. Any help anyone can provi ...Show All
