Search results

  1. W

    run time error 91 - global variable

    tried global: does not work. But what i do not understand is that why the same coding works in two other apps made on the same computer?
  2. W

    run time error 91 - global variable

    sorry, obviously public in the code, just misspelled here.
  3. W

    run time error 91 - global variable

    Hi, I am struggling with the following: I have made two different application where i have used the same coding for having a dynamic customized ribbon. In both cases, the same procedure: 1. UsysRibbons table with ribbon code containing onLoad="onLoad" (same naming worked in both instances) 2...
  4. W

    conditional formating with VBA onLoad

    Is this code sufficient to avoid the runtime error? Private Sub Form_Close() For Each ctr In Me.Controls If ctr.ControlType = acTextBox Then ctr.FormatConditions.Delete End If Next ctr End Sub
  5. W

    conditional formating with VBA onLoad

    I see. Is it correct to add then a delete method?
  6. W

    conditional formating with VBA onLoad

    thank you!
  7. W

    conditional formating with VBA onLoad

    great, thanks!
  8. W

    conditional formating with VBA onLoad

    I got it worked! The BackColor part was not right. Instead of setting the control backcolor, the formatcondition backcolor needs to be set. Private Sub Form_Load() Dim ctr As Control Dim frm As Form Dim fc As FormatCondition Set frm = Forms(tb) For Each ctr In frm.Controls Select Case...
  9. W

    conditional formating with VBA onLoad

    Yes exactly. OnCurrent text13=ID. then i would like to have the control to be green. In other words highlight it.
  10. W

    conditional formating with VBA onLoad

    I modified the code like this: Private Sub Form_Load() Dim ctr As Control Dim frm As Form Dim fc As FormatCondition Set frm = Forms(tb) For Each ctr In frm.Controls Select Case ctr.ControlType Case acTextBox Set fc = ctr.FormatConditions.Add(acExpression, acEqual, "[ID] = [Text13]")...
  11. W

    conditional formating with VBA onLoad

    I see, thank you. I have modified the code, with a select case of ctr. controltype. This part is ok now, but i think i have a problem with the add method. So what i would like to achieve is that in my continuous form, the row where one of its control has focus, be highlighted and i would...
  12. W

    conditional formating with VBA onLoad

    Hi, I have a continous form with multiple controls. I would like to have the conditional formating for these controls using VBA on onLoad event. Private Sub Form_Load() Dim ctr As Control Dim frm As Form Dim fc As FormatCondition Set frm = Forms(tb) For Each ctr In frm.Controls Set fc =...
    • Wysy
    • Thread
    • Replies: 25
    • Forum: Forms
  13. W

    Highlight current record on continous form

    sorry for not providing... https://answers.microsoft.com/en-us/office/forum/office_2007-access/highlight-row-in-continuous-form/a862821f-ebee-4ebc-93d9-e068debcab84
  14. W

    Highlight current record on continous form

    Thank you so much. I found this as well: "An alternative to highlighting only the control with the focus or using Conditional Formatting on every control is to add a text box with BackColor set to whatever BackColor you use on the other controls. Size this text box to cover the entire detail...
  15. W

    Highlight current record on continous form

    Thank you, but it changes all the fields on CF form.
  16. W

    Highlight current record on continous form

    Hi, I am trying to solve this: i would like to highlight the record/control having focus. I have seen several solutions but i wonder which one is the best for Office 365. thank you Andrew
    • Wysy
    • Thread
    • Replies: 7
    • Forum: Forms
  17. W

    VBA to download email from account

    no i do not use or want to use outlook. Only thunderbird.
  18. W

    VBA to download email from account

    Hi, I would like to ask if there is a way to create a vba code to download emails and save them to a table. Sending is no problem it is functioning. thank you
  19. W

    DLookup/Dmax function error after append query

    Hi, I have the following problem that emerged in my database. I have a table with alphanumeric id. I need to know the last one when i enter new data using an entry form. So on the entry form i have an unbound control with Dlookup/Dmax function. The function runs on a query based on the given...
  20. W

    subform total in footer

    sorry the control source is =fsubform.Form!control
Back
Top Bottom