Say I have a tables of records that are tests, and each has a sponsor company and a test company. Also, there is another single table with all the companies'...

Using Access 2003. Have a utilty db with a lot of small tables (2 or 3 columns, 10 or 20 rows). Each time I open the table in datasheet view, I'd like it to...

Here is my situation. I already have a database with a list of all the parts our facility manufactures: PartID, PartName, PartNumber, etc. I need to create...

I have a table "Invoices" containing, among other things, the date of the invoice, as type Date I have another table "Customers" containing, among other...

I am using Access 2000. I am having troubles exporting a table. It don't always work? 1. select the table 2. select from the menu bar File then Export 3....

We have an old database where one field has gone missing. If you check under design the field name is listed. But when you open the table the field is...

Is there a way to use the countif function to count cells in a range with 1) a red background and 2) that contain letter "A". Something like the...

I have recently been aproached with questions about Document management / Relational Databases for managing business. I also recently attended a presentation...

I'm setting up an Access DB (v2003) for use as the backend of a web application. As the db grows I see the potential of upsizing the db to SQL Server. So I'm...

The form is opened with a macro to open it to a new record with a autonumber. How can I undo this record if the patient's last and first name has already...

Hi, How would i design my database to work like this: We have 5 functional teams in the database. Four of those team can only have access to their...

Hello all! Newbie to Access 97 here. I'm trying to figure out how to automatically increment a specific alphanumeric so I can have Access 'assign' the...

Hi, is it possible to do self reducing lists in Access ? I have an Excel sheet that can accomplish this automatically because the sheet has...

hi i have three tables: products, categories and subcategories. any product may have many categories and many subcategories. in my products table, for the...

My table is linked to a text file. One of the numbers in that text file has 2 leading zeros. I do not want the leading zeros to be imported into the Table. ...

i want to copy the data contained in a particular cell in other cells in the same column. the problem is that when i try to copy the data by selecting multiple...

I am trying to create a database to show the homework I set for my various classes. I want to be able to enter homework for each class and then see a list of...

Hello, one of our old programers placed an email address some place in our database that is programically inserted into an HTM page. Could...

Hi. I have added a command button to my form which acts as a 'go' button for my calender control. this has stabalised my database and i only have one problem...

I'm creating a database for hiring/recruitment. There will be at least 3 tables in which each candidate will have a record - one for address/phone info, one...