By default, Access gives a Default Value of 0 to fields with a Number data
type.  I have been removing this value of zero from the Default Value
property of my Number fields, because I've considered it a minor annoyance
of no value.

Looking for possible causes and remedies to a certain type of corruption in an Access 2000 db
It's happened to the same customer 3 times in a year but I've never seen this before and it happens only to this customer
Once damaged, the db can't be opened in Access. AOIndex is missing ...

I have a serial number field that will consist of 8
numbers. Right now, the young serials only consist of 3
numbers but we would like to have the young numbers which
are not yet 8 characters be preceeded by zeros without the

I want to view the records in another(ie. history)
database.
I am doing something like this currently out of my main
database.

I am trying to create a database that would generate a
catelog, complete with pictures. I thought that if I
linked my photograph that my dtabase would not grow too
large, I find I am wrong. I need to be capable of placing

I have successfully completed several smaller databases
that work quite well.  Now I am undertaking the largest
project so far, and I have some design questions before I
have completed the first table.

In an Access table, I can easily designate a field as
unique so that 2 records can not have the same data in
that field. How can I specify that records be unique
based upon 2 fields?

Hi, here is an exemple.
I have a table with 3 column:
1- Manufacturer         2-Product          3-Representant
A manufacturer associate with a product may have many

Hi, this will probably turn out to be a newbie kinda question, but I need to
be able to cut data from one application and then paste this into several
fields on a table.. To show you what I mean, I have an example of the format
of the data......

This I am sure is a newbie question, but one that I am
having a hard time with. I am creating a repairs database
and I have a table for my repair tickets, for my
customers, for my repair locations, and for my parts. The

I'm having trouble with dates/times in my table. I have a
vb.net Date that I'm trying to add to the table. The Date
contains the date and time (timestamp) but when it gets
entered via my windows form, only the date shows up and

I am trying to delete a record from a table.  The record
is  auto-number and indexed with no duplicates
permitted.  When I try to delete the field I get the
following message "the search key was not found in any

I have a field on a table called "Status1" which has a
value of 1, 2 or 3 (the data is supplied as part of an
import from another company - I have no way of changing
what I'm given).

I have 3 tables, all with the same field names.
I need to create a query which,
- Pulls 2 field from table 1, but also adds a new field called "Category",
and populates it with "X"

Sorry about first post...
Tables:
 BusRouteTble     The "One" Table
  Autonumber PK