RockyMountainer's Q&A profile

• SQL Server Parameter validation

  Hi, How would one do a parameter validation. For ex: I have a date start and date end parameters to be entered by the user and the report gets generated depending on the user input. How would i validate the user entered date is acceptable .. your help is appreciated Thanks, Hi, You can write a function in VB language that validates the parameters.You have to write the function in Custom code which is under report menu.Report->Report Properties->Code.And You are using table to display the data.You can call the function in the Table Properties->Visibility->Hidden Like this:IIF(Parameters!StartDate.Value>Parameters!EndDate.Value,False,True); Otherwise:Another way for Dates validation is when you enter Startdate ...Show All

• Visual Studio Express Editions Moving Line

  Here's the code that I'm using, the idea is that a line is drawn the width of the Rectangle and moves down to the bottom of the Rectangle, I've had this working but after adapting the program to work with advice from a previous post it no longer works. Why is this Private Sub Pb_Paint( ByVal sender As Object , ByVal e As System.Windows.Forms.PaintEventArgs) G.DrawRectangle(myPen, Rect) e.Graphics.DrawLine(myPen, Rect.X, Rect.Y + Y, Rect.X + Rect.Width, Rect.Y + Y) If Y = Rect.Height Then Timer1.Enabled = False Me .Cursor = Cursors.Default End If End Sub Private Sub Timer1_Tick( ByVal sender As System.Object, ByVal e As System.EventAr ...Show All

• Visual Studio Tools for Office "Microsoft Visual C++ Runtime Library" error

  Since yesterday, my document customization created using VSTO 2005 causes an error to pop up in Word 2003 whenever I close the customized document: ------------------------- Title: "Microsoft Visual C++ Runtime Library" Body: "Runtime Error! Program C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information." ------------------------- With an OK button. If the document is saved before I close it, all of my changes are saved (including [Cached] fields), but if I choose "Yes" to save an unsaved document after clicking close, the save process is interrupted and the d ...Show All

• Software Development for Windows Vista TaskFolder.DeleteTask always returns Access Denied

  Vista Beta2 Build 5384. The following always fails with Access Denied: Set service = CreateObject("Schedule.Service") call service.Connect() Dim rootFolder Set rootFolder = service.GetFolder("\") rootFolder.DeleteTask("task name", 0) Using the Task Scheduler MMC I can delete the task. The task was created by the same user as the one running the script. Any ideas ...Show All

• SQL Server Importing / Exporting Data using ssms

  I have installed ssms, and the toolkit. When I right click on a database I don't have Import/Export under tasks. However I do have C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe installed and can invoke it manually. What do I need to do to get it to show up in tasks yep.. installing the Microsoft SQL Server 2005 Express Edition Toolkit will actually install the DTS related binaries.. both runtime and wizards.. in this case, you seems to be legally legitimated to use it... Mike regards ...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

• Visual Studio Team System Make AreaPath field required.

  Why is it not allowed to make the AreaPath field required In the Process Guidance for Agile I find the following definition of the Area field for the Bug workitem. "The area is used to group the bug by feature or team in the project hierarchy." I think this field should be set for every bug in order to allow good management of bugs and hence it should be required. I like the tree-view of the Area as well as the fact that it can be defined from within Excel or Project, but the fact that it can not be made required makes it useless for me. I now have to use different string-fields with (awfull, time consuming and not very manageable) long lists of when-clauses to force users to specify the foc ...Show All

• .NET Development deploying security policy

  Hello everyone, I'm trying to deploy a code group and permission set I created into a setup project. I've tried 2 different thins with no avail: 1. Under .NET Framework 2.0 Configuration, right click on Runtime Security Policy, Create deployment package. I followed the 2 step wizard only to create an MSI file that when executed nothing happens. It never asked me what code group to deploy either. 2. I want to run a script that I can execute on an MSI file. So I decided to use caspol. According to the documentation in order to create a Permission Set with caspol i need to use an xml file with the definition. That is great, but I don't have an xml file and I don't know how to export my permission set into an xml either. I couldn't ...Show All

• Visual Studio Team System How do I source control a website for multiple developers?

  OK, I'm officially stuck, and starting to get a bit rattled. I'm trying to bring up Foundation Server to provide source control on a web site that will have multiple developers working on it. I've successfully created a new Team Project. I've added the existing files to a new 'File -> New Web Site...' web site that I want included in the project, and have successfully checked them in. Now, when I got to open the project from source control, it can't find a .sln file to open...which makes sense, because the .sln files are not held in the same folder as the "real" files, and I've not figured out how to change that situation. Effectively, I've got a project with no solution file, so I can't open up the source controlled files. No ...Show All

• .NET Development How do I pass a variable for the sheetname parameter of the "Insert Into" command?

  I have a spreadsheet with 5 worksheets each named after one of our plants. The Insert Into command works fine with the sheet name hard coded in but I need it to use a variable (sPlant) How do I re-write this line so it will use that variable for the sheet name Thanks Private Sub Add_Record( ByVal source As Object , ByVal e As System.IO.FileSystemEventArgs) Dim en As New CultureInfo("en-US") Thread.CurrentThread.CurrentCulture = en Dim uFile As String = e.Name Dim TheDate As String = DateTime.Now Dim sFolder As String Dim sPlant As String Dim sFile As String Dim iUpper As Integer Dim PathPiece() As String = uFile.Split("\ ...Show All

• Internet Explorer Development OLECMDEXECOPT_DONTPROMPTUSER no longer working with IE7 final?!?

  I updated all of our systems last night and this morning I was suprised when I went to our FAX server and discovered 50 some odd print dialog boxes. After some investigating, it seems like OLECMDEXECOPT_DONTPROMPTUSER is no longer working(one of my applications sends nightly status reports to customers, it renders them in HTML and uses IE to print out to Server 2003's FAX printer). Upon clicking "Ok" 50 some-odd times, each one FAXed correctly. Here's the chunk of code that prints: ' Print File In IE Without Promting @ http://www.cygwin.com/ml/cygwin/2003-02/msg00911.html Set ie = CreateObject("InternetExplorer.Application") ie.Navigate(MyDocumentPath) READYSTATE_COMPLETE = 4 Do ' wait until page is loaded WScript ...Show All

• Visual Studio Tools for Office Creating xll files (excel library files) in visual c++ 2005 express

  Hey. I know this forum isn't specific to excel, but I haven't gotten any responses from the excel.programming newsgroup so I thought I would try here. I am trying to create xll files for excel so I can use my existing c++ code to do custom functions through excel. I have a book which explains the basic ideas, but it says to include xlcall.h and xlcall32.lib from the excel 97 sdk. These files won't compile in visual c++ 2005 express. i was wondering if anyone knew where to locate equivalent files which would compile in visual studio 2005 express, or any good resources on using visual c++ 2005 express to create custom functions for excel using xll files. Thanks. Hi, We do not discuss XLL development in th ...Show All

• .NET Development Problem with reading binary data from database, too much memory

  i'm using OleDataReader to read image column type data from Sql Server and Access DB. The problem is every time i get the reader with OleDbDataReader reader = command.ExecuteReader(CommandBehavior.SequentialAccess); i can see from the task manager the memory goes up to the size of the data i'm reading. and when i access the reader System.IO.FileStream fs = new System.IO.FileStream(path, System.IO.FileMode.Create, System.IO.FileAccess.Write); System.IO.BinaryWriter bw = new System.IO.BinaryWriter(fs); byte[] buffer = new byte[bufferSize]; long pos = 0; long l = 0; while ((l = reader.GetBytes(0, pos, buffer, 0, bufferSize)) > 0) { bw.Write(buffer, 0, (int)l); bw.Flush(); pos += l; } the memory goes up to 3 times of the ...Show All

• Microsoft ISV Community Center Forums Excel shape classname in Windows API

  Here's something I've been trying to find for a couple of days without success. I need to know what the classstring is for the excel shape object that you get when you add a pictures from a file... anybody :) The way I've understood it, every object has a classname and so should the shape object, but I can't find it. If I'm mistaken, please let me know! ...Show All

• SQL Server Missing Data Mining provider in Management Studio Linked Server definition

  I'm trying to define a linked server using Microsoft OLE DB Provider for Data Mining Services. MSDMine data provider is missing. Do you know where I can get this Thanks in advance. I'm have a Xeon 64bit proc. using SP2. And had installed: SQLServer2005_ADOMD_x64.msi, SLQServer2005_ASOLEDB9_x64.msi,SQLServer2005_OLAPDM_x64.msi, and SQLServer2005_XMO_x64.msi. The OLEDB provider for Analysis Services 2005 (which should be used for Data Mining) is MSOLAP, not MSDMine. MSDMine is the old AS 2000 provider. Some details on executing queries in SQL, with a linked server, can be found in this article (Executing predictions from the SQL Server relational engine): http://www.sqlserverdatamining.com/D ...Show All