I put this question out to another group but got no responses. Thought I would try here. In Access 97 I can edit an existing file import specification and...

Hi all! Quick (and prolly simple) question.... I have a drop menu running off a simple query. All I want to do is add another option within the drop menu...

Tables --------------- tblItems: itemId (PK), & other item fields tblVendors: vndId (PK), & other vendor fields tblVitem: vitemId (PK), vitemReference (FK to...

A database template to keep tract of paper documents stored in archive boxes at various physical locations in a building.

I have a table of past jobs my company has worked on. A feidl in this table is "client name". I have a switchboard setup with some reports on it. One of...

Hi Experts: I'm trying to create a lookup table from the below text file, here is some data: ID Field2 Field3 Field4 2122 TOTAL...

I am currently in the process of trying to create an Access Database Application. The database will be located on a local network and multiple laptops. In...

I have a table that has 10 characters in a "part" field. There could only be 7 or 6 (variable) characters that are actual, usable data. I have a form where a...

I need a database that will show an employees scheduled days (Monday through Friday). I would like to be able to just use a checkbox on a form and check...

I have set up a DB for our Transport Managment Dept. Containing a main table holding our trucks details (Vehicle Details). I have created a Servicing,...

Being a newbie to access, I have been given a task of creating a db for the patient management and tracking. This DB will have around 50 patients per year....

HELp save the remainder of the hair I have not yet pulled out.! My question is I have a form that has freight and material, and a field for total, when I use...

I have started a new post after posting in my old one. I'm not sure this the right way to do this as the old post has worked its way down the list and have...

Hi, I'm in the process of designing a database for certain geographical areas. This is will be one of the first databases I create. I've identified some...

Hope this is the appropriate group to ask. I have two general questions and one a bit more specific. (a) Are relationships defined in the back end effective...

I work at a place that has An Access Database. There are five departments. Each department is using its own version of the same access database. They use...

I've designed a database for my colleagues to use to log work given to our Admin section. How can I ensure they are not able to alter the design? Basically,...

One of the advices on MVPS.org is not to use lookup fields in tables, their commandment reads: 'thou shalt abhor the use of "Lookup Fields" which art the...

Hello, I'm working on creating a checkbook database for my church. I have the basics set up on it. I created a table of catagories of where money...

Using access 2000 (because that is what client has). I have a table with a large # of fields, 209 at present but it will come down a few when test fields are...