iNow

I would prefer if we kept to the theme of my first post. What do people think of the idea that global warming so far may be a boon?

I think that some warming clearly has helped mediate any cooling over the past millenium. It's an interesting piece. In the present, however, the key is balance. The amount and speed of our warming, really regardless if the natural cycle would be one of cooling, is happening much too quickly (as you yourself even seem to concede in previous posts, so really, I'm just reinforcing that point, not arguing it).

I must admit, though, I did get a chuckle out of the fact that you would open a post suggesting "boon" when much of this is speculation based on models.

Why not open a thread about how these models can't be trusted either (due to unknown variables)?

Well, trust me, that's not the truth.

I don't trust anyone in this regard. Can you please share with us a few specific examples (preferably quotes or links to specific posts) which support your assertion that people in this community who support their arguments are not respected unless they have a special user title, or that people with special user titles are only respected because of it? Anything with substance?

Bueller? Bueller? Ferris... Bueller?

There are residents here who make claims, without needing to make a suportive source, simply because, and this is the truth, they have earned a certain amount of respect.

Yes, many have earned a certain amount of respect, but, you know what? If ANYONE ever asked them to support a claim, they would. THAT'S the difference.

I'm not going to bother clicking your links, as you didn't even include a summary or snippet, but I do find it interesting that so many of them are CNN links considering CNN has terminated it's Science & Technology section.

Pulling this thread back on topic, you might want to google Computational Fluid Dynamics (CFD) for this. and its going to require a fair bit of processing power.

One would imagine that the modelling could be improved with clever use of fractals or some sort of Mandelbrot maths. As I understand it, they use fractals when doing modelling of moutains and graphic representations of trees and forests and all manner of things. It drastically reduces the need for computing power since you're not modelling each individual object or atom, just letting the graphic model be self-similar in specific ways.

(Also, can a Mod break the quantum computer tangent into it's own thread? Those posts really have zero to do with the question asked, and are rather silly at that).

Truedeity - Again, thanks. You've been a great help. One of the problems I was encountering when googling was not knowing which commands might help me with this. Using your code as examples, I have been working a bit to learn about these specific commands and statements.

Before, I was sort of shining a candle in the dark, but now I'm using a flashlight to look at specific spots. That's much nicer, so really... thanks.

However, I'm definitely in the "I want to figure this out for myself" club, so I'm trying to avoid just copying/pasting as much as I can (if that makes any sense).

An alternative is putting all of the SQL statement on one line without breaking it up. Try

 

strSQL = "SELECT Courses_Table.Course_title FROM Courses_Table WHERE (((Courses_Table.Course_code)=" & Combo0.Value & "));"

Okay. I did that, but then got a 3061 error like I mentioned above, except this time instead of "Expected 2" it said "Expected 1."

So, I have the combo box, and I right-clicked and selected "Build Event..." Here's what my code looks like right now, strSQL statement included, with actual field names:

Private Sub cboCode_BeforeUpdate(Cancel As Integer)
Dim db As Database, strSQL As String
Dim rs As recordset

Set db = CurrentDb

strSQL = "SELECT Table1.title FROM Table1 WHERE (((Table1.code)=" & cboCode.Value & "));"

Set rs = db.OpenRecordset(strSQL)

While Not rs.EOF

Title.Value = CStr(rs.Fields(0))

rs.MoveNext

Wend


rs.Close
db.Close
Set db = Nothing

End Sub

I basically created a dummy table called "Table1" which only has fields "Code" and "Title." I wanted to keep it simple, so sample values in the rows would be Code = Code1 and Title = TitleONE, or Code = Code2 and Title = TitleTWO, and so on.

This way, it will be easier to see what is happening, and I could then later replicate whatever we come up with into the actual table.

This is basically a side project for me, where I'm actually trying to help out a friend in management in another group. He's been working on getting a database like this setup for months, and I've been consulting him here and there, but I work on a different project so haven't had much time to devote to helping. So, this week we met, and I am now upset with myself for not being able to figure out this puzzle. I'm normally so good at puzzles!

Point being... no biggie if we don't solve it, but I'd sure like to know how to do this, as it really seems like it should be incredibly simple. Cheers.

So then you don't support compromise even if science and technology can fix the problems?

Compromise is useful sometimes, yes, but the only argument in favor of coal is "it's the best we've got right now." That's not good enough. It's understood to be disasterous on our environment, and I'm taking the longer term view that it needs to go away as soon as absolutely possible.

I hope we all agree on this point. If not, another thread may be in order.

Certain technologies cannot be explored, is that your position?

No. That is NOT my position. Coal is not a "technology to be explored." We've been using coal for centuries, and it's a "technology" to be discarded. THAT'S my point.

Okay, but I'll just repeat the same point I made before which you pretended you weren't addressing.

No need to repeat anything. You first asked if something was my point (and it wasn't) then moved into a reply on the assumption that it was. I think I clarified my point in this post, making the reply not necessary.

Also, I pretended nothing. I made that post early this morning, before I'd even had a cup of coffee. I think you give me far too much credit sometimes. Not everything I say has some deeper political meaning. Often, I just say what I think authentically, and that's all there is to it.

I could solve it for you (probably), however, i want to know, for my own derivation, what the units you are using.

Hi Tom - Just a reminder... Please, please, please don't do the work for the requestor. Ideally, you would explain to them how to work through it, maybe splitting the basics into steps without giving away the answer. More than a policy here at SFN, it's actually a good practice in life.

This is a novel idea. Citing yourself! I'll have to try that in class sometime.

Actually, there's nothing new about that at all, and it happens all of the time. The difference, however, is that you must cite something which was published in a peer-reviewed journal. Citing yourself, I guess, is not the same as citing a work which you've had published after peer-review.

My evolutionary psych professor did it all of the time. He had numerous works which referenced previous works he'd done.

Z.

Now, we're done.

I think the bigger point is that such a large and growing number of citizens are tired of our nation and constitution getting so overrun with religiot ideas. The founding principles of our nation are not judeo-christian, and the writings of those who were involved in the process of writing our constitution made it abundantly clear that the government and religion should be seperate.

In England, the exception is the politician who speaks openly about religion. Most (whether secular or not) know that religion has no place in the governance of a free nation. I just wish that more people in the US would realize this.

Obama is welcome to have Rick Warren host a personal service for him, his family, and his friends in celebration, but to have Warren playing such a prominent role at the inauguration I think is a smack in the face to those of us who truly want to see our nation prosper and get beyond the iron age fairy tales and superstitions.

Here's another generalized comment, not aimed at you but rather reflecting what actually happens in the politics of energy: It's easy to toss out catchy phrases like "there's no such thing as clean coal" and ignore the necessities of actual life in the real world. The left won the election, now it has to actually fix things. It can't just say "no" to everything scary or fossil-based, assuming wind and solar can't do the job alone.

Well, when considered in light of the heinous effects it's having on our environmnent, our planet, and the life on it, I have to ask you, why not? Saying no to the detrimental activities will by default encourage activity and invention in the cleaner ones (the renewable energies sector).

I urge you to recall that "there is no such thing as clean coal" is more than a catchy phrase. It's also a statement of fact, much like "smoking cigarettes causes lung and other cancers."

No worries, apparently he's got some great deals on male enhancement, too.

Yeah, but it also seems that thousands of ballots are awaiting a verdict on eligibility from the state Supreme Court, which could turn any existing counts completely on their head.

Interestingly, it appears that the Flying Spaghetti Monster got a vote, even though the Lizard People didn't.

change Combo0 to the name of your combobox on the form. the name of your combobox is on the function sub. Private Sub Combo0_BeforeUpdate(Cancel As Integer)

Yeah, I did that immediately after pasting your code... went through and changed the variable names to match those in my dbase. I confirmed that my combo box name in the WHERE clause of the SELECT statement matches that shown in the function sub.

Still getting the same error, and the debugger takes it to that same line.

Set rs = db.OpenRecordset(strSQL)

the name of your textbox for the title may also throw an error, double check the textbox name by selecting it and pressing f4 on the form.

 

Text2.Value = CStr(rs.Fields(0))

That one is changed, too, but we haven't gotten that far yet. The error seems to come a couple of lines before the Text2.Value = .... statement.

Okay. I'm not feeling this approach. I am not confident that I'll be able to replicate this on my own later.

What I want is something clean and simple. The logic as I envision it would be to program the Text box using some SQL code like this:

SELECT C.Title
FROM Courses_Table AS C
WHERE C.Code = Combo_Box.Value

Can't this be done in Access somehow? First, I wouldn't know where to put such code to make the text box function that way, and two, I'm not sure how to identify the combo_box.value.

Reason also says that chili pepper, salt, and chocolate shouldn't taste good together, yet they're outstanding. Empiricism crushes reason every time.

There are a lot of things in our universe which don't make intuitive sense, but you have to remember that our intuition evolved during a very short lifetime as a very small animal on a very small planet in a very small solar system in just one of billions of galaxies in a supercluster of galaxies which is itself one among billions.

Trust the experiment, not the logic. As smart as Aristotle was, we've come a very long way since then, and they call it "The Enlightenment" for very good reason. <pun intended>

This seems like a good idea... I just wish Democrats would've thought of it.

 

What was this committee doing for the past 8 years while the Bush administration spied on innocent Americans, approved the torture of prisoners, and outed an undercover CIA operative?

+1

Let's give as much power to the White House as possible when our guy is in there, and ignore his blatant unconstitutional actions. Now that we have this new kid facing unprecendented challenges and who has great ideas and global support, let's find ways to obstruct his progress.

Either lead, follow, or get the hell out of the way.

yes

 

theories are produced it seems by logic alone

 

sort of the spock syndome

This was already addressed above many times, but I suppose it needs repeating. The context of this discussion is "scientific theory," so your comments are far from accurate or true. If you would like to learn more about what I mean, you only have to look back 3 posts to my previous response.

Nobody here is talking about scribblings on the back of a napkin in a bar at 3AM after too many beers.

Could you ask him why I didn't get that 60 terawatt laser last Christmas?

Here was his reply:

If you'd like to PM me your credit card info, I'll be glad to go wrangle an answer out of him and report back.

Try typing "set rs = db.OpenRecordset("

 

A caption should appear that shows a list of the parameters; can you screencap it for me?

Okay, so I typed:

set rs = db.OpenRecordset(

and the following caption appeared:

OpenRecordset([b]Name As String[/b],[Type],[Options],[LockEdit] As Recordset

I played around a bit, and put the word "String" into the Type field, since that's how we declared strSQL earlier in the Event, but that didn't work either [it threw a Compiler Error, said it expected an open parentheses like ( ] ...Also, Options and LockEdit seem to be optional/non-required fields.

Thanks for the idea, but I got the same 3061 error with that new statement.

Please note, everyone, I'm perfectly willing to try/learn a different approach to accomplish this if appropriate. I went into this thinking it would be much simpler than it is, but I'm open to basic tutorials and attempts at working through visual basic (with a little bit of guidance on what the various parameters and statements do).

EDIT: Btw - Access 2003

How much does a polar bear weigh? Well, enough to break the ice. Can I get your number?

Why don’t you unzip my pants and let me show you the descent of man?

Without you, my organ would become vestigial.

Trust me Baby, my selection is ALL natural!

Stationary relative to whom/what?

Well, first of all, TD, thank you very much for taking the time to work through the example like you did. I was glad to see you response, and also glad to see your desire to help, so huge kudos on both fronts to you.

I put your code into my form (although, since I didn't provide the readers of this forum with exact table/field names, I edited those to match what I needed, as I'm at least capable of that bit on my own), but when I tried to test it and selected my first record from the combo box, an error occurred.

The statement was "Run-time error '3061'. Too few parameters. Expected 2"

The debugger sent me to this line:

Set rs = db.OpenRecordset(strSQL)

...which appears above immediately after your SELECT statement.

If I interpret it correctly, you've opened a temp record set (as rs), and you are trying to populate something there. Either way, it looks like "not enough somethings" were part of the Set statement.

Any ideas on what I can try?

Congrats to Klaynos and Mooeypoo on becoming super mods. Good picks.

I got one from Santa Claus today. That's classic.