I have been using access for sometime but never had the need to setup a relationship before and I appear not to be getting it right. I have a Pocket PC with...

Hi, I have been trying to figure out a way to have a sports draft on my web page. I cant seem to wrap my head around how to design the DB (very new...

As a beginner I designed a database that uses bound forms and tables for different parts of a production process. I used a table for good product and another...

Hi All, Just curious... If I change the layout of a linked table (widening columns so that entire contents of fields are shown), is there any effect on...

i have created a table with all the necessary fields which I then created two forms, both including different data, apart from four fields which I want on both...

Access 2003: Ok. I give up. How do I print the object dependencies? A Print just gives me the form I selected. I need a listing of what the form is...

I need to set up 8 fields that use the same info ABCDEF or G, but I need to have it dissallow an already used input. If field1 has a "B" then field2 options...

I have to setup a database of all employees on my floor (about 100 people). This tasks list will be for all new employees and current employees, when a new...

What I want for a Validation Rule is...= And of course, I get the error message..."Invalid SQL syntax - cannot use multiple columns in a column-level CHECK...

I have a table here that will store currency values. I've been reading up on the differences between the datatypes available and there seem to be 2 viable...

My industry require results to be to a preciscion of 6 decimal places. Access handles 1.012345 but returns 1. if there is no moderator ie result is 1.000000...

Hi to all, I work on an insurance project.I have a table, tblPolicies, which has a triple primary key: BranchID, CompanyID, PolicyN. To this table I want to...

hi how i could know teh size of my tables ? also my forms

I'm creating a form and while going and back and forth I can no longer view my form!

Hello All: I know how I have my access application right now that isnt quite right, but it works. But I would like to know the proper way to do this. I have...

There is some information regarding a disease for which the number of cases and case rates are stored for each year and for all the counties in a state. When...

I don't know too much about access but all that I know I am learning from mistakes. I have built a database that will help all administrative types in my...

Does anyone know of an existing template for Access which I can use as a base for a club membership system. The 'Contact Database' template which comes with...

Hi, I'm helping a local county office with a fairly big project. This county office does Assessment, Taxation, Survey, etc. We're just at the beginning stages...