I have 2 tables. One listing residents of a community, the other listing
members of a club.  How can I arrive at a list of community members who are
not members of the club?
Thanks.

Ok, I asked this in the excel group, but realized access would probably be a
better choice. I want to make a simple form that I can enter debits and
credits into and keep a running balance. The simpler the better, since I
will be the one using it and I am completely ignorant of ...

I have a user using MS Access 2002 that whenever they try to "Create table
by using wizard" the areas under Sample Tables and Sample Fields are all
blank.
I checked my computer also using Access 2002 and the Table Wizard has tables

I created a database and splitted so that many users can
use it at the same time. However, sometime I can update
the database at design view or create some new reports
without any warnings. Today when I tried to update a

I know this may be simple, but I'm having a brain-freeze.  I have a combo box
that shows a unique ID and an item description (two different fields) when I
depress the arrow. When I select the appropriate record, only the ID field in
the form is updated; the description field ...

How would I select a listbox row and Delete that row from a list box? (Using
a command button)

1. Do subdatasheets assist in normalization or just make the data harder to
maintain?  
2. In a drawer of 50 files 20 of the files contain other files (subfiles).  
To create a normalized database, would you suggest I create a table for each

I have a table which stored all information.
I accidentally delete all records.
Is there a way that I can get  those records back?
I just hope that I can get them back.

I am trying to get my access to count numbers for me, and I can not get it ti
format what I need I am using a accession number of PM-05-0001 to start can
anyone tell me how I need to set this up to automatically put in my numbers
for me.

I am setting up a sales DB for a company I am working for. they were
orginally using ACT! which i was not to excited about so i want to switch
over to access. what we are trying to do is compose letters/emails to
customers.  IE]

HELP…. I have an Excel workbook that I have moving over to Access 2000. I
have imported my entire workbook with the exception of a scorecard that is
maintained with formulas that are attached to the other sheets in the
workbook.

I posted yesterday with a query about sub forms, but haven't had a response
(probably didn't explain myself very well) but on reflection, I think my
problem starts with my table relationships and I'm stuck on how to resolve it.
I have 3 main tables:

I have read many of the posts in this forum regarding Lookup fields and it
seems like they may not be as good as advertised, but I would like to still
use it if possible. My problem is listed below.
I have a Customer table that includes CustNo and CustName and a second table

Access 2003
When I add a third table to the Query Builder, the query and associated form
won't allow edits, additions or deletions.  Why?  Here's the SQL Statement if
it helps anyone.  Thank you in advance!!