Search results

  1. NoLongerSet

    Great Function to Pluralize words

    Using the Pluralize function the above code could be rewritten as: intNoOfFiles = CountFilesInFolder("N:\Letters\", "*.pdf") stMessage = Pluralize("There [is/are] <b>#</b> file[s] waiting to be reviewed and signed.<br><br> " & _ "After signing:<br><br>", intNoOfFiles)
  2. NoLongerSet

    Great Function to Pluralize words

    @Mike Krailo I actually had a draft of the article that did exactly what you have, with "no" as the "zero" option in the format string. But then I took it back out because I thought it led to ambiguity between the -5 and 0 cases: 😁 There are 5 fewer fingers on his hand after the surgery. There...
  3. NoLongerSet

    Is there a way round the - "Mark of the Web"

    I wrote a follow-up article to the one @Uncle Gizmo referenced above with more details about how the mark of the web is actually implemented using alternate data streams: Details about the Mark-of-the-Web (MOTW)
  4. NoLongerSet

    Problems of migrating from Access to MySql or MariaDB

    Ben Clothier wrote about some of the important technical differences between a MySQL backend and an MS SQL Server backend here: How does Access talk to ODBC data sources? Part 4.
  5. NoLongerSet

    Combo Box woes

    Sorry @GoodyGoody, I just saw your post: Combo0 is the name of the combo box control on my sample form. You would need to replace that with your cmbRaceRunner combo box. So, your code would look something like this: Private ComboLookup As New weComboLookup Private Sub Form_Load()...
  6. NoLongerSet

    Partial Workaround for the "Could not lock file" bug

    The issue that this fixes is one where it's not possible to open an .mdb / .accdb file using DBEngine.OpenDatabase, even when you are the only one trying to access the file. The partial workaround does not allow the backend file to be opened by multiple users simultaneously. That's why I...
  7. NoLongerSet

    Partial Workaround for the "Could not lock file" bug

    Thanks, @shadow9449! And, yes, it is Mike (Wolfe).
  8. NoLongerSet

    Partial Workaround for the "Could not lock file" bug

    If you use the DBEngine.OpenDatabase method and started getting the following error message in your Access applications, you are likely a victim of a recent Microsoft security fix that had some nasty side effects for us Access developers. I wrote a function that acts as a partial workaround...
  9. NoLongerSet

    Code optimization needed

    You might also want to turn off ScreenUpdating in Excel. I'm not sure whether this boosts performance if the Excel Application itself is not visible, but it would be easy enough to test it by adding the code below and seeing if it improves your run times. Set objExcel =...
  10. NoLongerSet

    combobox.setfocus "not working" on a continuos form

    The situation @ubi is describing is very specific. To reproduce the odd behavior you need the following things all in place: Bound form AllowAdditions = False (or non-updateable record source) Filtered to return no results An unbound field in the header or footer section of the form The...
  11. NoLongerSet

    combobox.setfocus "not working" on a continuos form

    Ubi, the problematic behavior is a quirk of Access itself. Hiding the detail and navigation buttons does not help if you also apply the filter. My sample code may not have been clear enough about this. Here's some pseudocode: Will the filter return at least one record? If Yes, then...
  12. NoLongerSet

    Pop-out forms

    Screen.ActiveForm: returns the form object of the active form (raises an error if a report is the active object) Forms(Forms.Count - 1): returns the form object for the most recently opened form (raises an error if there are no open forms) Note: I included the first line--?Forms(Forms.Count -...
  13. NoLongerSet

    Pop-out forms

    Are you asking about Forms(Forms.Count - 1)?
  14. NoLongerSet

    combobox.setfocus "not working" on a continuos form

    Is the combo box in the form header or footer? Unbound controls in the form header or footer of a bound form exhibit all sorts of strange behavior when you filter the form so that no records are returned. The best workaround I have found for this situation is to avoid setting a filter that...
  15. NoLongerSet

    Export: Custom file name without folder path

    The Current Directory (CurDir) function might give you what you need. The Change Drive (ChDrive) and Change Directory (ChDir) functions can be used to change the Current Directory.
  16. NoLongerSet

    Pop-out forms

    Try checking the position of the form from the Immediate Window after you switch to form view: ?Forms(Forms.Count - 1).Name ?Forms(Forms.Count - 1).WindowLeft ?Forms(Forms.Count - 1).WindowTop ?Forms(Forms.Count - 1).WindowHeight ?Forms(Forms.Count - 1).WindowWidth
  17. NoLongerSet

    Your favorite software or app at the moment?

    I wrote an article a while back with a list of some of My Favorite Things. The latest and greatest addition to that list is the Everything file search utility. If you try it, I suggest you follow this quick tip from Tom Wickerath to ignore shortcut files.
  18. NoLongerSet

    Combo Box woes

    Gasman, It should work in 2007 without any problems. Let me know if you run into any issues.
  19. NoLongerSet

    Combo Box woes

    Here are the steps to import the "lazy-loading" combo box feature: Import the weComboLookup class module code from this article Add the following to the form's code-behind module: Private ComboLookup As New weComboLookup Private Sub Form_Load() Const MinimumFilterTextLength As Integer = 3...
  20. NoLongerSet

    Combo Box woes

    Here's a link to my article that has a downloadable sample database with all the code that I demonstrate in the video: Advanced Combo Box Techniques
Top Bottom