Search results

Ah, yes, stallyon, now I remember. Search by using the "filter by form icon" is the way to go when looking for a null or not null field, as well as to search for a host of other things. Man that was driving me nuts! Thanks to all who replied.

Not is Null doesn't work either Doesn't somebody know this one. It's got to be an easy one...I pull up a form. I put my cursor is say, the Email field. I want to search for any record that has nothing in the email field, so I click on FIND - What do I type in the search entry field to locate...

Is not null doesn't work Thanks, but 'is not null' does not work. Any other suggestions would be much appreciated.

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

You dah man! Thanx!

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

Not sure what you mean? I opened Word, and in the View Tab under options set it so that the Task Pane is to be open, but that didn't make any difference in keeping the task pane open in Access. Am I supposed to do something else in Word? And do I have to keep Word open when using Access if I...

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

Can't believe it's that complicated... All I want to do is create the same form and table with a different name so my co-manager can enter info in the same design form on his computer (we are NOT networked), but we will have different "named" forms so that when I copy his form to my computer...

Thanks Pat and... That's great Pat you understand why I want to do what I want to do, but we are not on a network. His computer is not networked with mine. So, if he uses the same form as me and adds stuff then when I copy his file to my computer it would overwrite any changes I had made in...

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

Thanks. And I am using AK2.

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

Thanks Now I can stop looking for a way to go longer!

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

Thanks Dave. That worked great!

Thanks Bob. That worked perfectly! You dah man!

Thanks, I'll give that a try. Thanks. I'll give that a try.

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.

One other question SoftBoss 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. Chablups