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...
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...
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...
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.
Just followed your instructions. I also rebooted the computer. I'm getting a EXCEL.EXE process each time I run the code. If I run the code 20 times excel open and closes fine (which is better than before) but I will end up with 20 EXCEL.EXE processes.
Here is the code... maybe I still have...
Hi All,
I recently ran into a problem with closing excel. This code has worked for over a year running 5 times a day with no problem. Recently Mircosoft office and XP SP3 updates came through on my PC. Now the code will not close my excel process. :(
I am using Access 2007 and Windows XP...
Thanks Bob. I will try out your suggestions and report back with how it goes. I've already modified my code a little compared to the original code from the book. I am sure I can apply your instructions as well. :) I will be back in touch.