We will likely be using Access 2007 ... We currently have Access 2000.
I am having a problem thinking though how to set up the tables in order
to get my design going in a reasonable direction.  Although the numbers
may change a bit;

When using a lookup field, which gathers its data from another table, is
there a way to create criteria breakdown without doing a query.  
For example.  I have a large rolodex table with hundreds of addresses
(tblRoladex).  In one field, I have Address Type i.e. Home, Business.   ...

I wrote in Dec. 07 regarding a consultant with suspect programming skills
(majority of programming done with macros and multiple examples of empty code)
.  I appreciate all the feedback.  The consensus was that he was lacking some
skills (one even said to "fire his *ss").  Problem ...

Ok, I am designing a database using access 2007. First of all i am trying to
make a table that tallys all Users points from an "Events" table. I am unsure
how to go about this. First of i have a "Users" table, which has 2 fields,
UserID (Primary Key) and Username, a "Events" ...

This is probably a simple question for most of you, but I really appreciate
the help!
I have a table named "Issues" with a primary key of "IssuesID" (autonumber)
what I created a form based off this table.  

I have a table with a field "Question". I want to use this table to create
anothertable "Survey" and the fields in the new table must be the questions
in the "Questions" table. Then I want to create a form from the  "Survey"
table and give scores to the questions.

I have three tables: Customers, Products and CustomerProducts. For
simplicity, the Customers table has two fields: CustID and CustName. The
Products table has three fields: ProdID, ProdName and ProdPrice. The
CustomerProducts table has three fields: CustID, ProdID and ...

I have copied an application to a different location on my HDD in and
attempt to modify and and test changes without affecting my original
application.  Unfortunately the copied application still looks for the
tables, queries, etc. in their original location.  Is the ...

I have developed a database in 2003 and now I need to install it in a mixed
enviroment some PC have 2003 and some 2007 is there an easy way to make sure
everything works the way it was designed and what is the best way to make the
changes? I intend to have a front end and back end ...

Access 2000
I want to add some columns to a table.
When I try to enter design mode I get a warning message saying I cannot
modify a linked table.

I currently have an application that I developed about 4 years ago using
Access 2000/VB6 on Windows 98.  I now use Windows XP.
I am a beginning programmer.
I have a need to Modify the application to (I think) use subdatasheets.

I currently have a spreadsheet that when I enter data in Excel, am I able to
create a Table where the info in Excel will populate in the Access Table? If
so, how do I go about doing that. I can do it in Excel, but I am trying to
avoid adding all these formulas and locking the ...

I have an Access 2003 mdb that is an FE to a SQL 2005 database. I began
getting ODBC errors and discovered I am unable to simply open linked tables.
The error is odd:
ODBC--call failed.

I am trying to have data entered into an add/edit field carried over to the
next add screen until the data is changed.  Example - If I put "Name" in the
first screen when I enter into a new screen the "Name" still shows in the
field and stays that way for every record until it is ...

I have not designed a database before, I have done queries, forms, reports
etc from db's that have already been set so I am in new territory here.....
I have inherited a database that was set up as a spreadsheet. I need to
break out into tables and know I need to pretty much start ...