Access 2007. I've created a database with a number input and I'm getting the following errors. I've formatted a field as Number Field Size: Single Format:...

I am working on a shared split database that has an inventory list with purchase and invoicing tables and forms. The inventory items are entered as a...

Is it possible to change the back ground color of a filed in a table according to its value. I want this to happen when the table is in datasheet view. I...

Hello: I want to tell you about a great site I found. They pay me to read e-mail, visit web sites and much more. It's free to join and easy to sign up! CLICK...

I want to set an auto number field in a table that will contain hundreds of thousands of records. The default structure is Long Integer and won't work. How...

Does any of you programmers know how I can program any of the mouse buttons (double clicking left or right button or even single clicking the roller) to...

I have a database where I have a combobox field that you can pick the raw materials that are used to make up a product..... __ 11111111111 __ ...

Hello all I am creating a table with a lottt of fields. And its giving me the too many fields. I guess I need to design my tables in a better...

I have the following tables (for business loans): Borrowers - Contains info on the borrower, address, financial info, etc. Loan info - contains details on the...

Hi, I am using Access 2003. I need to create a Database that keeps track of events that happen during the day and night. Events can either be Active or...

I've recently installed Office 2003, and added Access 2003, and they run fine, but, when I try to open an Access database I created in Office 97, I get a...

Can someone tell me how I can display the row numbers in a datasheet view when a query is run? I have looked and looked and can not figure out where and how...

I have an old unnormalized Access db. The main table is a flat table with all the fields being used. I would like to revamp this db. I am having trouble...

It it possible to do something like this: Consider these 4 tables from this screen shot. TblCrew TblJobs TblCrewType and a link table between them...

At present I have a membership database with all members held in one table. I have been asked to split this table into two tables - family and individual...

hello, I am having a small problem connecting the dots on the relationships between my tables. Here is what I have so far (1st word is...

I have 2 fields: and I would like to define the Primary Key as a multi-field primary key as the concatenation of + Now, may be null, but will always...

I have a table upon which many queries & forms are based. I keep loosing records, and I suspect this is caused somewhere along the way by VISUAL BASIC CODE...

How do I link a command button to an access report?

i have my tables sorted alphabetically, but when i add a new record i have to go and reapply the sort again manually... i want to have the sort apply...