If I use a Dlookup Function to pull the dat from a zip code table that matches the zip code in the query used for a report. Table1 Fields Name, address,...

It is my understanding that surrogate keys are generally recommended to ensure uniqueness of records. Is it not true that using surrogate keys implies...

This is not a drop dead issue, yet is there a way to remove empty input mask entries or old ones that have been created? I've seemed to have collected a few...

I need to set up a billing, payment(which also posts financial charges every 30 days after the first 30) I have the following tables: Billing Table , ,...

When I do a crosstab query, the dates do not come out in ascending date order; for example: 1/12/2004 1/19/2004 1/26/2004 1/5/2004 12/29/2003 The above...

I have updated office to office XP & in the selcetion drop down list of XP of insert object when using Access it no longer offers insert "Image Object" which...

MS Access 2K, Windows XP ======================== I have a database which is to be used by multiple "groups" of users, and each group may have different...

I am using Access 97 with a major query/report/macro database written by someone 5 years ago that has disappeared from the face of the earth. It...

List Price:$40.00 Image: http://bestdeallocator.info/image.php?id=B000XFBD08 Best price found: http://bestdeallocator.info/index.php?id=B000XFBD08

I am having trouble in getting my head round dates specifically employee holiday dates where an employee has holidays booked for the year which are added to...

I have a database which is a duplicate of another database but with the queries etc. modified. I want to now run the modified queries etc. on the original...

I discovered a problem changing the color of the command buttons because Iam unable to change their colors. When I right click on any button in the database,...

How do I update a table with a calculation performed in a form? I enter the data in the form, have a field for the total, have the correct calculation showing...

Access/VBA newbie here and I have the following situation: A research facility mixes elements(LotID), processes them, evaluates the end product and then uses...

I need assistance designing a database that will allow me to track/edit projects for the states that I support. I work in contruction and review design...

Hi, I'm using Access 2000 on Windows 2000 professional to create a simple reporting application. I split the database so I could put the mde file on a couple...

Hi, If I have a form showing results of a query how can I get them to automatically rerun/refresh the query each time that I open or close the form to give...

How would I get the drop-down to display the recognizable Name and input the corresponding Key? I've got a couple of tables, one for expenses, and one for...

I have a database designed to maintain Firearms Permit information. The main table has information about the applicant and has approximately 70 fields. A...

I want to use data from other tables to form a new table dynamically. Data exists in other tables, but it's not organized the way I need it to generate a...