truedeity

One of many things they wish to uncover is the Higgs Boson.

Ah, I had initially assumed it was a Number field. The SQL executes, however, it does not return any rows. Thus, your Text box does not update... Suggested Fix. -Adding * inside the single quote's of the comparison string. -Removing the space " ;" before the semicolon? Try this: strSQL = "SELECT [title] FROM Table1 WHERE LIKE '*" & cboCode.Value & "*';" And try this just incase. (Without semicolon, however, the semi shouldn't pose any problems.): strSQL = "SELECT [title] FROM Table1 WHERE [code] LIKE '*" & cboCode.Value & "*'" Ensure that data in Table1 in the code column does not contain extra characters, such as "spaces", however, the * usage should account for this occurrence! IF ALL ELSE FAILS... Try this one... strSQL = "SELECT [title] FROM Table1 WHERE LTrim(RTrim(Ucase([code]))) LIKE '*" & LTrim(RTrim(Ucase(cboCode.Value))) & "*'" and (The same as above, just includes the semicolon.) strSQL = "SELECT [title] FROM Table1 WHERE LTrim(RTrim(Ucase([code]))) LIKE '*" & LTrim(RTrim(Ucase(cboCode.Value))) & "*';"

I'm back guys. Sorry been away taking care of some errands. Alright, where are we at? Hmm.. Well, I see alot has been posted, I've been able to follow alittle of it reading though, however, was lost somewhere along the line where there are a few misunderstandings about Access. However, let's start this where I left off at, that being the SQL statment you have. I already have this worked this out on my laptop upstairs, kinda too lazy to go up there right now so I wont be double checking my suggestions in this reply. Anyway, before we get ahead of ourselvs I want to illustrate the misconceptions. Keep in mind as mentioned beforehand that you can use debugging and toggle though the code one line at a time. strSQL = "SELECT Table1.title FROM Table1 WHERE (((Table1.code)=" & cboCode.Value & "));" So I'm going to use the sql that was first provided as our working example. So I hope its not too much trouble to backtrack alittle... Ok, first let's make this work. Everything at glance looks alright. In SQL we dont need to use the "." accessor unless we are using Left Joins, Inner Joins, Right Joins etc... The syntax is correct here, just not required in this instance. strSQL = "SELECT Table1.title FROM Table1 WHERE (((Table1.code)=" & cboCode.Value & "));" strSQL = "SELECT title FROM Table1 WHERE (((code)=" & cboCode.Value & "));" Removed. Also, It seems the use of ('s and )'s are not required to accomplish the task. Although, the usage in this case looks ok... Lets remove them to be safe. strSQL = "SELECT [title] FROM Table1 WHERE =" & cboCode.Value & " ;" That should work. Unless ofcourse the code field is a string field and not a number field. You may want to verify that in the table design. Make certain that it is a number field. Otherwise, you can change the SQL to look like this: strSQL = "SELECT [title] FROM Table1 WHERE [code] LIKE '" & cboCode.Value & "' ;" Notice the single quote is directly beside the double quote. The brackets may not be required... But access understands brackets, so they are useful for this example. This should work.

Can you post your SQL string? Yes, my first approach was to see if you can program the textbox in the same manner. However, I could not replicate. I think, its because the property of the textbox does not allow you to obtain infromation from objects on the Form. Ie. ComboBox. But just incase, try this WHERE C.Code = [FormName]!Combo_Box!Value instead. In the textbox properties. Select textbox, press f4, there should be a value property or something along those lines. However, If I remember access correctly, I do not think this works. The only way to do is is though VBA code. Actually, I used to work at an accounts recieveable comany called Mirrus Systems a few years ago I was an Access Programmer, so from experience I am certain that the problem you are having is the SQL statment itself. Often times in programming the debugger will throw an error, but error is in the line above. Like in C# when you forget semicolins... Private Sub Combo0_BeforeUpdate(Cancel As Integer) On error goto ErrorHandler: [ALL YOUR CODE HERE] Exit sub ErrorHandler: YourTxtBox.Value = strSQL MsgBox Err.Description End Sub Now copy the SQL in the textbox and paste it here. I suspect, that your SQL needs a space at the end of each line. You may want to also test the SQL by creating a new Query, access will default to sql design mode, but in the upper right corner you can select SQL and paste the code itself. Then try to run the query. If it doesnt execute, that is the problem. Infact, if you have AIM just hit me up my sn is 'hackintoit'... Perhaps, I can remotely assist you with TightVNC? oh i just realized, easier than creating a textbox on the form, I think you can just use DoCmd.Copy strSQL should copy it to the clipboard. then you can paste.

I am 100% that the error is in SQL string. strSQL = "SELECT Courses_Table.Course_title " & _ "FROM Courses_Table " & _ "WHERE (((Courses_Table.Course_code)=" & Combo0.Value & "));" 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) 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))

Try typing "set rs = db.OpenRecordset(" A caption should appear that shows a list of the parameters; can you screencap it for me? Also, if you put the carrot cursor inside the OpenRecordset text and press F1, a helpfile will appear. Which will have pertinent information pertaining to the usage of OpenRecordset. Send any information across that could help. Thanks for Kudos man.

I am using Access 2003. However, the same method should apply in Access 2007 and earlier versions as well. In the Form Design, right click the Combo box and select "Build Event". If a message appears select VBA (code), It does not appear for me. If it does for you, it should be the last selection on the list. Moving on, You will see code module created for your combobox. Which looks like this, Private Sub Combo0_BeforeUpdate(Cancel As Integer) End Sub Here is the exact code you will need to accomplish your task, paste it inside of the sub function. Dim db As Database, strSQL As String Dim rs As Recordset Set db = CurrentDb strSQL = "SELECT Courses_Table.Course_title " & _ "FROM Courses_Table " & _ "WHERE (((Courses_Table.Course_code)=" & Combo0.Value & "));" Set rs = db.OpenRecordset(strSQL) While Not rs.EOF Text2.Value = CStr(rs.Fields(0)) rs.MoveNext Wend rs.Close db.Close Set db = Nothing On the Form I created, I selected the ID from the combobox, and the title populated the TextBox. I think there is infact an easier method, however, its been a few years since i played with access. Hope this helps, let me know if you have any other questions.

I have not said anything incorrectly, on this thread… There is no other more symphonious, and or artistically divine description for the collapsing wave function. The speculation I have drawn, where no other exists, sustains without undermining other established theories. Problem with the counter approach… Aside from super massive egos, my momentary distaste is that this is an "intelligent" community. And we should all breed intelligent discussion. Aside from the most primal impulse, to discredit all new speculations that surfaces before they sustain a process of interrogation on their own. Yet we accept blindly, all the ‘Now’ theories, that ALREADY CONFLICT with the Ether? The only ones we seem to support are our own… There may not be enough time to absorb the implications of disproving every single theory that is presented in this community, however, a new theory should be ranked and not ridiculed. Granted, it is my FIRST post. But if instead there was a ranking system, for placing speculation into its own perspective, then, over time it may grow and earn merit. As it finds more support from other ranking members. Rather than, being lost in the Ether-net… In closing, there is no exiting theory in quantum physics or modern science that started without violent opposition... Is there anyone that wants me to elaborate more on the details of my original post? Am I not making a sound argument…? SkepticLance (Primate) If something does not exist without an observer, how can it create outcomes that are observable later, if those outcomes are created while not being observed? Clarification: What I intend to mean, is that the universe is a part of the observation function. For which, there is no previous definition, or discussion. This is a completely new idea that has never been considered. And there are practical implications. But I believe it is the barrier that creates the universe of substance. Atoms are considered to be empty forces of energy. So if you’re asking me how can manifest destiny exist? In my view, all possibilities that can exist do exist. But I ask, which of you can explain why Atom’s materialize a physical universe at all? Atoms are considered empty forces of energy potential.

The time will inevitably come when mechanistic and atomic thinking will be put out of the minds of all people of wisdom, and instead dynamics and chemistry will come to be seen in all phenomena. When that happens, the divinity of living Nature will unfold before our eyes all the more clearly. Johann von Goethe, 1812 You do not experience present time!!!!!!!!! It is gone before your neurophysiology is able to perceputalize our holographic reality. Yes, I believe present time is rendered in the physical universe. However, I believe electrons materialize in present time at the point of subatomic fractures. Exemplifying, my point. That all waves of possibility that can be expressed by the particle, are expressed in a multiverse of realities. To claim that a photograph is one instance of present time, is stupid... The amount of light that enters the shutter of the lens, is manifested into a photograph. You don’t have to be a quantum guru to comprehend photography class. A Genius is not someone who can perform calculations. Foresight is the rare genius, it is the likes of Nikola Tesla that humanity is longing for. The best knowledge, is not knowing. Let intuition run its course, otherwise, you will learn yourself into a Box of impossibility. All cameras that develop a photo have the fading effect. One moving object can be seen in multiple places on the picture. Even the best stop-motion camera in the world cannot capture a single instance of present reality. Your suggesting the object existed in two places at once... I have been made angry. To anyone that cares. I have no more time for toddler minds. So here is my last vent… If you wish to offer evidence to refute my claim, or either from associated presses, and or bits of established science; provide forceful proof. In the words of Richard Feynman, “It’s not inconceivable? I just conceived it!” In my opinion, Quantum Physicists have formed their own religion. They believe only a few of their elite are able to even discuss physics. What a determent to humanity. Claiming they have the ineffable experience, after submerging themselves in long division. As they experience higher dimensions. What a(n) ego trip they are on. So does every fundamental Christian experience the same thing in deep prayer... (see, Richard Dawk for reason explanation.) You guys attack all external possibilities. Hiding behind the complexity of Quantum Physics, don’t over gratifying your own IQ. Physicists try so hard sowing the quilt of math around broken theory. There are so many KNOWN gaps, that science has to reinvent a new particle to explain something else without well known supported theories crumbling… To the extent that they are unable to perceive with intuition; All they know how to do is understand is the math they have spent their whole lives trying to grasp. The inaccuracy though “publish or perish” has mentality clouded their intuitions under the lime lights of obtaining a Nobel Prize. Besides, some of you responded as if you didn’t understand what I wrote initially anyway. Can anyone smarter post? We think of science as being based on observation and being open to change, but as you learn more about it and about the scientists themselves, you realize how much it is a religion. It is very closed [and] resistive to changing its fundamental principles… -Paul LaViolette

A photon is considered an elementary particle.

If you are claiming that the photon is the substructure for other particles, the answer is no. This is not the speculations forum. You are expected to respond with established physics here. Reply: I'm sorry if I do not understand. However, when I refer to the Standard Model of Elementary Particles illustrating three generations of matter a photon is part of the Boson Forces. There are also Quarks, and Leptons. Elementary Partiles do not have a substructure and is apart of the basic building blocks of the universe, from which all particles are made. Im not insulting the genius and advent of science and or depths of human imagination. Here is a link to the infamous, "Death Ray". http://www.nydailynews.com/news/us_world/2007/12/22/2007-12-22_scientists_find_black_hole_death_ray.html

Adding more to the speculation... Well I dont believe we are the only observer in the universe. The observation function is thought of as an action. That's the act of observing. I want to beg this question. What is present time? The right answer is that we can not know. We have never seen present time. Presnet time cannot be captured in a photograph. You can suggest that in exactly 0.000000000009 of a milisecond from, or before now is very close to a present instance of time. The only way to capture an instance of presnet time is to stop time. But we are still working on that one. But what if the electron only exists in present time? Then particles only exist in present time. Manifesting our physical universe. It is said that for every subatomic fracture a new universe is created. Every possibility that can exist, exists. So what if the particle exists in all realms of it's possibilities? And the act of observation suggests that within the wave of possibilities there once existed a particle here, or there. But now that particle is gone. And so is its electron. And observation merely implys that only the possibilities untill "present time" existed. So the electron faded in and out of all possibilities only existing in present time, and instantly vanished into the next issue of present time. Thus a particle and its electron has no fixed position in the universe.

Correction. A Photon is a particle, an "Elementary Partcile" which is a sutbstrucutre for all other particles. All I am asking is that we think alittle outside of the box. We really do not know what anything is. Most of our understanding of the cosmos is based on hubble photos and imagination. I am not insulting established sciences, however, its been a long time since we have questioned what light is. I am not saying that it is what I described. All that I said, is that if it were something else "xyz -frequency/wave?" i can only imagine the anomoloie occuring in a Black Hole. If light is what it is understood to be now. It can not occur. Try to find an explantion for a Black Holes death ray? From what I understand theres nothing in science established to support it. (If you goto cnn.com and search for "black hole death ray" you will find it.)

Originally Posted by zensunni What process do they use to detect the particle in mid-flight, anyways? My Response: Based on my understanding Richard Feynmans covered this in his lessons. The position of a particle cannot be determined exactly. However, the probability of its position(s) can be estimated. (I believe there is a good reason, see below.) Which is the best answer I can credibly offer you. Then again, it is my speculation that there are no particles in the universe...

I think, If light were not a particle, but rather a frequency/wave and you appealed to Max Plank vs. Einstine you could concieve this idea in a Black Hole. eg. F=Hz...

I want to offer my “theory of the day” to the community for scrutiny. I offer it as is… I do not claim to have a complete understanding of quantum physics; however, I am interested in the concepts and discussions it creates. All that I ask is that I would be credited as the first person whom presented this concept to the scientific community (Incase I got lucky “needle in the milky way”). My theory of the day: Maybeverse. What if the essence of matter is “the observer” and the electron only existed within space and time during observation. And the particle(s) state exists in a present time state, yet only existing wherever the electron was present within the subatomic fractures of a multi-verse. Could you imply that dark matter/dark energy is our observation of extra potential gravity interacting with the present time state as if it were not affected by the observer, eg. The wave potential… End. PS. have I posted in the wrong place? If so, I am sorry... I am new here… I do want to be able to post tidbit theories on quantum physics forums, with a (soup for thought style approach) which does not necessarily need to be taken seriously, because I have no credibility… However, I believe right brainers generalist, intuitive, creative, approach has much to offer the doableistic (left brainers) psychology on science. I love this forum.