Hello, I'd like to add another field to my table and for whole field to have all the same entry, namely the number "1". How can I do this? (I know how to add...

Hi all, Hoping someone can help. I want to setup the following relationship: --Employees, which can be supervisors or non-supervisors, may have one or more...

Hello, I'd like to add another field to my table and for whole field to have all the same entry, namely the number "1". How can I do this? (I know how to add...

I need to know the advantage and disadvantage of split databases especially in multi-user updating, database sharing on file server and data corruption and...

Hi, I am using Access 2000, and had a relationship setup to link 2 tables together. I later decided to change the design and delete the link. The link is not...

Hello, I have three tables, one for customers,one for invoices, and one for adjustment codes.The customers table works well for the one to many(cus)to...

I need to update data in several tables that I have created. Can update one table and have that same data automatically updated in other tables I have created...

Hello. I am using a database to combine two tables. One table contains static background information and the other is a user defined inputs table which may...

I know how to protect my complete database with a password, but, is there any way I can put a password just to open one of my tables? Thanks for your help

In the table, I set the field required to "Yes". If it leaves blank, the standard system error message popup. How could I replace the system error message with...

this is a test

I have a table of past jobs my company has worked on. A feidl in this table is "client name". I have a switchboard setup with some reports on it. One of...

Hi, I have a database that is shared by multi users. Is there any way that I can format the inputting of data so that it is uniformed i.e. All words start...

Hi Guys, can anyone help? Is there an access equivalent to SQL's truncate table command? I need to very quickly delete all records from a table but keep the...

Table1 has two fields that I want to link to the primary field in Table2. My goal is to create a query that lists data from different rows in Table2 for every...

I need to know the advantage and disadvantage of split databases especially in multi-user updating, database sharing on file server and data corruption and...

How would one make a expression that can perform two different addition operations to fill a field depending on the value of a number found in an earlier...

Hi, i am using access and i want to rank my table by group of product tblProd and i want a,... a,1 b,... ...

I've been asked to fix a database. I'm not an expert but I do have enough experience to know what's wrong. Currently this db has 3 tables tbl 1 - Names, main...

"How do I show leading zeros in a number field" I have a database that will generate a fixed length text file. in the number field, I must fill all 9 spaces...