Aleniko29139's Q&A profile

• SQL Server Show Monthly,Quarterly, and YTD revenue

  Hi All Experts, I need to show a result of a revenues total for Monthly,Quarterly, and YTD of a given sales person by a given period. e.g Period : 7-1-2006 to 8-1-2006 Sales Person Monthy Quarter YTD SalesPerson1 $1999 $10000 $100000 SalesPerson2 $1999 $10000 $100000 How can i do that Thanks in advance. It shouldn't be any worse than any other method. The calendar table is very small, so the join to it should not be very costly. Then it is just a matter of grouping. If you have too much data like this, then I would probably suggest going to an olap solution using Analysis Services, though I wouldn't know how to manually write that code in MDX :) ...Show All

• Visual Studio Express Editions VB/VB.NET/VISUAL STUDIO/EXPRESS/FRAMEWORK et al

  Hi, I managed to understand Visual Basic 6 to an intermediate level; then used Access extensively, acquiring some knowledge of Microsoft SQL along the way. Now it is time to move on to developing databases on the Web. I hear Visual Basic is obsolete and that Visual Studio Express is an easy way to get my feet wet in the new technologies. Please tell me: a) Will my little knowledge of VB 6 help me in the new teritory b) Do you have another suggestion concerning what I can invest my time in if I want to be able to develop applications that run in or out of the Internet I will appreciate a specific study guide/pattern you may suggest. VB6 is old and outdated and unsupported and has been replaced ...Show All

• Visual C++ Maximize windown command

  i know there's a command that maximizes a windown when the program starts. i'm running an SDI and want the program to be hardcoded to start at a maximized size. thanks for the help When designing the form, you should find the WindowState property among other Form's properties. Or, at runtime, set this property on Form_Load event: WindowState = FormWindowState::Maximized; Andrej ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Confused About XNA and DX10

  I am confused about the differences between XNA and DX10; is that correct: 1- XNA will have both fixed function and shader programming and effects also 2- DX10 will have only shader programming with no assembly, no fixed function and no effects. 3- DX10 will be on Vista only, since it is shader programming will Shader 3.0 (DX9.0 C and L) is compatible with Vista shader 4.0, so a program written on Windows XP DX9.0 C will run on Vista DX9.0 L but will not run on Vista DX10 shader 4.0 But why it will not run on DX10 Vista runtime if the program is only shader with no effects is that because shader 4.0 will not be compatible with shader 3.0 or it will run regarding windows controls with DX: 1- can we build application ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Major DirectX Problems

  I have been having problems with actually installing DirectX, and I've searched the forums and looked at all the possiabilities that could be causing the problems. I do not know why it keeps giving me an error when I have every thing linked correctly. Here is the error I get, and I dont know why its not working: ------ Build started: Project: CreateDevice, Configuration: Debug Win32 ------ Linking... CreateDevice.obj : error LNK2019: unresolved external symbol _Direct3DCreate9@4 referenced in function "long __cdecl InitD3D(struct HWND__ *)" ( InitD3D@@YAJPAUHWND__@@@Z) Debug/CreateDevice.exe : fatal error LNK1120: 1 unresolved externals Build log was saved at "file://c:\Program Files\Microsoft DirectX SDK (October 2006)\Samp ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Can I make a Resident Evil=type game with XNA?

  Hi all, Longtime gamer and complete noob when it comes to actually designing a game. Basically, I work in entertainment and have long wanted the chance to tell a strong narrative story in a game. When I heard about XNA I thought this might be a great way for me to learn and experiment with just how one designs a game. Now, I'm not expecting RE4 but I'm basically wanting to know if I could make something along the lines of the first RE or even simpler the first MYST. I don't care if all the backgrounds are pictures, etc. But I DO want to try my hands at level design, voice-acting for dialogue and simple generic baddies to kill, oh and an inventory of weapons! Anyways, looking forward to downloading the beta version tomorrow! ...Show All

• SQL Server Silly Query question

  I have been rewritting one of our applications to use SQL Express instead of Access. I am having a small issue that I cannot seem to resolve and have searched the forum thoroughly. My code is as follows: SearchPONo = Me.txtSearch.Text Set rs55 = New Recordset rs55.CursorLocation = adUseClient 'SQLSearchQuery = "SELECT * FROM POInfo WHERE PONumber LIKE '%SearchPONo%' " rs55.Open SQLSearchQuery, cn55, adOpenForwardOnly, adLockOptimistic Goto GetRecord GetRecord: If rs55.RecordCount() > 0 Then Me.DataGrid55.Enabled = True Set DataGrid55.DataSource = rs55 I am trying to get a PONumber from a user input textbox and if I replace the %SearchPoNo% with a partial of a PO Number ...Show All

• Software Development for Windows Vista SampleGrabber can't work well with rmvb file

  Dear all: I want to get Video, Audio sample data from various kinds of input file like avi, wmv, mpg, rmvb .... , So I use DirectShow and put two SampleGrabber filters in the filter graph. One for capture Audio, one for capture Video. The SampleGrabber for Audio is work well, also the SampleGrabber for video is work well but only for avi, mpg, wmv file. The Video SampleGrabber can't work with rmvb file. It happen connection error when I connect the graph. Is there any way to solve this problem I know the SampleGrabber don't support FORMAT_VideoInfo2 but how do I know this is the reason I can't connect it well if I can't use SampleGrabber to capture the video frame, what method should I use. Thanks! Jack ...Show All

• .NET Development Create a Shell Extension Handler thumbnail extractor with .net?

  Hi, My application creates nice graphics see http:// www.mavericksplan.com/mavericks  and it saves a custom document type. I'd like to show the contet of the document in Explorer when the user switch to Thumbnail view. To implement this feature I understand I need to create a Shell Extension Handler Thumbnail Extractor that extract the image from my file type to feed Explorer thumbnail vew, which is not easy at all for me. I look on the web and I found 1 C++ example and none in C#. Does anybody have a sample code to create a Shell Extension Handler thumbnail extractor with .net in C# Thank you Andrea That's still wrong. What happens when Explorer becomes written in managed code with a ...Show All

• Software Development for Windows Vista IE7 example: Keyset does not exist error

  Hi, Just trying to run the IE7 - cardspace demos on WinXP-SP2. I am able to get the security token from my personal card but during decryption of the token to get the claims, it gives an error: keyset does not exist . I have tried reinstalling the certificates but it did not help. Guys, please help me through this. Regards, Nishant Hey I got it working by changing the security permissions of C:\Documents and Settings\All Users\Application Data\Microsoft\Crypto\RSA\MachineKeys folder. Regards, Nishant ...Show All

• Internet Explorer Development Relative Protocol with JS files

  Testing with IE7 we have seen incorrect handling of relative protocols in a URL when the URL pointing to javascript files. The following works.... <SCRIPT language='JavaScript' type='text/javascript' SRC='http://foo.com/bar.js'></SCRIPT> But the following does not work <SCRIPT language='JavaScript' type='text/javascript' SRC='//foo.com/bar.js'></SCRIPT> This works on all major browsers including prior versions of IE. HELP!!! The reason to reference a JScript (or image, or css, etc) file using a protocol-relative hyperlink is to make a page that works correctly when referenced by either HTTP or HTTPS. By making the URIs protocol-relative, you can ensure that a secure ...Show All

• SQL Server New to IS -- please help me!!

  Hi i am new to IS and I have been trying to use conditional split but cannot get the syntax to work. Can someone please tell me where i can find a syntax guide or samples especially on how to make the datetime funnction and maths function work. And, am I correct that the syntax is not as simple as they look in the conditional split transformation editor thanks!!! If you want to know how to use individual function, then look them up in the reference I sent a link to, or just use your local copy of Books Online. They all have descriptions and simple examples, e.g. SUBSTRING(MiddleName,1,1) This example uses variables in the position and length arguments. If Start is 1 and Leng ...Show All

• Visual Basic DLL Created with VB>NET Called by VB6 Application

  I have created a DLL using VB.NET that is a wraper around several DLL's supplied by one of our maufacturers. We're in the process of updating out applications to .NET but currently we need to call this wrapper from a legacy VB6 application. So I created a COM library with VB.Net and it works fine on the development machine. I did not use strong naming, but when I try to distribute it to test machine and run it I get the following message: "The digital signature verification failed because the signature file could not be found." Is it trying to tell me I need to use strng naming Does it allready think I am Thanks in advance. How are you deploying your application Did you use ClickOnce ...Show All

• Visual Basic Code sample for dialing up in VB 2005

  Help : Need how to program a dial-up connection in VB 2005 to access a network You can try using the InternetDial win32 api function. You can find its documentation here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/wininet/wininet/internetdial.asp -Scott Wisniewski ...Show All

• Windows Forms Displaying Database information in ListView

  I created an address like database with first and last names and include a photo location in the database. Now I want to use ListView to display the photo and name of each row(person) in my database, but I don't know how to retrieve a string from a single cell in my database. can anyone help Try this (pardon me if the DataRow syntax isn't quite right, although I think I got it right ... it's a little different than the syntax for C#): Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load 'TODO: This line of code loads data into the 'FirstDatabaseDataSet.Addresses' table. You can move, or remove it, as needed. Me .AddressesTableAdapter.Fill( Me .FirstDatabaseDa ...Show All