• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 163
  • Last Modified:

browser window and adodc queiry

1/ i need to open a windows explorer window from vb with the address from a text box

2/ i had a picture of my office and i want to be able to click on a computer and view its details
i have got the form layed out with the picture at the top, boxes on each computer, an adodc linked to a database, labels to view the data, and a button to link you to the selected computers network folder
0
johnlwarence
Asked:
johnlwarence
  • 5
1 Solution
 
Shiju SasidharanCommented:
1.

'===============================
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Private Const SW_MAXIMIZE = 3
Private Const SW_NORMAL = 1
Private Sub Form_Load()
    Text1.Text = App.Path
End Sub
End Sub
Private Sub Command1_Click()
    Call ShellExecute(hwnd, "explore", Text1.Text, "", "", SW_NORMAL)
End Sub

'===============================
0
 
Shiju SasidharanCommented:
remove one End Sub from last post



Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Private Const SW_MAXIMIZE = 3
Private Const SW_NORMAL = 1
Private Sub Form_Load()
   Text1.Text = App.Path
End Sub
Private Sub Command1_Click()
   Call ShellExecute(hwnd, "explore", Text1.Text, "", "", SW_NORMAL)
End Sub
0
 
Shiju SasidharanCommented:
can u please explain ur second question little bit more ...
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
johnlwarenceAuthor Commented:
the second question i have got sorted myself so heres one to replace it

i have lots of list boxes covering a map of my office, the boxes indicate pcs, i can drag and drop them to any location on the map.

but i want to be able to search for a pc name and then that pc will show up in red

i have a textbox labeled text1, and a command button labeled command1

the labels are called pc*** representing their three digit number on a sticker on the side of the machine

please help
0
 
Shiju SasidharanCommented:
What is ur actual question ?
u need to collect machine  names from network ?
0
 
Shiju SasidharanCommented:
or machine names are being collected from database ?
where do u want to populate data ? to list box ?
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now