By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,725 Members | 1,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,725 IT Pros & Developers. It's quick & easy.

Allen - Your report list box

P: n/a

Allen,

I tried creating one of the report list boxes you have on your page
(http://allenbrowne.com/ser-19.html). I created the chk box, cmd button,
and module (saved as EnumReports). I assigned the listbox a
RowSourceType of EnumReports, and left RowSource blank.

When the form loads, I either get a "too much memory requested", which I
fix temporarily by changing the sRptName size down a little, or I get
nothing in my report list.

I have two reports in the database for testing.

Any idea what could be wrong? I'm using Access 2000, with no reports of
errors when the page loads.
Jan 19 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Presumably you are using the 2nd method in the article.
Try the first method instead.

The issue with memory could be anything, such as a full drive, an invalid
TEMP folder, or manually locking down the virtual memory available under
Windows, or failure to release the memory at a suitable time (the last Case
statement in the EnumReports() function.) If you only have 20 reports in
your database, you could certainly reduce the memory space in the 2nd
declaration i.e.:
Static sRptName(20) As String

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Kevin" <wi******@hotmail.com> wrote in message
news:pa****************************@hotmail.com...

Allen,

I tried creating one of the report list boxes you have on your page
(http://allenbrowne.com/ser-19.html). I created the chk box, cmd button,
and module (saved as EnumReports). I assigned the listbox a
RowSourceType of EnumReports, and left RowSource blank.

When the form loads, I either get a "too much memory requested", which I
fix temporarily by changing the sRptName size down a little, or I get
nothing in my report list.

I have two reports in the database for testing.

Any idea what could be wrong? I'm using Access 2000, with no reports of
errors when the page loads.

Jan 19 '06 #2

P: n/a
On Thu, 19 Jan 2006 12:09:49 +0800, Allen Browne wrote:
Presumably you are using the 2nd method in the article. Try the first
method instead.

The issue with memory could be anything, such as a full drive, an invalid
TEMP folder, or manually locking down the virtual memory available under
Windows, or failure to release the memory at a suitable time (the last
Case statement in the EnumReports() function.) If you only have 20 reports
in your database, you could certainly reduce the memory space in the 2nd
declaration i.e.:
Static sRptName(20) As String


Method #2 worked. :) To bad you can't get the caption to display instead
of the report name, but hey, I'll just rename it!

Kevin
Jan 20 '06 #3

P: n/a
On Fri, 20 Jan 2006 02:35:45 +0000, Kevin wrote:
Method #2 worked. :) To bad you can't get the caption to display instead
of the report name, but hey, I'll just rename it!

Kevin


Err, method #1, the second one I tried. You know what I meant.
Jan 20 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.