Is there any way to specify field defaults in SQL Create table? E.G. with
CREATE TABLE [MYTABLE] (MYFIELD DECIMAL(20,2))
how do I specify the field MYFIELD to have a default value of 100.75?

I am setting up a DB and it uses auto numbering for the first field.  I would
like to add a DB record between existing records. When I click on "add new
record" it automatically sends me to the end of the list of records.  How do
I insert a record between 2 existing autonumbering ...

We have a n ODBC link towards an SQL server application.
In a table there are notes stored.
If we want to retreive them via the ODBC link with data type "memo" we also
get all the information regarding the lay-out, lettertype,color, tabs etc.  

How do I add field to a back-end table that already has existing data in it?  
Basically I am trying to add another field to make the record inacvtive so
that you will not have to see it anymore.

I want to link tables from a second database file that will always reside in
the same folder as the first. Both files may be moved to another folder on
occasion, or the folder structure may change, over which I have no control.
Why can't I simply use the current folder notation (i.e ...

How do I set up a form that automatically fills certain fields once one piece
of related information is inputted? An example would be from a table with an
ID number and first name and last name fields, I want to fill a form for
another table and expect to just type in the id ...

hi, i work at a retail store that has mail order, i would like to be able set
up the database to retract a recurring customer's info such as the address
and credit card info...how can i do this?

I need to keep old employee's name on reports, but I would like to reuse the
employee number. I orginaly had the empID unique, but I just created a
uniqueID for emlpoyee records.  I know I should have done that in the first
place!  How would I emplement this to a back end db that ...

Hi Folks - Here's my problem. I have a table with a phone number field. Data
entry for this field was not controlled or validated. I have manually
'cleaned up' the mess. Now, I want to create an input mask that stores the
literal values. I know how to create an input nask that ...

BlankI have "compact on close" general option set for both my front and
back-end dbs.
I do a lot of table add, delete, change activity, from the front-end, on the
back-end db.

I have three fields say A,B,C in a table Table1....and I need the to set the
default value of the field C as the sum of the other two fields.
           A: [B]+[C] ???..(If u think this is right... well think again)
Any help would be greatly appreciated. :)

I have a back-end with three tables. Two tables are
children to the third table - i.e. they are linked with
referential integrity.
Data is inserted in the front-end through VBA. First a

Access 2003
Can I restrict the output of a NAME field to print only the FIRST LETTER,
i.e., the INITIAL?  Or do I have to create a separate Initial field?

Hi all.  I have a combo box populated by tblPropMaster that writes to
tblInvoiceHdr.  I can pull down the combo box and see the choices but cannot
select any.  It just beeps and does nothing.  Any ideas?
TIA

Hi all.  Thanks in advance.
Ive been putting together this database for the office.  Luckily I've had
time to experiment with quite a few suggestions and they work well.  Now Its
come down to decision time.  Here's my dilema.