Recent content by madeline

  1. M

    Refreshing a query from a form.

    Hi Anthony, Use Me.Refresh on your save,go or close command button then on click it refreshes. Madeline
  2. M

    convert vlookup to access

    Hi All, I have an Excel formula that I need to convert to Access 2007: =IF(F8="Active",IF(AND(C8<>"None",C8<>"COM"),VLOOKUP(N8,AQ6:AV11,L8+1,FALSE ),IF(C8="COM",VLOOKUP(J8,AX7:AY11,2,),"Error")),"Null") The vlookup looks to this: AQ6:AV11 1 2 3 4 5 5 11 16 20 23 25 4 7 12 17 21 24 3 4 8 13...
  3. M

    Events on Forms

    Thank you all you were awesome. Problem solved :)
  4. M

    Events on Forms

    mmmh thanks for this, but I can't find form_update anywhere :( even in the help files I can't find any reference to this.
  5. M

    Events on Forms

    Hi All, I've got a form where I want a date field to automatically change the date if any of the data on a row is changed or added. I've found a similar thread before but unfortunately I couldn't get it to work. Private Sub Form_AfterUpdate() Me.Last_Updated = Now() I really don't want...
See more
Back
Top Bottom