He is Cool's Q&A profile

• SQL Server Using Custom Assembly with Report Builder?

  Can you use a custom assembly within report builder, can I call a function from my assembly Thanks ...Show All

• Microsoft ISV Community Center Forums [ACCESS] How to create menu silimar the attached photo

  How to use vba to create menu when click the button from form in MS Access Hello Perry, I did this for a bit of fun and hopefully will help you too. I did this in Excel as I do not have Access at home. I'm sure the basics are the same. Create Userform1 with CommandButton1 Write this in the form code module [Form Module Code Start] Private Sub CommandButton1_Click() CommandBars("MyShortCut").ShowPopup End Sub Private Sub UserForm_Initialize() Call DeleteShortcut ' if "MyShortcut" popup exists then delete it Call createShortcut ' add MyShortcut popup End Sub [Form Module Code End] Write this in the Module1 Code Module [Module1 Code Start] Sub createShort ...Show All

• SQL Server Checkpoint restart

  I have a package that uses checkpoint restart. It is resposible for truncatings many sets of tables and then loading them. There are several ExecuteSQL tasks to truncate the tables and several corresponding data flows to accomplish the loads. If a load fails I want the corresponding truncate task to be part of the restart otherwise duplicate data may be loaded. Normally, SSIS will start at the failed task. I read something about containers that led me to think that if I put the truncate & matching load pair in a sequence container that the container would be the restart point, but either I read it wrong or it's not working that way. Anybody know how to accomplish what I want to do Mark Cha ...Show All

• Microsoft ISV Community Center Forums Generating Dialog Messages thru VBA over Excel

  Hi Guys and Girls, Thanks for the help so far. I'm on the last step. I need to generate fairly long dialogue messages dependant upon the data the user has entered. A sort of lok up using Inputbox which I understand and Dialogue boxes which I don't. I'm really stuck, I just need a little code that goes if data_entered = XX then .... open this dialogue box containing this text else if .... open another dialogue box else if .... another end. Is it possible to dynamically load texts to dialoge boxes rather than hard code them Again thanks for the help so far. Hamish Thanks but MsgBox is limted to what Excel offer. It n ...Show All

• Software Development for Windows Vista Empty File produced with CaptureGraphBuilder->RenderStream() then ImediaControl->run()

  I am writing a simple graph that takes a live mpeg2transport (hi-def) stream and writes to a filewriter. here is the relevant code that i am using. hr = m_pCaptureGraphBuilder->SetOutputFileName( &CLSID_FileWriter , L"c:\\test.m2t", &ppf /*out*/ , &m_pFileSinkFilter /*out*/); hr = m_pCaptureGraphBuilder->RenderStream(&PIN_CATEGORY_CAPTURE, &MEDIATYPE_Stream, m_pDeviceFilter, NULL, ppf); The file is produced , but is empty, 0 bytes. What am i missing Same problem here, except I am using an avi filename and type-- it writes only 64K and is not readable. Interestingly enough, if I connect remotely to the graph with Graphedit and run the graph from there, the file writes ...Show All

• Visual C# How to read current active IE window's html content

  Hi there!, I really hope someone can help me with this issue... it is really cracking my brain up:S What I want to be able to is to load the html content of the current active IE window by a simple IE Frame or console application. Not using the webbrowser component. That is possible but I just don't know how to do it. Maby with the HtmlDocument I have googled and googled.. I found this example http://www.codeproject.com/vb/net/ByPassAutomation.asp which is VB, but other than that the example does NOT work.. well I have IE 7.0 so maby it's because of the tabs.. can anyone please help me Regards, Qawi Hi,   I think I got it:) thanks.. however.. how do I install it to IE I got this..   Pe ...Show All

• Visual Studio 2008 (Pre-release) How do I display an embedded xaml document in a FlowDocumentReader (in C#)?

  Please, I need help. How do I display an embedded xaml doc resource in a FlowDocumentReader Here's some sample code: Window1.xaml <Window blah blah blah > <DockPanel> <FlowDocumentReader Name="MobjFlowDocReader"/> </DockPanel> </Window> Window1.xaml.cs public Window1() { InitializeComponent(); Uri u = new Uri("EmbeddedDoc.xaml", UriKind.Relative); StreamResourceInfo i = Application.GetResourceStream(u); Stream s = i.Stream; FlowDocument f = XamlReader.Load(s) as FlowDocument; MobjFlowDocReader.Document = f; } Why doesn't this work The line in red throws an exception. I apologize if the above code isn't clear. It's not c ...Show All

• Microsoft ISV Community Center Forums access2003 code modules can not be read after a compile and compact and repair

  after finishing up some code behind a form in access 2003 I compiled the database then compacted it. After that I could not access the code modules. I would get an error that the module did not be opened. Any help would be good downard26@msn.com I can not import and forms that has code or modules. I have not created a MDE. I did get and error when it was compiling but it was without a code. Just plain strange. I have never seen Access act like this before. ...Show All

• Windows Forms Progress Bar - ListBox

  Here's an example. Start a new Windows Forms project and drop a progressbar on the form. Then paste this code: public partial class Form1 : Form { System.Diagnostics.PerformanceCounter cpu; Timer tmr; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { cpu = new System.Diagnostics.PerformanceCounter("Processor", "% Processor Time", "_Total"); tmr = new Timer(); tmr.Interval = 100; tmr.Enabled = true; tmr.Tick += new System.EventHandler(tmr_Tick); } private void tmr_Tick(object sender, EventArgs e) { progressBar1.Value = (int)cpu.NextValue(); } } ...Show All

• Software Development for Windows Vista OwnershipTimeoutSeconds does not work

  Hi, In order to be scalable we have two servers running our workflows. Any server should be able to take over at any time. The workflows running on the servers make asynchronous requests via msmq to other services. The replies should be able to come back to any one of the servers and still be processed. What happens is that when the reply comes back to a server which did not make the original request (and then wait on an event), the server cannot fire the event on the persisted workflow, because it's still "locked" for use by the workflow. I am currently configuring the workflow instance ownership to be 2 seconds, and it takes longer than that before the response comes back to the server. I'm using the released version o ...Show All

• .NET Development CLR and thread deadlocks

  Hello, I'm hosting the CLR (.NET 2.0) in an unmanaged C++ app. The CLR is used for calling C# plugin functions through IDispatch. The C# plugins are COM visible classes and are created from the app main UI thread. They are mostly used for accessing the app through a COM primary interop assembly generated with TLBIMP.EXE. The interop between C# and the app is achieved through the default Microsoft COM wrappers. This is all working fine but I'm having a problem when the C# functions are called by the app from a worker thread. At this point the CLR attempts to interop with the app via the UI main thread which is causing a deadlock because that thread is locked while the worker thread is executing. From what I see in the call stack (b ...Show All

• Windows Search Technologies Problem Indexing E-mails with WDS 3.0 Beta 2

  I have upgraded WDS to Product Version 6.0.5486.108 {3.0 Beta 2 for Windows XP (KB917013)}. It seems to be indexing my files and running well but none of my e-mails are included. I have Outlook 2003 (11.8010.8036) SP2. As an experiment I have installed Google Desktop Search. It has no problem picking up all the e-mail messages on my HDD in the *.pst files. WDS does not index them at all. Just to give you an idea (of the magnitude of the problem) -- Google Desktop Search identifies more than 100,000 files on my HDD when indexing is complete; WDS only finds ~ 26,000! The difference is the missing e-mails. What is the 'trick' Just to add to my confusion Windows Desktop Search is not listed when I open Settings/Control Panel/Add or Remove P ...Show All

• .NET Development Bizarre .NET performance benchmarks

  While attempting to achieve a maximum performance in .NET code I have stumbled on a very peculiar effect. If you compile and run the following C# code, you get a better performance in Debug configuration than in Release configuration. Moreover, if you comment out any one of the unused (!) case blocks in the Distance method, you get 5-fold !! increase in the performance in the Release configuration. I would appreciate any explanation that anyone can offer. And it would be great to hear comments from the .NET development them if they are following this forum. Thanks, Victor P.S. I am using VS 2005 and Framework v 2.0.50727.42 using System; using System.Text; using System.IO; using System.Diagnostics; names ...Show All

• .NET Development Database data copy

  Hello, Don't know if this is the most suitable forum for my question but... i have 2 databases on the same pc.i want to query the first database and get some data as a result from more than one table.and using an application i would like to copy that data to another database in one table that i have created... how can this be done thnx in advance.... hello, sorry for not being more specific.i use sql server 2000 on my server pc.and i want the procedure of copying the data between the 2 databases to be done from a vb.net application..without using stored procedures... can this be done.. thnx again ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. problem getting font to work with XNAExtras

  I'm not sure if this is the correct place for help with XNAExtras, but I couldn't find any other forum about it. Anyway, I downloaded the tool, included the correct classes and made a .xml file and an image for the font I want to use with the tool that comes with XNAExtras. I included XNAExtras with the project and have all the code from the example programs included, but when I run my program, it tells me that the font I'm trying to use when I create a new BitmapFont object can't be found. Copying the same two font files into the existing font example causes the same error. However, when I try to copy the font files that were initially in the example and work fine there back to my own project, I get the same error in my own project. ...Show All