Hi, I created a new field and chose Data type number. It is Field Size Long Integer by default I noticed in table view, having typed 3.05 into it, it became...

I have designed a table. The numeric fields are defined as: fILED TYPE :NUMBER; FIELD SIZE : LONG INTEGER; DECIMAL PLACES:2 The problem, I am facing is,"The...

I am trying to create a database for a book program that I run. I am currently using an excel spreadsheet to track all books in inventory and who they are...

How do I show different pictures in individual Access database records (forms view)?

Hi, Should I make the field called ID in my second table a number or text type of field when that field relates to my first table's primary key field called...

I am working on a table with an autonumber field as primary key, now that is ready I need to set theinitial value of the field to zero, how can I do dat if I...

I have a database that tracks projects. One project may have several appointments related to it. I have a check box to mark a project as being complete. All...

Hi, I'm brand new to MS ACCESS and I am using MS ACCESS 2007. I would like to make a drop down list of different animal species for an animal shelter database....

Hello, I'm new in .Net world and there is so many info that I'm lost. DataSet is creted by Visual Studio 2008 to handle a FireBird database. Where can I...

Hi, I am trying to figure out a process from queries to obtain correct data from a table. For example, I have 3 fields Apple Red Big Apple Green...

Hello, I have desingned our church secretary database and I named it "Hahomion" all resideds in churchdata folder. The original design was in Indonesian,...

My managers keep putting dates in a text field. Is there any way to use validation where they can't put dates in a text field or n/a or some other comment in...

Here's the scenario... I manage the billing for a single client. This client is billed in a number of countries worldwide (30 Countries in total). Billing is...

I want to be able to "lock" a record once it has been created, I am using auto-number as the data type, that will show that the record has been deleted, but...

Hello all, I am needing some suggestions in creating a database to track attendees for two conventions. I need to track the attendees, conact info,...

Hi, I'm new to Access but have been studiously using the help, tutorials, and forums. I seem to have the tables laid out but am now stuck at getting the...

I have an existing table in a .mdb database and I want to add a text column that is not required. I can add the text column but when I tried to set it to...

My problem is that i have to fields in my databse that will hold values like ..240. needs to hold all three decimal places including 0. I can not get the...

I have a circus and need a database to reservation of tickets, can anyone help me to get such a system.

Hi, My office has a staff database consists of 3 tables. tblEmployee, tblEducationAllowance, tblMedicalAllowance. tblEmployee has EmpID, Empname,...