I have just converted an exsiting database to Access 2007 format. It is split, front end and back end. I have created a new field in a tables database as...

Greeings, I am creating a db to track who serves what function in what Sunday at church. So I think I need 3 tables. 1. people who serve 2. functions they...

I have a db that will eventually be split. tblChild has PK ChildID and is a linked table tblNote has FK ChildID (long). Relationship window will allow me to...

I have a database which stores information about courses. This Course table structure is very simple: CourseID, Description, Title, etc. I need to store...

Dear all, As a relative newbie to the art/science of database design, I was wondering if there was any consensus view on whether it's better to use an...

Hi, how can I get the parameters to print on a report so the reader knows what dates that information covers without having to enter the dates...

I'm anticipating something like this: PERSONS PersonID Person fields... REQUESTS RequestID RequestDescription RequestType

I am using Access 2007. I have a table ACCOUNTS, with fields for account number, account description, and account balance. There are 12 other fields for...

I am building a database of financial deals for companies. I will build a table with company details, including a field called txtcompany and then another...

I want to put one of the field names in my database on two lines. Is this possible? Example: Client Address City Zip ...

I am trying to populate a text box on a bound subdatasheet with the most appropriate value for the user to see.. Based on wether the component has a value...

We have a slit check database that uses some tables from our enterprise resource software to help populate records in the Slitcheck database. We don't want...

Sorry I could not enter a more descriptive title, I am not sure if what I want to do is even possible but I know this is probably the best place to come for...

I have a .mdb on a network drive, L:\Data\data.mdb. This database contains nothing but tables. About 100 of them. I have a .mdb on a local computer...

Hi I've already created a query based on a table and I am at a point where I would like to add two fields together and have the data from that equation...

Hi, I'm kind of new to the forum... I posted several days ago. I'm not sure if older posts are read so I'm posting again and I've been able to figure...

Here’s the scenario. I have four tables, all with client-related data, for instance, first name, last name, phone, address, notes about conversations and...

Hi, I building a database for karate classes and payments. I have these tables: tblStudents - for basic info (name, address etc) tblKarateCls - a lookup...

Hi Guys, Having a little problem with some code. I'm wondering if anyone with a keen eye can point out my error. Private Sub...

I have a table with many existing records, and it uses an autonumber key. I recently added another table for additional information that only applies to...