Hello, I have been reading about normalizing but still find myself a bit stumped when it comes to my own real-life needs. I got some great help here and am...

I am trying to design a database that keeps track of the salary of my people in my department. Because their hourly pay change when they reach their...

I have a number field on a form that I would like to count up to 20 from one for each entry. This is probalby something easy, but is avoiding me at the...

I have a very complex set of forms, tables, etc. Is this the best way to handle this? This is how I have it setup. You can see a screen shot here, as a...

Can we get the attendance record for 2006-2007 set up The one for 2005-2006 really works well. thanks ---------------- This post is a suggestion for...

Again, my small backpackers hostel located in Panama is keeping my wheels spinning. Now I am beginning to wonder. Is it so bad to have duplicates in my...

From the tool menu, I click start up and uncheck all check boxes. Now,in my database only have file, edit, insert, records,window, help. How to recover the...

Rather than have a lot of fields, many of which can be null, I'm wondering if you could just do a many-to-many relationship. tbl_Work WorkID (PK)...

Through a growing awareness of needs of the Deaf Culture, the sign for "I love you" has almost become a universal icon. I am very surprised that you do not...

I am a semi-frequent MS Access user that sticks to the basics, however I need to find out how I can store multiple checkbox values on a form into 1...

I have a table with audit steps to be performed. The primary key in this table is the audit step reference “G01�, “G02�, etc. The first table...

Paolo wrote: field 3 through 12 are the parsed remains of field 1 turned into integers(if field 1 is 13.254.12, then field 3 is 13, field 4 is 254, field...

You do not want to delete objects from MSysObjects! Fortunately, MS denies you permission to do that. If you are attempting to programmatically delete all...

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

Using Access 2000 with a beginner’s knowledge of VBA I am trying to set up a database to track scores for a Horseshoe League. (Scoring is very similar to a...

I am trying to design a calendar where if someone is not available it blacks that date and time. Please help

I would like help to set up a general absence log of teaching and non teaching staff at a school. A form needs to be set up where one can enter daily a...

I am trying to design a database that keeps track of where our customers fields are. We are trying to do this in a StateCountyTownship fashion. How can I...

I have created forms and report that adds up prices of parts as SUBTOTAL then I have another text box with the formula of =Nz()*.049 for the current tax rate...

Dear All This is not strictly a tables/ db design question, but I have friends and experts I trust here! I have a table of subscriptions paid to a...