Search results

Is there a way to change the background color of a textbox based on a yes/no answer? It's basically a checkbox, but I want to use a textbox instead that will fill black if true and stay transparent if false. Is it possible?

I need to be able to click on a control in my form that will pull 2 or more reports based on [policynumber]. The first report would be a cover letter, and the 2nd report would be an application. I can't make the application a subreport because the footer on the letter would screw up the...

Is there a way to correctly display currency in a bound textbox that includes additional text? the text looks like something like this: ="Your current premium is "& [premium] & ". Please blah blah..." The actual text is longer and more detailed then this example, but even with something...

I have a report and subreport based on respective queries. Both queries have criteria asking for [policy number]. How would I code it so that the subreport will automatically use the same policy number the main report is using? Thanks in advance

I'm not sure if I'm in the right part of the forums because this might be a query question. I have a productivity report based on 2 tables: the primary CUSTOMERS and dependent OPTIONS. Options has 1 field (called OPTIONS, the primary key), and the field has the values SOLD, PENDING, QUOTE...

I have a report that prints a list of my combo box values and a count in the footer. My combo box is called OPTIONS and has SOLD, DECLINED, PENDING, and QUOTE. How would I calculate the sum total of OPTIONS divided by total SOLD?

Anyone know how to calculate an average by choosing a number in a field coresponding to the month of the year? I have an average for year-to-date, but as soon as I add in a month, it'll list all averages for each month, and not the year-to-date. HELP!! This is the only thing holding me up on...

I have a table name PHONE MONITOR joined to a table called MONTH. I have a query returning the average of PHONE MONITOR. How would I do a create a query that calculates the year-to-date average of PHONE MONITOR. I know how to do it in excel, but can't figure it out in Access 2k. If I were...