I have one more problem to solve before completing my database.
I need to save address labels to file.  I know Label Wizard does this, but
my problem needs to be selective.  The customers are 'active' or 'not
active' and I need to create separate labels for both.

I thought I entered the following correct, but it doesn't seem to be working.
Can someone tell me if what I'm trying to do is possible.
I have a very simble two field table.  Say one field is words.  When I print
a report of all the words, if one of the words has ever been ...

there is one Tabular Form that shows all my records and another form based
on the same tables but shows only one record at the time.i used the button
wizard to add an open form button to the first (tabular form ) so there is a
connection between them.

I want to be able to click on an Unbound Listbox even if it hasn't any
records in it and return a value to an unbound textbox.  This value has
absolutly nothing to do with the contents of the listbox.  I just need
this value in the unbound textbox to know that this is where the ...

I am working on a database which involves 50+ vehicles, each of which can
carry from a list of 80+ items of equipment, and varying quantities of each
item.  I have in mind a main form which shows the vehicle and driver details,
with a sub form which lists all the items of ...

In one of my tables I have a field that is a Yes/No field, I want to get
Access to take records with a yes in that field and move it to another table.
Or, if that is not possible then atleast not have that record show up on a
report when it is generated.  Thank You for your help ...

I have a simple music dB that contains cd and DVD titles, artist,
recording company and date, all on the main form called Recording, and
the equivalent table.
A sub form and table called Tracks contains the track titles.

I'm very new to Access--self taught using Access Inside Out, Access for
Dummies, and trial and error.  
Just created a simple database (form and table) for interlibrary loans.  My
supervisor would like to see the most recent record when she opens the

The data entry form on a database I am using is showing something I haven't
come across before. The record navigation at the bottom says "1 of 1"
instead of "1 of 4157". I have a feeling that this is may be connected to
the fact that the form opens showing a blank record - is that ...

how ca i set up my own home page

A newbie here - I am putting several input masks into a date/time field in a
table. The mask is the usual: 99\->L<\-00;0;- and I have a couple as:
00\->L<\-00;0;- . I know from reading that 9 signals not a response necessary
and 0 is required response. However, the lead 99 or 00 ...

Ok...
There are lots of threads relating to this... but i cant seem to find
one that points me accurately enough in the right direction... hence my
need for assistance!

I have been reviewing the Northwind sample database application in Access
2003. I have completed my own application like the NW database presents. I
feel that I understand how the examples were coded and created. Microsoft
does not have an assessment or certification for VBA or I ...

I need to run a DlookUp to search for records and then when it finds
them I want to exclude these records from a rowsource.  How would I do this?
I've got this so far
NZ(DLookUp("MenuCatID","MenuInfo",[MenuID]=Forms!MenuMaker!MenuID),0)

Wish to create and print letters and/or labels and/or envelopes in mail merge
using contacts data.  However, cannot get complete info to print -- i.e.,
need full names w/honoraria, titles, company names, etc.  How do we set
defaults to include all fields needed?