Hi - I want to establish a car registry with just enough exceptions to create problems. The VIN field can be "unique" -- almost. VINs are generally 1 to 4...

Hi, In my database, I've programmed an alpha macro for a client directory by last name. And I have a macro attached that will pull up a message box when no...

in table creation how can I format a field to allow ALPHA characters only. No numeric Thank you

Question: How can I program Access 2000 to sequentially create the scheme for each new record: A001, A002, A003, ...A999, B001, B002, ....B999, C001, C002 and...

Hi Background I am developing a job file database that, stores all the client data and the job details. Now the job forms the transaction table with other...

I have a field that consists of an alphanumeric string that serves as a barcode. It's Input Mask looks like this 00"-V"0\T0\R0\-099\-0. A barcode will...

I would like to alter a table at run time. I had planned on getting information from the user and then by using the Alter Table SQL statement to add a column...

I tried to add an AutoNumber column using a Macro, but it did not work. The SQL I used was: ALTER TABLE 12 ADD COLUMN ID AutoNumber Can anybody please help...

I need to set the Allow Zero Length property of a column to true programmatically. Is there a way to use an ALTER TABLE query to modify an existing...

hi i'm using ado in a vbscript (wsh/.vbs) to apply changes to user's local mdbs. lots of "create table..." and "alter table..." commands are read from a...

Anyone know of an online list that has all the possible syntax for the Alter Table command? I need to know how to make a field a text, numeric, currency,...

HI there, I need to be able to add a new field to my table and change the data types of certain fields by using code. Any Ideas?

I have a field called that has had a validation rule applied via the table-design interface. The rule is "=0 And =1". I now need to change this rule...

No Access 2003, como posso alterar a ligação de uma tabela ligada ao Oracle atravez de ODBC, sendo que atravez de Origem de dados ODBC só posso alterar o...

Hello all. Lately I've been dealing with alot of corruption related problems with my back end so I'm beginning to think of ways to try and improve the...

I posted a database design question earlier, but am having trouble determining what would be the best solution. First of all, thanks to Tim F. for your...

Part of a database I'm working on has three tables: City, State, Country. For cities in the US I want to have a reference from City to State (stateRef in the...

I have a table that lists valid commodity types tTypes Name field I have a table that lists valid manufacturers tMfr Type field (lookup from tTypes) Name...

I'm starting a design separating company and contact info. Please have a look and make suggestion. http://www.collage.co.za/sql/diagram.jpg

Hi My users have a table with many fields and used in a variety of querys reports another user wants most of this data plus wants to add extra fields ..how do...