Working on a system that reports customer complaints. In a Excel version there is a report number automatically generated. This number is unique so a primary...

Say my table as Date, Year, Month fields and a user form has a Date Textbox with Cs set to Date in table Is there a way for the table to add the year and...

I have 3 tables named Products, ProcesList and ToolList. The ProcessList uses the Products table to get ProductNo The ProcessList uses the ToolList to get...

Hello, I am new ACCESS user and have some questions. 1. What kinds of joins (eg. next loop join, merge join etc..) Jet Engine provide? and could someone...

Hi there-- I need to store numeric data that should be able to handle up to 12 digits with up to 9 digits behind the decimal point. Thus, Currency is out and...

I need a school calendar 2006-2007. It needs to begin with the month of August and go through June. I would love the months to be on either side in boxes...

i'm trying to set up a database tracking order history and order receipts for inventory items, but i'm not sure what should be in each table, what should be in...

Hi guys, I was wondering if someone could help me a bit here. Im trying to desing an electronic register system for a school. In terms of the table design, I...

I am creating a lookup from a linked table, but the list appears blank even though I believe that I have set the columns correctly. How can I solve this?

want acalendar to use to rotate 3-5 children for assigned chores. have accesss 97 and word 97

Hi I have a lookup field where I want to select any field from another table. currently I can display each field but only select from one. Ultimately what...

My fax wizard has kept all 4000 faxed pages that I have ever received on my pc. It is starting to slow my pc down. How can I get rid of those saved faxes and...

I'm attempting to add a field to my A2007 database that would allow for attachments (primarily word). But when i attempt to add the field, i do not get...

I have a time ago designed a database that has been functioning as expected but all of a sudden values in combo box drop lists have disappeared. Not that...

I have two tables: PRICE_LIST (PK)MetalType SellPrice and CUSTOMER_PRICE_LIST (PK)CustomerID (PK)Date MetalType BuyPrice

Hello, I've been working on this for a while, and can't get it to work. I am using Access and Outlook 2003. The following code give me "Error 3276 Invalid...

Hello, I've been working on this for a while, and can't get it to work. I am using Access and Outlook 2003. The following code give me "Error 3276 Invalid...

Hello, I'm looking for code that will link an Outlook Address Book to my database. I want to use code so that it will check and link to the address book...

Hi there I am trying to design a new database used to track people registering with my company and also different company information. I work for a...

We are wanting to make a database that will store Event Report information on individuals. I need some advice on the best way to set this up. I've already...