Recent content by NoLongerSet

  1. NoLongerSet

    On/Off control for continuous form

    @CJ_London: Very nice. This article may be of interest to you in trying to handle continuous forms with scrolling. The "deprecated" function that I show in the article included code to identify the current position of the scroll bar so that I could restore that position following a form...
  2. NoLongerSet

    On No Data

    I wrote a series of articles about my custom PreviewReport function that I use to wrap DoCmd.OpenReport. One of those articles focused on the "'OpenReport' action was canceled" error message and how I deal with it. Finally, I wrote an article with code for a simple function, InformNoData()...
  3. 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)
  4. 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...
  5. 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)
  6. 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.
  7. 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()...
  8. 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...
  9. NoLongerSet

    Partial Workaround for the "Could not lock file" bug

    Thanks, @shadow9449! And, yes, it is Mike (Wolfe).
  10. 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...
  11. 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 =...
  12. 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...
  13. 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...
  14. 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 -...
  15. NoLongerSet

    Pop-out forms

    Are you asking about Forms(Forms.Count - 1)?
Top Bottom