I am somewhat new to access and am restructuring a database as par t of a summer internship. The database is for fundraising and is designed to provide a list...

I originally created a table with LookUp tables/fields. I have queries and forms based on this table. Now I have seen the light and need to get rid of the...

In my DB i currently have a junction table: ModelsXREFSuppliers. It has FKs to the Models table (Model_ID), SupplyParts table (SupplyPart_ID), and the...

To all you access Gurus I have been asked to look at setting up and access database to do the following To keep a record of pupils and 9 tasks the pupils...

I am trying to use the DLookup function in Access 2003 to get a form to return a set of possible test results based on the name of the test entered in the...

Hi, I am designing a split database. How should I design the database so that when I add a new record it is not saved until the user clicks a save button. I...

Hello! I am trying to build a fairly simple form for a project I am working on. Have only intermediate Access knowledge. The form that I am building is...

Hi Everyone: I have a split database. I added a new table, but I cannot link the table to the front end. Is there a method to follow? I did try to re-link...

I have taken over a database with a Memo field in it. About one-fourth of the records have data in the Memo field. All of the field lengths are less than...

Is it safe to use the same object in two different places? For example can I use the same subform to display the same records on two different main forms,...

Just a thought. If 2GB is the "upper limit " for Access db, it would appear that this is beacuse at this size , there would be millions of records that may...

I have realized from reading through many posts and tutorials on normalization that I need at least one more table in my database for it to be normalized. The...

I have an Access Database that runs on XP (Access 2002). There are multiple queries that pull multiple job codes. In other words each query has multiple job...

I have an access 2000 database which is getting corrupted more often than I would expect, and only on one table, all other tables never get corrupted. The...

I am working on modifications to an inefficiently designed Approved Vendor database. The vendors have certificates have expiration dates. Some vendors have...

I have a database that has thousands of records. In my main table I have a primary key named "Social Security." I was asked if I could change that name to...

I have a field in an purchase order database that I am trying to create in which I would like to be able select multiple records from another table into that...

Hello! I'd like to calculate the average of three or more fields using the AVG function. Ideally the AVG function should be able to figure out what number...

My son is a football coach. I'm trying to set up a DB that he can use to look at a variety of values related to a player in a variety of different ways. ...

I'm creating a database basically for large amouts of text information. I'm breaking this information into 4 different variable categories, such that the...