Recent content by vbaInet

  1. V

    Setting the default value to the last used value

    Did you select Event Procedure and paste it in the code window? And ensure that control name is correct. I would use the After Update event of each control.
  2. V

    How to send different attachments to different recipients

    Concatenate the file name with the field value from the recordset in the Attchments line.
  3. V

    VBA Code for IIf statement

    I explained how you do it using an Update Query.
  4. V

    Calculated textbox to table

    My post came a bit late because I'm logged in from my phone.
  5. V

    Calculated textbox to table

    If it's another table that you want to update, create an Update Query that references the calculated value and use RunSql or Currentdb.Execute to fire the query. Everyone else makes a good point about not saving calculated values though, but sometimes needs must.
  6. V

    Query "And" on same field

    Ah alright, I understood it differently. I'll take a back seat now that you're back online.
  7. V

    DateDiff Function

    She's always looking for new functionality ;) You can look into the RGB() function.
  8. V

    Create hyperlink to open Access form

    I'm not on a pc at the moment but check the DesktopPath variable to ensure that it's returning a value, then step through each line as it runs.
  9. V

    Looping through Files - Access holding on to first file name

    Very good! :) Welcome to AWF by the way.
  10. V

    Improve Efficiency

    Select Count(id) in the recordset sql and return that field value. That's lightening fast. Include a forward only option too.
  11. V

    Remove "potential security concern"

    There's only the registry option.
  12. V

    Looping through Files - Access holding on to first file name

    Remember I mentioned "Subsequent calls". You've already called it once before the loop so where do you think the next call to Dir() should go? Have a think.
  13. V

    Position cursor to left bottom of control

    I'm not a laptop at the moment but if I remember correctly certain controls have a Context menu property where you specify the name of a context/pop up menu to allocate to the control. Access handles the rest.
  14. V

    Report loop -slight issue with ' or ""

    I said that in jest :) But seeing the code you most likely need an Else or Else If statement instead of two If blocks.
  15. V

    Report loop -slight issue with ' or ""

    For your eyes only then ;)
See more
Top Bottom