oompa_l's Q&A profile

• SQL Server attempted to divide by zero

  hi, i had this formula written for a textbox in a table, but yet still encounter the following error: expression: =iif(countdistinct(Fields!room.Value)=0,0, sum(Fields!rate.Value)/countdistinct(Fields!room.Value)) error: attempted to divide by zero. any way i can solve this problem thanks! HI Everyone, I generally use the following statement =IIF(Fields!Profit.Value<>0, Fields!Profit.Value/ Fields!Sales.Value, Nothing) For the most part this formula is simple and effective... BUT (there is always a but!!) I received an error message "attempted to divide by zero". I checked the tables to validate column formatting and everythin ...Show All

• Visual Studio Express Editions Making 1.1 Framework applications in 2005

  I was just wondering, cuz im sure there is a way, to make .NET Framework 1.1 compatible applications with VB 2005. I mean like make a program that would run on any computer that a program made from VB 6.0 would- u kno with the older looking buttons and all. Id appreciate nebody who knos :) To all intents and purposes this answer is correct - however you can write applications for the 1.1 framework using nothing more than notepad and the .NET framework 1.1 installed. You can compile these using the VBC.EXE compiler which ships with the .NET 1.1 framework. That said - you could use VB Express to create the souce files, which you would have to ensure didnt use any .NET 2.0 framework functionality which d ...Show All

• Visual Studio Express Editions Having trouble updating underlying database

  For some reason i can not update the underlying database. Some times when i first run the app after all the controls are set up i get one viewing and one update and then i get a NOT able to COPY database or Can not Access..... This has something to do with the database not being in the debug bin folder...I am not in debug mode when this happens. I have followed the video line for line; step by step and i am having so much trouble with this... Here are my steps.. 1. start new project 2. add database to project 3. add datagrid to form 4. assoisate grid with dataset and binding source And this code in the behind-------- private void Form1_Load( object sender, EventArgs e) { // TODO: This line ...Show All

• Visual Basic Bubble sort numbers in a listBox

  I am a student.  I have a lab that I am working on that has a listBox that I can enter numbers into. The numbers are all integers. I enter them via a textBox and an enter button. I have this part figured out.  Now the hard part.  how do I get these numbers entered into numerical order with a sort type function or subroutine. I figure we have to 1. put them in order, and then 2. put the newly sorted list back into the list box, replacing the old out of order list. any tips here would be greatly appreciated!  I can't find anything in the text as to exactly how to do this. The action will all tie to a "sort" button . thanks again!       I did notice on ...Show All

• Visual Basic Where is the Fill() method?

    I am trying to add new rows to MyDataBase.mdb with the below code. My problem is that it does not identify the columns. It fails with the error message “Name1 does not belong to Customers”. But it does so do Name2. I think it’s locating the database and table as I can retrieve data with the open code using SQL Select.   Can anyone help Please hemo   Dim connection As New OleDbConnection()         Dim myadapter As OleDbDataAdapter         Dim myDataSet As New DataSet          Dim newrow As DataRow         Dim MyTable As DataTable &nb ...Show All

• .NET Development Node vs. Element? Collapsing... Elements?

  I've been developing a customized C# XML serializer, because of the lack of support for Generics using the XmlSerializer class, and I use the XmlElement quite a bit. One of my questions is what is the major difference between a Node and an Element I see that the XMLElement class inherits from XmlLinkedNode, which inherits from XmlNode, so does the word "element" simply define a "group of nodes", but can be a single node I am just curious about is all. Whatever the "group" is, my real question lies with how to programmatically collapse these "groups" My Xml file will be representing a config file that can easily end up to be 20+ pages long, so it would be really helpful to collapse ...Show All

• Visual Basic Image On Mouseover (Repost because nobody replied to the origional)

  How do I get an imgae to display & follow the mouse by having my mouse over another image You can also set up a custom cursor that only displays when over a particular control: ' Cursor from image example. ' Example uses a button, picturebox ' and openfiledialog Public Class Form1 Dim pubcur As Cursor Private Sub Button1_Click( ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click OpenFileDialog1.Filter = "Jpg files (*.jpg)|*.jpg|Bmp files (*.bmp)|*.bmp" If OpenFileDialog1.ShowDialog = Windows.Forms.DialogResult.OK Then ' If you do not size the cursor's source ' bitmap as shown below (32x32). The ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3D racer problem (collisions)

  Hi im trying to make a very very basic 3d racing game. Basically, ive spent hours trying to work out how to detect whether my rocket (the car) has left the side of the track or not. I cant work out how to properly use bounding boxes/bounding spheres in 3D and i dont understand how that would even work with a track with bends etc. Here is my source code for you to download and try and understand what I mean. Any help is really appreciated. EDIT - http://www.sendspace.com/file/6pcunk http://www.megaupload.com/ d=G6CLZF70 Or if someone could just explain how to go about working out whether the car has left the track or not What fuctions you should use or whatever. Music - aren't this worms Hmm even by loo ...Show All

• Windows Search Technologies WDS 3.01 not displaying Outlook 2003

  Hi, I have been using WDS 2.06 for a while, and recently had to install WDS onto another computer in my office. I have now installed WDS 3.01 for Windows XP onto this computer. For some reason I cannot index Outlook 2003. I have the option of indexing Outlook Express (which is NOT the default mail program), but not the option of indexing Outlook 2003. Please advise if there is a way of making Outlook 2003 available for indexing. Please bear in mind that I am not as computer literate as I would like to be. Thanks James Thanks, it is working now. I guess I should've considered the fact that Outlook wasn't running at the time! It is often an obvious solution that you just can't see. ...Show All

• Visual C++ Strange Error - Please Help

  Hi all, I wrote a dll (using a definition file). When I call one of the function within the dll from another application (to test the function), I receive a strange error (Messagebox format): Application.exe - Ordinal Not Found - The ordinal 34 could not be located in the dynamic link library. Note I have linked with the .lib file, have included the header file and copied the .dll file to the application directory. (Note that I'm exporting 34 functions) Can anyone help Thanx Oops ... my bad, The functions in bold are the ones that are giving the error...... File Type: DLL Section contains the following exports for ElkoUtility32.dll 00000000 characteristics 45334FDA time date stamp Mon Oct 16 11:24:42 2006 0.00 versi ...Show All

• Windows Search Technologies WDS 3 - RTW Final not indexing .xlsx file which have ODBC SQL Connection

  Hello, Brandon recommended me posting this problem I noticed in the WDS 3 RTW. Basically the WDS 3 RTW, and (Beta 2) cant index the contents of Excell new format (.xlsx), if the excell contains a ODBC (SQL database) connection. The easy way to reproduce is to, create a new .xlsx file using Office 2007 B2TR, create a ODBC SQL connection to any database/table that you have access to. Save the file and wait for index, it will index the filename but never its content. With the WDS 2.6.5 this problem doenst happen. Regards, Marcus Marcus, Ack! - this problem was reported while we were in beta. A bug was filed (and fixed) in a pre-release build. It must have broken again in a later build and made its way to RTW. ...Show All

• .NET Development Formatting problem with layout.

  Well I'm new to asp. software and I'm teaching myself. Never had this problem with HTML so I'm not sure what the difference is. Problem: my tables are shrinking and moving all my content when the Internet Exploerer is shrunk in size. So unless the Internet Explorer is full size my content, text and everything moves. The tables aren't holding their form and content in place. Tables are all set in percents (for widths). Anyone know how I can fix this Thank you. When you specify width in perent, then the layout is auto audjusted relatively to the width of the parent container. Here the parent is the BODY which is the entire browser area. So when you reduce the size of the browser window, the width of ...Show All

• Visual Studio Express Editions Null Reference Exception

  For some reason i keep getting this "Null reference exception was unhandled - object reference not set to an instance of an object" Does anyone what this or what is could be causing it. I'm using arrays to store stuff which then makes an instance of a panel. I have 4 of these, they are all identical and use the same panel, but one of them refuses to work and I get this message, I've checked it over and can't seem to see anything different between that 1 and the other 3. ReneeC, everyone is both political and social, however that is not why we are here. There are many forums for discussing those subjects. This is a programming forum and I respect it as such and will not be baited into other discus ...Show All

• Windows Forms How do I reference a control's properties?

  I am new to VC++ but not to programming. I am trying to change the Text property off a textbox when I click a button. However I cannot determine the proper syntax to reference the text field. Form name - Form1 Textbox name - Textbox1 Button name - Button1 In Button1.Click I tried the following - all of which fail compile Form1::Textbox1->Text = "Hello World" ; /* error C2227 */ Form1::Textbox1.Text = "Hello World" ; /* error C2228 */ Textbox1.Text = "Hello World" ; /* error C2065 */ This can't be that hard, but I can't find where it is documented. If you're inside a form event (like a button click), then something lik this should work: ...Show All

• .NET Development How to compile SimpleSnapIn sample in MMC 3.0 on Win2k3 R2 using VStudio 2005?

  Hi - I'm trying to compile SimpleSnapIn sample but got 3 errors "The type or namespace name 'SnapInInstaller' could not be found (are you missing a using directive or an assembly reference )" The other 2 errors are similar to this error but referred to 'SnapIn' and 'SnapInSettings'. Any idea how to fix this compile error I'm new to MMC 3.0. Jenny You need to add a reference to the assembly that implements the Microsoft.ManagementConsole namespace. I'm not sure how you get that assembly but I guess you need to download and install the MMC V3.0 SDK ...Show All