• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • 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 SasidharanAssoc Project ManagerCommented:
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 SasidharanAssoc Project ManagerCommented:
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 SasidharanAssoc Project ManagerCommented:
can u please explain ur second question little bit more ...
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
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 SasidharanAssoc Project ManagerCommented:
What is ur actual question ?
u need to collect machine  names from network ?
0
 
Shiju SasidharanAssoc Project ManagerCommented:
or machine names are being collected from database ?
where do u want to populate data ? to list box ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

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