Recent content by nigel brown

  1. N

    Highlight field if empty

    Ok, I will check it out and see if I can find out how to do it. Kindest Regards Nigel :) or :confused:
  2. N

    Highlight field if empty

    Hi On my report, I would like to highlight any fields (Text Boxes) that are empty. I suppose it is a kind of condition formatting like in Excel, maybe not! Please help Nigel VBA Virgin
  3. N

    Not show record if false

    Hi I have a query, the fields are in this format: 01 is yes/no 01 Estimate complete date 01 Complete date 02 is yes/no 02 Estimate complete date 02 Complete date This format goes up to 40. I am asking if 01 yes/no, is false then do not return the field when the query is run. In theory...
  4. N

    Link form

    I hve found out why the form is blank. If there is no associated record, it returns a blank. If there is an associated record, it returns the record and works. Thanks for all your help. Nigel
  5. N

    Link form

    Both are called Site Name and both are text fields.
  6. N

    Link form

    Hi again Tried without and with the square brackets and same result, form with no detail. I am not VBA or code savvy so I am not much use, sorry. Nigel
  7. N

    Link form

    I put the code in to a event of a button on the first form, on pressing the button, the form opens but there are no text fields or other button on the form, nearly there. Nigel
  8. N

    Link form

    Hi It did not like this DoCmd.OpenForm "Count of Learners Employers", , , "Site Name = "" & "Site Name&"" Yes, linking one text field from one form and opening another form using that value as reference to pull that value from a query result. Nigel
  9. N

    Link form

    Hi I have a form open, I would like to open another form taken from a different table, they are linked through [Site name]. How do I link it so the associated record opens in the second form? Regards Nigel
  10. N

    Calculation

    Where do you mean?
  11. N

    Calculation

    Hi Attached is a cut down version. On the form, there are two unbound boxes. Low is 15% of No of Learners Medium is 30% of No of Learners Thanks Nigel
  12. N

    Calculation

    I have got it sorted now. Many thanks for those that replied Nigel Hi all I have a form that displays a value calculated in a query and displayed on the form. I have put two unbound text boxes on the form, in these boxes I need to calculate 15% and 30% on the value displayed from the...
  13. N

    if statement, I think

    It is working after amending the field name on one area. Just testing it with various dates, but it is looking good so far. Will keep you posted. Regards Nigel VBA Virgin
  14. N

    if statement, I think

    Hold on, I just noticed a name [ ] was incorrect. Just amended and it looks ok, will report back shortly Nigel
  15. N

    if statement, I think

    do you want me to attach the database, it is small as using a test bed at the minute? Regards Nigel
See more
Back
Top Bottom