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 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...

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...

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 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...

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...

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, 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...

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...

From two tables I run a query which gives me, for example: RecNo Name Add1 Type 1 Joe A Plumber 1 Joe A Plumber 2 Fred...

I have a situation where I added indexes to a table in my sql svr db back end and went into the table design from Access (where they do not allow you to edit...

I have been using DateValues from Excel in one of the fields of my Access db to be able to sort accurately on its matching date. I'm sure the...

Hi, I use Access 2000 to store and report on data extracted from an RMS (Point of Sale and Back Office). To improve the reports I produce I want...

In the section about improving the performance of an Access database, MS Access Help first says: You can make dramatic improvements in the speed of queries by...

Hi, I want to have one of my tables protected so that it's contents cannot be changed. Other tables are to be open as normal. Can anyone point me in the...

Please guide me to where I can find an access template for calculating commissions on sales by sales person. We are planning to integrated to our existing...

I would like to change the position of buttons on the expanded field created by the Zoom() function.

Hi I am currently helping set up a database for a Rare Book Dealer. My first initiative in designing this database is the stock control issue. The Dealer...