the ingredients of my situation consist in three tables a) Audit Reports (parent): PK = "IRB Number" b) Evaluations: PK = "IRB Number" and "Date of...

I am trying to create a database that will allow users to login and go right to a form customized for them. They should only be able to modify data on their...

I am setting up a table that includes the field "First Name" and "Familiar First Name" I want the default for the second field to be the first since in most...

hi, I have a question that I hope one of you with more exensive knowledge on db design can shed some light on. I'm working on a db in access '02 that stores...

In Access, can you set a field that will flash or blink if certain parameters are met, for example, the number entered is less than 10?

I have a database that is designed for multiple persons to enter information in via a form. The initial record is to record the purchase order...

This may be more suitable for the new users section since I'm a new user, but it's about design, so I'll try here first. I've got a monster spreadsheet I'd...

-- KarenLouise

I AN DOING A DONKEY DERBY FOR CHARITY AND NEED TO MAKE A PROGRAMME FOR THE RACE BUT DONT KNOW HOW TO CAN YOU HELP THANKS

Hello, I'm new at database design and I'm trying to make my first real program. Administration /reservation of numberplates to be used in car garage now the...

I have a table TBL_Tech that has its PK as the TechID. This is the FK for two other tables. I just found out that after a tech is terminated, the supervisor...

Hello, I have a table populated by an append query. The append query appends those records from the source table whose 'model-Nr' field has changed. I want...

Hi, i have a table where passwords are kept and i need a vaidation rule that means the password must have at least one letter and one number. Also woud it be...

I want to have a table with imperial heights stored (eg 5'10") but when I create my inpout mask with 9'##" ( 9"' "##"") it just displays as 5'10. Is there any...

Hi: I have "inherited" a database that has the main table maxed at 256 field defined. Any suggestions on how to clean this mess up easily? Thanks Sandy K

Access XP - I am trying to change the data format in a table from Yes/No to text. Whenever I attempt to save the changes I receive an error code...

I have value to add two values from two tables and publish results to a third table. ie: (v1 in table A) + (v2 in table B) = (v3 in table C) Is there a...

1. I have a one-to-many relationship. But everytime i go back to the relationship window Access automatically creates another relationship using the same table...

Im looking for the Input mask that allows for dates in 2000. Thanks