Hi, I created a database of which I have several individuals use. Currently, I have a form that includes the following fields "Loss$"; "Branch$"; "Advisor $";...

is there a way to use multiple validation rules in table's properties that would return a unique message depending on which rule was violated as data is...

I have a contact database that I need to import data into on a weekly basis. The data is in an Excel file with client and contact information all in one...

I have a clolumn that I want to show a negative number, but Access shows 0.00%. Here is the equation that I'm working from. Unit Price Change = (Proposed...

I have a clolumn that I want to show a negative number, but Access shows 0.00%. Here is the equation that I'm working from. Unit Price Change = (Proposed...

In an Access 2000 database how can you find the size of each table in the database without having to export every table to a new file?

In an Access 2000 database how can you find the size of each table in the database without having to export every table to a new file?

I am in the begining stages of designing a DB which would track the expenses of 40 customers . Each customer has a unique five digit ID and the expenses...

Hi I have a database design with three tables: 1. Student Table 2. Student/Topic table 3. Topic Table The purpose of these tables is to allow students to...

I have a database Access 2000 file format, and stored in a shared folder so several users can access it at the same time. Most of the time it works fine, but...

I have a new database that has tblRentalAgreement, tblCorpBusiness and tblMajesticExpressRenters. All have primary keys that are autonumbers. TblCorpBusiness...

This question must have been asked before, but I cannot see anything of relevence in the present posts so forgive me if I am duplicating an earlier...

I have a back end database that contains a number of tables linked to one by an ID field. The ID field ("MainID") is the primary key in tblMain. The field...

I am trying to set focus to a list box. The listbox is accepting bar code font data. I am trying to only allow parts in the list box when the operator...

Dear All, Newbie Access .mdb I am trying to create a database (Table1) with Access 2003 Professional on my XP PC. The Table1 includes 80 fields and one row....

Hello: I have a simple Access 2000 database with 2 tables; tblSites and tblLandspreading. I need to look up the date a site was last used from the...

Hi all, I need some advice with a database I’m trying to design. Its main purpose is to asset track PC’s and other related items within several different...

Hi, I seem to be having some problems designing these days, mental block or something. I have the following scenario for a small painting/building...

At the moment I have simple Access DB with 3 tables Companies, Contacts and Activities. In the Company table we have stored the address...

Hello , I am trying to build an application where I have a weekly spreadsheet of data that is averaged and sorted prior to me getting it. the data in the...