hi, looking for some help, long and winded sorry. Have a database at present which has table 1 in it and need to add another table say table 2 which will hold...

Suppose I create two tables to store information. I want to desing a form where I can have the fields of both tables. I want to know how to access the fields...

I'm faced with a unique problem. many-to-many self join I have a list of drawings. some drawings include subdrawings and those subdrawings can have more...

I am working on a fossil database in Access 97 and an stumped on how to build a conditional relationship. I have 3 main tables (age, specimen, and fossil)...

I want to format a field in a table to take either dates or text. Now if I format it for "short date" it won't let me type in text ie: N/A or not needed. ...

I am trying to create a query to run two tables; sinle relationship of transaction date but one table may have multiple entries of a transaction while the...

This may take a little to explain, but I hope I can get you to understand my setup. I have a sub form which shows a list of records assigned to a user. This...

Hi When I change something i a form (design view) ,the program stops responding for while. Not used network connection are disconnected.

I was trying to update field size in table design. I get a message saying 'You can't change the data type or field, it is part of one or more relationships....

I have tried numerous ways of setting up this subform and each one has presented with shortcomings. Maybe someone has a suggestion of a better way of...

I calculated downtime using a query and now I need to change negative numbers (not downtime) to zeros. Please let me know how I can do that. Thank you

I have added the 2002 Template Wizard to Excel and I'm creating records in an excel database but I can't create records in an Access database. The...

Hi I want to add an Autonumber field to a table and its form. I want the format of it to be six digits no matter what the number (ie - 000001,000002). Is this...

I have a table called Servers with a Primary key of Server_ID; a table called Modems with a primary key of Modem_ID, and a table called Server_HDD with...

I am trying to build a table and one of the fields requires the user to make more than one selection from a drop down menu or in a list. I know it is easy to...

Any suggestions (including "out-of-the-box" solutions) can you recommend for creating a web based time recording tool that is not based on calendar days (ie...

I have been assigned a task to create a database and need some advice on the correct design. I am not new to Access, but nowhere near an advanced user. The...

I am setting up a database of customers and I want to assign each customer a unique password. Can Access automatically generate this for me. I want...

Im designing a database application that will be built using a SQL Server backend but I couldnt see a managed newsgroup for sql server table design so, as Im...

I have a new CD changer that holds 300 CDs, and I want to organize my CDs so that I can play any CD whenever I want without having to scroll through the whole...