Hi, I have an input mask on a text field in an access 2000 table, which is very simple LL\ 00\ LLL (Three groups of characters, 1st letters, 2nd numbers,...

I have a simple test design with two tables, each with PK, and one has a FK. I am trying to create a relationship from the PK of one table to the FK of...

In an access db is it possible to add vba code to provide customized validation rules on a field ? For instance, say I I have an email field in a record, and...

I get the message that there are too many fields - while I have many fields what is the upper limit for a single databse as it's not clear how many you can...

When I delete customer info from a linked table, the customer info is removed from the other tables in the database. I need to be able to delete old customer...

Here is a picture of my current relationships: http://img140.imageshack.us/img140/7793/relationships.jpg Hi all, I have just joined the community and I have...

I'm trying to create a Main Menu Database Selection page, when the database is opened by a user, that will allow my users to select certain forms, data entry,...

It's time I re-worked the Parts/Ordering/Book-In tables, as I've outgrown my original, I'm interested to hear opinions on how the table structures should be...

Hi Phil, you will need to create 2 queries to resolve the outer join of the link table(Attendee), the first query should...

Hi all, Is there a definitive view on whether to allow null's in foreign keys, or whether it is better to have a bogus entry in the parent table to...

Hello, Is there a 'best practice' when it comes to creating forms based on many different tables? Generally I try to use as few subforms as possible, using...

Hi, I'm trying to figure a way of having a single stock table that can handle items that are bought and sold in multiples (eg. Spark Plugs bought by the...

I want to design a table to store data on labtest aquisitions, to print out labels later. It will be a list with 100 different tests, every test with its own...

I am building a database of financial deals for companies. I will build a table with company details, including a field called txtcompany and then another...

Someone has asked me to create a database and include what they call a "push" function that will automatically create an email to warn that a contract renewal...

For a Health Club membership system, I have been tasked with designing a Parent and Dependants (Family Members) table so we can track what Members are...

I am new to Access. I entered product information to the "Products Table" how do I link the information to the "Inventory Transaction Table"?

I recently got the suggestion to create a Contacts table which would have ALL names & addresses in it - whether it's our employee, our vendor, or our client....

I've taken the strong advise of many in this forum to create a single table for my business Contacts - whether they be vendors, customers, employees,...

I have been fooling around with Access on and off for a couple of years -- mostly simple applications with only a few tables and simple relationships. I know...