CODEWITHSUNDEEP
sqlmysqlms-accessvba
Alex Gordon
Alex Gordon

Reputation: 60711

ms-access listbox weirdness (memory issue?)

i have a huge sql query that is attached to the rowsource of a listbox.

the SQL statement seen here:

ms-access: select from another query

actually returns the correct information if that information is under 2 records.

however if it returns more than 2 records it still populates the listbox but it populates it with null values. when i right click on one of the values and press COPY, it gives me this message:

"there isnt enough memory to retrieve data for the list box"

Upvotes: 0

Views: 288

Answers (1)

Tony Toews
Tony Toews

Reputation: 7882

But does the query work if it is run separately? And is the number of columns in the query the same number of columns as you've specified in the listbox Column Count property?

In your reply you state that you have to combine it? Why? Basic trouble shooting is to see if you can run the query separate from the lixtbox.

Upvotes: 2

Related Questions