Hi, this is my scenario: tblClient, tblContract, tblEvent and tblEmployees. Clients have Contract and Contracts have Events. Example1: Client=Weddings.com,...

I want to open a form from another form with a Command button, but I want the record on the form that I open to be a specific record based on the first form....

I have two tables, one is a list of transactions that have taken place over a wide group of offices and the other is a list of offices and the locations them...

I have two fields that need to be concatenated to form a third field which is used as a primary field. The data for the first two fields is typed in on a form,...

I have a database that captures blood levels by date for each patient. I need to do a summary report that will show the total number of blood levels within a...

I am building a form using Tabs for each form of the application. When I add a field that should link to another table( I have a query set up linking them) I...

I want to enter some data in a form, hit the enter key and have the date filled in for the next record and the focus set to the field below the date...

I need to have multiple notes for clients. I have my client table and my notes table. On my client form I have multiple subforms with one of those subforms...

I want to create a document database, a library of documents. In the end, I'd like to be able to search the database for a specific document or words in a...

This appears to be easy for me, but for some reason I can't get my head around it. I have a find button that I would like to give me the results for all...

I have inherited 9 stand alone databases that need to be merged into one package. The problem is the auto number it is the primary key and unique Identifier...

What is maxium # of records per table Access 2000?

I used this program to schedule macros to run overnight. It helped me out a lot, maybe others could have a use for it: http://macros.subpacket.com Regards,

I have a database in Access 2003. I have two linked tables - one with basic information on people, one with information on a particular event. They are...

I have one main table for names, addresses, and other fields. I have three forms - each form for a different category of person with the forms only...

I would like the data in a particular field to be a calculation based on numbers in two other fields, i.e.: Annual Rate = Annual Rate per Square Feet *...

How do I import selected data and selected records from one access database to another access database. The field names are not currently always the same. ...

In a database containing address information, I would like the selection of a particular building to automatically populate the address fields with the...

this is the information i want to store in my tables. i have an assembled product, let's call it a car. The car will have several different assemblies with...

I'm trying to decide on the best way to design a database that will be tha majority of yes / no values for instance i have a multiple jobs for one piece of...