I am using Access 2002. I am trying to design a table that will store the input, and some output, from a spreadsheet. I have 239 fields. Because newer records...

How do I set up a field as datatype percentage? I.e. to enter percentage increases. I have tried to set it up as "Number" format "percentage" with 1...

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...

Hello, I have 2 tables of our church membership, member table and addrfess table In member table there is a foreign key of address table. When we come to...

The code works (Thanks, Stefan Hoffmann) that checks the employee survey number against the table and allows the survey to activate (or become visible). How...

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...

Is it possible to make a concatenation of a 3rd field from fields 1 and 2 all in the same table? If so, can I make that 3rd field the primary key? -- Dale

Hello, I've had no problems in the past developing databases for my company because I have always been directly involved in what we do and so it has been easy...

I am currently setting up a small application where some of the users will not always have access to the database on the office shared drive. Though not...

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...

Hi All, I am working on a scheduling program. We need to schedule shipments of orders and pull from stock. The orders would be in a FIFO method or First In...

I was wondering if anybody has done this or wanted to do this. I want to relate row headings in table a to Column headings in table b. or put another way I...

Hi Guys, Looking for help with this issue. I have an invoice form with a field and want, on save, to create a sequential number. If user cancels the...

The general situation: the law office that I'm working for is converting their Lotus DB to access. It already has approx. 200k records that are several...

Does anyone know of some one who is able to build database at low cost as i am just starting my own business

I need a database that will show an employees scheduled days (Monday through Friday). I would like to be able to just use a checkbox on a form and check...

I'm using Excel to keep data on students I'm currently describing the state of any particular field as either '*' = student has started this part of their...

I need some guidance in setting up a database to house our employees annual job appraisal review. We currently have a Word doc that all the employees fill...

Im trying to create a database that contains info. about our agents and the company they work for. I created two tables - Agent table and Company table. ...

I have a mdb file made by access 2003. It has five tables having relations between them, 4000 parameter queries, and 100 forms, which are used for parameter...