Evan Mulawski's Q&A profile

• Microsoft ISV Community Center Forums Making changes to Access database table - via Recordsets or Update Queries?

  Hi, firstly, sorry if this is the wrong part of the forum for this question (things seem to have changed recently). My question is this: I am writing some VBA code to automate a job that I perform regularly, in MS Access. I need to carry out updates to data in an Access table, in a repetitive manner. The data needs to be put in a format that is mailable, I need to create fields like Age (from dob), Age Bandings, Gender (from title) etc. Before I knew any VBA, this was all done with Access Update queries and some lookup tables, but I never bothered writing a macro to speed this up. Now that I understand recordsets a little better, I've written some code to automate much of what I need to do, but to be honest, I dont know whether t ...Show All

• Visual Studio Express Editions outlining

  Hi, I don't know if this intentional behaviour, or if I'm missing something obvious, but I would like to be able to use outlining to be able to expand and collapse functions and other code blocks such as after "for", "while" or "if". As far as I can tell, I can only set the editor to allow function outlining, and if I want code block outlining, I have to disable automatic (function) outlining and select specific bits of code and press Ctrl+M Ctrl+H. Is there a better way which allows both function and code block outlining simultaneously I'm using C# 2005 Express. Many thanks, Jonathan not sure if I follow. Are you aware of using the #region regionName #endregion to expand/col ...Show All

• SQL Server Remove FileGroup

  I have removed all the files from a filegroup ...when I do sp_helpdb I don't see the filegroup... but when i try to remove the filegroup using ALTER DATABASE <DB> REMOVE FILEGROUP, it says The filegroup 'XXX' cannot be removed because it is not empty any idea... Thanks Ranga Hi Ranga, Maybe a partition scheme is still mapped to the filegroups. Try dropping the partition scheme before removing the filegroups ...Show All

• Windows Forms How to share an object instance through all forms just like vs6.0's global variables?

  Now I am doing a c#.net 2005 database project.At the begining, I want to design a login form and after user successfully logon, I will store its account and something else such as Sales Month selected. But I found that c# is purely object oriented language and there is no gloabl varialbe. I wonder how to do this. I have been used to web design and this is my first real winform project(Before only some simple projects). So there are many questions during my design. Another problems: After I new a child window in its Mdi parent, I want to transfer some information to the child, how can I do Now I am trying to define some members and methods to manipulate them in the child form, and so I can invoke the mothods to transf ...Show All

• .NET Development Localhost gone missing, but can IP to the page

  We have setup a virtual server Windows 2003/IIS6. When I remote to the box, I can browse to pages within IIS web listings. Strangly enough it uses the IP address instead of localhost when it resolves the page. The same is true if I try to access the page from the command line. When I try localhost I get the error (Http 400 - Bad Request, Page cannot be found). Here are some clues for your perusal ASP.Net page with one item in it <%=now()%> fails to come up in either scenario, (see #2). //localhost/Dir/file.asmx fails but //177.23.25.67/Dir/File.asmx works . IPConfig reports that there is no Connection-specific DNS suffix. But the box has an IP address. ASP is set for .Net 2. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727&g ...Show All

• Smart Device Development Emulator mouse driver problem

  Hi All, I have been able to develop an OS image using Plaform Builder and I am able to deploy the application on the ARMV4i emulator. However, when then application loads I cannot seem to use the mouse on the emulator. The mouse pointer remains at a fixed location and cannot be used, however I can use the keyboard to navigate through the application. I have included the S32410 Matrix Keyboard/Mouse English device driver when the OS image that was built. From my understanding, it is the device driver that the Microsoft ARMV4I Device Emulator supports. Just to clarify what is installed, I have the following; Virtual Machine Network Driver for Microsoft Device Emulator ARMV4I BSP for Windows CE 5.0 Microsoft Windows CE 5.0 Emulato ...Show All

• Visual Studio Out Of Memory error

  Visual Studio 2005 (8.0.50727.42) Visual SourceSafe 2005 (8.0.50727.42) I have a solution with a Web Application project, a Web Service project, and I've just added a Database project (old kind, not the new SQL Server Project type). The projects are each bound to SourceSafe on a remote server using VSS integration. This Database project has around 800 stored procedure scripts, and since I added these items to the project I get a delay of around 30 seconds to 5 minutes or more for any SourceSafe operation that I do. Most of these delays result in an error popup saying Visual SourceSafe | Out Of Memory. I hit OK to this popup and things continue, but things aren't quite right (VS still shows a file as checked out even though it managed to ge ...Show All

• Visual Studio Express Editions DialogResult and Vb warning

  Warning 1 Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated. D:\data\IeI\gp\AppCom\IeFinMgr\FormIeFinMgr.vb 742 29 IeFinMgr code: Dim od As New OpenDialog() Dim myDialogResult As DialogResult = od.ShowDialog(Me) If myDialogResult = DialogResult.OK Then ShowUrl(od.PathOrUrl) End If however the above did work. How should I code so I don't get the warning on DialogResult.OK You are getting this warning because the form has a DialogResult property. Of course, you are using the enumerated type name here, not the property. The compiler ought to be smart enough to pick the type name, not the propert ...Show All

• Internet Explorer Development Force IE7's menu bar to the top

  How do you move the tool bars in interent explorer 7. When i try and move the Menu bar up or down nothing happens. Trying to get the Menu Bar on top then the URL bar 2nd and so forth but cant seem to move the toolbars. Help pls! Thanks EricLaw, This is the fix I have been looking for, to force IE7's menu bar to the top. Imported your tweek into the registry and back to a more clasic menu layout. Thanks again! ...Show All

• Windows Forms ContextMenuStrip / MenuStrip problem

  Hi, I'm having a problem with ContextMenuStrips / MenuStrips. When I hide one item in the menu and then use the keys to navigate the menu scrolls for some reason. Thanks. hi, i didn't understand your question well, what do you do to hide one item, and what do you mean by the menu scrolls best regards ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I position the ball to the center of the screen?

  Sorry newbie question here! ^_^' I started the tutorial in Help and I got my sprite to appear on the screen but it is in the top left corner. How do I make my sprite to appear in the center instead of the top left Any help would be much appreciated. Thanks, Nodoka ------ New question. I got my sprite to appear in the center of the screen. How do I get the sprite to move in a random direction when I compile and run it Here is my code currently: #region Using Statements using System; using System.Collections.Generic; using Microsoft.Xna.Framework; using Microsoft.Xna.Framework.Audio; using Microsoft.Xna.Framework.Content; using Microsoft.Xna.Framework.Graphics; using Microsoft.Xna.Framew ...Show All

• Visual C# C# - Generics on this class type

  Hello, I am trying to instantiate a generic class, using the current class as a parameter. Normally you would do this like this (assuming a class MyClass): private Generic<MyClass> _g = new Generic<MyClass>(); And then i wrap this instance in a read-only property called MyGeneric: public MyGeneric<MyClass> MyGeneric { get { return _g; } } However, this is not really object oriented. Since any class derived from MyClass (MyDerivedClass) would have an instance typed on MyClass, not MyDerivedClass. i.e: MyDerivedClass.MyGeneric returns a Generic<MyClass>. So, how can i instantiate a Generic class using the current class-type as a parameter, in a truly object oriented (polymorphic) m ...Show All

• SQL Server Sizing SSAS2005 Server

  Hi! I am looking for a document or formulas on howto size a Analysis Services 2005 Server. I will have a bigger model - guess ~10 GB (howto calculate more exactly if I have it already modelled - this is only relational size diveded by 4) I have some dimensions with 1 Mio members at key level. Performance is highly important I have two small <=5000 Member parent child dimensions I have multiple measuregroups some calculations we want to do dimension update / partition processing / incremental processing on the same machinge we use enterprise edition we will have up to 2000 named users - regulary no more then 50 concurrent (at peak time maybe 75-100) IS there a 2 processor (4 in Hyperthreading) 64 Bit w ...Show All

• SQL Server Access Denied - SQLSERVER 2005 Integration Services

  Hi: I am getting access denied error "cannot connect to server" while trying to connect Integration Services. I am trying to connect from my laptop to the SQLSERVER database server. I followed the document "Connecting to a Remove Intergration Services Server" , doc id: aa337083. But I can connect to IS if I log remotely to the server. Any thoughts on this Thanks -Rajesh I am getting following errors. =================================== Cannot connect to cvsslmdd1-vm. =================================== Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) ------------------------------ For help, click: http://go.microsoft.com/fwlink ProdN ...Show All

• Windows Forms DataGridView CustomComboColumn BackColor turning black when DataBound

  My issue is that i am creating a Custom Combo Cell that inherits DataGridViewComboBoxCell, that will set its datasouce from the business object that the DataGridView is bound to. I am using the OwningRow property to get to the business object and the OwningColumn to get the DataPropertyName. The properties of the the BO are actually what we call "SmartObjects", They provide the meta data from the database and so on. These objects also have methods to get lists of valid values for each field. These methods are returning a DataTable and that is what is eventually becoming the DataSource of the Combo Box Editing Control. The list is bing populated with the correct value but for some reason the backcolor of the editing control is black. ...Show All