i see...but how i can make a query , filtering all records with no data criteria in a field...i want to be able to find all records in which no values have...

I have a form with a sub form set up. My form has information on an individual My sub form has information about each time that individual is searched. The...

Hi i get the first bit of coding in and it opens report - but it doesnt show the record that im on - its showing all 200 of them. Would there be another way...

I had read someplace that a table name can be change in the relationship window if the table is an alias. I have tried to "right click" the table, which is...

Good Day. I seem to have a wee small problem with an Access database I have created. The problem is what I would refer to as the 3 foot error (back of chair...

Exactly as I stated in my last post. When you are building a query and want to return the records where a particular field has nothing in it, put IS Null in...

I can't seem to find Access as part of the Microsoft Office suite. What package should I be buying to get Access onto my new PC?

thanks!!! "Klatuu" wrote: Exactly as I stated in my last post. When you are building a query and want to return the records where a particular field...

The lowest level would be Office Professional. You can, however, purchase a stand alone copy of Access. "Lizziepuff" wrote: I can't seem to find Access as...

i need to run a DOS ECHO command to LPT1 in WXP. can VBA do this? if yes, syntax please. tia, mcnewsxp

If its failing to find the Combo20, Could it be the Me.Combo? Could you help/write the code differently? Would it help to change to a numeric field? I have all...

A multi select list box behave a little differently from other controls in that it does not, on its own, return a value, regardless of whether anything is...

Hello I have created an access database which contains a form. Part of the form has three boxes that I want to contain dates. The first date that I will...

Do a little testing, first. Open the form in form view. Open the VBA editor and type in: ?Forms!FormName!Combo20 And see what happens. "georgiaboy" wrote: ...

Probably another cockpit error. But when I input ?Forms!FormName!Combo20 The compiler changes it to Print... "Klatuu" wrote: Do a little testing, first. ...

Use the immediate window. "georgiaboy" wrote: Probably another cockpit error. But when I input ?Forms!FormName!Combo20 The compiler changes it to...

It makes perfect sense! Go into design view in your form. Check the names of the boxes for the handover date and snagging date. (Right click the box, choose...

This shouldn't be this difficult, but I can't make it work. Thanks "Klatuu" wrote: Use the immediate window. "georgiaboy" wrote:

You are correct. It should not be this hard. It is a very common thing to do. There has to be something going on we are not seeing. "georgiaboy" wrote: ...

How embarassing. I set the Combo Box wrong in the Wizard. I had selected check bos one instead of: Find a record on my form based on the value I selected from...