Search results

Awesome! Just what I needed. Thanks again.

What date do I put in the form field?

Thanks Pat. Exactly what I needed. Don't really need this part answered, but it'll save me a step: How would I adjust my queries so that I just enter [policynumber] once to pull up the 2 separate reports?

blahblah was actually in another post I made, and that one was answered. What I'm trying to do here is I have an application with about 20 yes/no checkboxes in a form. The report I print is based on the query that feeds both the form and the report. But instead of printing a checkbox on the...

How would I do this in a report? In the form I just use a checkbox, but when I print the report I want it to fill black in a textbox.

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

Thanks to both of you. Rich's suggestion was a little easier on my puny brain to figure out, but it works like a charm!

MattS, you are the man! Never even thought to look for that option. Thanks a million!

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

That makes sense (didn't even think of that). Now how do I write the expression? I'm still not sure how to specify values in a field.

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

How could you tweak this to use a text box instead of a combo box? I want the user to be able to type in an account number, and if the account number is not entered, then an add account dialog would open.

Thanks!

That's what I tought, but for some reason, my memo field is being treated as a text field. Thanks though. I have no idea why. Data type says MEMO. Any ideas? BTW: How do you add a space in vb? The code is: Me.COMMENTS = Me.COMMENTS & vbCrLf & Now() & Me.NewComments & vbCrLf It...

Thanks! Got it to work. Now about the 2nd part of the question: what kind of trick could I use to make my memo longer than 256 characters? I'm trying to create a event log for sales people who need to document who called in and the topics discussed.

I'm not very good with vb. I got the button to work, but I can't get the memo to keep the old info. It keeps replacing memo with the new info. I used the code above as a on click event for the button. What do I need to do to fix this? Also, how do I get rid of the 256 character limit on memo?

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?

I have a similar question about 2 companies, but both companies are part of the same table. I have another table called OPTIONS that has SOLD, DECLINE, REJECT, etc. as options but they are all under one column. How would I get the numbers of SOLD policies for 1 company in a report? I have a...