Search results

Hi, I need some help on this one... How can I stop the the fields being selectable in a continuous form? When I open the attached form, the first field is always selected and spoils the effect of the form. I do not need to able to select the records. See screen shot. Dave

Hi, I have created the attached continuous subform. When I open this form, the first field is shaded grey and spoils effect of the form. How can I stop this happening? I don't need to be able to select records. Pleasde see the screen shot. David

Boyd, Fantastic, this has provided all the answers!! Cheers. David

Boyd, This looks very interesting. I shall have a play with that and see if I can make it fit what I am trying to do. Thanks for posting that link! Dave

It has taken me three days to try to embed a multi select list box into my already quite complex, but working query. I have a VBA routine that collects the selected values and places them in a text box txtTaskQuery on my form. A command button then requeries the form. The format of...

Uncle, you are right – I find it hard to ask the right question using the right terminology. I will try again… I want to open a Form such that records are filtered based on one field matching that stored in another table (ProjectID). So the form opens and records are filtered based on...

Hi, I have a form based on query. I want the form to open to show all records with the default ProjectID value (listed in another table). Then once the form is open, I want the user to be able change the ProjectID using a combo on the form. The combo loads with the default value. I...

Dear Uncle Gizmo and twoplus two, Thanks for your help. This expression did the business in the end (I had a ; instead of an , :o). RfiRef: "RFI" & "-" & [ProjectNo] & "-" & [TaskNo] & "-" & Right([RfiNo]+1000,3) & "-" & Right([RfiIssue]+1000,3) Ref...

Hi, So I tried to to place the following in the expression builder, but it does not accept it. RfiRef: "RFI" & "-" & [ProjectNo] & "-" & [TaskNo] & "-" & [RfiNo] & "-" & Right([RfiIssue] +100;3) Right([original_number] + 100; 3) will add two leading digits to a numeric string Is there a...

Merry Christmas & hope you are anjoying your cold turkey sandwiches (I am). I have a query with one field that concatonates five other fields in the query, thus: RfiRef: "RFI" & "-" & [ProjectNo] & "-" & [TaskNo] & "-" & [RfiNo] & "-" & [RfiIssue]. RfiNo and RfiIssue are fomatted in thier...

Would it be better to do it in code triggered by an on enter event for the subform? David

I don't understand how I can apply the rule to the rest of the recordset. Say Column 1 is Open or Closed and the remaining columns are something else. How can I tell Column 2 to have a red background if column 1 = Open? Dave

Paul, I have applied conditional fromatting, but it changes that 'cell' only. How do I go about formating the whole row? Cheers Dave

No, but I was under the impression that would work for the field only and not the recordset (the same as excel). I will have a look now. David

Christmas Greetings All! I have a subform generated from a query and I would like to change the background colour of the a row (recordset) dependent on the value in one cell. How do I go about that? Dave

Hello, I have created a Query By Form. The results are in a Subform. I would like, on the same form, to bring up the record for the highlighted line in the subform. How do I go about doing that? Dave

ByteMyzer, After a little fiddling to make it work with my other expressions, this worked fine. Thank you very much for taking the trouble to generate that screen shot. Dave

Thanks Brian, Yes I see what you and MSAccessRookie mean. But there must be a way of putting this together using expression builder, isn't there? For example to filter on the status of Titles (see first posting) and a status being open or closed, I did the following...

Thanks MSAccessRookie, If I look at the SQL view, there is a really complex query going on (built I guess by the multiple other expressions in my design view). I would not know where to insert ByteMyzer's SQL code. I am now wrestling with trying to build the expression in design view...

Dear Posters one and all, I appreciate all help and anybody that takes the time to reply. If its the wrong help and it dosn't work; I will have still learnt something. I appologise if I have phrased my question poorly and led to a breaksdown of the US-UK 'special' relationship. However, I...