Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: chromarog
  • Content: Threads
  • Order by date
  1. chromarog

    Access 2007 NZ() is working but the group by is not grouping

    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...
  2. chromarog

    Access 2007 NZ() is working but the group by is not grouping

    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...
  3. chromarog

    Access 2007 query to fill a textbox

    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...
  4. chromarog

    Access 2007: Help in summing up two summed columns.

    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...
  5. chromarog

    IE Shortcut on start menu opens "Open With" dialogue box

    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...
  6. chromarog

    Excel resizes margins based on printers

    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...
  7. chromarog

    Vista System Builder??

    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...
  8. chromarog

    Please please tell me what the &*$% I'm missing!!!

    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...
  9. chromarog

    BoundColumn conditions

    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...
  10. chromarog

    Textbox1.Focus() errors out in MOBILE asp page

    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)...
  11. chromarog

    Concatenation in a Case Statement

    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...
  12. chromarog

    PC Migration

    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...
  13. chromarog

    Multiple Parameters from one dropdown select

    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...
  14. chromarog

    Missing Text in Mapping Editor - PC 7.1.2

    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...
  15. chromarog

    Access database on the network is getting corrupted

    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...
  16. chromarog

    Ok, here's the background. We are o

    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...
  17. chromarog

    Power Supply Requirements?

    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...
  18. chromarog

    Word2000 replacing names and pronouns with "I"

    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...

Part and Inventory Search

Back
Top