Search:

When the button is clicked, I want the file (it's a XPS document) to be opened in windows.
The file will be in the same directory as the visual basic project.
Therefore, I need the code to open the...

No no guyz.... I literally want the file to be opened in windows when I click the button.

When the button is clicked, I want the file to be opened.
The file will be in the same directory as the visual basic project.
Therefore, I need the code to open the file using "app.Path".
Any...

i tried the text property, list and index. none of them work!

tired it. still doesn't work! any ideas?

Please ignore that. it was a typing error. Here is the correct statement :

rsVehicle.Fields("Companies Registerd To") = txtCompany

thnx for pointing it out. fixed it in the original post too.

I'm using a MSHFlexGrid (fgdVehicle) to input data from a database ( via a recordset (rsVehicle) ).
You can either enter the data into the database in two ways :

1. From...

YESS!!!!!! THANK YOU SO MUCH DOOGLE!!!!!!!!!
you never fail to help me!!!! I am so grateful to you man.
Thank you so so much!!! XD

YESS!!!!!! THANK YOU SO MUCH DOOGLE!!!!!!!!!
you never fail to help me!!!! I am so grateful to you man.
Thank you so so much!!! XD

Dim xString As String, xRow As Integer
Dim boFound As Boolean, J As Integer

cmdSaveNew.Enabled = False
xString = InputBox("Enter Company Name : ", "Search")
If xString <> vbNullString Then
...

I did what you said.
And now whether I enter correct/incorrect data, the whole program becomes unresponsive when clicked "OK" in the InputBox....

I did remove the "txtSearch.Text = xString" line as it kept highlighting that line and giving the error "Object required".

It highlights the line : " fgdCompany.Row = xNext " and gives an error saying "Invalid row value"

It highlights the line : " fgdCompany.Row = xNext " and gives an error saying "Invalid row value"

It seems to be that there is a MAJOR problem in this code.
The code works and gives the correct output when wrong data is entered.
But this is the problem. When correct data is entered, it...

I'm so so sorry. I completely forgot.
Here's a link to the CodeGuru post : http://forums.codeguru.com/showthread.php?527475-Search-for-data-in-a-MSHFlexGrid&p=2084681#post2084681

I tried the method you said but it didn't work. Can you please give me the code for it..... I would greatly appreciate the help!!!

In my form, I have a MSHFlexGrid (fgdCompany) and a Search button.
What this search button should do is when I enter data into the InputBox, it should search for the entered data and highlight the...

okay. thnx!

It's just a simple database storing some customer and invoice details.
The database package is Access 2010.
Can you help me?

I'm looking for a simple database-server maintenance and management software.
It need not to be free but it must be known in the field of networking.

I use VBDataReports in my software. For them to be created on the installed program, shouldn't VB be installed on the computer?

I use the properties window to enter the picture. Therefore I don't need to include the pictures. Correct?

What do you mean "Picture properties at design time". Can you please explain a little bit more :blush:

There are a couple of pictures I will be using on the form. What about them? Should they also be stored like the database?

SO if I install the program on another computer that doesn't have Visual Basic 6 installed on it, the program would work perfectly?

If I install a program that was created by Visual Basic 6.0 (via Package and Deployment Wizard), and install it on my computer, is Visual Basic 6.0 need to run that installed program?

OMG OMG!!! It worked. I tweaked the code a little bit with the one you gave above and it works perfectly.
But the problem is, it only highlights the first column of the row that the searched data...

I'm currently using this code.

xString = txtSearch.Text
For xNext = 0 To fgdCompany.Rows
fgdCompany.Row = xNext
xRow = fgdCompany.Row
If xString =...

hi. When I run the program it gives the error "Next without For" and when clicked debug, it highlights the line "Next x"

hi. When I run the program it gives the error "Next without For" and when clicked debug, it highlights the line "Next x"

I have a MSHFlexGird (fgdCompany) and a search command. When the user enters the search data into "txtSearch", the command should search for the data and show it to the user by :

Highlighting...

the code works great!
but one more small question.
Is there anyway that i can highlight the row that is found by the search on the MSHFlexGrid?

I have a MSHFlexGrid that gets all records via a recordset from a database.
I want to add a search function so that it would search for the data entered by the user on to the search textbox. But it...

never mind guys. my problem is solved. it was a error with the file location.
big thank u to DataMiser and firoz.

I didn't use any code. I created the Data Reports using Data Environments and made all the settings and preferences from the Data Environment itself. (Refer to the first link given on original post)

no. my .mdb is not password-protected. and what should I use as the Provider String (I mean, what should I enter to that textbox?)

Hi there.

I developed a program that creates Data Reports using this way : http://www.vbtutor.net/vb6/lesson40.html
But instead of using "Microsoft Jet 3.51 OLE DB Provider", I used "Microsoft...

okay.

Here's my problem.
I have a form in which a Microsoft Hierarchical Flex Grid (fgdCompany) is used to display records taken from a database to relevant textboxes on the same form.
When a...

hey there,

Here's my complete code for a delete button that deletes a record in a Hierarchical Flex Grid.


Dim rsTour As New ADODB.Recordset
Dim cn As New ADODB.Connection
Dim...