Access TS database?

[midian777]

Hello everyone and I apologize if this is not in the right forum to start. I just got my hands on 2007 access, and I am currently creating a database. I was hopeing it would be easier to use since I am very familiar with excel, but I have discover access really is another type of animal.



Heres the concept:
I need to create a trouble shooting database that has customer go step by step through a process.

example: unplug your cable modem from electricity. Is this done?
example answer if (yes) proceeds to new trouble shooting question.
Example answer if (no) unplug the electrical cable from the wall to the modem. is this done?

So the whole premise ios easy to understand step by step question based on yes and no answer. If you answer yes it takes you to another question or solution, if you answer no it will potentially do the same thing?

Any guidance at all in these areas would be greatly appricated.

[midian777]

ung sorry about all the typos.... mah fingers are getting ahead of mah brain.!

[TheShabz]

Are they all yes/no questions?
will the user ever enter any data into a textbox?

[midian777]

Yes all the questions are built yes and no.

Are they all yes/no questions?
will the user ever enter any data into a textbox?

[TheShabz]

So you need 3 tables to start with.
1. tblUser (user info)
2. tblQuestions (questions)
3. tblUserQuestion (junction table for many to many relationship)

lets assume you have 5 questions.

Set up a form that contains a textbox, an option group and a button. The form's OnLoad event should use a DLookup to enter the contents of the first question into the textbox (Dlookup("question","tblQuestions","questionID = 1")). The button's OnClick event will run a For loop such that:

Dim i as Integer

For i = 1 to 5
if (optAnswer = 1) then
'SQL to update tblUserQuestion with the question ID and answer
else
'SQL to update tblUserQuestion with the question ID and alternate answer
end if
'Dlookup to populate the txtbox with question with ID i + 1
Next

After that you have to decide what criteria will provide a solution and end the sequence.

I used a little pseudo code there. I'm assuming a bit of table structure and vba knowledge here. Google is your friend for exact syntax. It's best to play around with it until you understand it. There are most likely cleaner ways to do this with more clever code, so again, experiment until you get it and post back with more questions.