Hello! i want to prevent entry in one field on a form unless another field has been filled in. Could someone please tell me how to do this! Thanks Derek

Conditional formatting doesnt seem to work for a null date. I want a DateCompleted control to turn red if there is a Null date. maybe something like on...

On a continuous form I need to compare two fields in each of the rows and format the font color and/or back color in one of them according to the result for...

Hey guys, I have a field in the subform that I would to change color after validating the item number. I am already using conditional formatting, but the...

I am trying to apply conditional formatting to a combo box for more than 3 conditions. I would like to wrie this in Visual Basic. Can someone help me with...

i have an access2007 report that i am trying to setup conditional formatting where the user sets the "Alert Value" by a single record in a table here is my...

In Access, I'd like to be able hide fields which are not relevant to the current record, as is possible in CSS in internet applications. For example, in a...

I am building a table with several list boxes. When entering a record, I want the user's selection in one list box to effect the choices in another list...

I am creating a data base for a competition and entries need to be pigeon holed into a section and a catagory. The Catagory is dependant on the Section, if in...

Hello, I have a quick (probably EASY) question. If anybody can answer this for me, it would mean the WORLD to me. I have a field in a table "Consent Form...

I have set a validation rules for a table and also for fields. Now I need to set another table validation rule to say: If field1 = “complete�, then...

If table1 has the columns c1, c2, c3 and c4, is there any way to make c1 required, c2 optional, and one of either c3 or c4 required? For example, c1 c2 c3...

Hi all, I am somewhat new in this so any help will be highly appreciated: Problem: I have a large number of objects that may be of type: A, B or C and...

I am trying to build or find a template to schedule conference attendees based on a group that I assign them. Attendees have required sessions based on their...

I know this is simple, but I've just plain drawn a blank on how to correct, been years since I've done it. I've worked on a Access application which of...

Hi NG, I'm revisiting one of my applications and was wondering whether I could/should normalize table that stores configuration data. I have over 20 different...

Designing an MS Access 2003 VER database for the recording and recall of library records. Would like to have a 'keyword search" option to recall library...

Whilst trying to configre a field as a Lookup Wizard, the whole Office suite crashed. On restart, all the backup data had been corrupted, and the system lasted...

Hi I would like to configure of the fields (the primary key ) to allow two unique formats of entry. These formats a 1. A number which could range from 3 -...

I have a fairly simply database. Vendors have Sites and Sites have Site Visits My user wants me to give her a form so she can take a set of Sites that are...