Search results

OK, currently I have a listbox which displays some results using an SQL query in the row source. In the list box i display records from a parent and child table. Therefor i'm getting duplicate information from the parent. (picture) This is what i want for display purposes. But I want to be able...

good Idea, Thank you.

Ya, but distinct wont work because they are combined. so the records themselves are distinct even though the parent aspect of the record is being duplicated. Parent record -- Child Record Class1, Jan 12, 80 kids -- Grade 4, snowshoeing Class1, Jan 12, 80 kids -- Grade 3, Trapping. Class2, Jan...

OK this one is likely all over the internet so lets hope people stay off Google. A lecturer decides to play a fun logic game. She selects 3 students to stand in a row facing the front of the class. The student at the back (C) can see both students in front, The student in the middle (B) can see...

OK, Question, I was going to be using the list box to tally some numbers. The data displayed has how many people attended an event. so i was going to have some code that just runs down the list box and added them up. my problem is this... The powers that be, collect the data as a TOTAL per...

thanks! :)

Ya, that worked for me, but different than the answer i was given.. (well slightly different, same basic idea of course) (7x7x(7+7)/7)+7-7

When i hit Cancel the value of MyYear turns out to be "", not null. is that unusual?

HMMM.. type mismatch.. So i'm thinking an error catch would be a good idea hu?

Geez, i'm starting to run out of these.. ok... Using only basic arithmetic operations (+ - x /) can you get 98 using only 7 sevens? Each 7 may only be used once and you must use all 7 sevens. 7 7 7 7 7 7 7

VBAInet - I added your suggestion and it STILL didn't work, so I took a really close look at the brackets and there was one too many MySQL & " WHERE (((Year(tbl_SchlPrgms.[Date])))=" & CInt(myYear) & "));" Deleted that Red one, and now it works like a charm! Thank you both soooo much! i was...

I thought i had the square brackets around the first date field?? am i missing one. SOS - That didn't work either.. :( i have a fear that i'm gonna be out of luck shortly. Should I change the field names to non-reserved words?? would that help?

I'm still getting nothing. My complete code that I am currently using is: Private Sub Command3_Click() 'Make the list box display the school programs information Dim MySQL As String Dim myYear As String myYear = InputBox("Enter Year") MySQL = "SELECT...

Ok, in a nutshell, i'm working with a form where i have a listbox. and based on a button the user selects, i want the listbox to populate with something. So I'm setting the rowsource to be an SQL statement, and then from there doing a requery. My SQL statement that works in a query is: SELECT...

hmm... alright... well the M one was easy.. lets try..this: Which English Word has nine letters, and remains a word at each step even when you remove one letter from it, right up to a single letter remaining. List each letter as you remove them, along with the resulting word at each step.

What occurs once in every minute, twice in every moment, yet never in a thousand years?

YAY! go Chergh... mensa?

No, it was answered a while ago. They are 2 parts of a set of triplets. OK new one.. Complete this sequence of letters: o, t, t, f, f, s, s, _, _, _.

would you be able to give an example of the numbers?? what it was, vs what it is now, and what your multiplying it by... There are some known issues with 2010 and how it does calculations on some numbers.

LOL, ya, I love that one.. Ok well i'm fresh out for the time being. Have a good weekend everyone! (I'm leaving at lunch!! YAY! Gonna go to Niagara falls try and win me some money at the BlackJack tables!)