Search results for query: *

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

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

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

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

Hi there, I currently have a form with an embedded MS Graph chart. The chart's row source query changes based on selections the user makes in a couple of combo boxes also on the form, hence causing the chart to change and allowing the user to look at different statistics. What I would like to...

Hi there, Does anybody know how I can insert a chart into an Access report programmatically? As far as I can tell, there is no simple myreport.add.charts.object method available in any of the libraries I'm referencing and I'm STUMPED!! Any help would be greatly appreciated. Thanks, jjmclell

Hi there, I have 3 combo boxes. The values you can select in cmb_2 are based on a query of what you select in cmb_1 and the values you can select in cmb_3 are based on a query of what you select in cmb_2. Now, what is supposed to happen on the form is the user first selects a value from...

Hi there, I'm having a strange problem with the layout of my relationship tables. I have a table that is beyond the extent of where I can scroll to and I can't delete it. I know it's there b/c I can see the relationship line running to it from another table but like I said, I can't scroll up...

Hi there, I have a date/time field on my form and I'm having a problem where the access keeps adding seconds to my time entry. For example, if I enter a date and time of: 2007/04/10 3:52 PM Access changes it to this when I switch the focus on the form: 2007/04/10 3:52:00 PM Is there...

Hi there, I'm running into a problem with an 'OnCurrent' event I coded into my form. This is the code I'm trying to execute: Forms!frmCSA!subfrm1CSA.Form!subfrm2CSA.Form!subfrm3CSA.Form!Description.Locked = True I'm certain there's nothing wrong with the code itself...the only time I get the...

Hi there, I've got a form that looks like this: MAIN FORM SUBFORM1 SUBFORM2 SUBFORM3 I'm trying to code an event in a listbox in SUBFORM1 that locks a textbox in SUBFORM2 if the user picks a certain item from the list. However, I can't seem to get the code right in order to...

Hi there, I've designed a form that has 3 nested sub-forms. I'm having a problem when I switch to a new record in the main form, then switch between records in the 2nd sub-form, and then switch back to the previous record in the main form...the problem is that the 1st sub-form just disappears...

Hi there, I have a sub-form within a sub-form and I'm trying to add a jpeg file for a picture just by using the properties box of the form. However I keep getting the error "Object variable or With block variable not set". Does anybody know why and what I can do to avoid this? I am an...