Search results

First, how would I write the If statement to check whether there are records on the subform? Second, the three activities are all different. A little more info about the database follows: Table for main form: tblObjectives Table for subform: tblActivities PK on main form: ID (autonumber) FK...

I have a subform that tracks multiple activities for each objective. However, one of my objectives always has the same three activities. What I want to do is, from the click of a checkbox (with the value = True), create the record for activity 1 and put specific text in the activity field...

The advice was in no way bad. You helped me think things through. I truly appreciate your help. :)

I figured out why the On Format event wasn't triggering. 2007 has an additional report view than prior versions. I am looking at the report in this new view. When I open the report in Print Preview, the code fires. I guess I'm going to have to have the report open in Print Preview instead of...

I put the code in the On Click property of the section of the report with the control...and the code works fine there. For some reason, the On Format event just isn't firing when the report is opened.

I went one step further and created an unbound textbox with a brand new name. It had a calc making it equal to the original calc control. I used this in the reference and it still didn't work. It feels like I'm trying to breathe through a straw...a very small straw. That feeling is one of...

Me too. It's odd that it doesn't even execute at all.

I created a blank database, turned AutoRename off, and imported everything into the new database. This didn't help. It was worth a shot though. I think that because this database is only a week old and I never had to change the name of any fields in the tables, that there wasn't much chance of...

Because the code doesn't give me an error when I put it in the On Format event of the section where the calculated control is, I decided to debug the code there. I put a breakpoint in and oddly it doesn't seem to even be firing.

This is a report, not a form. I've tried all three ways (Me. and Me! and no Me). There is a Case Else statement which makes all the rectangles not visible.

Runtime Error '2424' The expression you entered has a field, control, or property that Microsoft Access can't find. Using the variable didn't do anything.

Not bad at all.

I didn't preview my post and noticed after I posted that it was messed up. It seems that we both reformatted it at the same time. LOL

I am trying to have certain rectangles become visible or not based on the value of a calculated control in a report. However, it gives me Error 2424 and points to the calculated control Me.calcOverallRating as the problem. The control is available in the list after I type Me. and therefore is...

The final solution to this issue was some well placed quotation marks. = """" & DLookup("[DateYear]", "tblReportYears", " right([DateYear],4) ='" & Year(Now()) & "' and" & "[FiscalCalendar]='" & "Fiscal" & "'") & """"

I've tried that already. Also, I'm doing this via code and not in the default value property of the control. This is because the default value is dynamic and changes based on the value of another control. When I put my expression in the Immediate Window it shows the value I want as 2007/2008...

It must be magic. As inexplicably as the problem occurred, it has vanished. Hopefully the glitch won't return. The odd thing is that the issue was reproducable on different days with two different computers. Darn those gremlins!!! If this rears its ugly head again, I will post back. Thanks. :)

I'm not sure if this belongs in this section or not. I created code to set the default value of an unbound combobox based on the following expression: DLookUp("[tblReportYears]![DateYear]","tblReportYears"," right([tblReportYears]![DateYear],4) ='" & Year(Now()) & "' and" &...

The fields are on the report. Even if that were the problem, it wouldn't explain the page number issue or why it calculates properly when I add a new control to the report. I can add any control without even setting a source for the control and it fixes the problem until I restart Access. Thanks.

I am baffled. My report has some unbound textboxes that perform calculations based on other fields in the report ( e.g. =[CountOfUniqueStates]+[SumOfCountNoState]+ SumOfCountNonUS] ). When the report loads I get the #name error. All three of these fields are on the report so it's not a question...