Solved Multiple search engine with dropdowns

I opened the data files and I am not sure if the structure you sent is what you meant to send. I am assuming you want a top level for Music, Videos, and Audios. That is not what I see. Please look at the zip file and see if that is correct.
 
OK thank you very much. When you can do it. Good luck today!
 
Do not worry about sending files. I will make it so you can store any amount of folders but provide an application table that can store up to three default directories.
 
This version allows you to store 3 folders in the application settings. To load all three folders the command is
SpanAndLog.
This clears out the table and loads in the direcotory folder data.

I currently call this after setting the default folders. If you distribute the application you may want to prompt the user at startup if they want to respan.

For demo purposes I show you how to reload the tree with a different directory. When you put this together you will probably pass 1,2, or 3 via open args to the form. Then instruct it to load that tree.

Now there is a lot of error checking that you need to do. You need to check that the folders to span exist. That the folders return records.

Again this is a demo. You need to put the event and procedures together in an order that meets your needs.
 

Attachments

  • Like
Reactions: WAB
Hi. I just saw the database. It's very good. Some details:

1. You have removed the ReadFiles button, which I think is interesting for updating folders and files.

ScreenShot001.jpg

2. You have enlarged the tree so much that it pops out of the screen. I have managed to make it smaller by copying the tree of another version, but I am not able to adjust it to the height that I show in the image.

ScreenShot002.jpg

3. It does not expand automatically when you enter the frmMS_FormsTree form.

ScreenShot003.jpg ScreenShot004.jpg
 
1. As I said it is a demo. You need to add/remove/organize the features that you want. All code is there you just have to call as needed.
Again if these are big directories you do not want to span all the time. After you span once you may only prompt the user to span at opening of the db and let them decide if things have changed.

2. This is no different than any other control. You can resize it any way you want. You need to resize the form and then the container in the form.
3. I can do this in the MSCOMCTL treeview, but I cannot get it to work with the MSFORMS. I contacted the developer on their website for help.

Excel: An msforms (all VBA) treeview; How to use

jkp-ads.com: VBA treeview control How To Use
jkp-ads.com
 
MajP said:
1. As I said it is a demo. You need to add/remove/organize the features that you want. All code is there you just have to call as needed.
Again if these are big directories you do not want to span all the time. After you span once you may only prompt the user to span at opening of the db and let them decide if things have changed.
Click to expand...
Hi. I already know that it is a demo, so I have tried adding the code to read files and it does not work. I leave you what I have done.
MajP said:
2. This is no different than any other control. You can resize it any way you want. You need to resize the form and then the container in the form.
Click to expand...
Yeah I guess. The point is that there are like two or three objects and I don't know which one is the one that won't let me shrink it.
MajP said:
3. I can do this in the MSCOMCTL treeview, but I cannot get it to work with the MSFORMS. I contacted the developer on their website for help.
Click to expand...
Well, let's see if he responds, because it would be an important improvement.

Thanks!
 

Attachments

The form is resizeable. You need to shrink the form. It is a standard access form. Nothing special
 
I have already managed to put the size I want and also make the ReadFiles button work.
I think they have answered the question you asked.
 
And I have also gotten it to expand when starting the form by adding this when loading the form:

mcTree.ExpandToLevel 1, True
mcTree.Refresh
 
I update: to automatically expand the sum of folders and files, in total you have to add:

Code: 
  mcTree.ExpandToLevel 1, True
  mcTree.Refresh
  mcTreeSummation.ExpandToLevel 1, True
  mcTreeSummation.Refresh
 
What remains for me is to ask you, apart from this tree, that it already works the way I want it, a question that has arisen these days regarding the counts we saw a week ago.

1. I have seen that in this database to make a tree you have added a module called mdlQueryUtilities, and in the database that we made with the counts in the dropdowns there is also a module called the same. Do they have the same functions and procedures to be able to combine them?

2. I am thinking of creating a continuous form with a list box, because I have files in multiple locations. That way, I can select multiple locations. I have several doubts about this:

2.1. Would it work with the modules to create filters that we saw with the counts in the dropdowns that we saw a few weeks ago?

2.2. Can you create a continuous form with list boxes? I have not found anything on the internet and I have tried to create it but I have not been able to make it work.
 
1. I have seen that in this database to make a tree you have added a module called mdlQueryUtilities, and in the database that we made with the counts in the dropdowns there is also a module called the same. Do they have the same functions and procedures to be able to combine them
Click to expand...
The same. I needed it for the insert query
2. I am thinking of creating a continuous form with a list box, because I have files in multiple locations. That way, I can select multiple locations. I have several doubts about this
Click to expand...
I do not understand the question
2.1. Would it work with the modules to create filters that we saw with the counts in the dropdowns that we saw a few weeks ago?
Click to expand...
If you are saying you would like to replace your continuous form with a listbox this will work. Instead of apply the filter to the form you can bind the listbox to the dynamic query
2.2. Can you create a continuous form with list boxes? I have not found anything on the internet and I have tried to create it but I have not been able to make it work
Click to expand...
If you mean simply replace the continuous form with a big listbox yes. The form is just unbound and you have a large single listbox in the detail section.
 
mcTree.ExpandToLevel 1, True
mcTree.Refresh
mcTreeSummation.ExpandToLevel 1, True
mcTreeSummation.Refres
Click to expand...
I forgot the refresh.
 
The reason: there are songs that can belong to more than one album, as often happens with compilations. So that's why to put have a multiple list box to select several, and that the filter that we did with drop-downs and the FAYT can be applied to it.
 
The reason: there are songs that can belong to more than one album, as often happens with compilations. So that's why to put have a multiple list box to select several, and that the filter that we did with drop-downs and the FAYT can be applied to it
Click to expand...
No that cannot be done, with or without any filters. There is no you can bind a multi select listbox to a control. Your locations have to be stored in a junction table unless you use a multivalue field. That is two bad ideas.

I would concatenate the value using a concatenate function in the query
So you display. location1; Location2; Location 4
If you want to add or delete locations than you do that with a pop up form.
You also have the calculated field with only IDs, but not shown
1;2;4

Then you can code a filter. It can be done, it will be complicated.
 
You must log in or register to reply here.

Similar threads

zelarra821
Solved Detect the active field and its value
2
Replies
25
Views
1,048
zelarra821
zelarra821
T
Filter Form with multiple Unbound combo box and dates
Replies
15
Views
836
MajP
MajP
A
Need VBA Help with Printer Status
Replies
1
Views
222
June7
June7
K
Filtering in data sheet view on combo box with multiple columns?
Replies
1
Views
609
arnelgp
arnelgp
nimeshaanethmini
Need Help with VBA Code for Access Form Filtering
Replies
5
Views
351
Uncle Gizmo
Uncle Gizmo

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom