Search results for query: *

Hi g, I haven't tried your new post yet. Since whatever I put in the ctl.value = No/0/false did't work, I finally used the unbound form as frmInput and based query on form and tblPersonality. It seemed working! Thank you so much for all your help. You've been so patient even though I asked a lot...

Hi g, It does make sense to make unbound controls in a form instead of a table. As for query, before we had SELECT 1 AS Indicator, tblPersonality.Type FROM tblInput INNER JOIN tblPersonality ON tblInput.Indicator1 = tblPersonality.Indicator1 UNION SELECT 2 AS Indicator, tblPersonality.Type...

Hi g, Thank you for pointing out the set-up issue. It is supposed to be a utility program on a website. So anyone can go in to check off some indicators and get their personality type and then go away. Indeed, it's probably not necessary to save a record. But then how do I make all the...

Hi g, It worked! Thank you. I know why I was confused now. Somehow, I thought I would get only those personality types when indicators in both tables are YES. Of course that requires a where clause that says that. Your detailed explanation really helped a lot. One more question...

Hi g, Thank you so much for your patient explanation. I deeply appreciate it. I tried it out. The Totals worked for a user input. I still have two questions in mind though. One is that I expect the query TypeResultList shows those types that match what the user input for Indicator 1...

I have a question about a query setup. I have a table called tblPersonality with 16 fields. One of the them is "Personality types". The rest of them are personality indicators which are all yes/no fields. There are altogether 10 records in the table. I want users to select indicators...

Yes! Please give me some code examples! I really appreciate it. THANK YOU.

Hi, I want to base my query on checkbox values from a form and then automatically opens a report that shows the query result. How do I detect checkbox values and how do I put it in my query dynamically and link it to report? There are more than 15 checkboxes in the form. I can't do 15 if then...

Thanks so much! I wanted one more thing though. :-) I want to give the user a second chance which is also their last chance. If on second try they still click a wrong answer, the message will be "Sorry, you fail." Can you help me on that? Thank you!

I want users to use checkboxes to answer a question. They should check 3 boxes out of 6 available. The right answer is 2, 5, 6. If they choose them, the popup will say good. If they choose say 1, 5, 6. The popup will say wrong, try again. Then 1 will be unchecked, 5 and 6 will remain checked...