I'm supporting a database that is comprised largely of fields and variables with the data type Single. Over the years, the client's needs have changed, so...

I have a subform with fields: First Name, Last Name, Phone, Expiration Date, Membership Status. I want to create a calculated control to display the total...

I've got a database which includes a number of tables, some of which are linked on a primary key. When I first designed it, they didn't have a unique...

I have two tables : Expense Reports , Expense Details just simillar to the tables in the sample db , Expense reports but with more fields I am using db to...

Is there a way to play a Wav sound file when a command button is pressed?

I created an Inventory Control Database using the template in Access 2000. My only problem is that the products table does not meet my needs. I need to...

i had designed a front end for marking attendence by simply clicking comboboxes for 52 students. i require a report in following format and the design of the...

I want to add my own color to Access Palette and set colorindex to this color. Could any one give me anysuggestions of how to do it?

Instead of having to change a cd or game in our consoles in certainly would be a lot better if the console had a six cd changere in it wouldn't it? How great...

I have an employee table which has unique employee ID as primary key. I need deal with another table and infromation using Login ID which the system re use...

I want to build a relationship between a query and a table. MS Access allows me to create a text(4) in the query and an integer field in the table. Does it...

I'll try to lay this out as clearly as I can, but the reason I'm posting this question is because I'm uncertain if this is the 'right' structure so...

I have a form that was designed in a previous version of Access and I need to change properties to one control in that group. The properties box omly shows...

I'm getting weird problems in Office 2003 SP3. The first one is simple to reproduce. 1) Create a new blank database. 2) Add a new table "Table_1" and add a...

Are there any issues in having a date/time field as my primary key? thanks.

I have tables that are deleting "backwards". For example tblA is the parent of tblB and tblB is the parent of tblC. When I delete a record from tblC (through...

I am trying to create a database for entries for a dog show the following is how I have set it up so far TABLE - DOG_DETAILS - Fields - Registered Name,...

I have following tables tblcoursepayment with autonumber invoice number field. tblitemSalesPayment with autonumber invoice number field. how can I generate...

Hello, I am using Access97 and I currently have a db that I use to record the pages I receive from remote sites but I am currently using a combination of...

Time is our most precious asset, we should invest it wisely. http://smallbusinessebooks.googlepages.com/