Recent content by mistera

Paul, You were absolutely right! ProjectID is an autonumber field and when I changed it to be variant in the function, everything worked perfectly. THANKS!!

I have a form where the control source of several text box fields includes a function that looks up values in a table that is not the form's record source. The default value in the property for these fields is set to 0. Unfortunately, when I migrate to a new record, these fields display the...

I did not have to specify a default value on the subform control's default value property because the underlying table's design has the field to which the control is bound set with a default value of zero. The missing piece that made the zero default work without truly allowing additional...

Woo, hoo! Thanks spikepl for the suggestion. That worked! I changed each subform's property for Allow Additions to Yes. I also changed the properties for each control on each subform for Enabled to No and Locked to Yes. Also, the mainform Enabled and Locked properties for the subform...

Thanks to everyone who responded to my post. I'd like to address each of the responses: JHB: Setting the Default Value property for the control will only set that value for new records. Since these subforms are for display purposes only, that property will never be used since no new records...

I've searched the forums and cannot find a problem similar enough to my issue to resolve my problem. I have a main form with 3 subforms. Each subform is identical except for the value of the filter property. The filter is for the same field, but with a different value for each subform. So, for...

Yippee!! I figured out the issue. While the problem appeared to be with the line of code I had highlighted, it was actually due to the fact that the "Y2 Other" field was missing from my query that was used as the recordset. Once I added that field to the query, everything worked just as expected.

I've determined that the problem has something to do with the Excel worksheet cell reference, but I'm still not sure what the issue is. In order to narrow down the issue to whether it was related to the rs recordset value or to the Excel worksheet cell, I tried changing the target (left side...

Good thought, but that isn't it. I tried adding the brackets and the same error occurred. When referencing a field using the Fields keyword and using the name rather than the index number, putting that name in quotes is usually enough and the brackets are not necessary. When I put a...

I'm stumped and need some help. I am trying to transfer values from my Access 2007 database to an Excel file, but I am getting error 3265 - item not found in collection. Below is a snippet of my code. strFileName is the fully qualified name of an Excel file. The error occurs at the red...

Awesome! I created the function and used it in the query as suggested and it works like a champ. Thanks so much!!

I've searched several forums but cannot find a resolution to my issue. I'm using Access 2007 and have a query in which I have a Where clause that includes a TempVars variable. Here is the SQL: SELECT tbl_CostCenter.*, tbl_OpEx.*, qry_OpExByCC.* FROM (tbl_CostCenter INNER JOIN tbl_OpEx ON...

Did you ever find a way to do this? I have a similar situation in that I have a sub-form that is a pivot table and I want to change info displayed in the main form based on the user "selecting" or clicking a cell in the pivot table. Basically, all I need is to capture the row/column info from...

Did you ever find a way to do this? I have a similar situation in that I have a sub-form that is a pivot table and I want to change info displayed in the main form based on the user "selecting" or clicking a cell in the pivot table. Basically, all I need is to capture the row/column info from...

Okay, I did some more searching and found code that should work, but for some reason I'm getting a subscript out of range error. Here is the code I added to the form's open event: Me.PivotTable.Activeview.DataAxis.FieldSets("Budget").Fields("Budget").DetailBackColor = "Green"...