I have what I believe to be a very simple problem for all of you who know Access better than me. I am using Access 2007 and have a field in my table where an...

Help, I am not much of a programmer, but I have managed to build a fairly good tool. The original code was written in 2003 but upon the conversion to...

I am trying to create a unique PIN for members in a table (not the primary key) that will be 4 digits long, and would like each new entry to be incremental. ...

Ok - from what I understand a "MEMO" field type should allow at least 65k worth of data to be saved in your database table. However, I am manually opening my...

I am building a database catalogue of all our reports and want to include the SQL and VBA used in the reports. I have added a memo field to hold this data...

I am a VERY novice Access user and attempting to build my company's first database. I've created three tables to track our consultants: Consultant Contact...

I need help in creating a solid table structure for tracking vehicle waivers. I posted this before, but I cannot find the related post. I will try to give as...

Hi I am quite new to Access but I am desperate to learn as much as I can as fast as I can. I am currently working on automating an annual leave process at...

I'm just curious if it makes sense to use junction tables in this instance: student - studentID, studentfirst, studentlast, gender, age (adult, teen, or...

I'm looking into correcting a previously developed database that was originally done and works like an excel spreadsheet (all fields are currently in one...

I have 2 tables table "Person" and table "Team" with a 1-M relationship a person can be a member of 0 or 1 team but a team can have from 0 to 5 Persons at the...

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...

I've created database application to be used as EMR (Electronic Medical Records) in Access 2007 (OS- Win XP). The physicians will be using Tablet PC instead...

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 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...

Does anyone know the max records Access can hold before it brings a network to its knees?

When I do a crosstab query, the dates do not come out in ascending date order; for example: 1/12/2004 1/19/2004 1/26/2004 1/5/2004 12/29/2003 The above...

I need some help with table design. Below is the structure of just a few tables from a database. There is a One-To-Many relationship between...

Running Access XP How does one remove a lookup field from a table. I have gone into the relationships area and there are no relationships visible. Go into...

Hi, I have been reading a book that talks about using a many- to-many resolver or junction table but I just don't get it. I have two tables: tblProjects and...