borice's Q&A profile

• Visual Basic Free Add-Ins VSIP DVD.

  [I was hoping to add as a separate annoucement at the top of each forum area.]>> Hi everybody, You might like to get the FREE Add-Ins VSIP DVD, i've just got mine. See http://msdn.microsoft.com/vstudio/extend/partnerdvd/ for details. Regards, S_DS ...Show All

• Visual Studio Express Editions Application.StartupPath in DLL

  I often use Application.StartupPath in my applications. Now I want to use something similiar from within a dll but I can't find any code to do it. All I get is "Application" is undefined. I want to get the StartupPath of the application that calls the dll. Is it possible A code snippet would help. Roger The Application class is defined within the System.Windows.Forms.dll assembly and if you add a reference to it you will have access to it. Don't forget to add a 'using System.Windows.Forms' to the top of the file you are using Application.StartupPath in so that you do not have to type it's full name (unless you want to ). ...Show All

• SQL Server Best Practice Analyzer for SQL Server 2005?

  Hi everyone, a long time I was using a nice tool called "Best Practice Analyzer Tool for SQL Server 2000". I would be interested whether this product is or will be available for SQL Server 2005. Does anyone knows something about it Regards, StSt Hi, Microsoft is currently working on a BPA for SQL Server 2005. There is no release date known (at least not public). Just a little patience ;-) Regards ...Show All

• SQL Server count of null values in columns

  Hi, I would like to ask how can I get count of null values in each column together I know I can use COUNT(*) - COUNT(<col>), but I need to explicitly name every column in the query.... is it possible without it This still requires you to know col01 and col02 names. imagine table A B x NULL NULL NULL x NULL What I'm looking for is something like SELECT COUNTSofNULLSinCOLUMNS(*) FROM MyTable which would return 1 3 You know I need to not specify any column names since I don't know them. ...Show All

• Visual Studio Express Editions 'Excel Macro' converted to run outside?

  This may or may not be the right place for this. I have a little Excel Macro (created by trial/error and one *** load of searching forums) that converts a XLS version of multi-paged PDF into the data that matters. The PDF are Forecast worksheets, that lose all formats when made a CSV/XLS. So from a nice little 50 page PDF report it becomes 4000+ lines in Excel. Now I have the macro done that (that can be converted using VB Express - I only just found out about it) removes most of the ***, and condences it down to the answer (i.e. a 22,500 line XLS became 17 lines with the forecasts that did not balance). Ok, now the question: How can this macro be made more fool-proof Current idea's are: Convert to a DLL so that a user ...Show All

• Microsoft ISV Community Center Forums Open PDF file

  Hi everybody, I'm creating a program in MS. Access but I just want to ask:, how to open *.pdf(extension) file in visual basic access (vba) thanks in advance. :-) Hi sweet66 - sorry but ive been away for a while - yes that was exactly what my code did but it also allowed you to browse for the file and insert the path into datasheet view - a guy called Derek Smyth who is one of the fountains of knowledge on this forum helped me out with it - glad you got it sorted though. Rhys. ...Show All

• SQL Server Adding DataSet as DataSource to Report Published on Report Server from ClientSide

  Hi I am Creating Click Once Windows Application with Reporting Services 2005.I have created Report and Published on Report Server.In my windows application I am successfully able to view my published report through report viewer control. Now in my application I am getting a dataset from my custom webservice. I want this dataset data to be added to my report as datasource at runtime on Client Side ,as my report is on Report Server. waiting for help!! Thanks in Advance Pankaj You can dynamically set the data set using .LocalReport.DataSources.Add. If you look on http://www.gotreportviewer.com/ you will find examples to go by. You may also want to look into writing a custom Data Processi ...Show All

• SQL Server Deploy Reports via Visual Studio 2005

  This seems to be a basic issue, but I am having a problem trying to deploy a report to Reporting Services. I have setup the deployment options under the properties of the Project. But each time I try to deploy a report, I get "The request failed with HTTP status 504: Gateway Time-out" When I try to connect to connect directly to the TargetServerURL via a web browser from my client or the server itself, I can browse the structure fine. Not sure why I can't deploy via Visual Studio. Thoughts Thanks To localize the test, I put the system running the Visual Studio on the same subnet. It's wide open with NO ACL control or routing from that point. ...Show All

• Visual C++ Windows Media Player - Visual C++ Runtime Library

  OK...I am not sure if this is where I need to post this, but it looked like the place. I am running Windows XP I have been trying to open my Windows Media Player 10 and this is the message that I get.... --------------------------- Microsoft Visual C++ Runtime Library --------------------------- Assertion failed! Program: ...rogram Files\Windows Media Player\wmplayer.exe File: .\geiss.cpp Line: 509 Expression: hdc == NULL For information on how your program can cause an assertion failure, see the Visual C++ documentation on asserts (Press Retry to debug the application - JIT must be enabled) --------------------------- Abort Retry Ignore I have tried downloading WMP again, but nothing. The player was working O ...Show All

• Visual Basic Referring form objects

  Hi all, I'm converting a VB 6 exe project to a VB 2005 project. One main functionality in VB 6 that gives errors in VB 2005 project is as follows: In VB6, i have a initial form called frmApplication that loads up. There are two other forms Form1 and Form2. Based on the user settings, frmApplication then loads either Form1 or Form2. Form1 and Form2 differs only by appearance. What i mean, all the controls in both the forms are same including the name except there position of the control on the respective forms. When frmApplication is loaded, it creates a object of Form1 or Form2 depends on the setting and assigns to frmObject. Now in VB6, i access the controls in Form1 or Form2 in runtime using frmObject.lblName.Caption = ...Show All

• SQL Server Different results for MDX queries when using Attribute Hierarchies

  We receive different results for the follow 2 MDX expressions. The only difference is that the second parameter in the Where clause uses a separate dimension called Asset Class in the first query, whereas in the first it uses an Attribute Hierarchy dimension on the Asset dimension. The first provides the expected results which is the top 10 Equity assets, whereas the second returns just 3 Equity assets which belong to the top 10 assets overall. Can anyone explain this Using a cross join in the Topcount function works, but unfortunately ProClarity which we are using does not deal with this properly. Query 1 SELECT NON EMPTY { [Measures].[Value Base] } ON COLUMNS , NON EMPTY { TOPCOUNT( { [Asset].[Ass ...Show All

• SQL Server BUG: SSIS imported package errors with 'Guid should contain 32 digits with 4 dashes'

  I have imported a package using SSIS into the Maintenance Plan folder from another server. It imports fine, but when i Modify the package then click save I get the following error : 'Guid should contain 32 digits with 4 dashes'. This has been reported on other forums without resolution. Pete Please see the following article for a possible solution: http://support.microsoft.com/kb/922651 ...Show All

• .NET Development getting variables from flash and posting back a response

  Hey All, I know how to post a variable to an ASPX page in Flash. How do I get that variable in ASPX and post back a response Thanks! ...Show All

• Windows Forms Adding Files to the Partial class?

  When I create a form in visual studio it creates 2 files for me using the partial keyword to spread out the class. My question is: How do I add more files to that system I first thought I could just right click on the form in the solution explorer window and add new code file. That option was not there. I tried adding a new code file to the project, and then typing all the same "using"s, the same namespace, and the same partial class name, but then it made it its own form with its own 'designer' mode. I don't understand how it could even do that. All I want is to spread out my code to multiple files because this one big file is getting huge and ugly. Any help would be appreciated. ...Show All

• .NET Development Dataset Update

  I have a dataset, and a save button that issues an update: myDataAdapter(myDataSet).Update() This works fine the first time the button is clicked. However, it I make changes to the record then click it a second time, it does not save the record. Is there another command/code i should be entering after the first update I have some more info based on testing. The first time I enter, the record is being inserted. It's second calls to the update (which should issue an update statement) that do nothing. If I call an existing record, I don't have any problem calling update() as many times as I want, and it will work ...Show All