How to Populate Lis Box with 1000 records?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list box that needs to be populated with a lot of data. The data
are coming from a table with SQL script that returns the records. When I
tried my own code the application crushes and it displays memory failure
message. Can any suggest a good way to achieve this?
 
What do you mean, "a table with SQL script"? That does not mean
anything. It's like, "an apple with video tape".

Generally, if you want to get some values out of a table, into a
listbox, you need to set the ControlSource property of the listbox, to:

(1) the name of the table;

(2) the name of a query that uses the table, or

(3) a SELECT statement that uses the table.

Which of those are you currently doing? What /exactly/ is the error
messaage you're getting?

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
I have a list box that needs to be populated with a lot of data. The data
are coming from a table with SQL script that returns the records. When I
tried my own code the application crushes and it displays memory failure
message. Can any suggest a good way to achieve this?
Click to expand...

Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.
 
Back
Top