Hio I am trying to create a lookup on a number field (Indexed Duplicates OK) but when I select the Lookup Wizard, i am getting an error message telling...

My database is separated into FE and BE. All tables are in the BE. I had been assuming that the relationships were stored with the tables in the BE, but I...

Hi, I am attempting to create a table with the Client ID field based on the last 4 digits of SSN, 2 digit date and auto number. The table has the...

Hi, all, I am creating a db for a school basketball league. I want to track team stats per game, students stats per game, and games played. I have the...

I posted this problem in the queries newsgroup, but didn't solve the problem there and don't know where else to post this, so I'm trying here. I think my...

I thought I knew about normalization, but I'm baffled. Our Psychology deparment want the Mental Status Exam (MSE) in a dbase. The instrument has normal patient...

Trying to get a normalized structure for Talent Management company We are TALENT MANAGERS that represent TALENT (actors, singers, dancers, models, writers,...

For the last couple of weeks I have been trying to design a website and it is proving to be a bit more challenging than I thought. I thought I had managed it...

Design question: When is it necessary to create a compound primary key in a child table? For example. I am working on a database that records information about...

I'm new & just started to learn Access so please, use English in the answer. I created your regular db, Name, Address, Address2, city, state, zipcode. I used...

I have a split database (Front & Back) - for some reason access cant link to the back end tables using a relative path (even tho the front and back are in the...

A General question during development process - could the re-ordering of tables, for instance, if I sort a table on a particular field then save it- cause data...

I have a form from which I open all the reports of my datebase, but on my reports, I have activated the On No Data event. This event works well whenever I...

I have an access database that I use for tracking complaints. It was designed by an IT person who is no longer on staff here and we currently do not...

Hi all, I'm starting a new thread because i did not get response for my latest posting in the other thread (Confusing relationships), so i started a...

I have a database that handles purchase orders. All the forms etc work exactly as designed, and the data is pretty well normalised. However, usability is a bit...

I have just recently re-designed a Database that I inherited. The old had Major problems, one table, 500 Fields. It was too confusing, for me anyway, to fix. I...

I am making a horse show database. Setting up one to many relationships between the tables. The problem is that when I try to add records in data sheet view...

i want caluculate difference between two dates if it is more than 24 hrs it is become zero later hours are displaying in caluculation in access table or in...

I have 6 Access databases and 2 Excel workbooks. Each of these databases/workbooks contain customer data. Most of the customers have a customer number (some...