Search results

Thanks Dave. The little check boxes, where the check marks are put, are by default, grayed out. Is there any way to make that default just plain white when there is no check in the box? Thanks, loved your "bumpy road" too.

Is there anyway? I have already created the check boxes in my form in Design View. I did not bind them to anything, because I thought I was saving time by not putting the fields in my table first. In other words, I just clicked on the form in Design View and put in the check boxes. I spent all...

Thanks ShaneMan, but one little problem Thanks for the fast reply Shane - The problem is I have no Control Source in my check box properties because I never had the fields in my Table to start with. I just clicked on the form in Design View and named the labels whatever I wanted. I figured it...

Do check boxes have to be bound to be able to save them in your forms? In other words, when you check the box and click save, does the check box have to be bound so that the check mark can be saved? Thanks.

Thanks for your reply, I'll try to be more specific I am not using any code. It's really very simple what I'm doing. I have a form and there are various documents that have to be checked in on the form, so, I went in to design and then clicked on the tool box. I then clicked on the icon in the...

I just spent all day redesigning a form and putting in check boxes from the tool box, but when I saved the whole thing and tested it by clicking in the check boxes to put the check marks in the boxes and then clicked save, it did not save the check marks! AARGH! When I went back to the form all...

Here's the answer For anyone that's interested, I found the answer myself. Go to Tools menu, click options. Then click Edit/Find. Then under Default find/replace behavior, chose General Search to search all fields and match any part of the field. NOTE: Changes made to this setting don't take...

When in forms view and searching for a record, is there any way to set the default after clicking on FIND, to "Any Part of Field" instead of "Whole Field" Thanks.

I am designing a report. There is about an inch and a half of blank space at the top and bottom of report. Is there a way to cut that down to say a half an inch so I can get more lines per page on the report?

I have a query in which one of the fields is for "Total # of Homes". It is not an expression or a calculation. It is simply the total number of homes taken directly from the table for each record. How do I total all the records and get a grand total for all the records for "Total # of Homes" in...

So you mean I can't get there from here ... I'm sorry, maybe I didn't make myself clear, or maybe I'm just not understanding you... I'm not trying to get a sum of two fields in the same record. What I am trying to do is this: I have let's say twenty records. There is a field in my query which...

I have a query in which I have a calculated field. Lets just say it is [A]+[B]. I want to total all the records for that field, so I click on the total button on the tool bar and I get the Total Cell. So I read help and it tells me that if I have a calcuated field I must click on "expression"...

Did it, but still doesn't work ... help Okay, I did exactly what you said, but it still didn't work. Here is what I put in the new field box: CSng(Format([Your Total Listings 03]/[All Listings 03],"Fixed")) Actually, I put exactly what you said but the "0.00" was apparently changed to the word...

Thanks, but where do I write or put the code you gave me? Sorry, I am new at this ... I don't know what to do with the code you suggest. Where do I put it? What do I do with it? Thanks.

I have made a query and one of the fields is a percentage. The percentage is a result of an expression (the division of a larger number into a smaller number). The problem is I can't get it to sort because, I think, there are too many decimals in the percentages, like each one is...

Won't sort, get overflow message because I have too many decimals for it to sort Yes, I have figured that out and done that, but since the percentage figures are the result of one number being divided into another, the numbers are many decimal places long like .8230840284023840, and then when I...

Geez - One more problem, but I'm almost there with your help Yes, I have figured that out and done that, but since the percentage figures are the result of one number being divided into another, the numbers are many decimal places long like .8230840284023840, and then when I try to sort...

Don't know what you mean Where do I carry out the calculations in the underlying query? I tried to do it under the percentage field under criteria. I right click and use build, but that is not working.

In my report I am trying to arrange percentages in ascending order by using "View" and then "Sorting and Grouping" which works with other fields like last name, date, etc. But the percentage that I am trying to arrange is a calculation - a smaller number divided by a larger number, and it won't...

Thanks Wayne & One more question Thanks Wayne, your answer got me on the right track and I solved my problem. I've got another one though. In my report I am trying to arrange percentages in ascending order by using "View" and then "Sorting and Grouping" which works with other fields like last...