Recent content by KirkComer

Ahhh... thank you Brianwarnock. It worked perfectly. You have just made my day a lot easier. :) =IF(A1=0,0,IF(AND(A1>0,A1<=8.5),8,IF(AND(A1>8.5,A1<=9.25),9,IF(A1>9.25,11))))

I need a formula to use in a excel spreadsheet... Cell A1 could be any number between 0 and 12. I need the formula to reflect this in Cell B1: If 0 Then 0 If >0 and <= 8.5 Then 8 If >8.5 and <= 9.25 Then 9 If >9.25 Then 11 I'm sure its a simple way to do this without using VBA. I guess my...

I have a chart that I need grouped. It shows only the summary chart for each grouped line. Here is the chart SQL: SELECT qry_focus1.[Main Section], Sum(qry_focus1.Hours) AS [Delay Hours-Summary], Sum(qry_focus1.Occurrences) AS [Delay Count-Summary] FROM qry_focus1 WHERE...

Thanks Brian and Royce. I didn't try Royce's suggestion but Brian's worked perfectly. Thanks Again, Kirk

I use this on most queries where I need to return all results if the form field is left blank. Works like a charm every time... Like [Forms]![frm_main_menu]![Week] & "*" Or Is Null except for this time... I need to filter by week number (52 weeks in a year)... problem is if I enter week "1"...

Did you ever find a solution to your problem? I have the same problem. Unchecking the DDE checkboxes did not help. If I run the access database from my desktop (or anywhere else) by clicking on it normally I get the error message. If I hold the shift key when opening the access database I do...

Just wanted to let everyone know that I believe I have figured out the cause of the EXCEL.EXE processes not closing in task manager. I had one computer that was working correctly. I did the microsoft update for Windows Live and immediately the same problem started happening. I then...

Okay. Thanks. I will try this out.

Kiwiman, Is this what you mean? http://support.microsoft.com/kb/210050

It has to be something to do with those microsoft updates I recently received on my computer. I'm at a loss on this one. Maybe microsoft will make a update to fix my update. lol

vbaInet, I removed everything except what is necessary to do the excel dump. All you have to do is open the "testform" and the code will run. I still have the same problem. I just tested it on another computer and it worked fine with no processes left behind. Kiwiman, Give it a try and see how...

XP Service Pack 3 Microsoft Access 2007 Microsoft Excel 2007

Its got linked tables (so it won't work) but I could maybe just make them into regular access tables if needed for you to test. I'm sure its something from the new updates because I haven't had this kind of trouble since I started using the code over a year ago.

vbaInet, Made the change but same exact result. I always close out all the EXCEL.EXE before running the code.

One of the microsoft updates was the addition of microsoft office live to my computer. I wonder if that had anything to do with it?