Here I am with yet another problem.
I want to add data in a tree viewer controller dynamically from my database.
I am using ms-access as my back-end
Please help me ASAP.
Thank you in advance
VB6 will "understand" the two lines above as the same thing, and you'll not get an error. If you pass a control for a sub or a function, instead, you will probably get strange fenomenous... your program can poltergeist the screen... ;)
Back on Earth, the line TreeView1.Nodes.Item doesn't point to a method or property, and you may get errors.
Try this little change:
If Not objLista.SelectedItem Is Nothing Then
- SelectedItem points to the selected item (dahn...) in the TreeView control;
- Key is the key defined for a single item (must be unique);
- Text is the text displayed for user.
And please take care about SQL syntax.
If you want to search records that match a criteria OR another criteria, you don't use AND operator...
If optcombined.Value = True Then
Set adorsRAM = New ADODB.Recordset
For i = 0 To Node.Selected
sSQL = "SELECT * FROM Master_final WHERE windows='" & Node.Text & "' and office ='" & Node.Text & "'"
this code is showing an error
object variable or with block variable is not set.