Search results

  1. I

    refer one record to table with relationship in form

    I have two tables called [ncr table] and [actions]. These have a relationship defined by [ncr code] I have a form open, also called [ncr table] which I have got a text box on which I have set up with condintional formatting. What i want to do is for this text box to chage colour if my record...
  2. I

    docmd.applyfilter with dates (uk format)

    I have a form for a table with a [due date] field. I want to apply a filter to the form to show only overdue records so I am using DoCmd.ApplyFilter , "[due date]<#" & Date & "#" I am also trying to count the number of overdue records in a textbox using Forms![ncr table]![overdues].Value =...
  3. I

    filter form and continuous form with pages

    Hi all, I have a couple of questions about my form (see below) 1. I want to apply a filter to show only the open records (defined by the closed checkbox). what is the best way to do this? 2. How can I make the form non-scrollable so that when the page is full, I need to move to a different...
  4. I

    tabular form, format each record differently

    Hi All, Any help on this one woudl be much appreciated. The picture below probably better explains what I want to do but I'll give it a go in text I have a tabular form with multiple records For each record I want to change the fill colour of the "Ass." textbox depending on if there is a name...
Back
Top Bottom