At the moment I have simple Access DB with 3 tables Companies, Contacts and Activities. In the Company table we have stored the address...

I have a database which has a list of products and prices in one table. I have another table which is updated each day from a file of new sales. If a new...

I have two versions of the same database. I'd like to be able to compare the table designs in the two databases and have the differences highlighted. Is there...

I have a list of approved appraisers in a table called appraisers and a table called collateral. In the collateral table is a field for appraisers. The two...

I would like to be able to compare data in to databases automatically and get a report stating data diferences. The database has many tables - and I want a...

I am working on an Oil and Gas Access database in which the company Imports MS Excel files that consultants fill in while they are working out in the field. ...

My "imported or linked" database has duplicate rows. The (columns) fields I need to extract only need one row for each entry in the invoice field. Please tell...

My company is an electronic contract manufacturer. Our customers give us parts lists and we build their product for them. I want to build a query that will...

I have to match names from one list to another list that is in Excel format from TSA. I need help on how to set it up, if a program that exists...

I would like to compare 2 Files in Access Database 2000. One File is questions and aswers correct and the other file is a selection of choose the correct...

Hello I just recently took over a database to add some reporting capabilities. As I usually do when adding code, I tried to compile it. I keep getting...

My switchboard on an existing database has suddenly stopped working. Everytime I try to open it I get the following message: "Compile Error: Function or...

I'm using the default value Now() for a Date/Time field in a table. It has been working fine for over a year. All of a sudden I'm getting the above message. ...

HELP! I don't know what happened. I was just doing basic cleanup of forms and reports. Now any event that fires gives me an error - all based on "File...

Hello: We're creating a stand-alone database application in MS Access and do not want users to see the code. How would we compile this file? Thanks! -- KGD

I am new to Access. I have imported an Excel Spreadsheet. It has my Customer information... Customer ID, Customer, Address, City, etc. How do I make it show...

Hi, I would like to set up a custom counter for processes in my facility. I'll list my table structure first, then explain: *ProcessXData* DataID, where I...

I have a very complex database - I'll admit from the get go that I'm probably in over my head. Having said that... hiring a programmer is not really an...

I'm using a database to track patients enrolled in research protocols at our medical center. Any one patient may enroll in several protocols. I have a...

I am designing a new data base that contains issues (to resolve). The table I designed as all the information for the basic issue. What I need to know is how...