Recent content by jjmclell

Hi there, I'm using MS Access 2007 and I'm looking for a way to batch print each individual record of a filtered form recordset to pdf. I'd like to be prompted at the start of each print job to select the file location. It has been ages since I've worked in VBA and I do not even know where to...

Alright, I figured out how to do it using sub-reports and grouping in the record source queries. And yes, the above diagrams were for demo purposes only. Thanks. -jjmclell

I'm creating a database in MS Access that has 3 many-to-many table relationships in it. The database is for organizational projects - each project can have many partners involved and can meet the intent of multiple policies, and every combination of this relationship. I was thinking of...

Hi Julie, Part of the problem with the project schedule is that it was created by people with no real training in MS Project, and one of the 'project managers' who has been updating the project file from time to time originally entered all of his tasks using Manual Scheduling, without...

Hi everyone, We have a task in a schedule that was entered as a fixed-duration task. There are no resources assigned to the task, the task has no predecessors, and no tasks rely on this task as a predecessor. The duration of the task was set to 25 days. When we went to update the % Complete...

Hi there, Is there a way I can change the colours of the bars on a Gantt chart? I opted to use the %Complete option and the default colours are a light blue for incomplete and a dark blue for complete...it's hard to differentiate. Thx, jjmclell

Hi there, I have a bunch of data in Access and I'm writing a program that will use that data. What I'm wondering is which is the best way to go... Should I build my application in Access VBA and use queries to retrieve the data from the tables whenever I need it, or should I populate arrays...

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...

Ok, I just had a bit of a revelation. My problem is that my control is an MS Access control, not an MS Forms control. I had assumed that if I had a control in a form, it must be an MS Forms 2.0 object, which (in the case of a listbox) has the list property. But it's a native MS Access...

I think I know what you're saying genomon. When I type "listbox1.", the list of methods and properties for autocomplete definitely doesn't include the "list" property. However, the MS Forms 2.0 object library, which I have checked off in my references, describes the List Property of the...

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

Cool, thanks for the help everyone!! jjmclell

Ok, it seems I've figured it out. Instead of using Form1.listofItems.Selected(next) and then trying to return Form1.listofItems.value I used: Form1.listofItems.Itemdata(next) I swear I've found a bug though b/c the value property of a list box is supposed to return the bound column value...

ItemsSelected is the collection of selected items in a multi-select list box. I have the multi-select property set to none so it doesn't apply. Currently, the way things work, when I select a different item in the list box, the previously selected item becomes unselected as I've verified in...

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...