Hello, I have created a database including all students who have applied for admissions at my school. I have included 4 fields that give the student a "score"...

Hi, I have 2 Access 2003 databases will call A (client) and B (physician). Each of these have 2 main tables, Table A and Table B. I have linked the...

I'm working on a db of our companys Items. So far I have; tbl Items - ItemID (pk), Item Name, Item Sales Price, etc tblVendor - VendorID (pk), Vend Name,...

Is is correct that subdatasheets don't work when the tables are attached? When I open the backend mdb that has the tables, it works (works = the...

I am designing a database to track revenue generated at various sites from various programs. I have the following tables: Sites, VPs, Programs, Revenue...

I'm trying to setup a database of our company items. Some items have more than one vendor. I'm not sure how to link more than one vendor to an item I...

I have a lookup field in my table looking up values from another table. It works in the table, it works in the query but in the form it only shows up as a...

I have this message when I try to update information in forms based on queries that have been created from two or three tables. I have checked Help and...

Okay i'm looking to create a database for deliveries. I want the deliveies to go by projects. I am learning and i was hoping for some feed back. I created a...

When sharing databases on a network with multiple table links to other databases on the network, I frequently get "read-only" when I open my primary working...

Hi all, I'm looking for a (preferably) free download or other option to try and go through and do an S&R throughout an entire database. What I'm doing...

Hi all, I was wondering if there is a maximum number of rows in Access 97? I'm currently parsing a text file and adding the values into a table. The files...

I need to know if I create two fields in a table how I can have them filled out automatically if possible. I want to create an insert date and an update field...

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

I'm trying to store my MIVA products export in Microsoft Access. One of my first challenges is the category codes in MIVA. Each product can have...

Hi, There are several TEMP tables in my Access database that have essentially the same fields, but are used to support different reports. Each table...

First, I don't know if this is possible and second, I don't know if it's best to use Access or Excel. This is what I want to do: I have many instruments that...

I keep getting a "TOO MANY FIELDS DEFINED" message when trying to add a new field to an existing table with 22 fields. This also happens when I try to create...

is is possible to make database window unaccessable to users (except for admin) .so that they can use db thru swithboard.

I would like to use Access to manage my contacts. Access has a very good template for doing that. I then want to export the data to Outlook. The field names...