I am Trying to Use a calendar as a control to search for data. I have a form limited to a list of non duplicating dates from 2003 through 2010. The Date sets...

I have tried in vain and am running out of patience and time. Please assist. I have many tables (too many). Main tables are -- customers orders order...

Hi I'm building a database, maximum number of records will only ever be approx 500. Each record has initially about 15 fields associated with it, the...

2 tables Table 1 : tblContact (name address phone contactType) Table 2 : tblContactType How do I create a form to enter new contact records, and update...

Hello All. I have not attempted to use an option group before, so please bare with me. I have an archive table, which contains 5 different types of archives,...

Hi, I have a table for maintaining record of forms coming in from consultants. The form needs to go through a series of inspections and may be rejected...

I want to attach Date Control with ComboBox, I m u using Access 2003

i have created a switchboard in my database but now i can't see it. I looked under forms and all other but it's not there. when i open the switchboard manager...

I have an order details form that contains: CLing ProductID (look up description of product and populate the following fields) Product Code (this is pulling...

Hey My knowledge of access is 1 day old please excuse this question if it seems common sense. I have a form with combo box saying "person" then I have a...

Hi, I have created a form from a select query and it won't let me write directly into the text boxes to update the tables linked to the query. How can I make...

I don’t have much experience working with unbound forms. My job is to convert the exiting database with unbound forms that was created long time ago to bound...

I have a table with three different transaction types. It's Primary key is "WBS". The source table for main form has the same primary key and is set as a...

I've a form bound to a table with a number of fields. A text box calculates a value and shows it on the form. However, i need to record this calculated value...

I keep getting the message You can't assign a value to this object with the options The object may be a control on a read-only form or The object may be on a...

Some forms are not displaying in a db I set up, but haven't seen for a while. It is used by the office I built it for. When I last saw them, the db...

Hi- I have a form w/ a phone number field. In the table the number is formated as ########## I would like it to look like (###)###-#### on the form....

Apparently, I have missed something in splitting my database. Database setup is as follows: User-Level Security has been implemented. Users are not given...

Does anyone know of a way to change the color of only a few items from a list within a dropdown menu box (so they stand out from the others when the dropdown...

Form created with wizard in Access '02 comes up with a blank as record 1. It will insert records into related tables but will not show records once closed &...