Dear Fye, I posted this question somtime ago and the below was your answer, I tried today to add it in different places and in different format but it...

need your help please first I will till you what is my work. I am working in a govermental office I recieve and account patients treatment invoices from varios...

Create Your FREE Niche Search Engine For Earning Affiliate Program Commissions. http://Findality.com/tissa.htm

Hi everybody, I'm trying to design a table for my invertebrate data. I have many samples and over 70 taxa identified. However, most of these taxa are rare...

I have created a database for a homeowners association where the owners each own a share in the corporation. Whenever there is a change in ownership, title,...

For anyone interested I found the answer I was looking for When I start my program I "Hook" the Access Application Handle 'Hook the Access application so we...

Hi When I change something i a form (design view) ,the program stops responding for while. Not used network connection are disconnected.

Hi Everyone Somebody suggested that I could use update query to add all values from one field to another one. I want to add autonumber values to a numeric...

I have just started using access 2007. I used 2000 in the past. I need help with handling auto numbers. In my 2000 data base I had a Serial Number field that...

I have a excel spreadsheet at work for shipments comming in to the country for us, and then delivered by a transport company to a said power station. Among...

Hello all, I created a database on a corporate server with 20 users, 4 tables, 30 forms (that contains simple code) and 20 queries. Size prior to split is 14...

I want to format a field in a table to take either dates or text. Now if I format it for "short date" it won't let me type in text ie: N/A or not needed. ...

I am working on a fossil database in Access 97 and an stumped on how to build a conditional relationship. I have 3 main tables (age, specimen, and fossil)...

I am trying to setup a small DB to keep track of staff performance and quota management in various projects I supervise. This link is to a screenshot from...

I have a table that consists of the following fields name, number, effect date, term date, date posted1, item1, debit1, credit1...date posted13, item13,...

Hi, I have a field in a table where users enter the time a task took. This is entered in minutes, such as 90 minutes (1hr 30mins) The field is currently a...

There doesn't seem to be much information around about Access Pivot Tables, and I don't do much in Excel. MS Help is no help whatsoever. I'm trying to create...

I was trying to update field size in table design. I get a message saying 'You can't change the data type or field, it is part of one or more relationships....

Hi I want to add an Autonumber field to a table and its form. I want the format of it to be six digits no matter what the number (ie - 000001,000002). Is this...

How do I prevent rounding up or down. I'm using 2000 and regardless of what type number I select, the result is rounding up or down. I want to be able to...