Is it possible to set up a field that contains a date
range? I do not want two separate fields for start date
and end date. I know I can set it up as text and type
dd/mm/yy - dd/mm/yy.  However I need it to be recognized

I am designing a database to be used to help us emailing
customers. They can sign up to be emailed about specific
products, but I'm not sure how to store the information
about which models each customer wants to be emailed about.

I have a field email with a validation rule: Is Null Or Like "*@*"
How can i expand this rule with the option that no spaces are allowed?
Tried: Is Null Or Like "*@*" Or Not Like " "
But that doesn't work...

Thank you Tim
Your instructions worked perfectly
I wish I knew what I actually did, but
that's not important now.

I am trying to add a field to an Access table through VB.
I need to find out first whether that field exists in that
table or not. and if that field does not exist in the
table then only will I alter the table. I am using this

Hi good day, I would like to find out something. Now, my
employer wants me to create a database to record
information about all the company's vehicles. Like when
was their last tune up and when the insurance is due and

If I go into design view in Access, how can I cut and paste all the
fields/information from Table Design view to Excel or something like that so
I can print it?
I really need to access each table in my DB and it would be great if I could

I also wish to create a Anime Listing System via Access. I
was wondering how to setup the database. So that I can
have the title of an anime series in one field, but have
the alternate names of it be listed in the form using one

Ok, I have it mostly setup in Access 2000. My problem has
to do with listing the episodes I have of a series.
Example, if I have only episodes 1 through 5, 13, and 16
out of a 26 episode series, then how do I set up the

I have searched through Help and several manuals but
cannot determine if it is possible to format the contents
of a column (text field) in an Access table to center
alignment or to wrap the text (as you can do in Excel).

Ias there a maximum number of fields for a table in Access
2000.

I am trying to create a (Access 2000) table
programmatically using VB 6.0 ADO and create table
command. A field with Number data type in the table
defaults to field size double. My problem is I want the

I have created a database with fields as follows:
 Formal Stock Application No Serial Y_Id M_Id Area Type Note Visited
     2321-08-03A 2321 43 08 A Retail RETENTION - RESIDENCE & SHOP
What I wish to do is have the  serial field etc automatically updated from

I have a table that maintains info on equipment.  I would
like to associate a computer brand name with various model
numbers.  For example, Compaq may have Deskpro 4000 and
Deskpro 2000; DELL may have XPST 450 and GX100.

How do I set the starting autonumber to other than 1 ???
Does it matter if the table has already had records added so long as they have been deleted?
i.e. if the table is empty is it possible even though it had had records added then deleted?
I looked in Help but its very vague.