Christopher L's Q&A profile

• Visual Basic Requery Not Updating Control

  I am using Access 2003. I have a subform on a form (form1). The record source for the subform is a complex query that has calculated fields in the query. The subform just displays the query values (it does not calculate fields in the subform). When a process on another form (form2) executes, it updates data in a table that the subform (on form1) record source query is using for one of its calculated fields. When the form2 process adds a new row to the underlying tables of the subform query, a Subform.Requery will successfully show any new rows in the subform with all the values calculated correctly. But when the form2 process just updates a single field of a table that is referenced in a calculated field in the query of the subform r ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. incrementing a value over time?

  do you know how I can create a function that runs every second or know of one that runs every second so that I can use it as a means of incrementing a value over time, is their a way to do this, also code would be a big bonus. Create an "elapsed time" member variable in one of your classes - your Game class, for example.In your overridden Game.Update() method, update the member elapsed time using the GameTime that was passed in. When the member elapsed time has passed 1 (for one second), you know that one second has passed. Subtract the 1 second from the variable and then do whatever it is you wanted to do. Your Update() method, in your Game-derived class: protected override void Update(GameTime gameTime) { this.elapsedTime ...Show All

• Microsoft ISV Community Center Forums Run Time Error 9 when Calling a Userform

  Hi folks, I am getting a run time error # 9 when I run a macro that calls a Userform or when I try to run code in a Userform module. The code performs beautifully on my computer, but it did not work on a coworker's computer. It ended up working on 3 out of the 5 computers I have tried it on. I have tried changing security settings to low, and a bunch of other stuff, but I cannot get the code to run on the computers that get the run time error on them when I try running the code on them. I get the run time error when I try to load or show any userform in the workbook and I get it if I try to run code that is in the userform module. However, if I paste the code into a regular module and run it, the code runs fine. Does anyone know what co ...Show All

• Windows Forms Put a glass panel over form while processing?

  Dear all What i would like to achieve is placing something like a glass panel over the form while is doing some processing and show a proress bar. Little something like that , which would informa the user that something is happening:) Any ideas or advice Is there any code examples Cheers Oh, I know that it's not meant as an interactive control. What I meant was, the first time I make it visible, I clearly redraws itself about 5 or 6 times before it settles down. After that, subsequent Visible = true calls are fine. It seems to have alot to do with the alpha blending. The lower the alpha, the greater its apparent need to redraw. ...Show All

• Visual Basic Project-Properties-Settings Question

  My application connects to sql express with a connection string. Question is, in the settings connectionstring, There are 2 choices. 1. Use Windows Authentication. 2. Use SQL Server Authentication. If I use #2 (Use SQL Server Authentication), and enter a Username and Password....Does that mean that the login must always use the same Username and Password ...Are they hardcoded...Can I use a variable ..If so, how I'm not sure what item in list I should add the connection string to. I went to Properties-Data-(ApplicationSetting)-(PropertyBinding)..looked at list ...Show All

• .NET Development Socket listening and Accepting

  Hi, I've recently tried experimenting with socket listening but am having a few problems... The code I'm using is the following: Private Sub Socket_ConnectionRequest( ByVal sender As Object , ByVal e As AxMSWinsockLib.DMSWinsockControlEvents_ConnectionRequestEvent) Handles Socket.ConnectionRequest Socket.Close() Socket.Accept(e.requestID) MsgBox( "Accepting connection from: " & Socket.RemoteHostIP) End Sub I'm trying to make it so that every time a user connects, it Accepts their connection, but what's happening now is it is only accepting one connection and denying the others. Is there any way I can fix this Please help! I've updated my code to VB.NET ...Show All

• SQL Server How do I determine the IP number and TCP Port of a SQL instance

  I'm trying to determine the specific IP address and the TCP port on which a SQL server is communicating. As far as I can tell, I can't use SMO for this, since I need a method that is compatible with both SQL 2005 AND SQL 2000. Is there a work around or can I use DMO Since my target is to be able to use this code against multipel servers, it would be nice to find the method with the least overhead possible. I would also like to avoid being forced to read registries remotely. -- Jakob Bindslet According to BOL (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/smo9/html/6527388b-26b5-4ebb-8a52-0cf4415f9134.htm) the Microsoft.SqlServer.management.Smi.Wmi namespace isn't supported on SQL Server 2000 and below. ...Show All

• .NET Development DateTime format

  Hi everyone, I’m stuck with datetime matter. I’m getting totally crazy with that. I’d like to obtain the following format: 2006-08-11 08:08:22﹐ but I have not success at all. Let me know where am I failing. Attach you the snippet of code: ci = New CultureInfo( "en-GB" ) Dim datetimeVal As DateTime Dim result As Boolean result = DateTime.TryParse(System.DateTime.Now, ci, DateTimeStyles.AssumeLocal, datetimeVal) datetimeVal own 8/11/2006 8:13:32 format. But ci.DateTimeFormat.UniversalSortableDateTimePattern returns "yyyy'-'MM'-'dd HH':'mm':'ss'Z' for that culture. Thanks a lot, Try something like this: Dim ci As CultureI ...Show All

• SQL Server Problems with Win2000 connecting

  I have a SQL Server 2005 in use locally. I'm trying to connect a remote location. Using WinXP Pro, I can connect just fine. However, when I try the same connect string on a Win2000 or WinXP Home computer, I cannot connect. All these computers are plugged into the same network (hub even). I've updated all the computers to MDAC 2.8. To connect, I open the ODBC Administrator in Windows, enter my SQL Server IP and instance name: xx.xx.xx.xx\abc, change the network library to TCP/IP and enter my username and password. This works great on the WinXP Pro machines. This is the error I get on the other machines: [Microsoft][OBBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()). [Microsoft][OBBC SQL Server Driver][TCP ...Show All

• Visual Basic Parsing a non-delimited(space I imagine) text file

  I have a text file that has been exported from a Progress Database v8.23e (this is an old system, i know) . I need to parse the data to a dataset or XML or anything that has structure heh, any ideas Ive tried multiple threads here on parsing text files as well as searched MSDN/Codezone and they did not work. 0278XX'S XXXXXX PXXXXXX #49 101new multi unit 94919S & W WHOLESALE SAND ACCXXXXXX GRILLED CHICKEN SALAD 5.00EA428565-00 3.95 09/07/06 0278XX'S XXXXXX PXXXXXX #49 101new multi unit 94919S & W WHOLESALE SAND ACCXXXXXX CHICKEN SALAD ON CROISSANT 4.00EA428565-00 3.25 09/07/06 0278XX'S XXXXXX PXXXXXX #49 101new multi unit 94919S & W WHOLESALE SAND ACCXXXXXX CEASAR WRAP ...Show All

• SQL Server SQL 2005 Express install fails on XP64

  I have had 3 tries at getting SQL Server 2005 Express installed on my XP Pro 64-bit. In the System Configuration Check at the start of the install process I get two warnings: COM Plus Catalog Requirement and ASP .NET Version Registration Requirement (64-bit ASP .Net is Registered. Required 32-bit ASP .Net to install Microsoft Reporting Services 2005(32-bit).). In the Setup Progress I get green ticks for MSXML6, SQL Setup Support Files, SQL Native Client and SQL VSS Writer, but half way through SQL Server Database Services I get a popup - Generic Host Process for Win32 Services has encountered a problem and needs to close. Then another popup - SQL Server Setup could not connect to the database service for server configuration. The er ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA 360 games.

  Will you be able to burn game's off your computer from the XNA game studio or not Hey come on, there will never be a "Oxy-Acetalene torch" edition. That was a joke... The only distribution method will be live, burning it to a disc will never be possible because the xbox does not play burned cds. ...Show All

• .NET Development Automatically detect Internet Disconnection C#

  hello all, I am making a program (Internet Dialer) in C#.Net(visula studo 2003) that automatically connects to the internet using Ras APIs. It has been done successfully. Now I just want that whenever the internet disconnects (due to phone line taken out or ISP problem etc), the program should not hang up but a message should b displayed so that I am informed about net disconnection. Also if it reconnects, it is good. Now it is so happening that when the net disconnects, the program hangs up and all is over. please help me! thanks in advance to all thanks Rizwan and JonCole! Rizwan I did what you asked to do but it is not serving the purpose! Jon,how can I access these events you mentioned Because I am using a wi ...Show All

• .NET Development Creating a Proxy for Client-Web connection

  Hi, I have created an application that uses internet connection (think of it as a web browser), but this application is going to run on another computer, by another user, and instead of accessing directly the web, I need that application to access the web, through my computer. So basically I need to create a sort of proxy server for that application, so it accesses the web and receives the data, all done through my computer, that will be using a small application to serve as a 'proxy' for the connection between the client application and the web. ? I need help in creating this kind of server, and I will also need to know what will the client application need to communicate with the 'proxy server', that will be my computer. Here ...Show All

• SQL Server Standard Edition vs Enterprise Edition

  Hello, pls i would like to know if i can do a full backup and recovery (with the option of restoring to a point in time) with the MS SQL Server 2000 standard edition Thank you. Emeka Yes, all backup functions are available in all editions. In order to be able to recover to an arbitrary point in time, your database needs to be in "full recovery mode" and you need to periodically back up your transaction logs. ...Show All