Open Table or form in access 2007

J

Jose Perdigao

In acc2003, when I open a table with many records (200.000), the table
immediately opens and then the records is coming, I like this feature because
the screen is no blank and the user can see the data.

The forms have the same behavior in acc2003.

Also I created the following procedure to open the form and it also behavior
as above.

Dim cn As ADODB.Connection
Dim Rec As ADODB.recordset

Set cn = CurrentProject.Connection
Set rc= New ADODB.recordset

rc.Open "J1_Allocation", cn, , , adAsyncFetchNonBlocking
DoCmd.OpenForm "zzz"
Set Forms!zzz.recordset = rc

With this code, when I open the form ZZZ, immediately start to show the
records.

I convert the ADP to acc2007 and it doesn't have this behavior. Does it need
to set any parameter?

I need help,
Thanks

jcp
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass parameter to sp 1
export excel data to access table using ADO 0
Fields Properties 4
Export specific fields from access to Excel 0
CurrentProject.OpenConnection ignores default language 1
Using Access 2007 (adodb) data to fill a user form 2
adOpenStatic Recordset still changing my table 5
Exporting data with vba from Excel to an Access 2007 db with password 8

Top