Hi I have created a database in Access 2007 which will be placed on a server. At the moment, the database will have 10 users at a single time. Is it...

I have 2 tables, one containing information about the staff of an office (names, address, tel, etc.), and the other one containing their salary history...

Access Novice - WinXp/Access 2003. I am a self taught access newbie. I have spent almost a year browsing these newsgroups as a daily ritual. Although these...

When in Table Design please add a way to alphabetize the fieldname list. It's very tedious to manually move the fields up /down one by one to sort the...

I have several many-to-many junction tables. I'll name three: PeopletoCountries, PeopletoTopics, PeopletoInfotypes. My ultimate goal is to show the mapping...

I have a large table (32 fields, 500 000 records). I am trying to "clean-up" the data and want to change one field from text to number. I keep getting...

Sorry for the previous post - it had two post mixed up... I have a database on Projects. I have PROJECTS that can have many participants, and PERSONS that...

Am new at Access. Been studying books on Access 2007 and tables I've created are not efficient. Have feeling am going about it the wrong way. Currently...

Hi, I have a database for my publishing company. We publish monthly magazines, 12 separate titles. Currently my database stores the number of issues for an...

I've searched through these forums and read alot of discussions regarding not using a lookup in a table. Instead, one should put that information in another...

We have been using a product called Access Autopilot for the past year, but have been having some problems for several months. We have not been able to get a...

I've got a fairly simple db with only 4 tables. Only two are linked by a field called E58# with a one to many relationship. In the "many" table I want to...

in the "Sales contact management database" template that is offered at the MS download site is a text box labled notes. It allows for an unlimited amount of...

When I set up my Customer database 3 yrs ago the record number corresponded to the Customer ID which was set to autonumber. At some point and I am not sure...

I've created a database, split it into front & back ends, and put copies of my front end on other user's machines. These users have been given...

Hi, Can someone please explain how to set the value at which an autonumber will start? I have two different tables and in one table I want the primary key...

Ok..I've taken three classes on Access now and not one has addressed those lovely pop up switchboards. I would LOVE to know how to make one..any help out...

I am pulling information from a linked table SQL Database into access 97. This table will be continually changing. How do I select a record and add it to...

Hi, i'm not too familar with Access so please help me out here i have table 1 with Customer ID + address1 where table 2 with Customer ID + address2 what i...

Hi, For educational purpose, does anyone have some links to sites where I can get a functional Access database on an Accounting system (inventory...