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

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

Hoping this is a simple fix and my initial set up is correct. I have a number of tables in a DB which is tracking particular criminal activity. For the...

Hello, I've had no problems in the past developing databases for my company because I have always been directly involved in what we do and so it has been easy...

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

Is there any way to put this into plain english I am much better at visual instruction, I to am trying to build a training data base that can generate reports...

I have a real Dilbert kind of assignment that I am hoping that someone can give me a hand with. Currently my company uses a spreadsheet to calculate the...

Is there a way to get an append query to take all paste errors encountered during its operation and move them to a table of user(my) specification, rather than...

I am looking to create a web database for my web site. My web host provides My SQL, can I use a Access database to store the data. Where can I find the steps...

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

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

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, Just a new learner about databases. I have created a client database using the contact management template as a starting point. I have placed a...

In our Data Base - automatically between the City and the Province there is a comma - in bulk mailing the Post Office wants us to NOT have the comma - is...

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

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

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

I've entered all my data, but now I want it to be displayed in Forms in order by a specific field. How can I do that?