For those with access to an SQL Server, the query works in SQL Server 2000, 2005, and 2005 EXPRESS and is provided below. For those without SQL Server, I...

Hi I have created a database in Access 2007 which will be placed on a server. At the moment, the database will have 10 users at a single time. Is it...

Hi, I would like to create a 2 drop down menu on my form. Primary Type & Secondary Type. I would like to limit the secondary type to options that are related...

Please see the attachment. How can I create a form like this to store information. Here is what I have done. Created table BUSINESS , which has all the...

Where would I find a simple stock control template -- Thanks Ken

I am starting a new db to track hydraulic fittings and inventory. I want to do it right, from the start by having it normalized, and not quite sure what I am...

Hi, I am on Access 2003 via MS Office Pro - 2003. I am working on a club membership tracking in Access. Originally, the software was built for the...

Hi, thanks in advance for the help. I am trying to design a relatively simple database (or so I think so) in Access 2003. I have to data contained in 2 Excel...

-- We would appreciate your suggestions for a tax database to track preparation and filing of tax returns. The basic account information is downloaded from...

Access 2000 I've been working on a small flashcards database as a learning project. I have the following 2 tables: Side A - Contains the text for side A of...

I distribute my A2K mdb to collegues. At times to implement improvements I have to modify the back end tables, which is a pain in itself to do programatically...

I need to replace a wildcard character ($) in one field with the contents of the ID field in the same record. My database is 3000+ records, so doing this by...

Hi guys. I am building a database for my university and need to keep track of students and tutors who are using the carparks. My tables are as...

Hi, I got some problem, I check a lot of past thread and can find similar question but not exactly the problem that I face. Anybody can tell me how to hide...

I am having troubles with the Linked Table Manager. When I invoke it with the check box to prompt for a new location I get a message indicating I do not have...

I need to update data in several tables that I have created. Can update one table and have that same data automatically updated in other tables I have created...

Hi. I seem to remember seeing something about this in a past post but I cant find it using search. Is it possible to make a copy of the table relationships and...

I have designed a Access 2007 database to be used by multiple users. Some users will need edit/add capability and some will only have view capability. The...

First time I have inherited a db with no documentation and which I am having trouble figuring it out. Which or how is the best way to figure someone else's...

Hi I have got a problem in establishing the relationship between the tables of my database. I am creating a database where to put different...