I have 2 tables in a data base with a relationship defined beteen 2 fields eg: FAMILY ID (AUTONUMBER - PRIMARY) related to FAMILY ID (NUMBER) I have a LOOKup...

Access 2003, need to customize switchboard and sub-switchboards to make more efficient. Need to title each switchboard with title other than the name of the...

Recently the company I work for switched to windows 2003. I currently support 3 Access databases, front end/back end, written in Access 97. I converted the 3...

I'm starting a design separating company and contact info. Please have a look and make suggestion. http://www.collage.co.za/sql/diagram.jpg

Hello Access Users. I've been setting up list boxes for a while now (enough knowledge to be dangerous I guess). Why does my list box selection (once it is...

There doesn't seem to be much information around about Access Pivot Tables, and I don't do much in Excel. MS Help is no help whatsoever. I'm trying to create...

I created a data collection database that has been distributed to remote offices on rented PCs. The PC's have Access 2K. I built and maintain the db on...

I am setting up a new database and am wondering how to sort a lookup list after adding new value. I have a list of job titles, with the primary key as an...

Is there a premade layout for recording my music collection in Access?

I'm trying to populate fields in one table with data from another say I have a table with employees in as follows employeeID(primary key) name charge...

How to restrict a date from being entered Example: start date/ end date

Is it possible to define the default value for the field in the table design to be the value of the field from another table. (Dynamicaly defined default...

Over the last couple of weeks Outlook Express seems to lose my primary e-mail account password and I have set it up each time. It remembers the password until...

Unless i enter my password, every stinking time. I did the regedit patch and that has not worked. This is killing me. Do I need to go an use a third...

I'm currently building a db for my company that produces a 2 reports. Report #1- company's we like. Report #2- company's we don't like. These reports need to...

hello as suggested by Jeff Boyce I had redesigned by Access database to remove redundancies to make it a normalized one. The tables have all the required...

How can I have the value of a field depend upon which table the value of another field can be found in? e.g. Table 1: Table 2 has a, b, c, Table 3 has c,...

Hi there, I'm trying to put a field for an elapsed time into a table, for track cycling results. I need to keep times in an hh:mm:ss.000 format, or at...

I am about to deploy an Access application packaged with developer tools. The question has arisen "Can I use this on a LAN for access by multiple users? I...