Search results for query: *

Skip, again I owe you a tall cool frosty mug of a beverage of your choice. Seeing the logistics nightmare there, I'm afraid all I can do is click the Thanks link. And thanks KJV for moving the thread for me.

Nevermind, I reposted. Thanks, Rog...

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

It's an access 2007 query. I'll repost there or will this be moved accordingly?

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

Oops. Sorry, missed the first part of the question. I got all confused when the debug came up bupkiss. But thanks for the solution. It worked!! I had tried the delimiters but I had them enclosed withing the single quotes of my original code. For future reference, is something like this...

All I get is the same message I've been getting. Run Time error 3464 Data Type mismatch in criteria expression. And when I click the debug button this line is highlighted. Set rst = db.OpenRecordset(SUSQL)

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 have another question related to this. How do I get the results to a text box? I would like to populate the results in a text box for each "priority" from the resulting Sum field ABCD. Is DLOOKUP what I'm looking for? I've thought about a single button that fires three seperate queries to...

Oh and Dhookom, I'll have to look into that, there is another column that indicates that hours were put into the process but they were classified as a normal procedure and not a breakdown. I'll use your information for the next step in the project though. Again, much appreciated for all the...

Cool, thanks Skip. I didn't realize that. Thanks for that. Rog...

I owe you one. Thanks a million. Rog...

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've tried the start menu properties of showing and not showing, thinking that it would reset all the registry settings but no dice. The Internet Explorer Icon pops back up in the Start Menu but I still get the Open With dialogue box. My guess when this virus gets it's hooks into your system...

Oops, forgot about that part. It's IE7. And I did try the support link and no good. It still does the same thing. Kjv, the shortcut creation is just as good, the only problem is the shortcut that windows puts in the start menu has that Microsoft shortcut where when you right click, instead of...

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

Sounds like that's what I've been working with ever since I've had a microsoft product. lol. Thanks again, Rog...

Thanks for the quick response. I appreciate it. I guess another question I have is, what's the difference between the system builder license/key and a oem license/key? Is it really the support issue?

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