hello i'm trying to change the colour of background. And i don't know how? I'll happy if you can help me.

I can't explain how my expression worked the first time I opened my form but now keeps displaying error. It's a simple expression =/ Can anyone help me. ...

Hello: Recently I have converted a Access 97 database to an Access 2000 database. I copied a version onto a CD, hence making it read only. The problem I have...

Background: MainDoc table = serial number field only. NameList = SerNum Name Address CompanyList = SerNum Company Address I have to program a way to input...

I have access97, and I like to migrate all the database to access XP. Is there any tools that I can use to make the migration painless. Thank you

In a data entry form, how can I checked if the data in the field already exist in the table. I have a field called Claim Number; if the user enters a Claim...

Is there a way to put a counter on a form that displays a count of the number of subform records associated with the main record?

If anyone out there can help, I would really appreciate it. I have three table. Table 1 consists of input data (1) ProblemID p(k) Table 2 is the join table...

I have a main form that has a subform and the subform has a subform. When a value from a combo box on the first subform is selected, I want the second subform...

I have form that is based on a query. When there are no records, the form does not show any control when it is opened. When there is at least one record the...

Hello, I have put in a control source RiskAssessment the default value of "N" and a Validation Rule "Y" or "N". The trouble is the default value never shows...

I would like to know what code and where I would place it that when a user is filling out a form from the database and does not select the submit button but...

I used the Design Wizard to create a form with textboxes. The textboxes are present in the Design view but not the form view. How do I fix this? TIA infael

On my from i've created a fiel called "Memo. I also set this field property as Memo so that I can type whatever I want on this field. My problem is I can't...

I have a form with a list box that contains three items (LName,FName,PersonID). Using recordset and Bookmark when you click on an item in the list box the...

Is there a way to stop the debug window from opening? A Module?

So- I've had this form for years and it's based on a single table. It's a simple form and a simple table that contains information about our members. table...

In an earlier thread, Ken Snell suggested that the information listed at http://www.mvps.org/access/forms/frm0028.htm might solve my problem with data...

Hi, Does anyone know how to set the Check box or option button's value? In Access database, the default checked value(yes) is -1, and the default unchecked...

I have a fairly complex form based on a query (made from 3 tables) and containing a sub form. The subject of the form is course information and the sub form...