Recent content by guillermo88

Hey Mike, thanks a lot for your tips. I went back to my original queries and that seems to be the problem. First of all I have to grids, the first grid will show custmomers with transactions date = date() and amount > 2000 thisform.grid1.RecordSource = '' nSecsSta = SECONDS() * 1st Query...

Yes, all the tables are sitting on a network, and the exe is in every local computer

This is my dummy query in the init event of the form. I added a msgbox to check how long it takes the query. And the msgbox comes very fast the I click the msgbox button and that's where it takes time. In this case now it takes time to load the form. SELECT COL_AGT, INV_NO, DATE, REM_TEL1...

The problem seems to loading the the grid with the cursor. I just tried the same select statement from the command line an it works very fast.

I going to create another method with dummy select statement in it so it will run only once. Thanks. Something else Is it any difference in using RecordSourceType=Alias and SQL Statement? I have another with very similar criteria and it works fine

I added a table in my DE (Invoices)

Hey Mike, But do you need to then resize the grid columns on top of that? The reason why I resize it's because when I re-query the columns change the width. This line of code in the DE is in the init event Thisform.grid2.recordsource = “” If I don't, grid will try to load the table...

QUERY TAKES TOO LONG I have a form with a grid I have an invoice table. I want to display records that match certain criteria: First_name, last_name I also have indices for each field first_name and last_name. The problem that I am having is it takes too long that query and sometimes I have a...

I have and index already. It is on Agent + invoice

I thought I fixed the problem but I didn't. The new shortcut that I create was reading the data from the local directory and not from the directory in the network. I create I new directory Test in my C drive and Test\data for my tables in the drive F: and the same behavior when loading the form...

I don't why but seems having the executable on the network slow down loading the grid only the first time. I created another shorcut but this time the executable was in local drive and the data was and the network and it seem that fixed the problem

I forget to mention that this aplication is running on the network (Executable and data)

I have a form with 2 grids Grid1 contains information about invoices Grid2 contains transactions related to invoices This form allows to look information by a column agent and column invoice No The table Invoice has an index on agent + invoice_no Table invoices have 23,000 records Table...

Dave, I am just trying to use modem for now. Thanks.

Dave, I am just trying to use a regular modem right for now Thanks.