Search results

Where? I NEVER said that, nor do I think ra** is ever okay. Ah, but that's an assumption on your part, which I've just cleared up. Multiple times. It's not just about ONE life, it's about TWO lives, and taking responsibility for another life under your care! Look, I realize ra** is an awful...

For that matter, will we ever really know? I find that life is very much rooted in mystery, and the further that we dig, the more questions. And questions are a good thing! But we never can, nor ever will know all the secrets of the universe no matter how hard we try to unravel, otherwise...

Well, it might not appear to be logical because it doesn't follow the normal knee-jerk reactions these conversations can have. My main point is that regardless of how the conception occured, it occured. Through nature it results in a human. The Founding Fathers of the United States believed...

Well, basically, it is multiplying one column which uses a combo that queries against a database to pull values. These numeric values all have labels (lbs., kg, etc). The combo box records the value to a table. Because of the text involved, I cannot have that part of the table be numeric, so...

I don't believe I did that. I guess you can go back and re-read. But there are folks who legitimatize ra** as a reason for abortion, but not when it was consensual. I just don't understand how ra** can make a difference if a birth should occur or not.

In the case of ra** of an innocent person, does it mean the resulting baby is somehow "less" of a human and therefore doesn't deserve being brought up to be a part of society? Isn't labeling "ra**" as ok but "abortion-as-birth-control" just classism of what's right is not? To me, life is life...

I have a query which calculates results from varioius cells. Some of these cells will legitimately have #Error values in them. At the end, all the calculations are tallied together to return a final result. How can I tell Access to ignore #Error, or to recognize it as a null value?

Lutheran, 24, USA. I oppose abortion unless the woman's life is at risk. I believe in the unalienable rights to Life, Liberty, and the Pursuit of Happiness. While I do believe needless abortion violates all three of those principles, it particularly violates the life one. I'm not coming at...

I have a form/query in which people enter various data regarding what is on a pallet. For every item there is a default quantity which is pulled from a table. The quantities all include amounts like "50 lb. bags". I need do do a calculation based of the quantity of the items (IE there are 40...

I am building a placard tool which will be used to identify pallets containing up to 10 different items. I would like for the user to be able to select on a form how many different items will be on the selected pallet before being able to input the data. For instance, if the user inputs "5"...

Hi all, I have a table in which multiple item numbers are stored in the same record. I am trying to build a query in which the item descriptions are pulled from a different table, but can still tie together the item # and the description multiple times on the same record for different item #s...

*Phew* I thought I was going crazy! I tried rebuilding the entire sheet as well from scratch and was still getting the same error. I appreciate Holger's help; I hope he has an idea of what's going on here, because I'm stumped and am not sure how to fix this. The issue comes down to between...

Hi Holger, I don't quite understand what you're getting at. What didn't I care to mention? I've shared everything possible and I'm really trying to learn and understand what's going on. You've been of great assistance to me, so I'm not understanding where you are coming from on that last...

I do seem to have one issue left. When I close out the workbook, I get a runtime error '1004' when a filter has been applied. Upon closing the workbook, I'd like for the filter to be "un-filtered" but not removed completely, so I used a combination of both your code and Brian's code. Here's...

I removed the reverse as advised (it appears to be redundant) but onTime still fails. I'd think that onTime and this function should be able to co-exist together. :/

Well, I added in the following code: ActiveSheet.Unprotect Password:="TNT", UserInterfaceOnly:=True, AllowFiltering:=True and the reverse when the workbook closes: ActiveSheet.Protect Password:="TNT", UserInterfaceOnly:=True, AllowFiltering:=True but this has been causing OnTime to fail. How...

Thank you; that works perfectly!

Thank Holger! A couple of questions: first, it seems to take the AutoFilter off completely. Is there a way to leave the Autofilter on the worksheet but just reset the values to "all" so the filter is active, but the filters applied to the worksheet are removed? Second, is it possible for...

Hi all, You guys have been a huge help with my Excel conundrums the past few days! Is there a way I can use VBA to automatically remove filters on a sheet and have it default the active cell to A1 when a sheet is saved and closed so that the next person to open it sees it "fresh"?

Is it possible for Excel to force quit after a certain period of inactivity? I have a spreadsheet that unfortunately can't be shared due to a couple issues that arise whilst sharing. I'm just concerned that if someone opens the sheet and walks away, they lock out other people who need to...