21 Matching Annotations
  1. Feb 2023
    1. If you close the report without explicitly clearing the filters, Access remembers them and you can click Toggle Filter again to reapply them next time you open the report. This works even if you close and reopen the database. However, if you click Home > Advanced > Clear All Filters, Access clears the filters completely and you’ll need to start from scratch next time around.

      Interesting to know how Access saves the filter you wrote.

    1. Searching is the #1 task that a user has to do. I will say this again:Searching is the #1 task that a user has to do.

      Keep reading. Maybe this has to do with server filtering. I don't know. But it seems interesting so ...

    1. In the example(s), Mypass is a SQL pass-through query you created. You simply create one working PT query, and then you can (usually) then use that one PT query anytime you want raw T-SQL or to run a store procedure 100% server side. So we are in effect overwriting and re-using that one PT query anytime we want raw SQL to run server side.

      This tells how Access has changed over the years and how different it is from the version I worked with ages ago.

    2. Now for running and executing store procedures, or say a sql update to “many” rows, then you most certainly want to use a pass through query, since processing of records does occur local client side.

      So, it's important to research and learn about pass-through queries.

    3. And AGAIN a SIMPLE USE of the “where” clause will result in sql server view ONLY sending down records that meet the criteria you set via the Access built in “where” clause.

      So, building the where clause when opening forms/report is one of the best ways to go.

    4. So placing forms! Expressions inside of a query always been a bad idea since then the query is now “married” to some silly form.

      Wouldn't myself imagined this. But it's very the very truth. The query becomes attached to the form. You can not use it anywhere else!!! And this is the way I was doing this ...

    5. You can change the SQL string in the pass-through QueryDef and specify the Form field:

      So, this is a way to execute that query on the sql server side. Would it be difficult to implement?

    6. Second, would be to pass a SQL string from Access to SQL Server (pass-through query) and have it execute on the SQL Server side.

      Ok, so we need to do some research about pass-trhrough queries. Do they execute on the server?

    7. You can make these changes 100% inside of Access, and not have to really use anything SQL server side to achieve this goal.

      This is just wonderful. Just need to work on the Access (client) side. No need to affect the server side (always more difficult to work with)

    1. WhereCondition Optional Variant A string expression that's a valid SQL WHERE clause without the word WHERE.

      According to what I read, this Where clause goes to the server and applies there. So, we just have to do what we do in js: open a filter form first, build a filter from there and then open the form with that filter (with no Where word).

      Doing that, it's sql server who picks up that filter and applies it server side!!! Just what we need ...

    1. Using the advanced filters requires writing expressions. Expressions are similar to formulas in Excel, and to the criteria that you specify when designing a query.

      As you have to create expressions, these filters are more advanced and difficult to create than previous ones.

    2. In addition to these filters, you can also filter a form or datasheet by completing a form (called Filter by Form).

      So, it seems filter by form only exists for: forms and datasheets.

    3. Filter settings will remain in effect until you close the object,

      So, the filter is going to be removed when you close the object. Does a way exist to make filters saved? I mean, with the object?

    1. Essentially, sorting and filtering are tools that let you organize your data. When you sort data, you are putting it in order. Filtering data lets you hide unimportant data and focus only on the data you're interested in.

      Some inputs about sorting and filtering in an Access Database.

  2. Jul 2022
    1. Documentación Git del comando Git restore

    2. git-restore - Restore working tree files

      Aunque dice que restablece working tree files, también restablece el Index (desde HEAD)

    3. In overlay mode, the command never removes files when restoring. In no-overlay mode, tracked files that do not appear in the --source tree are removed, to make them match <tree> exactly. The default is no-overlay mode.

      Git restore puede eliminar archivos en el working. La opción para que no ocurra es --overly. Pero esta no es el default.

    4. If a path is tracked but does not exist in the restore source, it will be removed to match the source.

      Importante saber. Si, por ejemplo, un file está en el working pero indicamos un commit como source donde no existía el file, este es eliminado desde el working (!!!).

      nota: revisar opción --overlay. Si usamos --no-overlay, algún file que no exista en source no es eliminado. Pero el default es --overly (eliminar).

    5. by default the working tree is restored

      --worktree: restablece el working (desde el Index) --staged: restablece el Index (desde el HEAD)

      Nota: --worktree es el default.

    1. GitHub Blog post donde se hace referencia a los nuevos comandos:

      • Git switch
      • Git restore

      Nuevos en la versión 2.23 de Git

    2. Highlights from Git 2.23