I am using Access 2000 on W2K & XP Home machines.  I am designing a db to
track calls for a volunteer fire department.  I have a table for calls that
keeps track of the date and time of the call and the location of the call.
I have another table that keeps track of the people ...

Does anyone know if there is a table file/database out
there that contains all the cities in canada, that I may
download...
If so please help.

I believe I have experienced this problem before but I'm
not sure.  Isn't there a problem when number data is
inserted into a table like:  01001, 02002 ???  I think the
key is beginning with 0(something)?  Once written to the

I need to know how to add a record inbetween two records
that I already have.  I have been looking in the help, in
books, and on the internet and can't find anything about
that.  If anyone knows how to do this please let me know

I'm pretty sure I have a design problem here but can't
seem to see it (although I'm sure it's right in front of
my face!)...
I have a database that stores library information

The autonumber field in my table is used already as a primary key.
I want to introduce another incrementing field to use as a "sort" field in
my "InvoiceLines" subform so that the lines are always in sequence.
How do I do this in the "InvoiceLines" table?

I have a table in access with a few number fields followed by a memo
field.
Each time i fill in ascending figures like 3 - 4 or 8 - 9 in the
number fields, the memofield is filled in automatically by access with

I am creating a table, which includes a field titled
Problems.  This field needs to handle multiple entries,
e.g.,  1. Called vendor 01/02/03
      2. Called vendor 01/03/03

I am trying to use the template for Order Entry supplied, but when I try to complete the first customer order, I get a pop-up box telling me that a required record is required in the Orders table.
Is there a very quick and easy fix for this slip up?

I have a table with an 'attainment' column and
a 'numerical value' column. When an attainment value of
say 'P1' is entered I want the 'numerical value' column
to return a value based on another table

I have a database we have used for 3 years--all of a
sudden it will not assign a new number.  It is pulling an
old one and then indicates it is a duplicate value.  I
have it maked as Yes (no duplicates) with long integer.  

My database has many parent/child records of part
components and ratios that I need to string together for
reports and queries. This concatenation process is proving
to be a performance issue. I've been thinking about adding

My database is organized by data area, e.g., client
financials, client demographics, client employment info,
etc., so that client updates across all forms is an
arduous process.  (The client must be culled then updated

I have a copy of access 2000. I have format a data base for some customers. I have enter enought field to start entering names in the data base. I would like to be able to continue work on the format of the data base while somebody enters the names. I am new at this. Can someone ...

I am setting up a simple "cash register" program using
Access.  I am not well schooled in Basic but know my way
around macros okay.
First I have tables which contain the items and thier