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??

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...

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...

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

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...

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?

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?

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.

I have a main form opened up and when I select a command button - it opens up a second form on top of the main form. I want the second form to stay on top unless you select the close command button on the second form. If you click out of the second form - it stays in the foreground. They only...

I have a main form called checkpoint and a subform called network_object. On the subform is an text box called SourceName. Here is my code Forms!CheckPoint!network_object!Me.SourceName = "test" 'Forms!MyMainFormName!MySubformName!MyControl Only thing is - it never updates the subform...

Nagging Error here it is - I am using treeview with a imagelist. Run-time error'35613': ImageList must be initialized before it can be used Any ideas on how to fix this?

When I click on the parent node plus sign and it expands and shows the child nodes, how can I get it to msgbox me when I click on the child node what the orginal parent node was?

I have a working treeview. I can expand the objects and view all sub (child) objects with no problems. What I am trying to do is when I click on an item, a message box will pop up telling me the item name. Any idea on how to do a "on click event" for items in the treeview? I have searched the...

When I am in the code base and type in Dim item as (a box pops up) and I can select the objects from within it. How do I add to this box? I am trying to follow an example on treeview and they have dim db as database. In my need access database that I am working on does not cantain the object...

I have a tab control box with 3 tabs. Names: Network, Services, Resources. When you click the Services tab, it should auto hide some fields on the form. The thing is, you have to click a 2nd time in the tab control box for it to work. Is there a way to have it automatically hide the fields...

I am trying to use the on ket press event. My code is simple: Private Sub SourceRecord_KeyPress(KeyAscii As Integer) If KeyAscii = 46 Then MsgBox "Delete Key Pressed" End Sub Only thing is - it does not reconize the del key being pressed. Any idea's on how to use the delete key? Thanks

I have some command buttons grouped together. I see how to make it visible or not visible from the properties. Only thing is, there is no name field under the other tab. How do I make it visible again if a user clicks a certain action? Normally I would use me.othername.visible = true.

I have this line listed as the control source. ="( " & Format([Date],"dddd") & " Week " & DatePart("ww",[Date]) & " )" & DatePart("ww","12/31/" & [year]) The last DartPart shown in red does not work. What I am trying to do is get it to display the following: "Monday Week 6 of 53." The only...

I am trying to update a table called employees. The field I am trying to update in the table is called Notes. It get's the information from a text box on the form called Me.[Notes] Here is my code: DoCmd.RunSQL "UPDATE Employees SET [" & Notes & "] = Me.[Notes];" And idea's on how to get it...