Search results for query: *

I'm having trouble with the NZ() functionality. It works the way it should, I'm converting a null result to the number 3, but then my group by's are still seperating the results. SELECT T_VSMSMP2_BreakDown.WOTYPE, nz([T_VSMSMP2_BreakDown.PRIORITY],3) as PRIORITY...

I'm having trouble with the NZ() functionality. It works the way it should, I'm converting a null result to the number 3, but then my group by's are still seperating the results. SELECT T_VSMSMP2_BreakDown.WOTYPE, nz([T_VSMSMP2_BreakDown.PRIORITY],3) as PRIORITY...

I've googled and searched and I'm ready to give up. I never thought it would be this tough. All I want is to click a button to fire a query and have the result end up in a textbox. If the project wasn't going to build on itself and grow, I would look into Dlookup and such, I can't seem to find...

I need some access 2007 help. I have a form I'm working on and I thougth what I wanted was something pretty simple but apparently I'm doing it wrong or going about it the wrong way. I have a query that hit's a table that does some summing up. This is the results: PRIORITY RegSum OthrSum...

I just recovered from duking it out with "XP Antivirus Pro" spyware and I think I got it, however, when I try to start Internet Explorer from the Start Menu in XP I get the "Open With" dialogue box. I can browse to the program files\internet explorer... exe but it will not work. It never shows...

I've run into this before but I just resize and go on, however the people I support freak out about this and I have to agree with the not so computer literate on this one. When an excel form/spreadsheet is created and it is pretty much the whole page being used, the page is created, printed...

I bought a hard drive bundle. It's a legitimate purchase from a reputable vendor. What I THOUGHT I was getting was just a vista ultimate oem disk, what I GOT was vista ultimate system builders edition. I haven't opened the shrink wrap yet so I can still send it back, but if I don't need to...

I'm trying to do the right thing by using stored procs but i'm really leaning toward ad-hoc if I can't figure this out. I've been working on this for two days now and I'm getting no where. In short the page is loaded with ONE line in a datagrid with a button to order. The page load works great...

I need to have a seperate column that displays a warning if the condition is met. I'm trying to find examples of if then statements but I can't find anything out there or I'm looking for the wrong thing. I'm looking to add a fourth column that will have a flag, text, picture, anything, that will...

I'm trying to create a scanning application. The last hurdle I have is to get the form to load with the focus in 1 textbox. Me.ActiveForm = Me.Form2 TextBox1.Focus() I get "A form tag with runat=server must exist on the Page to use SetFocus() or the Focus property. " I have 17 (SEVENTEEN)...

I either need a resolution to what I have or a cleaner way to get the desired results and I've looked around, I keep getting a "EUREKA" moment only to be disappointed that the results are still the same. I'm trying to get a 3 digit number from a longer string. It's a varchar column. The last...

I've searched the forums already so if this has been addressed, I apologize. I just want to make sure that there haven't been any new ideas on this topic. I do all the pc imaging (among other things) here and I have a unique situation that I knew would one day come. I have to migrate a pc for...

Ok, I'm going attempt to describe what I need. I want to choose a parameter from a dropdown list of months. When I select a month (January for this example) I want the start date to be passed to the @startdate parameter (this is successful), but I ALSO want to send the end date for the month...

One of those bizarre things. I upgraded to 7.1.2 and in the mappings designer, when I double click on one of a list of mappings, which brings up the Edit dialogue box, then click on the ports tab, the text is WHITE on WHITE background. In the process of posting this I've solved the problem...

I posted this in the Office forum and have been keeping an eye on the thread but I would like to ask the Novell guru's this as well. thread68-432977 is a snip from the descrition from the above post: When a user opens up an Access database, the LDB file is created with info of who is opening the...

Ok, here's the background. We are on a large Novell Network with multiple mapped drives etc etc. We have a bagillion files on the network. Now.. Access databases seem to be having trouble. When a user opens up an Access database, the LDB file is created with info of who is opening the file...

I'm currently running a 1.3 duron on an abit kt7, non raid. I'm currently running a geforce2gts 32meg card. I bought an mx440 128meg card. I plugged it in, it booted fine, detected the card, all was looking good. I changed the resolution and lost power. It constantly reboots once it gets to the...

While writing fiction, names in my story as well as the pronouns describing them, were replaced with "I". Not automatically, but somewhere along the way during the multitude of Save Now and Save Often that I live by religiously. I also transport on floppy. So, is there a known problem...