Search results

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

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

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

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

I have a PivotChart (as a form in PivotChart view) that I formatted to have the series label show in the chart (which is easier for the end-user to evaluate in a pie chart if they can see the number each piece represents). The problem is that when a piece of data in the chart goes to zero (or...

How would I go about transferring the values contained in one form to a subform where the values are placed in a new record? The below code is called from a command button and places the values in the subform. However, it places them in the record at which the cursor is in. I imagine I would...

I am using PivotCharts to graphically display my data. However, when I place the data into the chart it names the labels with the calculation (e.g. sum of X, count of X). How do I edit these? The only posting in the forum I saw recommended doing the sum in the query and then base the PivotChart...

I'm trying to figure out how to move the cursor to end of text in a textbox after I set focus to the control. Right now all of the text is highlighted when the focus is set. The code I'm working with is very simple: -----------------------------------------------------------------------------...

The title pretty much says it all. I have a series of cascading comboboxes. However, if combobox 2 has no values to choose from, I would like to turn Visible = False so that the users don't have to click on it to find that there are no choices. Essentially, I have cboCategory and...

Here is what I'm trying to accomplish. I have one form with a button on it that calls another form to add additional information. I want to be able verify that there is not already data entered for the specific record. The reason it is a separate form and not a subform is that the data in the...

I am using the code below to transfer values from one form to another. However, I am getting the following error: "Runtime error '-2147352567 (80020009)': You can't assign a value to this object." Using the immediate window I see the value of each OpenArgs, so it's not a question of the split...

I'm trying to use code to set validation which checks if the value of Audience is "other" then the value of the control Other cannot be empty. It works fine while I'm in the subform. However, if I click out of the subform it puts focus where the user clicked. I tried putting the code on the...

The following example code works fine in one of my forms but does not work correctly in two others. My issue arrives when I enter the new data in frmAddSponser and return to the form that called this form. The Response = acDataErrAdded is supposed to requery the combobox and allow you to exit it...