stak32's Q&A profile

• SQL Server Report Headers vs Page Headers

  Hi, this is probably a simple question but I just can't figure it out. I'm using SQL Server Reporting Services 2005 sp1. I'm trying to design a report that displays a particular embedded image on the first page, and then a different one on every subsequent page. I.e full, fancy company logo on the first page, and a trimmed down version on every other. In Crystal, I would have simply used the Report Header and Page Header sections to achieve this - easy. However, in SQL Reporting Services, there is only a Page Header section - therefore whatever I place in the Page Header shows on every page. Now, I know how to stop it displaying on the first page, but I don't know how to display the other image instead. I read in a support forum t ...Show All

• SQL Server How to get the latest & earliest date?

  Hi, How to get the latest date from ColumnDateTime and the earlier as well Maybe something like select max(columnDateTime) from yourSourceTable where anIntegerColumn = 14 If your column is a varchar column that WHERE condition will look like: where aVarcharColumn = 'theTargetString' ...Show All

• Visual Basic close method of Form

  hello. A question please. Is it neccesary to call form.close before exit of the application Thanks... No, it's not. That's a method call to close a specific form, which may, or may not close the application. ...Show All

• Windows Forms Rich and Plain Text

  Hi Does anyone knows how to code an Open Rich text or Plain Text file in childForm with RichTextBox thanks jbattat Hi I am having a little problem on how to declare the " theSelectedFile". Can you assist jbattat ...Show All

• Smart Device Development Who has a PPC-6700 Sprint AudioVox Mobile 5 (Can I use GPS?)

  I have the Sprint AudioVox PPC-6700 and I know that it has the built in GPS chipset but everywhere that I search I can not find out how to actually access the API. There are a few of the GPS API references throughout msdn & msdn2 but none have an actual walk through. It is very easy to access the phone API's and contact lists/appointments and whatnot but the GPS is not to be found. As far as the GPS is conserned one could argue that it isn't ment to be programmed or something but the fact is that in all documentation it says that e911 can use the gps and also applications that need your location (such as movie times or resteraunts in your location). I really need to find out how to manage this out even with just a simple quord ...Show All

• Visual Studio Express Editions Date conversion

  I need to create folders with the date as part of the name. (How can I remove the slashes) The folder name should be "111206_<student initials>" when application is executed on 11/12/06 msStudentDir = FormatDateTime(today(), "yyyyMMdd" ) & "_" & gsInitials & "\" doesn't work Use this: msStudentDir = Today (). ToString ( "MMddyy" ) & "_" & gsInitials & "\" -- SvenC ...Show All

• Smart Device Development Massive Update

  Hi, I'm doing a massive update into a table (more than 100), it's taking a lot of time is there a way to optimize this processe in CF2 Regards Mario Ola Mario, I really don’t know if CF2 has functions to optimize your update query but even if it has, you should consider a way of telling the user if your App is working and is not stopped. You should create a thread for each N rows and display the progress in a progress bar, this way the user can still use you App and will be able to see the progress of the operation. Hope it helps. ...Show All

• SQL Server Reinstall Sql Server Express After Developer Edition

  I had to uninstall SQl Server 2005 Developer Edition because of hardware requirements, and reinstall Express Edition download version. But SQL Server Database Services fails with this message: SQL Server Setup has determined that the following account properties are not specified: 'AGTACCOUNT' . Error Code: 28006. The first time I installed Express the flow of setup ended well without any message. How to act Can you provide two pieces of information First, find the latest *_SQL.log file located in %ProgramFiles%\Microsoft Sql Server\90\Setup Bootstrap\Log. I need some info from the log, so please search for these two strings: <Func Name='SetUnattendedSvcAccountProp'> < ...Show All

• Windows Live Developer Forums display pin info

  hello is there a way to display the pin info as soon as you add the pin instead of the mouse hover over thanks. No time to check sorry but try this: after you add the pin: var pin = new VEPushpin(pinID, latlon, icon_url, title , details , iconStyle); map.AddPushpin(pin); var element = document.getElementById(pinID); element.onmouseover(); John ...Show All

• Visual Studio Team System Team Foundation and Reports

  Hi guys, I am new to team foundation. I have to generate reports using Team foundation. Any idea how it can be done. Thanks, Aditya You can start by reading Team Foundation Server Reporting  http://msdn2.microsoft.com/en-us/library/ms194922(VS.80).aspx Then if you have specific questions I would ask in the Team Foundation Server - Reporting & Warehouse forums http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=480&SiteID=1       ...Show All

• SQL Server Drill to Detail in ProClarity #2

  Hi, Here is my prev post on this... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1006426&SiteID=1 Please do check the same. Regards ...Show All

• Visual Basic How to change the culture in a thread or application or program.

  my VB.net 2005 Application is My .Application.ChangeCulture( "en-GB" ) the problem is, my OS dateformat may be will not be matching my application culture. e.g. 7 april 2007 at my application = 2 July at my OS my prblem is: when I send 07-02-2007 to my database it will save depends on my OS format then when I retrieve the value it will be 02-07-2007, it changed from april to july Sorry, I don't know much access... but can't you specify the date/time format for the column in access If so, you could do so. Also, don't you want to specify the date as #<date># instead Best regards, Johan Stenberg ...Show All

• Visual Basic VB 6 to VB.net

  Hi, How can i cahnge the following VB 6 code to Vb.net to populate a combo box in the form load While Not rscomp.EOF cmb_Comp_Name.AddItem rscomp.Fields(0) rscomp.MoveNext Wend You can still use Recordsets in VB.NET, you'll just need to add a reference to "ADODB" in the Add Reference dialog. The While...Wend construct is no longer used in .NET, and additionally you'll have to add ".Value" when you access the data. I haven't tested this, but this should work for you: Do cmb_comp_name.items.add rscomp.fields(0).value rscomp.movenext Loop until rscomp.eof Hope that helps, Jonathan ...Show All

• Visual Studio 2008 (Pre-release) How to create an Object in XAML using its parameter constructor?

  Hi I am trying to create a usercontrol with two constructors,when i ever create a object of this control i want to pass some default value to this object ,using parameterized constructor,but when ever i create this object in xaml its constructor is not called. Is there a way to create a object in xaml so that its parameterized constructor is called rather than its default constructor . Unfortunately I think XAML only supports default/parameterless constructors. If you only need to specify one parameter you could use a simple TypeConverter . Otherwise you could restructure your constructor logic behind individual properties. ...Show All

• Software Development for Windows Vista Starting a workflow form a replicator task

  Hi, I launch a worflow form a task replicator(in sharepoint) you can see the code below. The normal beware should be : for each user the function copy a file in the work folder and launch a a worflow associated with this file. for example with 2 users : user1 and user2 the workflow should do this user1 --> go in the SubWorflowLaunching --> create the file work/file_user1 --> launch the workflow My wf associate with the file work/file_user1 user2 --> go in the SubWorflowLaunching --> create the file work/file_user2 --> launch the workflow My wf associate with the file work/file_user2 and finish but when i added the line to start the subworflow : this.workflowProperties.Site.WorkflowManager.StartWorkflow(myWorkingItem ...Show All