• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Search results

  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 ;)
  16. V

    Report loop -slight issue with ' or ""

    Best way to learn and remember ;) What code did you use and what was the result? It's all related so the same thread is fine.
  17. V

    Report loop -slight issue with ' or ""

    Do stuff and see the result ;) And I can see that you've chosen to still open the report beforehand.
  18. V

    External Name not defined

    If you Google "how to set a breakpoint in VBA" you should find lots of useful information. Might be best looking for videos on it.
  19. V

    Looping through Files - Access holding on to first file name

    Following Gasman's advice, subsequent calls to the Dir() function gets the next matching file path. By the way instead of copying the file across and deleting it, you could move the file... same process as cut and paste. https://msdn.microsoft.com/en-us/library/office/gg251462.aspx
  20. V

    External Name not defined

    Oh I see. You can't run that sub in the immediate window. Only public functions or subs in a Standard Module (not a Form Module) can be run from the immediate window. You can however put a break point in the sub and test the initialised variables in the immediate window when it breaks.
Top Bottom