the value you entered isn't valid for this field , i created table when i go
to design view of table i get this message, i have customer name , city  and
state field and Display source is combo box, row source tab/ qry
row source i have query ... SELECT CustomerTbl.CustomerID,

I am designing a database that has many tables.  These tables reference data
across a broad range of interests [eg. videos - location, health - stress,
web sites - reason, etc].
I want to know if I could create a top level DAP that would have buttons on

I have email addresses such as iwasa_ta/p/khi@khi that I would like to send
to. It seems Access doesn't like the underscore ( _ ) in this address. I'd
like to know how to get around this.

I'm trying to build a database on city councillors, wards, and their actions.
I have a table COUNCILORS, a table WARDS, and a table COMMITEES.  I'm trying
to figure out the best way to list the committee members (who are all
councilors).

Hi i have 3 tables with relations...
SELECT dbo_v_Configuration.SEARCH_CODE, dbo_V_SERVICE.NAME
FROM (dbo_V_CONFIGURATION_ITEM_ON_SERVIC INNER JOIN dbo_v_Configuration ON
dbo_V_CONFIGURATION_ITEM_ON_SERVIC.CONFIGURATION_ITEM_SEARCH_CODE =

database needs to record up to 10 rooms, bookers, dates and times.

I've been inherited an Access application to support, and I noticed that lots
of tables have unnecessary indexes. In other words, some indexes have the
Primary property to No, Unique = No, and Ignore Nulls = No. So I ask myself
if all these three properties are No, then why is ...

I have 4 types of users:
1) administrator - full control
2) president - allowed to READ anything
3) sales director - allowed to READ/WRITE/DELETE any record for any of the

I have a table that holds numbers (access codes) for members of a
gated community.  The numbers are limited to 4 digits and I've
selected some of them for codes.  I would like to be able to create a
report that lists all possible numbers plus the ones I've selected

I want to create a ("status") field in my contracts tracking table to tell
me the status of the contract based on whether or not some other fields in
the table (yes/no) are checked (yes).  Basically, I want to create code
where an inspection of the other fields is made in order.  ...

In table design view for a text field I am aware that by using the '>' or
'<' I can make the text appear either in Upper case or Lower case.  However
is there a way to make the text appear as Initial Capitals as in:
10 Live Here Avenue

I need to design a database that I can keep the stats for my son and
daughters basketball games.  I was wondering if anyone already has anything
like this that they could share or suggest how I would go about design one
myself.  It doesn't have to be to fancy.  It just needs to ...

I have 2 tables. Peoplesoft_data which contains employee info and GC which
contains course info. The primary key in both of these tables is the
employeeID. I need to relate these 2 tables as a one-to-many, with the GC
table on the many side. What is the easiest way to do this?

I would like a field in a table to be recorded as a julian date for the date
entered.
So whether I enter a date from 2003 or 2007, the field would record the date
as

I'm in trouble with three of my tables.
1) tblCommunities (CommunityID is the PK)
2) tblModels (ModelID is the PK and CommunityID is the FK)
3) tblSalesLeads (LeadID is the PK and CommunityID is the FK)