iNow

Yeah, doG described this process to me on the last page of this thread. I'd never seen it before, and it was cool. However, the suggestion is a bit like telling me to split a novel written in Swahili into individual sentences. It doesn't matter how small I make the chunks I'm analyzing, I don't speak Swahili. Yeah, I may be wrong, but I don't think this is the problem. I set most of it up using the wizard. I didn't write a single line of code. I just changed the values in the Properties window. Like I said, I was really close before opening this thead, but just couldn't get it to work. My gut tells me that the reason the title is populating the code field in my output table is that I set the textbox "Control Source" equal to "Code." I am pretty sure that doing so told Access that I wanted whatever value is in the Title field of the form to be entered into the Code field of the output table. It makes my form look good, but seems to miss the intent on my output. Anyway, thanks for the offer to look at my code, but as I mentioned above, I haven't written any. Any code I entered was a copy/paste job from truedeity and doG. Unfortunately, none of those got me where I needed to be (or, more accurately, I didn't understand it well enough to make it work), so I reverted back to my previous approach which at least had the form working as I wanted. line[/hr]

My first thought is that it would heat the disk through which it passes, but I'm really not certain.

North, Considering what you've said is counter to the previous posts in this thread, you need to share some evidence in support of your position, or, at the very least, some math describing the gravity in the center which supports your claims.

Nonsense. You may as well have said that purple unicorn farts cause erections in leprechauns. Let's see some evidence in support of your claims, north.

Are you in charge of hanging the Mission Accomplished banner? That's pretty sweet, dude. I hope you enjoy the experience.

This is wrong. If you care to prove your assertion with citations and/or evidence, please have at it.

OTOH, the way it's currently set allows users to choose for themselves. I don't care either way, myself.

Some of us prefer to sign our messages of thanks.

One major incorporating both is an interesting idea, hence Mokele's suggestion of biochem.

This is simply false, and can be rejected on its face. Your argument implicitly suggests that even people born with genetic brain disorders have the same potential for achievement as people without said disorders, and that is just untrue.

Indeed, you're correct. Sorry about that. The answer then is the atmosphere. It's our atmosphere which causes the lag. http://solar-system-astronomy.suite101.com/article.cfm/first_day_of_winter Earthly Conditions as a Result of the Solstice In the winter time, those in the Northern Hemisphere receive fewer hours of sunshine and less direct rays of sunshine, which combine to make it the coldest season. Many people wonder why the "first" day of winter isn't the middle point of winter and why it's not the coldest on the solstice. It is understandable to wonder why, if the December solstice marks the shortest day and the farthest south the sun will get, that it hasn't been colder leading up to the solstice and that it doesn't get warmer more quickly as the sun moves north again. The answer lies in the Earth's atmosphere. It is a cumulative effect. In the summer, it takes the atmosphere a while to warm up from receiving the additional radiation, and therefore it is not hottest at the summer solstice. In the same way, the atmosphere has taken some time to cool down so that it is not the coldest at the winter solstice. The same thing can be noticed in the atmosphere on a daily basis. It is not warmest during the day when the sun is highest but in late afternoon. It is not coldest in the middle of the night but instead just before the dawn. Or, using an analogy: http://www.usatoday.com/weather/resources/askjack/wfaqsson.htm The coldest part of the year lags about a month behind the shortest day, just as the warmest days come a month or so after the longest days. To keep the answer simple, we won't consider warm or cool air coming in from other places, but will assume the air at a particular location stays in place, warming and cooling. We could think of the air in such a place as being like a bank account. If you add money to a bank account, it grows. If you add heat to air it warms up. The Earth is always losing heat, like a bank account that you're always taking some money from. If the amount of heat arriving from the sun is exactly equal to the amount leaving, the temperature stays the same. As days grow longer in spring and early meteorological summer, the balance tips to more heat arriving than leaving. This is like adding money to the account faster than you are withdrawing it. The air grows warmer and warmer. On the longest day, the amount of heat arriving is greatest. But, even after the days begin growing shorter, the amount of heat arriving is more than the amount leaving. It's like continuing to add more money to the bank account than you're taking out, even though you are adding less than you were before. Sometime in the late summer or during the fall, depending on how far north of the equator you are, the heat "account" is in balance. From then on, more heat is leaving than arriving and the days grow colder. Now, you're taking out more than you're adding to the account. In December, when days are shortest, the "withdrawals" from the heat account are greatest. But even after the days start growing longer, more heat is leaving than arriving. The heat account is growing smaller, even though less heat is leaving. Eventually, however, you arrive at a day when the amounts of heat leaving and arriving are in balance. Then, the amount of heat being put into the account becomes greater than the amount being withdrawn. The air begins warming up. Here's a graphic and text that help show why longest days are not the warmest.

Hi Ishmael, It's not so much a factor of "how long the sun is out" nor "how long the day is." The duration of the day is not as important as the angle at which we face the sun. So, in winter, the light we receive from the sun is at more of an "oblique" angle, so basically it's effect is less intense (the radiation from the sun is spread out over a larger area and has to travel farther, therefore is more dissipated on arrival). This is all explained pretty well here. Maybe it will help. Ask more questions if you have them. http://en.wikipedia.org/wiki/Winter

No worries, friend. I know you conceded the point, and that you are also not against gay marriage. Further, it was not really you who suggested the 5,000 year definition, but it was Warren (whom you quoted in post #8). He was the one who said it, therefore he was the one being ultimately rebutted. You just felt the brunt of it since you were the one sharing his quote in support of your argument. I think part of the passion against him is the fact that he equates gay marriage with incest and pedophilia. That's where he is being an ignorant buffoon, and that's where people take issue with him and his invitation to the inauguration. He has done great work, on climate change, helping in africa, and many other things, and his leadership on those issues is to be commended and acknowledged. However, he is still really wrong and really ignorant on the issue of gay marriage, and his heavy assistance in the passage of Prop 8 should be strongly criticized, and he ostracized for equivocating gay marriage with pedophilia and incest and supporting state laws that are implicitly discriminatory.

Boy, ain't that the truth. You're right, I think we agree on much of this, only disagreeing on our sense of the urgency required to mitigate the risk caused by CO2. Cheers.

Okay. It's a fresh new day, and I've had my Sunday morning political round table fix (I've grown to enjoy This Week w/George S more than MTP lately, but have pleased with the new tone and pace offered by David Gregory). So, I've read your comments, and think I understand it. The basis seems to be that you don't pass the actual code to the compiler, but instead work with concatenated snippets of various pieces, which when appended to one another, will be read as the proper code statement. More or less correct? So, from a high level view, that makes sense to me. I understand the logic, which helps. Here's where I struggle, though. I don't know Visual Basic, neither the syntax or the commands, nor do I really understand how Access forms tie all of the information together. It's as if I've been taught that an adjective modifies a noun, and that a noun is a person, place, or thing, but when shown either (red or table) I don't recognize it as such. I'm like, "Red?" What's that? Never heard that before." So, I tried to update the RowSource field on my title value (the one I want to autopopulate based on the users selection of course_code in the combobox), but nothing happened to the Title listbox when I made my combobox selection of course code. It just sat there. I also tried to do the append semicolon (& ";") statement you suggested at the end of your post, but the results did not change. So, in essence, I'm back to where I started. Before I opened this thread, the closest approach I had was to set the Course_Code combobox with Bound Column = 2. Then, I changed the ControlSource on my Course_Title box to be the "Code" field (instead of the "Title" field). This worked... It populated the correct title into the Title field based on the code selection in the code combobox. (see attachment) The failure, however, was in the Output Table. By changing the Control Source of my Title field to the Code field, I wound up outputting Title information to the Code field of my Output Table, which also left the Title field in the Output table blank (so, it made the form look correct, but didn't feed the data the way I intended). Like I said in the OP, I know I'm missing something painfully simple, I just don't know what that is. Thanks to each of you who have bothered spending a little time to try pointing me in the right direction. Your contributions are not unappreciated.

One idea would be to visit the staff and students of each of those departments at the schools. You can do this either before applying, after being accepted, or even some combination of both (heck, you could even wait until your sophomore/junior year, time is not the issue here, the visit is). Walk around, look at the facilities, chat with the students, sit with the professors, basically... explore. If you do this, chances are good that (in your gut) you'll know which one feels more "right." Good luck, and welcome to SFN.

It was not my intention to be unfair, so I do apologize for that. I know you're intentions are good, so I should have been more careful. However, the point I take issue with is your attempt to objectively designate the gay marriage issue as less important than getting divided peoples working together, as such a designation (less/more important) is inherently subjective. Further, one could easily argue (and, in fact, I have in many of these threads) that arguing for equality in state regulations and applications thereof is actually MORE important than the less tangible and more abstract goal of coming together ideologically. The former represents an issue of personal liberties and equal application of the laws to minority groups, whereas the other represents an issue of shared progress based on deeper principles. After all, we all find ourselves within at least one minority group during our lives, and we each would demand equal protections and applications of state rights and regulations when we do. That doesn't mean we cannot work in parallel to find consensus and shared interests, nor that these priorities are in any way mutually exclusive, only that some changes require immediacy while others require consistency, two rather different political arenas, indeed.

Well, the Supreme Court disagrees. While I would not normally cite the SCOTUS in a science discussion regarding the harmful and disasterous effects of CO2, this is a politics thread, and I am rebutting a political/policy point you made, so find it extremely relevant. http://www.nytimes.com/2007/04/03/washington/03scotus.html In one of its most important environmental decisions in years, the Supreme Court ruled on Monday that the Environmental Protection Agency has the authority to regulate heat-trapping gases in automobile emissions. The court further ruled that the agency could not sidestep its authority to regulate the greenhouse gases that contribute to global climate change unless it could provide a scientific basis for its refusal. Following its discussion of standing, the majority made short work of the agency’s threshold argument that the Clean Air Act simply did not authorize it to regulate heat-trapping gases because carbon dioxide and the other gases were not “air pollutants” within the meaning of the law. “The statutory text forecloses E.P.A.’s reading,” Justice Stevens said, adding that “greenhouse gases fit well within the Clean Air Act’s capacious definition of air pollutant.” http://en.wikipedia.org/wiki/Massachusetts_v._Environmental_Protection_Agency The petitioners were found to have standing, the Clean Air Act does give the United States Environmental Protection Agency (EPA) the authority to regulate tailpipe emissions of greenhouse gases, and the EPA is required to review its contention that it has discretion in regulating carbon dioxide and other greenhouse gas emissions—specifically, its current rationale for not regulating was found to be inadequate, and the agency must articulate a reasonable basis in order to avoid regulation. In addition, the majority report commented that "greenhouse gases fit well within the Clean Air Act’s capacious definition of air pollutant."

Well, there will be some "buyers remorse," in that many people did seem to have artificially high expectations of Obama. In that sense, some people will be let down when he simply can't do it all. Me, I find that he was definitely the BEST choice, and that he is certainly going to do better than those who opposed him would have (it's all relative essentially). However, to the thrust of your point, we tell these ideological scumbags how wrong they are, and how much they're hurting the country all of the time. But, you know what? Logic is wasted on their position, as they construe all disagreements as coming from people who "hate america first" or are "liberals" or whatever other derogatory label they can conceive. They don't listen to reason, they attack it, and it reinforces the bubbles of their worldview.* How do to deal with this, I'm not sure. All I can suggest is that we keep winning over the minds of people with logic and reason, and hopefully soon such idiotic approaches like those of Scarbourgh are marginalized into the realm of the inconsequential. * Like this (the example in the first minute and a half): http://www.thedailyshow.com/video/index.jhtml?videoId=213369&title=halloates-pay-tribute-to-alan

And the CO2? Is that not a pollutant in your approach?

Well, yes. It does exemplify the hypocrisy of the Christian view on this, but more... It defeats the argument that "marriage has been the same for 5,000 years," which is the context in which it was first shared in this discussion. I think it may have been you who said this, or maybe ParanoiA, but the fact is that no, marriage has changed dramatically through the years, and the Christian church itself had gay marriages often just a few short centuries ago. The point being, we can't lie to everyone about reality just to maintain some alignment with a bigoted and misguided worldview, nor should we accept faulty arguments in support of a weak position. That's crazy. "It doesn't impact ME much, so let's just let it work itself out." Sorry, mate. That's crazy. The majority is shifting, and the problem is hugely important to those it impacts. The fact that it doesn't impact you very much directly really matters not. What you said above is just crazy, and baffling really.

TBH, none of it was obvious at all, in fact, most of it went over my head. I need to look at it again in the morning. I just got done doing some more work in my master bathroom, and am tired. The thing is, I'm not really a code person (yet). I had a class in HS about 14 years ago where we learned some Pascal. The then took an intro to SQL 3 day class about a year ago, and that's all I got. I do a lot of stuff in databases for work, but it's almost all put together using the graphic editors (and self taught at that). Anyway, I know I'm capable of figuring out coding syntax and languages where needed, but I'm not even sure where to start with Access. Thanks for the post above. I'll review it again after Meet the Press tomorrow morning to see if i can digest it and put it into practice. Cheers.

Okay, that made the error go away. Now, when I select the dropdown menu on the combo box, nothing else happens. The title field stays blank. EDIT - Never mind. Had to set the Bound column = 1 (it was set to 2 previously). Now, the title field does populate with a title value, but no matter what selection I make in the combo box, it always shows TitleONE. (even if I select Code2 or Code3, it doesn't change to TitleTWO or TitleTHREE, just remains as TitleONE) EDIT2: Okay, so I closed the form, deleted my output table values to start and test from scratch, and now selecting the code value in the combo box doesn't do anything (i.e. The title field remains blank). EDIT3: If I change the Bound column in my Title box to "0," it again shows TitleONE regardless of selection.... EDIT4: Never mind. I closed the form, emptied the contents of the output table, and reopened the form to test again... the Title field isn't populating at all, even with BoundColumn in Title field = 0

Thanks, TDS (also, good seeing you). What's the r in your equation? It looks like mass of the electron times velocity of the election times radius (?.. didn't think electrons had radius) equals plancks constant over two pi. I just don't know enough about it to know how that equation applies to the question at hand.

No, it's not a bad thought at all, but I keep getting an error when I try.