I have designed a contacts database which contains names of both personal &
business contacts. To avoid data entry errors, I have several tables which
relate to field in my tblContacts:
tblContactType:

A School information database. I have a Table "students" PK StudentID and 4
other secondary tables with "Students" as a child key in each - all linked to
Students 1 - many (CK Students). The first 2 tables work fine but when I
enter the 3rd table, the data i the successful query ...

I have a date such as JAN 1-15 in the middle of a text field and i would lie
to know how to set up the query that would bring out the results based on
this criteria.

I have been trying to experiment with methods from within Access 2007 by
which I can develop a simple search engine (like the type found on the
Internet) from data tables or queries.  So far, I've managed to create
point-and-click forms out of queries.  One problem I've ...

If a query produces 0 entries is there a way to open a specified form
For instance if my queries searches for a client and does not find them it
will force the "enter new client" form to open?

I have two tables [Tbl_Customers] and [Tbl_Orders] these are linked by
[CustID]. When orders are entered into [Tbl_Orders] a [Date of Order] field
is populated with current date.
I am trying to write a query that will show what customers have not placed an

I wasn't able to find anyone with a similar problem to this one - so,
I'm hoping one of you guru's can give me some direction on this.
I have a form that runs off a query and populates a table.  The
purpose of this form is for general data entry.  At the end of the

I am looking to use Access to automate my accounts receibable cash
application, and provide reports of remaing open transaction, Unapplied
payments, and Payments that do not match the transaction amount.  I have
multible charges and payments for a given transaction reference.  I ...

I need to remove characters and spaces from a database field and
replace() is not working for me. I dont know if I am using it
properly. I am putting it in the queries window and it says I cannot
use it without select or update. Can some1 help me on how exactly to

Hi,
I have 2 tables, one it has customers who are past due and another table
that has customers who have paid and not past due after a certain period.
My objective is to find the customers who hasn't paid yet. I did a query,

All,
I am a non-Access programmer drawn into a problem in Access which I
have never seen before.
I have a database that includes the following 2 tables (format is

I have a general question on Access 2003.  I have several applications that
run in the following manner:
Step 1: Make Table queries runs and creates some large tables (extracting
data out of ORACLE, etc.).

I have a VB6 SP2 application that suddenly fails to compile.  I get the
subject error message when attempting to do a Data Control refresh.  I'm
using Access 2003.  Most existing posts address Access 97, 2.0 and/or 4.0.  
I'm at a loss, and at my wits end.  Any help would be ...

I have a an Access 2003 db of 11,000+ records. Each record has a field named
Product Type. The field is now blank and I would like to enter the phrase
audio books into each field. Can I do this with a query? How?

I designed an access report with a facility and a buch of contacts for that.
I created a group on the facility ID. I want only a certain type of contact
to show up in the facility group header and rest of the contact types in the
details sectio.