Recent content by jjmclell

I figure out it seems to just be a problem when viewing the report, as it's turning out to be about 120 pages. It prints to PDF fine, so it doesn't actually seem to be a problem building the report, just an issue viewing it all on screen in Access. A bit of a ridiculous report to create but...

This is what I find strange... I'm really doubtful I'm pushing Access to its limits. Here's the structure of my report: Main report - record source is a table with 6 records, no calculations Sub-report 1 - record source is a table with 24 records, no calculations...

I'm running Access 2010 and I've created a report that has 3 nested sub-reports. When I add the third, the report starts crashing when I go to view it with the following errors: system resource exceeded there isn't enough memory to perform this operation I've read that reports can contain...

Hi there, Should be a simple question...when I use DCount in query builder, do I need to be in aggregate mode? I did a DCount without turning on aggregate functions, and the resulting query looks correct but there's a weird display lag in the query, i.e. when I scroll down the data table, the...

That's a good idea...I did a little searching on that site but not much. I've googled it a thousand times but in all that, like I said, I found one other reference to the problem with no response by the international community. I will search the microsoft website more thoroughly but I'm not...

I think I've narrowed it down. I thought that maybe it was b/c I hadn't been repairing and compacting, so I rebuilt the entire database and started doing that regularly but the problem persisted. I think the problem is exporting the chart to a .gif. I'm using the acOLEClose action after...

Hi there, I'm having a problem with a bar chart (MS Graph 8.0) in one of my forms. I have a number of events written that programmatically change properties of the chart - some work on the actual chart application such as changing the title of the chart, while other events just change some of...

Great! Thanks for the help everyone! jjmclell

Ohhh, so what you're saying Bob is that my list box is not an MS Forms 2.0 control, it's an Access control...two different things? I've been under the impression that b/c I'm working with a form in access, it must be an MS Forms 2.0 object and therefore all my controls must be MS Forms 2.0...

I have multiple columns in my list box though and the idea would be to set a variable to the value in each column, not just the bound column. I'm working on a click event where the user can move the items in the list box up or down in the list. Using the list property, from what I can...

Hi there, I'm trying to use the list property of a listbox in Access and VBA won't recognize the property. temp = Me!lst_Items.List(0, 0) I get this error when trying to execute the above code: 'Object doesn't support this property or method.' Any ideas? jjmclell

The multiselect property is set to none...I assume that means single-select (see very end of my 2nd post). It's not that the listbox wasn't returning a value...it was just returning the value of the previous selection. jjmclell

Ok, well I got the code working. I used Form_Charts.lst_Charts.Itemdata(ctrl) instead of Form_Charts.lst_Charts.Value I swear I found a bug though. The value property is supposed to return the bound column value for the selected item in a listbox and if I programmatically changed the...

Ok, the event is just an On Click event. Here's what it's supposed to do: The list box in question has a bound column that returns the name of an OLE object in a report. On clicking a button, the selected item in the list box returns the name of an OLE object in the report that is to be...

Hi there, I have a list box with a bunch of items in it. The user can select an item and hit a delete button to remove it which then causes some other things to happen. Basically, as part of that event, I need to select the next item in the list and return its value, as shown below...