Search results for query: *

I have a form that has four controls- the first three are combo boxes with integer values, the fourth is a text box for a total of the three combo boxes. all the controls are bound to fields in a query/table. (So that the text box with the total saves to the table). I am trying to write the code...

I have constructed a crosstab query and report based on it where I have two row headings: Region, and STatus. The only values in Status are "New" and "Old" The column headers are type1, type 2, and type 3, and the field values are an integer. I am trying to change the backcolor to yellow where...

I have constructed a crosstab query and report based on it where I have two row headings: Region, and STatus. The only values in Status are "New" and "Old" The column headers are type1, type 2, and type 3, and the field values are an integer. I am trying to change the backcolor to yellow where...

I have an Access report based on a crosstab query, with rows as "month" and columns as "employee" with values as sales dollars for that month. I am trying to shade the highest value in each month row. The shading is not hard, but I dont know how to construct the code (have tried dmax function)...

ORIGINAL THREAD: I have a report based on a crosstab query, with rows as "month" and columns as employee sales dollars for that month. I am trying to shade the highest value in each month row. The shading is not hard, but I dont know how to construct the code (have tried dmax function) when...

I have a report based on a crosstab query, with rows as "month" and columns as employee sales dollars for that month. I am trying to shade the highest value in each month row. The shading is not hard, but I dont know how to construct the code (have tried dmax function) when trying to find the...

I have been working for several days to write code for a report in order to change the backcolor of a report control noted here as "[1]" if it is the maximum value in the field. I am almost there, but I am getting an error message I dont know how to deal with. Here is the code: Option Compare...

I have been attempting to shade a control in a report when the highest value in a query field is shown. I received some assistance in the form of code suggestion as follows: Option Compare Database Option Explicit 'Global declaration to hold the max value Dim lngMax As Long Private Sub...

I have a control tied to a query that in a report returns several values. I am trying to use conditional formatting to shade the highest value in the field. I have used bracketed expressions, not field values, to accomplish this. I understand from Access help that the conditional formatting...

I have created a query where I try to return six records that correspond to six states. For each record, I am trying to create an expression in the query that returns the average of one field , with a criteria limiter, for each of the six states. I have used Avg iif to do this. I cannot get the...

I am in a query where I use a dsum function in several different expressions in the query. in the dsum, I am setting a criteria on a field in the same query table, i.e, where I sum dollar values from one field based on a range of values in another. Example: sum the dollar values from the for the...

Greetings to all. I have an Access report with bound text box controls in the report detail section that come from a crosstab query. Call them controls a and b. I want the backcolor of control b to change if the value of control a is equal to a certain number. I am not certain if I write the...

I have a report already created based on a crosstab query. one of the fields in the report is [region]. In the table the query draws from, there is a field regionid, a number. I cant get it into the report because of rowheading limitations of the crosstab. I have tried to write code assigning...

Greetings to All! I have created report where I want to run a procedure where in the detail section of the report I have a text box with different calculated values. When the text box is 90 points, I want an OLE object to appear, 80 points another OLE object, and so on. If there is no value in...

Greetings to all. I am attempting to create an event procedure (so to speak) in an Access report. I have designed an OLE object that I want to appear only if it correlates to a certain value in another control. i.,e if the value appears, the ole object appears or is visible. I have written code...

I have several calculated controls on a form (based on the controll source property being a dlookup function )that I want to have the values captured in a database so they can be sorted. I created a bound control text box, and in the corresponding unbound control text box I wrote an event...

I have created a form with bound textbox controls where certain values are typed in. I have a corresponding unbound textbox with a DLookup statement typed in the Control Source Property that matches the typed value in the bound control to a table of range values. I am trying to get my...

Cannot find correct process for creating a junction table in Access. I have attempted via help screens, instructions dont seem to work. Always seems to be an outer (type 2) join automatically created between the two tables I want to relate through the junction table. I have created one junction...

I am trying to use the Workbook BeforeSave Event (if appropriate) to prevent an excel worksheet from saving if a particular cell does not equal the number 1. Cant seem to get it to work. I also would like a message box that pops up if the value of this cell is not 1, but no yes/no choice is...