I have an application that I am working on and am trying to decide the best way to accomplish this. I have a table of phone numbers (DIDs) that we own. I also...

Hi everyone, I'm interested in hearing the opinions of people who use (or choose not to use) combination keys in their table structure. What do you think...

I thought mde file suppose to reduce size. Why my mde file size is larger mdb? Ashley

Does anyone know of a good source for sample databases? I am looking for an H.R. Skills db.

I need to set up a simple table in which I am keeping track of height and weight out to 2 decimal places. What do I fill in design view after selecting number...

I have a comma delimited file that has 900 fields. I understand that Access has a 250 field limit. Is there a solution for this problem or do I have to look...

Hi, I am wondering about proper or accepted practise for ID'ing records in a relational database. My question is this... If I have a table with a unique...

i have my tables sorted alphabetically, but when i add a new record i have to go and reapply the sort again manually... i want to have the sort apply...

Hi, if you use the date() function as a default value in a table, does it automatically update when you open the table or actually modify a record? Is there a...

I am creating a database for volunteers from all over the World. I want to set up a table to use in a combo box of the standard list of countries you get in...

I have a table with an autonumber that I need to start with the number 20801. Access help says to change the New Values property. I don't see that property...

I have a few simple questions: 1. How can I know the actual size in KBs of each table in my database? 2. Is there a way to force a database attached to a...

I have a table with a hyperlink field. I have set the hyperlink base in the database properties to c:\folder. I want the user to be able to type in the...

I have a two field table, where the first fields allows a user to choose from a drop down box a list of categories (from a table). Based on their choice of...

I am working on a application that has several date fields, some of which are optional. I know that you insert/update date fields enclosing them with #. How...

Hope someone can help.... I was asked to create a contract databse, however, there are over 100 contracts with a minimum of 5 pages, each page containing at...

I tried to locate the "Compact on close" feature. Opened Tools, General tab, Options but I do not have a compact on close feature. Is this only available in...

I recently added a field to an existing table, and shortly began receiving "Field '(fieldName)' cannot be a zero-length string" error messages for various...

Hi, I recently set up a number of databases on a new server in another country. The server (windows 2003 small business server) with windows 2003 loaded, had...

does anyone know how to create a table with a currency field that automatically places the decimal 2 places to the left I would like to be able to enter a...