I've got a couple of append queries where both tables have the same fields...,except one of the tables has them in a different order than the other. Being...

I have read many threads about this error message and I completely understand that it means one person is updating the record while someone else is trying to...

I am trying to create a database that will store calculations temporarily until I buy that item, which then record all figures. I don't know if this is the...

I have a table tbl_Structures. In Design View, I have added field descriptions to all my fields. For example, the field txt_PartNum has a description Part...

Hi guys and gals Just wondering. From a storage perspective, if I have a field that has the data type Text with a size of 50, does Access actually allocate...

We have converted our database to Access 2007 and I'm noticing 2 "features" that do not work like they used to. Feature #1: When designing a query and I...

I have created a nice little database that reflects a floor plan and has a button to provide info about each computer. I am want to further enhance this by...

I'm relatively new to this game and I have a question. I am trying to create a calander that will come up automatically when the database is opened which...

I am looking for basic DB to be able to track open positions with relative data for recruiting

Hi, in a ac2003DB occurs next problem. On a head-sub form and when they do delete a record in the subform the primary key suddenly will be removed of the...

So, I have been reading that it is impossible to create a "revision history" table for a set of records that use multi-valued fields. But I am a believer in...

Hi, I am trying to develop a small database within which I have two fields: called 'Drop off time' and 'pick up time', these are used to calculate a feild...

Every month I get a Zipfile with over 300,000 records in it, which I go get and put into an Access database. Everything works great except the date. There is...

I have a table built with names, control no. and notes. I do not want to duplicate the names, control no. and notes in that table. I have another table...

Wondering if there's any way I can use the "Wrap Text" feature just like in excel for the Memo field in Access form? I have an "Employee List" form with one...

I am designing a Components database to analyse forecast costings of parts based on quotes. I have two tables that appear to have a Many-to-Many...

I need to make a database for a Career Day coming up soon at my school. There will be 300-350 students making 5 choices of 20 different presentations. However,...

Dear friends, I am in the process of developing a database for a dancing school, in which many students will be recorded and each student will have to pay...

Hello: I have created an employee table with a primary key: employee_number. I also have two fields: Last_name and First_name. How can I avoid allowing people...

I am using an Access database to fill in and print claim forms. The claim form itself is embedded as a bitmap to the background of the report. This has made...