Search results

How do you tell if a form is open or not? I have a main form that when a user selects a command button, will open another form. From the new form - it may open a 3rd form. I would like to close the 2nd form after the 3rd form opened up. Any idea??

Dim Node As Object took care of the error and works like a charm.

I have a treeview with child and grandchild fields. How do I get the treeview to expand the child fields when the form is opened? Code: For Each Node In TreeView.Nodes Node.Expanded = True End If Next Gives me an error on 'Node' in the For Each statement. Error: Compile Error...

It does not understand setfocus.

I have 2 listview controls called Source and Destination. I am using the form keydown event to capture the delete key. When you press the delete key - how can I tell which listview has focus so I can delete the correct object from the selected listview? Code: If Not...

That did the trick. Thanks!! You would not happen to know the rest of the listview switches would you?

I am using a treeview and a listview control. I am trying to figure out the total items in the LISTVIEW control. Does any one know how? I am using the following but get errors: listView.Items.Count

This did it: DoCmd.RunSQL ("DELETE * FROM table_rules WHERE " & _ " table_rules.RULE = '" & Me.Rule & ";" & "' AND " & _ " table_rules.MAIN = '" & IconParent & "' AND " & _ " table_rules.SUB = '" & IconChild & "' ") Now I delete the correct line...

That works great except it deletes all rules of the same number. I only need it to delete the online. I am trying to take your example and add this: DoCmd.RunSQL ("DELETE * FROM table_rules WHERE table_rules.RULE='" & Me.Rule & ";" & "'" & table_rules.MAIN='" & IconParent & "'") I get a...

The fields I am looking to delete in the table called table_rules Are MAIN, SUB, RULE, SOURCE, DESTINATION. Here is the command I am using: DoCmd.RunSQL ("DELETE table_rules.* FROM table_rules WHERE (((table_rules.RULE)=" & Me.Rule & "));") I am getting a data mismatch error. Does someone know...

This will show how to do it: http://www.access-programmers.co.uk/forums/showthread.php?t=66278&highlight=call+module

I have a form that currently accesses a function via code. I would like to move the function to a module to help with the growth of the main code. How do I call a module from my main code?

That did it :D I had the split working but could figure out the for next statement. Thanks for the quick reply!

I have the following string: SearchString = "checkpoint;firewall;serverA;serverB;serverC" Under normal code, I would use: For I = 1 To 5 MsgBox Entry(I, SearchString, ";") Next This would pull out each word from my string. is there a simple way in MS Access to do this?

It turned out to be .smallicon = oTree.SelectedItem.Image

In the following code - it updates a listview with the item select from the treeview. It adds the correct name (.Text = oTree.SelectedItem) but I cannot figure out the property tag for the image file. Right now I am using a default image for all items (.SmallIcon = "Network_Icon") .SmallIcon...

Does any know where I can get a sample database of how to drop and drop from a treeview to a listview box? Or any sample code? I have viewed code on how to do a combo box to a combo box but it seemed somewhat sloppy.

It used to work great till the anti virus nazi installed McAfee on my laptop. Now when I go into help - it just sits there and I listen to my fan kick into high gear. Bad thing is - I disable it and at midnight, the epolicy server re-enables it... Long live the IT nazi! :D

That did it. For as long as I have been playing with access - I have always wondered what popup and model did. Now I know... Thanks for the help!!

That worked. Only thing is - even though the second form stays on top, you can still click on items on the main form. Is there a way to make the main form inactive without closing it allowing you to only click on the second form?