Search results

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?

Add this: Private Sub TreeView_NodeClick(ByVal Node As Object) MsgBox TreeView.SelectedItem End Sub Works like a charm!

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

Access2k is correct. That did the trick!!

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

If Me.TabCtl111 = "1" Then ... does the trick! 0 is page 1 1 is page 2 2 if page 3 and so on. Thanks for all the help in pointing me in the right direction!! :D

Ok, I found what you are talking about and can get things to happen. :) Now the problem is, I cannot seems to find the correct code to tell me what tab page I am on. This is what I am using: If Me.TabCtl111.Pages = "Services" Then MsgBox "true" Else MsgBox "False" End If But it produces an...

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

THAT DID IT!! Thanks a bunch for the replies!! :D

Mile-O-Phile, Do you have a code example on how to use the keydown event. I swapped everything containing KeyAscii to KeyCode and the DELETE still not fire for me. =======================================================

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.

This works: ="( " & Format([Date],"dddd") & " Week " & DatePart("ww",[Date]) & " )" & DatePart("ww","12/31/" & Year([Date]))

Good idea but it does not display. It gives the #Name? in the field now.

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 ended up back at the beginning again. Here is my code: DoCmd.RunSQL "UPDATE Employees SET [Notes] = '" & Me.[NoteField] & "';" This updates ALL the fields in the table with the information. How do I add the WHERE command to look at the ID field of the table and match what is listed in...

Here is my new code: DoCmd.RunSQL "UPDATE Employees SET [Notes]=" & Me.[NotesField] & " WHERE employees.name = ME.[EmployeeName];" Employees is the table name Notes is the field inside the table Me.[NotesField] a field on the form that you fill in. Me.[EmployeeName] is the ID # of the name...