Dropdown menu with fields
Forums
I want to create a dropdown menu with the fieldnames. In my test script (Test fields to dropdown menu works) it works but in my project script (RB Temp 1) it doesn't work. What do i wrong? I want to understand how the basic code is to populate a list and show it to the user.
funny how one line of codes
funny how one line of codes changes it al. But basicly from the case ID/action you can call functions to run. Do you prefer to get as little code in the displayIt function and define it as seperate functions? And is there a way to make a function more flexibel to use it multiply times but with different variables? Thanks again for your time.
Hi, the finale step in my
Hi, the finale step in my script for the user is to select the fields from the different tables. I used the script code which you provided a few days ago with a dialog box with two lists with the field names and buttons to change fields from one list to the other. At the moment there are two things i don't understand: 1) what is the reason for using a templistbox variable? 2) After the user selected the fields to use and press ok i there a way to show the selected fields by the user in messagebox or a static text? And 3) When i repress the button to select fields agian it didn't rememberd what the user did before that, is there a way so that previous actions in selecting fields are rememberd?
I tried to do a direct
I tried to do a direct extraction and add the fields selected in the list to the direct extraction using the following code:
For i = 0 To UBound(tempListBox1AB$)task.AddSFieldToInc tempListBox1AB$(i)Next i
Instead of: 'task.IncludeAllFields
but i got error: object does not support this property or method. Can you help me, where i'am thinking wrong.
1) Hi Robert, the templistbox
1) Hi Robert, the templistbox variable is to hold the array for each of the list boxes as they are constantly changing. The tempListSelect varaible holds the users selection.
2) Sure, just create a message box after the user has clicked ok. The loop through the items and display the message, probably something like:
msg = "You have selected the following fields:" & chr(10) & chr(13)
for i = 0 to ubound(templistbox2$)
msg = msg & templistbox2$(i) & chr(10) & chr(13)
next i
msgbox msg
3) For three you would have to compare what is in the first templistbox1$ and remove those that are in templistbox2$. If I have some time I will see if I can come up with the code.
Hi Robert,
Hi Robert,
The reason it worked in the first one is because you are closing your dialog and then reopening it so that is how the drop-downs are getting populated. In the second example you are using the DisplayIt function so you need to see another function to attach the list to the array, just naming it the same does not work here. What you need is to use the DlgListBoxArray, this allows you to attach an array to a dropdown through the dialog function. So after the Call GetFieldList1() add the following lines and hopefully that will get it working:
DlgListBoxArray "DropListBox1", List1$()
DlgListBoxArray "DropListBox2", List1$()
DlgListBoxArray "DropListBox3", List1$()
DlgListBoxArray "DropListBox4", List1$()
For each of the drop lists we are adding the array that holds the list of field names.
Brian