Search results

This is driving me nuts. Two questions. #1 - When searching records for a field that is NOT EMPTY, what is the code that you put in when using Find to locate those fields that are NOT EMPTY in forms view? - In other words the field you are seaching for has something in it. I thought you put in...

In the zip code field of my form, if the first number of the zip code is a zero, such as 02436, the zero is deleted as soon as I leave that field. The zero won't stay and I want it to so I will have a valid 5 digit zip code. In other words, as soon as I leave the field the zipcode is changed to...

Is there a way to always keep the task pane open? Right now when I open a file from the list on the task pane displayed under OPEN, the task pane disappears when the file opens. Then when I open the task pane again by clicking on the little white sheet of paper icon at upper left for "new", the...

I have a table and a form that I designed. Now I need to copy all the fields and the design of the form I just created and give it another name so my partner can use the same design and fields, but put in his own information. Is it possible to copy just the design and the fields. If so, how do I...

I designed a query, opened it and printed it. But the margins were too wide and I needed it to print in landscape also. So I changed the settings and it worked fine, but I can't get it to save the settings. Is it possible to save the printer settings for printing a query, both the margin and the...

I am adding fields to my form in Design View and I need to lengthen the page to make more room. Up until now, no problem, but now I am at 22 inches long and it will not expand any farther. I have just been grabbing the little bar at the bottom of page and pulling it longer, but now it has quit...

Where do I go to make the F keys perform a particular function when moving around in a form, like "go the the last page of the form" or move to the top, or to page two etc. Thanks.

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.

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

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

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

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

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

I am designing a report in which I have a column that is for "Total Listings" and this "Total Listings" number is the "Sum" of some other entries in a form. The "total listings" shows up fine in the report for each entry, but when I try to total the "Total Listings" at the bottom of the column I...

On the main access screen, on the right side where you choose what datebase file you want to open, under "Open a file" I am only given one database file to open, and then a yellow folder icon, next to which it says "more files." How can I get the menu to list more than just the one file under...

How do I turn off auto save? I don't want the form to automatically save as I move from form to form. I want to be prompted to push the "save" button. Thanks.

Joe657 I have a data base which has five files within that data base. I want to take one of the files and put it into a separate database with a different name so that I can e-mail it separately from the others. How do I do that? It must be easy but I have spent hours trying to figure it out...

I enter a sale price and then in another field, a percentage commission received. I have another field that automatically calculates the dollars received based on the commission. This calculated amount shows on my form, but not on the table, and therefore it does not show on my reports. Why is...