New repair information project

[Mr Wolf]

I want to start a new project that will fault find & recommend a repair. The idea is using a family tree style method. e.g.
Has the bread turned brown? No.
Is there power to the toaster? Yes.
Did you put the bread in the toaster? Yes.
Is the dial set in the right place? Yes
Are there lights illuminated on the toaster? No, Has the fuse gone in the plug? Yes. Replace fuse following instruction 0001
if the fault is not found, or the direction of information does not cover the fault, then a new dirction can be made when the fault is found.


I want to do this with as little macros as possible. do we have a project thread i can start this in?

Mr Wolf

 

[Ranman256]

this could be done with 1 form, but the # of macros is irrelevant.
a combo box to pick the item to work on,
this event would pull the set of questions needed (a query, that opens from a macro)
user fills in the questions into a subForm.
save button saves the data and closes form (macro)

macros are not a problem, you click on the button property events
click macro
fill in what you want.. openquery or close form

its just a fill in the blank process.

 

[HiTechCoach]

Mr Wolf,

I think what you are asking is how to ask a question and get a response. Based in the response, use a Decision Tree (click here) {I think that is what you meant by family tree} to figure out the next question and/or response.

I create wizard style forms that use a decision tree to determine what to do next. This does require some VBA code.


I do not remember seeing any discussions on this subject in any Access related forums. I have seen it is SQL Server forums. A search on Decision Tree or Decision Tree Analysis will get you lots of results.

I want to do this with as little macros as possible.

The good news it that you can do very power stuff with Access VBA code with only a few lines of code sprinkled in the appropriate events. Unless you are doing Access Web databases, I would urge you to learn to use VBA. VBA code is what takes your database to the next level.


I only do desktop database in Access. I use VBA code. I do not uses macros except for the special one named autoexec.