I have a database with 2 tables, Catagories and Products, I have created a relationship between 2 fields, CatagoryID in the Catagories table and CatagoryID in...

I am trying to track sales for a C-store. There are 12 departments, some are taxable some are not. how can i go about creating a table or two where when pulled...

I have an order entry database that I created. When entering an order I need the unit price of the item to bring up a default value from the products table AND...

Is there any ways of putting a lock on an application access db to lock users after, say 90 days? -- The fun is not in the speed but the sudden stops!!!

Table with just one column which is an autonumber column - how do I insert records? -- Tim Ward Brett Ward Limited - www.brettward.co.uk

Thanks for your assistance Tina. I don't think I explained myself enough. With what I have read about many to many relationships, it stated that you had to...

When using Input Mask on Access 97 does anyone know if you can input your own "Error Message"

Good morning. I am new to Access databases and to date I have done a considerable amount of research and reading but am unable to ensure the steps I am taking...

Hello, I am trying to run a total * count: Totals: (Sum((!*!))) This returns the * to Totals My has the following: Between And I need the total for...

I need to track contracts our company has with other companies. I thought I would create a table that would contain CompanyInfo such as...

Hey Guys, I'm trying to set up a data base for an office file system. We have alot of paper stuff here and we're trying to use access to help us file...

I have a table with an autonumber field. I routinely delete records from this table and add new ones using code. Is there a way to reset the autonumber to...

I know how to make a column prevent duplicate values with an index; however, I have a column where many values are null which is OK, but I can't use an index...

I have what a believe to be a fairly obvious use for access. i.e a company contact list where the user can add some data to each user and company. Basically,...

I am new to Access programming. My problem is I have a combo box that adds a new record to the underlying bound table. When I enter a new record I get "The...

I have a database that has linked tables to another database. I have an absolute path set right now, but will be distrubuting to customers. Can the linked...

I created a bankruptcy data, using Case Number as the Primary Key. I now need to know how to disallow duplicate Case Numbers. The Case Numbers are 8 digits...

I remember from Access 97 that there was a 200,000 row limitation for a Access table. Does any know what the row limitation is for Access XP (2002), or...

When I try to print the relationships in my Access database, I end up with extra lines and box symbols in the upper left corner of the print that don't show on...

Please excuse my poor explanation in advance, I am a self taught Access user with no programming background. I am re-designing tables within my company's...