I would like to see diferent ways to track student attendance data. I currently have students in a three level class that attends three times a week for 30...

I created several switchboards in Access 97, moved the application to Access 2003. I made changes in the switchboards using Access 2003 Switchboard Manager,...

Hello all, I've got a table which shows Account, WeekEndDate and Volume and it shows data from the last 52 weeks. What I'd like to be able to do is create a...

Hi Guys, I am having to add a number of new tables I have created to a current system and have wonder if anyone has a quick method of being able to add...

I want to have a validation rule that enforces the use of "@" for the "email" field of a table. How is the validaton rule created? I am not very proficient...

I have a database that has a table that includes a "Spec#" field and a "superseded spec#" field. The superseded spec# field says is the spec that replaces...

I NEED YOUR HELP I create employee table : Employee Name Address in Table. item table : Item No Item Name in Table pay table : Employee Name Address...

Is it possible to lock a record from being modified after information has been entered? My employer wants to make sure that after a record is entered and a...

I've tried all templates. I simply want to place a company header. All the templates I've tried enable to write company name. When I try to go to the next...

Arvin Meyer has one available for download at http://www.datastrat.com/DataStrat2.html. -- Duane Hookom MS Access MVP "...

I have a table with multiple fields i.e. Hourly Rate, Personnel Trained, and Hours Trained. I have an additional field were I want to save the dollar...

I am part owner of pet store and I want to build a database. The problem is I don't know where to begin. This is what we are trying to track: We are trying to...

Hi, I'm having a little problem with making forms. The situation: I'm making a database for someone who is giving courses (design, etc). There are 4...

I desperately need help in setting up a database to track test scores for students. I don't want to bore you with details, but should probably give you some...

I need to create a data base of phone numbers so that when I run another list of numbers, the new list will not contain any duplicates from the master list.

I am creating a database which tracks Newspaper subscribers, carriers and areas delivered. I have 3 tables: Subscriber Data, Carriers & Areas. The Carrier...

I am new to this group and a relative newcomer to Access. I've been using a rather cumbersome Access database for the past 2 years to schedule our 580+...

Thank you for all of the help provided. I have a data base that has a log number. The number consist of yy-xxxx (y = two digit year and x = case number i.e....

I would like to alter a table at run time. I had planned on getting information from the user and then by using the Alter Table SQL statement to add a column...

I am working with a full version of Microsoft Office 2003 and have interests in MS Access. Currently, I am trying to use the Microsoft Common Dialog Control,...