There are some 800+ cities/towns/placenames in NC
and exactly 100 counties. I would like to have tblCities
and tblCounties set up so that a city whose geographic
boundaries extend say into 3 different counties can be

I've read a number of posts over the years that dealt with
the issue of database bloat. I'm wondering if anyone has
determined exactly what information comprises the bloat
when it does occur. Has anyone ever looked into that

I am new to Ms Access and I want to use the Date and Time picker on a
form. One of my computers allows it but the control does not appear in
the list of ActiveX Control in the second computer. when I try to open
a database file that already contains that Control, its opens without

i have an access MDB linked by ODBC to SQL2k.
I get a strange behaviour when i do an INSERT INTO to a local Mdb table
from  "LEFT OUTER JOINED" SQL tables.
If the related table hasn't related record to the first table,

Dear reader,
By working with a frond-end and back-end databases with the use of linked
tables the performance, if both mdb's are on a local drive is reasonable.
But in case the backend is located on a network drive the performance is

I want to produce age profile information from a group of club members
with recorded dates of birth.
I can create a selct query to count the number of members between 20
and 30 years of age (for example) OK.

I have a combobox on a form that contains titles of categories, one
of which is to be assigned to a record.
I'd like to show users some notes on each category to aid in the
selection decision, but I can't find a way to determine which row

How would I go about creating a formula to fill in the unknown values??
Is this possible using VB for Access.
100000 = 850
75000 = ???

I'm creating a report that tracks calls.  Each call has a date when the call
was received.  I want to create a report that groups and totals all records
in a given month, however I don't want the individual dates for calls to
show up.  What I want to do is basically create a ...

I haven't run into this exact scenario before. I imagine
there's a simpler approach to extracting the email addr
than in other situations I've faced.
Consider a table of records consisting of a single text

NB:!!!!Please note that our ticketing system does not process
attachments.  Please
include all portions of your complaint/report as plain text within the
body of

I'm currently presenting certain dates as YYYY/MM because Day=01 is understood.
YYYY-MM, however, looks cleaner to my eye.
But I can't get it to work with both .Format and .InputMask.  They seem to
conflict when it's time to save the field's value and an "Illegal format"

A couple of years ago I got a nice mde-database for access 97, and I
want to use it again. But I found out I cannot convert the mde-file to
access2000.
I don't have the mdb-file, since it was distributed by a company (which

I have a table with sporting events and the scores per event for each
member. Each member partakes in at least 6 events per year.
Question 1, how can I find and sum the three higest scores per member for a
year and get a total. (this total will determine the ranking of the member

Having nothing better to do today, I decided to do something that apparently
only Michael Kaplan knows how to do (and cannot disclose due to legal
reasons).
My method is really nothing more than a stupid cheat, embedding the whole