RickyBIBI's Q&A profile

• Microsoft ISV Community Center Forums Run-time error '1004' in import macro

  I have written a macro to import data from a website however i get an error below Run-time error '1004' sql syntax error and when i try to debug it it goes to .Refresh BackgroundQuery:=False Any clue regarding how I can solve this Thanks in advance Hi don76, That helped a lot. The first thing I see is a problem with the SQL statement stored in gcquery. gcquery = "SELECT asset.cusip, asset.cur_amt_outsd " & _ "FROM dmo_govcorp..asset asset WHERE asset.cusip in (" & cusip & ")" There is an additional . in the FROM clause and also there looks like a duplicate asset in there too. FROM dmo_govcorp.asset WHERE asset.cusip That might solve the ...Show All

• SQL Server Execute Process Task syntax problem

  Hi I want the following command processed by the "Execute Process Task": c:\relog.exe c:\perflogs\log.csv -f SQL -o "SQL:PerfCounters!PerfCounters" relog syntax: relog [path to file] [-f: to SQL format] [-o to output SQL:Databasename!DSN"] The name of the file I want to be processed by the windows relog utility is a variable which is created by another preceding task: User::Variable In the "Execute Process Task" there are three parameters I have to use: Executable: which I think needs to be relog.exe Arguments: C:\Perflogs\ User::Variable -f SQL -o "SQL:PerfCounters!PerfCounters" WorkingDirectory: C:\Windows\System32\ As you can see in the Arguments, it's not going ...Show All

• Visual FoxPro Combobox do not display

  Hi gurus Need your help, I have two forms, form1 and form2, In form1 I have a combobox, this combobox is populated using a view, on form1 I have also a button, Once I click on the button ,form2 comes up and the value on my combobox is passed from form1 to form2, this works ok, here is where the problem comes in, once I close form2 and I go back to form1 even thoug the value is there, my display on my combobox is blank, only when I click on the combobox the value shows. how can I force the value to stay what Am I missing Thanks a bunch. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Accessing internet resources?

  I understand from the FAQ that the XNA Framework on the Xbox 360 will not have any support for Xbox Live, which means no network gaming, at least at this time. However I would like to know whether there is any support for accessing resource assets on the internet For example is it possible to access image resources on an internet site using a C# HttpWebRequest Albert Ho *MSFT* wrote: Hi Emil on the Xbox 360 there is no networking support for developers to use in their games. We definately understand that networking is a key scenario and we would love to enable it. We are investigating how we may change this for future releases. aL Ouch, will the pro version of xna studio support ...Show All

• Visual Studio Team System Create a Test List in VSTE For Dev

  I am trying to set up a build type in Team Foundation Server that runs a set of unit tests as part of the build process. However all the docs I see reference features I can't find. I suspect they are part of TE for Testers, which I don't have. How can someone who does not have Team Suite, or Team Edition for Testers create a build type that can run unit tests Microsoft will fix the problem in the Orcas timeframe. For all that can't wait yet another year, there is the “ Test Manager Add-In for Visual Studio Team Edition for Software Developers ”. This Add-In makes it possible for developers to manage the lists of tests, build hierarchies and execute tests from the Team Edition for Software Developer ...Show All

• SQL Server Date Context

  How can I get two measures in the same query with different date contexts For example, lets say I have two measures, Payment, Taxes and Amount. This query would get me total amount for both measures for 2006. SELECT {Measures.Payment, Measures.Amount, Measures.Taxes} ON COLUMNS, {Company.Name} ON ROWS FROM MyCube WHERE Date.Year.2006 How can I get the total Payment for 2006, 2007, and 2008 while leaving the generic query date context which is 2006 Thanks in advance. Thanks for your reply. The problem is more like this: SELECT {Measures.Payment, Measures.Amount, Measures.Taxes} ON COLUMNS, {Company.Name} ON ROWS FROM MyCube WHERE Date.Month.[Feb 2006] How to get the Payment for the whole ...Show All

• Smart Device Development Not Able to see Solution name in Solution Explorer.

  Hi All, I am facing a strange problem. whenver i add new windows project or solution in visual studio 2005 , i am not able to see complete tree strucrure in solution explorer. The tree structure starts from C# windows application's name rather than solution name. Ideally, whenever we add any new project in the studio we see solution name at the root elemet of tree structure but this is not the case with me. Though i am able to see solution name while adding new website but not in the case of windos application. This all resulting in another problem that i can't add another project to the same solution because i can't see the solution name in the solution explorer. can any one please help me on this. Thanks & Regards, - ...Show All

• SQL Server Books Online July 2006 issue

  The SQL Server Books Online was working installed on my workstation fine until this morning. Now when I open it up it does not show me T-SQL reference with all the commands and functions. Yesterday I was on the MSDN website using the Books Online. Could some pointers in the program been corrupted I have uninstalled and reinstalled Books Online to no avail. Please help. Thanks, Fred Hi Fred, Okay, this sounds like maybe a filter was accidently set that is limiting the returned topics. At the top of the Contents tab, there's a "Filtered By" drop down box. Make sure the filter is set to either 'unfiltered' or 'SQL Server 2005', or 'SQL Server Database Engine'. That should resolve t ...Show All

• Windows Forms Best way to select ComboBox item after binding?

  Hi, I have a County combobox in Employee details screen and I have bound a data source with ValueMember and DisplayMember from the County master tablewhich has list of all counties in s state. The ValueMember is county id and DisplayMember is the county name. I have the county id from Employee table and I need to select the appropriate county in the County combobox based on this county id. As counties can become inactive, I cannot just directly use SelectedValue property which is set to county id. I need to loop through all combobox items and check if the id exists in the list (from ValueMember) and then select that item if it exists. What is the best method to achieve this Thanks, Shyam He ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. New Starter kits?

  Hi everyone! I just joined the creators club and deployed my first game (The spacewar kit) and everything worked great! But I was under the impression that with the launch of the creators club we would have access to more starter kits and tutorials. Are more of these comming in future updates Or am I just missing them 1) Yes. 2) No. The XNA racer kit is not ready yet. See here . ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I do 2D graphics in Direct3D?

  I amwritting a map maker and all I need is to view, zoom in and out, and highlight the square the user is pointing at. GDI+ has proven WAY too slow for this so I'd like to use DirectX. I can't seem to find a sample or tutorial that's not about 3D. I just want to have a buffer of bytes[] and an offset. I remember being able to lock the screen device, manipulate the buffer, then unlock and it would update the screen. Are you not able to draw 2D surfaces anymore Any help would be appreciated. Tom P. Hmm, so you can't get the screen buffer anymore That's disappointing. I'll look into the texture example you gave above. Thanks, Tom P. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Distributing games with XNA runtime

  So what's the best way to distribute the XNA framework with a game Just point people at the framework download on the Microsoft site Include the XNA framework installer with the game I was clicking around and found in the project properties-> "Publish" -> "Application Files..." options, I can set the publish status of Microsoft.Xna.Framework.dll and Microsoft.Xna.Framework.Game.dll to "Include", which copies the dlls with the game. Is this enough to get the game running on another PC, assuming Framework 2.0 is present and DirectX is up to date Thanks! Hi, I’ve found a post that proclams how to add XML framework as prerequisite: http://blogs.msdn.com/pstubbs/archive ...Show All

• Visual Studio Error install GAX

  I received the following error from the msiInstaller when installing GAX: Event ID: 11001 and in Source: MsiInstaller Product: Guidance Automation Extensions -- Error 1001. Method not found: 'Int32 Microsoft.VisualStudio.Shell.Interop.IVsSolutionEvents4.OnQueryChangeProjectParent(Microsoft.VisualStudio.Shell.Interop.IVsHierarchy, Microsoft.VisualStudio.Shell.Interop.IVsHierarchy, Int32 ByRef)'.; (NULL); (NULL); (NULL). As someone any ideas about the origin of this problem I deinstalled a previous version of GAX, check the registry settings, checked with Windows Install Clean Up,... After searching and searching I found the solution of the problem: http://forums.microsoft.com/msdn/showpost ...Show All

• Visual Basic &H308 ???

  Hi,   For hours ive researched, any explanation would be great, nearly any developer knows the answer im sure.   take this for example: [code] Private Const WM_CHANGECBCHAIN As Integer = &H30D ... Protected Overrides Sub WndProc( ByRef m As Message) Select Case m.Msg Case Is = WM_CHANGECBCHAIN If m.WParam = CType (mNextClipBoardViewerHWnd, IntPtr) Then mNextClipBoardViewerHWnd = m.LParam Else SendMessage(mNextClipBoardViewerHWnd, m.Msg, m.WParam, m.LParam) End If End Select [/code]   this part: Private Const WM_CHANGECBCHAIN As Integer = &H30D   The &H30D i know its a hexadecimal value and may re ...Show All

• Visual Studio Express Editions Path in VS 2005

  I am having a hard time creating a path to my images folder whether it be an absolute or a relative path. I continue to get this error can somebody please help this is time sensitive. Thanks DKB System.IO.FileNotFoundException was unhandled Message="\images\die0.png" Source="System.Drawing" StackTrace: at System.Drawing.Image.FromFile(String filename, Boolean useEmbeddedColorManagement) at System.Drawing.Image.FromFile(String filename) at My_Craps_Game.Form1.DisplayDie(PictureBox picDie, Int32 Face) in C:\Documents and Settings\David\My Documents\Visual Studio 2005\Projects\My Craps Game\My Craps Game\Form1.vb:line 99 at My_Craps_Game.Form1.rollDice() in C:\Documents and Settings\Davi ...Show All