When I create a subform, it is "pasted" on top of the related form. Is there a way to only view selected subform(s) by way of a button control and then toggle...

I have a database that tracks our student's performance... they sit at a machine where they first create their student record by entering their ID number and...

Is there a way to limit the number of digits entered in a long integer type field? I would like to limit this value to 7 digits. Russ

I am writing this because I had a different post in another newsgroup and they recommended that I change my design. The way I have it set up is I've got a...

I have a database that I use to track my hiking activities. In this database I have a master list of all trails such as: ABC Trail DEF Trail HIJ Trail Now...

Selling 12GBs library of logos, graphics, web templates, scripts, softwares on 2 DVDs for $16.99. Email me at for free samples....

I am having trouble with a many to many issue. We are a Yacht charter business and each charter order can have many products associated. Each product may...

Greetings to all of you who read this thread. I am about to plan and design a database but I would like to know how I can set the price for it. I do not know...

i have been working in an NGOs so i need how to used in Ms Access the Data Field according 2 my Desires when i design the table so i need a date Field one of...

okay, i'm good to go, then. thanks again! :) Just remember to breath deeply... ;-) -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security:...

Eight Tables suddenly appeared on my Database Table listing: MSysAccessObjects MSysAccessXML MSysACEs MSysIMEXColumns MsysIMECSpecs MSys....etc, etc From...

If I wanted to "copy a Import/Export Specifiction Specs that I created in one database to another, how would I do this. My current Spec have over 100 columns...

I would like to see a template in ACCESS for a creating Glossary/Dictionary. ---------------- This post is a suggestion for Microsoft, and Microsoft responds...

I work for a small newly established company and am setting up a database in Access on Office 2000 Premium to store client information and account information....

I am trying to update a system by issuing an UPDATE and then an ALTER statement. I suppose this normally should work no problem; however, inside of a...

Can someone help as ive been thinking of a way to design a part of my database and can not decide if it will work. What i want is a record of different...

I'm trying to put in an if/then statement for the C/O line of my address datebase because not all the records have a C/O. This is what I'm entering in the...

How do I establish a foreign key constraint? " wrote: Allen Browne wrote: The 3rd table will contain fields: ...

Just noticed that none of the Relationship connecting lines in the Relationship design window have any marks on them indicating 1 to many even though the...

I am using the can shrink... is there any other recommendation? "Rick B" wrote: Use CAN SHRINK to make it take up no space when empty. -- Rick B