Rui Dias VD's Q&A profile

• Microsoft ISV Community Center Forums Building dynamic forms in Access

  I need to make dynamic forms in access. For example i have a query that selects a user and 3 jobs he has. So the result in the query has 3 lines. Now i want for those 3 lines 3 different textboxes. Is this possible in VBA or not I already searched the help of access it self and i cant find anything about it. thx for your help in advance. query select SLAnr, SLAbeschrijving from SLA where SLAuser='userid1' table is like this SLAnr SLAbeschrijving SLAuser 1 beschrijving1 userID1 2 beschrijving2 userID1 3 beschrijving3 userID1 4 beschrijving4 us ...Show All

• Visual Studio Team System Create Unit Tests: default template & IDisposable

  When using the Create Unit Tests dialog, the generated code doesn't properly call Dispose on my disposable class. Is there a way to modify the code template used by this command The style I've developed for dealing with this is to add a member variable to the test class for the target, and put initializaiton of it in a [TestInitialize ] method, and call Dispose in the [TestCleanup ]. This keep the [TestMethod]'s lean and easy to maintain, and the cleanup method gets called even if the test fails. Unfortunately we don't have code template that you described for test generation and I don't think there is an any easy workaround other then what you have done. What you have asked is a good suggestion and I would recomment ...Show All

• .NET Development "admin console" in CCF troubleshooting

  when I try to explore (Groups,Roles and Application mapping) error message box shown contain " unable to retrieve the requested information" please tell me why and sent reply to my mail please by mdawood@alscorp.com This forum is dedicated to questions relating to the system.net namespace. Please repost to a more applicable forum. Please see http://www.microsoft.com/community ...Show All

• Visual Studio Express Editions certification

  Can you point me in the right direction on how to get certification in MCPD Where Sites are located I am in Atlanta. Are there any sites here Are there any sites that let you work while you get your certifications Howmany certifications do you have to pass Thank you Dee Hi; Most MCPD certifications require 3 exams. these 3 exams usually consist of 2 exams for the required MCTS cert and 1 exam for MCPD. There are also upgrade exams that you can do if you already have MCAD or MCSD certifications. There is a lot of details online on the microsoft site : http://www.microsoft.com/learning/mcp/mcpd/ As for doing the certifications I usually prefer to use self study method, which is a bit har ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Using a resource file (resx)

  I want to use a resx file to call all of my game content and resources (sound, images, sprites,ect...). How do you call the resx file in you classes and how do you let the classes know what files you want to use Thanks ahead of time. I have just finished the development of a free tool that I call ResEx , composite, translation friendly resource editor for .NET. It is a free tool and I intend to keep it free, containing all current features. A small charge may be applied for some features I may introduce later, just to help me keep supporting and enhancing the project. I encourage you to download ResEx and post any suggestions to the discussions page you can find under Help menu of the application. Info ...Show All

• SQL Server Web Synchronisation Using RMO

  hi every body please help me out on this issue , since i am at final stage in finishing up the module. Previously i had done web synchronisation using RMO it is working fine at my office where i have an 2003 server which is an domain controller , publisher i have configured on the 2003 server , and i had subscribers on xp Machines where it was well working fine, clients were not on the domain , it is an independent Machine. we had an security error which was resolve by this same forum, ie the client windows login id should exists on the server too. only then synchronisation is happening at our office, Now the problem is i have an same setup , but the server 2003 is hosted at a remote place , which is not an domain controller, n ...Show All

• SQL Server could not process the cube

  hi, after i deploy the cube ,i will run it i am getting the following error i have used the database egss Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Egss', Name of 'Egss'. how could i solve this regards lalitha hi , Thanks i fixed the problem i deployed the cube.. regards lalitha ...Show All

• Visual Studio 2008 (Pre-release) Problem with FaultException on the client side

  Hi Everyone, I have a little problem with FaultException on the client side. Everything works fine except the exception on client side now is [System.ServiceModel.CommunicationException] while on the server side the process throws back [System.IO.DirectoryNotFoundException]. What should I do in order on client side to catch the same exception which throws back from the server (See codes at the end of this message for more details) Regards, JDang // Service contract and implementation [ServiceContract] public interface IFileTransService { [OperationContract] [FaultContract(typeof(Exception))] void PutStream(Stream inStream); } public FileTransService : IFileTransService { public void PutStream(Stream inStream) { ...Show All

• SQL Server SQL LTRIM()

  hello everybody I have a table with one colum in which i need to get rid of the leading 0's. It would have been easier to just change the datatype to int. However i can not since some columns have some characters in them. LTRIM() only seems to get rid of leading blanks..Anybody know a function on how to get rid of Leading zeros. i.e 00089 gets changed to 89. Thanks You may also be interested in this query. Declare @Temp Table( Data VarChar(20)) Insert into @Temp Values('0000089') Insert into @Temp Values('24') Insert into @Temp Values('Eight') Insert into @Temp Values('00000A') Select 'Before', Data From @Temp Update @Temp Set Data = Case When IsNumeric(Data + 'e0') = 1 Then Convert(VarCh ...Show All

• Windows Forms WinForm control in IE example failed in .NET Framework 2.0

  The QuickStart sample "Controls in Internet Explorer" can run normally when the code is compiled in .NET Framework 1.0. However, when the code is rebuild in .NET Framework 2.0, the control could not receive value set via its property. In the script : function ChangeText() { simpleControl1.Text = text1.value; } The value of "Text" property of simpleControl1 in fact does not change after the code execution. This problem does not appear in .NET Framework 1.0. Could anyone explain this Thanks! I found this while digging into something related. http://support.microsoft.com/kb/911721/en-us spid=8940&sid=228 Nathan ...Show All

• Microsoft ISV Community Center Forums Projects, objects & modules

  I started learning VBA in MS Word yesterday. I have some programming experience in C++ and Java. I am trying to understand how the environment is structured and what Projects, Objects and Modules represent. For example I recorded a few macros using the macro recorder and then opened the VB Editor to see what was created. I notice that under "Project" are 3 folders. One is named "Microsoft Word Objects". Within this folder is what looks like a file named "This Document". What does "Project" represent What does "This Document" represent What is the difference between "This Document" and the "Project&q ...Show All

• Visual Studio Express Editions Start help with threading

  I’m new to c# and struggling to get the code right to run the “ HttpBetFairAccountSnapshotResponse response = request.GetResponse();” as a background thread. Can anyone point me in the right direction HttpBetFairAccountSnapshotRequest request = new HttpBetFairAccountSnapshotRequest (); request.Method = "Get" ; request.Account = defaultAccount; //Execute the request and get the response HttpBetFairAccountSnapshotResponse response = request.GetResponse(); if ( response.BetfairBalance != null ) { localbetfairAvailableBalance = response.BetfairBalance; StringBuilder builder = ...Show All

• Microsoft ISV Community Center Forums Select Syntax problem in a Query

  Hi - i have a query setup that is held on a subform that displays all activities that have been logged by users.  there is a field called 'leadofficer' that displays the name of the user who logged the activity. Based on prior help from forum users I thought it would be easy enough to set criteria whereby the form, when opened would only show activity where the values in the 'leadofficer' field would equal the value of the user who has logged in - where the value of the user who has logged in is held in a global variable called 'loginname'  - but i was wrong! - ive been wrestling with the SQL syntax in the query but can only get it to work by having the query to prompt me for the name, which is no use because it al ...Show All

• SQL Server OleDb Source Error - Connecting to Oracle 9i

  Hi, I have my datasource in Oracle9i and destination is Sql2005. I am connecting to Oracle 9i through OLEDb provider and when I connect to my DataSource using OLE DB Data Source, I get the following error: Warning at "guid code": Cannot retreive the column code page info from the oledb provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale Id will be used. Could anyone please help me trouble shoot this problem. Regards, Sudhakara.T.P. sudhakaratp@hotmail.com ...Show All

• Visual Basic create controls at runtime in vb 2005?

  i am using vb.net 2005 exp. edt. i want to create some group of controls like labels,texbox and combobox,in runtime .is it possible .For example if user enter 5 in one text box . we have to create 5 set of controls. which control i suppossed to use Tab control or ContainerControl if any othere control is there pls let me know thanks in advance Yes you can...in fact the designer code does it for you. Have a look at the .designer.vb file and you will see how it creates controls. For what you need you can do something like: Dim MyTextBox As New TextBox MyTextBox.Parent = Me MyTextBox.Location = New Point(10, 10) You can then use AddHandler and RemoveHandler to add and remove events for the control. T ...Show All