Decision Tree Series - Building a Decision Tree Database in Microsoft Access. Part 6: Drag-and-Drop Images


	Back to Decision Tree 6 Comments List

Pinned Upload Images @Reply Bookmark Link Email Next Unseen

Decision Tree Series

Richard Rost

3 years ago

One thing I have learned from the last couple of series I've tried to produce with TechHelp videos is that people aren't very interested in multi-part series like this. The decision tree series did really well with the first video, but interest dropped significantly after the second video. The same thing happened with the association videos and a few other multi-part series I've attempted. So, in the future, I plan to stick to single TechHelp videos with an Extended Cut. Beyond that, additional material will move into a seminar, so those who are interested can purchase the seminar or at least a template.

If you're interested, here is a list of topics I envision continuing with for the decision tree. If there's enough interest, I'll put this together as a seminar or a template:

- Listbox showing the path through the decision tree so far, allowing you to click back on any one item instead of having to click the back button multiple times.
- Breadcrumb trail similar to what you see at the top of my website for easier navigation.
- Special hidden keystroke for the viewer form to load the editor at that point.
- A report showing dead ends in the decision tree, helping you identify where you need to spend time fleshing it out. This would essentially be a query showing all nodes that have no children.
- Option for other users to suggest options, which you can then flesh out later.
- Integrate a dice roller so outcomes can be random: 30% for one outcome, 70% for another.
- Port it online so others can participate, requiring ASP and SQL.
- Allow storylines to converge, enabling you to jump to another location. This could be useful not just for a Dungeon Crawl Adventure, but also for gathering troubleshooting data.
- Make the parent combo box only display items that are above it in the tree.
- Track popularity by adding to a node's score every time it's clicked, helping identify common problems and solutions.
- Use the decision tree to gather free-form text-based information from the user for later use in a report. This could include asking for model numbers or contact information.
- Implement basic IF-THEN logic to provide different paths based on previous answers or user attributes.

Feel free to let me know if you're interested in any of these topics. If there is enough interest then I will continue this and if not then that's okay too I'll move on to other projects. My to-do list is quite long I'm just trying to see what people are interested in.

	Adam Schwanz @Reply 3 years ago
requiring ASP and SQL. More on this ;)

	Kevin Robertson @Reply 3 years ago
I'm definitely interested in seeing more with the Decision Tree. Loved what you did with the images in part 6. Very cool. The list of topics sound neat and would be perfect for a seminar if you decide to go ahead with it. Would love to see what else you can implement for the Dungeon Crawl Adventure.

Juan C Rivera @Reply

3 years ago

Like both Adam and Kevin's comments like to see this developed more. esp as you move from characters the pictures get updated. also is there a way to hide the hyperlink in a way to cover the image box and have it update ? I am trying a button as you did in a prev lesson but not getting the results I like to much flashing going on. Not a game stopper but like to see how it can be done as my spaghetti coding is not as elegant as some of the moderators here.

Kevin Robertson @Reply

3 years ago

Juan,

I moved the Hyperlink field over the top of the Image control (making sure it was in front) and set these properties.
This is so the text in the field cannot be seen.

   Shape Fill: Transparant
   Shape Outline: Transparant
   Font Size: 1
   Font Weight: Thin

I then added the following code:

Private Sub ImageHyperlink_AfterUpdate()



    Notes.SetFocus

    If Not IsNull(Notes) Then Notes.SelStart = Len(Notes)

    Me.Refresh

    

End Sub



Private Sub ImageHyperlink_Click()



    Notes.SetFocus

    If Not IsNull(Notes) Then Notes.SelStart = Len(Notes)

    

End Sub

There's probably a better way to do it but this method is simple and seems to work.

	Richard Rost OP @Reply 3 years ago
Hmmm.... I'm AFK right now but does the drag and drop trigger the on mouse over event? You could pull the hyperlink field to the foreground that way maybe?

	Juan C Rivera @Reply 3 years ago
just did it and it works fine this is NICE! :)

	Sandra Truax @Reply 3 years ago
I love the drag and drop of the hyperlink. This is going to be so much easier than using the PickFile or copying and pasting the link manually. Most of the time I have the folder open already that has the file, so dragging it now is a blessing. Thank you!

	James Cox @Reply 3 years ago
Rick, I appreciated the Decision Tree series and find it valuable as I do all of the videos with Access you post. To be honest I like the series videos you make because there is usually new ways of doing things. That's my two cents. Your Access learning videos is why I'm a member and a subscriber to your YouTube channel. Keep on doing what you do and I'll be there to learn along the way.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Decision Tree 6.

Next Unseen

New Feature: Comment Live View