How do I set up a field to enter a percentage (example 25) and have it stored in the table as .25? Everything I try (setting format int eh table with...

The first box in my form, I have combo box for user to select his/her name then fill in the remain of the fields. How do I freeze all other fields in the form...

Hi, I want to use the same form to Add new data and to display results from a query. The two buttons themselves are on different forms. The query displays all...

I am working with Access 97 and have a form with a ComboBox (cboFirst), a TabControl and a ComboBox (cboSecond) on the first tab. I also have a "Sentinel...

I am having a problem where I have a main form with buttons on it to link to other forms. In 2003, the links work, but in 2000/xp, they do not. I have tried...

I have two tables, Student_Info and Reading. Student_Info is my main table. Both tables have correlating forms. My goal is to enter information on...

How to create a select query with two tables (one to many relationship) that the query can give the number of record (group by count) from a field at the one...

Hello all, I have a form field that performs a calculation based on two other fields in the form. How can I get that result to show up back in the table upon...

Using Access2000. My form is based on a query that combines 2 tables (Availables and Master UPC file). I'm in the grocery business so I use UPC numbers broken...

Here is what I have and what I am trying to accomplish: I create orders for clients on a daily basis, but only invoice the clients once a month. So what I...

Does anyone know how to change the color of the scroll bars in an individual form? I can change the background color in the properties tab but the scroll bar...

I have a drop down list on my form that includes operatorid,lastname and first name. I would like to have the drop down list be sorted by last name even...

I have a bound control field (FIELD1) and an unbound control field (FIELD2)on the same form. I want the user to be able to put a value in the unbound field...

How do I use a textbox on a form with a DLookUp() function to display data from a table?

I have a control source =& to display/print a single bar code for a purchase order and line item. I have a form linked to a query to lookup the purchase order...

Where is the quickest way to find a forms name. I've looked in the form's properties and find the name of the record source and the caption, but don't see the...

Has anyone had a problem with text box's on tab forms. I have added a tab form with several tabs. I inserted a couple of Text Boxes and then decided to copy...

I am using an unbound form (frmSpecify) to specify report (rptTraining) criteria. Among its controls are text boxes for Start Date (txtStartDate) and End Date...

I have created a drop down list that displays the last and first name a two different fields. when i select the name I would like it only stores and displays...

I have a form where a value can be entered into text box. I obtained an if statement from this newsgroup that prevented a value being entered if it was a...