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...

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

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 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 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...

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...

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...

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 have a split database and need to send to other office to use. In that office, they do not install link manager so they are unable to change the table path....

I have a list of 1000 discrete passwords (and that list may grow from time to time). I'd like a system where when I click a command button ("Generate...

How do I get the weekday function to return a weekday "label" instead of the number? Thanx, Paul

I have created a lookup colomn in a table that gets it's list from a query that has two colomns. Once I have chosen from the lookup list, only data from one of...

I asked this question a couple of weeks ago but the suggested answer didn't meet the need. I am a newbie at Database design and any help would be...

Hi, i'm not too familar with Access so please help me out here i have table 1 with Customer ID + address1 where table 2 with Customer ID + address2 what i...

I have a table with 3 fields licence number = 6 characters / name of license holder & address off licence holder. The second table are individuals who may...

Hi, In a table I have 1 field(expense_id) which is a auto- number field. I want to create another field using the same value as the (expense_id) BUT...

Please help...this is killing me! Is there any way that I can enter certain information in one table (i.e. account #) and it create a blank record in another...

Scenario: Table 1 UniqueID is created= 2004-01 2004-02 and so on... Table 2 UniqueID is created from unique ID from Table 1 and