I have a client/case database with multiple tables and several users. When a user modifies any field in a client or case record, I'd like to record...

Hi, I am using Access 2002 and I am trying to put accounts numbers in a field call account number, the only problem I have is that I am unable to put 017108,...

Hello, I am doing a project for my company..i have some problem in designing the database... The structure looks like this... Activity Table has columns...

This question has come up once or twice in the newsgroups recently. I've read those posts without coming down strongly on either side, but now I'm faced with a...

Hi I would like to create a custom data type (or whatever the terminology is) when I am designing my fields within design view. Can I create a data type using...

I have two tables which are joined by a common field. In the parent table, this key field is an autonumber field. I would like to write some code which takes...

I followed the instructions he http://support.microsoft.com/?kbid=304932....almost. Instead of linking the tables first, I imported the queries, forms, etc...

I am setting up a database for employee training records and need some advice about relationships. How should I set up the relationships? Our training records...

Access 2000 - When you activate the Input mask wizard there is a button in the lower left corner (Edit List) that allows you to add or edit items in the Input...

Hi - I am having troubles figuring this out, although I'm sure I'm just not thinking this completely through... I'm building a job tracking db, and for each...

Hello, I'm trying to put together a database that hosts the answers to questions posed to students. I have all the students in one table, all the questions...

I have imported ASCII data into an Access table. All of the fields show a 255 size. None of the data being imported is larger than 50 in field size. For...

I have been working with a front-end / back-end configured database for a while and it works great. I have been creating the queries in the front-end but now...

I will try to simplify the problem. I have two tables called samples and Isolates, and would like to store pictures for both. I can join these each with the...

I am having a dilemma with a Hotel Booking Project which is a small part of a larger project. If someone can help me with this, or refer me to a sample DB it...

I need a way to prevent gaps caused by data entry errors. Example: I have a control on my form where a contract number is entered. The same contract number...

Are subdatasheets indicative of working relationships and if so, are they really important? All of my tables have subdatasheets (just for my own info so I...

Question: Is there a way to define a different default switchboard depending on which user is logged in? Our company has multiple departments, and we want...

Hi, I am creating a database for quotation purposes. The functionality of the database is to input part number and quantity and get the price of the part...

Hi NG, I'm revisiting one of my applications and was wondering whether I could/should normalize table that stores configuration data. I have over 20 different...