Recent content by TondoBoy

I tried it on mine and it works. I just wish you can have more control on the product. Mine prints two thirds of the way and then cuts off the printing.

Andy, I hope you that you would'nt mind but I found out that I did not do an actual multiple sort when I tested the code that you recommended. I found out that the last part, which is populating the flexgrid back, was not working properly. I tried to correct it to no avail. Would you mind...

I found the solution to my problem. Outside of the the DO Loop, assign I = row number and inside the loop replace the syntax " For I = 4 To hfgbud.Rows - 1 " with I = I +1. Remove the outside "Next".

What am I doing wrong? I ran the same SQL on my Access database and I showed 194 records but when I ran this code in the VB program to populate my MSHFlexGrid only the last 20 or so are showing on the grid. Running the debug, I can see that it is picking up every record up to number 22 and then...

Here's a sample if your are making an ADO connection. Make your connection: dim conn as adodb.connection dim rs as adodb.recordset dim strSQL as string set conn = new adodb.connection set rs = new adodb.recordset strSQL = "SELECT * from tablename" conn.open =...

Thanks for the help...

I'll appreciate some help. I populated my grid from Access DB and now after some data changes I want to save it to the DB. The grid is not bound. What is the simplest code I can use to do this? A sample code would be helpful..

Do a variation of the following: Option Explicit Dim cn As ADODB.connection Dim rs As ADODB.Recordset Private Sub Command1_Click() MsgBox cn.version End Sub Private Sub Form_Load() Set cn = New ADODB.connection Set rs = New ADODB.Recordset cn.Open "Provider =...

Brian, It worked with SQL statement. One more thing, how do I go about creating similar reports, but passing parameters to the SQL from VB. Is it possible? I tried but Crystal Report would not let me do it. Thanks again....

Thanks a million balves! It is the answer I was looking for.

Thanks, it sounds like coming from a voice of experience. I will try your advice and keep playing with it until I come into an acceptable solution.

I am newbie with Crystal Report and I would like to ask the experts a basic question. I am using Crystal Report 8.5 with VB and Access db. 1. Is there a direct way to use a SQL statement in Crystal Report? It is a complex SQL statement that retrieves data(SELECT), Total by group(SELECT...

AndyGroom, It worked perfectly. That was extremely helpful for me. Thanks again...

Andy, I have not tried this out yet but it makes sense and it should work. Using a listbox to do the sorting is a neat idea which I never tried before. I will try it out and let you know how it worked. Thanks a million...

Can anyone tell me if I can do multiple column sort on MSHFlexgrid? I have done single column sort but not multiple. I cannot find any reference. Thanks in advance.