Recent content by inspector-71

  1. I

    refer one record to table with relationship in form

    I know how to do the conditional formatting, just not what code to use in it when referring from a table in one form to a different related table
  2. 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...
  3. I

    docmd.applyfilter with dates (uk format)

    yes date/time data is correct. I think I have solved it now with DoCmd.ApplyFilter , Format("[due date]", "mm/dd/yyyy") & "<#" & Format(Date, "mm/dd/yyyy") & "#" and Forms![ncr table]![overdues].Value = DCount("[id]", "[ncr table]", Format("[due date]", "mm/dd/yyyy") & "<#" & Format(Date...
  4. 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 =...
  5. I

    filter form and continuous form with pages

    it's ok, i just didn't know the syntax for using dates. DoCmd.ApplyFilter , "[due date]<#" & Date & "#" worked fine
  6. I

    filter form and continuous form with pages

    ok, the closed filter now works a treat. Thanks. I also want to filter when due date is > todays date i.e an overdue filter. I'm not having much success with this using docmd.applyfiler "[due date]>..........not sure of syntax "[due date]>date" asks for an input for date "[due date]>" & date...
  7. 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...
  8. I

    tabular form, format each record differently

    many thanks for the replies. A good reminder not to overlook the obvious routes first!
  9. 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...
See more
Back
Top Bottom