I have a user using MS Access 2002 that whenever they try to "Create table by using wizard" the areas under Sample Tables and Sample Fields are all blank. I...

I am having an MS Access database and when I try to open it I get the error: Microsoft Jet database engine stopped the process because you and another user are...

Why round(1.125,2) gives 1.12 on Access Functions and 1.13 on Xls functions?

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

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

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

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

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

Hi, 1. Background: I have a member database for a local community club. I’m in the process of adding membership renewal processing to the module. ...

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

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

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