I have splitted my database into 2 files . one containing tables which is placed in a server and the other containig forms, reports and queries that each...

I am using the Student form for (obviously) a list for students. I had to add check boxes through the design view, but when I click on the check boxes for...

Bit of a "noob" question but here goes.... I am using an unbound form for data entry purposes. I am using an unbound form as I have some VBA code which...

Hello all! I am writing a database for a friend of mine who is a realtor. One of the tabs on her client form is going to contain pictures of the...

I have a large database (approx 900,000 records) with 95 fields. When the database was originally created there was no Header Record, so all the fields are...

Hello, I would like to assign sequencial numbers to invoices (YYYY/sequecial number), where YYYY - year: 2008/1 2008/2 2008/... but when a new year is...

I have a table that has a column related to another column. (It's a linked list.) This relationship is defined explicitly and enforced. I want to enforce the...

I have 3 separate clients for whom I have installed an Access database. The databases have been in use for 5 years in one instance and 3 years for the other...

Hi, I'm trying to create an MS Access database to store bird sightings. I think I've created all the tables that I need, and tried to form the...

I have a report that contains 2 graphs that work off the same query but different fields. Also on the report I have test data information that is pulled from...

Hi I import data tables, that come in through another source (mainframes & Spreadsheets), every week. However the fields names of the tables are all coded...

I have a database where I have customized the user login function. My table (tblEmployees) contains four fields (lngEmpID, strEmpName, strEmpPassword,...

Hi Background I am developing a job file database that, stores all the client data and the job details. Now the job forms the transaction table with other...

I'm trying to understand how to put data into a report. I am looking at the Northwinds Traders sample database, specifically at the "Sales Totals by Amount"...

Windows XP, Access 2000 ======================== Hi, I have a table with a field for firstName and another for lastName. Unfortunately, the suffixes for the...

I have a MAKE TABLE query that updates the information from one database to another. Now I would like to have this table updated automatically. I have linked...

I have a form that lists employee accomplishments. I have to update these all the time. The form has a table in it, and one of the columns in the table is...

I want to develop a TO-DO List that will basically write itself. I need to be able to tell it that if I do TASK A on Day 1, then, I need to do Task B on Day...

Problem In a multi-use database, how do I restrict a user from having access to certain records and allow it for others. The scenario is as follows: The...

Is there a way to get the AutoNumber feature in Access to begin incrementing at a number other than 1? For example, to begin the numbers assigned to a customer...