MS Access 2003 Data Field Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table which stores my companys Software Register Information and
have only one problem which I cant seem to get to work, and this is making
the Software ID Number field have a specific format.
All Softwares have a ID of the followinf format: "S###"
that is the letter S in capital and 3 digits.
eg. S001, S002, S003.... S398, etc.
I would like this to come up automatically in the Softare ID field on the
Data Access Page which I have created.
Can anyone help me???
 
Persian said:
I have a table which stores my companys Software Register Information and
have only one problem which I cant seem to get to work, and this is making
the Software ID Number field have a specific format.
All Softwares have a ID of the followinf format: "S###"
that is the letter S in capital and 3 digits.
eg. S001, S002, S003.... S398, etc.
Click to expand...

Do you mean:

CREATE TABLE Apps (
software_ID CHAR(4),
CONSTRAINT ck__Software_ID__format CHECK (
Software_ID LIKE 'S[0-9][0-9][0-9]')
);

You need to use the OLE DB provider e.g. an ADO connection or the
ironically named ANSI mode in Access2003.

Jamie.

--
 
I have no idea what ur on about.
where do i write the code uv supplied?
i have used no code in creating my database!
just want 2 format the field to allow automatic numbersing in the format S###.

onedaywhen said:
Persian said:
I have a table which stores my companys Software Register Information and
have only one problem which I cant seem to get to work, and this is making
the Software ID Number field have a specific format.
All Softwares have a ID of the followinf format: "S###"
that is the letter S in capital and 3 digits.
eg. S001, S002, S003.... S398, etc.
Click to expand...

Do you mean:

CREATE TABLE Apps (
software_ID CHAR(4),
CONSTRAINT ck__Software_ID__format CHECK (
Software_ID LIKE 'S[0-9][0-9][0-9]')
);

You need to use the OLE DB provider e.g. an ADO connection or the
ironically named ANSI mode in Access2003.

Jamie.
Click to expand...
 
Back
Top