Search results

  1. X

    Solved Subform. Format property. Show header and footer. No difference in putting YES putting NO

    I think you are confusing 2 concepts: - "Encabezado o pie de página" (Page/foot header) - "Encabezado o pie de formulario" (Form/foot header) The "Encabezado de página o de formulario" is only shown when the form is printed or on print preview and the property "Mostrar encabezado/pie the...
  2. X

    Windows 11 Laptop Very Slow?

    For an I3 processor some processes are a resource eaters, for example... Windows Update. It's also very important the processors generation to understand its behaviour.
  3. X

    index & seek

    No, AFAIK ADO connections to AZURE SQL servers don't implement the "seek" method. You can use "find" or "filter" to search records.
  4. X

    index & seek

    The OP said that he Back End is stored on SQL Server Azure, so this link doesn't apply.
  5. X

    index & seek

    IMO the best and fastest option is to use a Pass-through query (if you don't need to update the tables)
  6. X

    Automatic second quotation mark, parenthesis, bracket....

    You can set/unset this option if you use Rubberduck:
  7. X

    Run an EXE

    In VBA, executing a shell command with spaces in the path requires enclosing the path in double quotes. Here’s how you can do it in MS Access VBA: myPath2 = """C:\Program Files (x86)\VATECH\EzDent-i\Bin\VTE2Loader_ReqAdmin32.exe"""
  8. X

    Is 32768 the maximum number of objects in a MS Access database?

    The short answer is: No So you might be wondering: “What is the maximum number of objects in a database?” The short answer is: “Nobody knows it!” I’m going to explain what tests I’ve done and what the results are: I have developed an easy procedure that is able to create any number of new...
  9. X

    Typical situation 1:1 Superidentities with subidentities

    Sorry @The_Doc_Man, you are rigtht, both must be singular. These relations refers that a person can have several roles (client, customer, etc. ) and each role whith different attributes.
  10. X

    Solved How to get the project name?

    You can try to change the name of the VBA project from the VBE.
  11. X

    Solved How to get the project name?

    Look at the outputs, Arnel's solution and mine give different outputs.
  12. X

    Typical situation 1:1 Superidentities with subidentities

    I have several relations 1:1 with no issues. It is a way to organize your database. Example: Person 1:1 <- Clients Person 1:1 <- Customers Person 1:1 <- Workers Person 1:1 <- Contacts Person 1:1 <- Other stuff... ... Somebody could say that I could use only 1 table to store all the data but in...
  13. X

    Signature Image in GMail email body

    Perhaps this threat helps you. https://www.access-programmers.co.uk/forums/threads/add-images-in-cdo-mail-message-htmlbody.304778/
  14. X

    Form DSum Calculation for Tax Year

    Hello, Test this other example.
  15. X

    Solved How to get the project name?

    To get the VBA Project Name, you have to use: Application.VBE.VBProjects(1).Name
  16. X

    Convert tables from Access to SQL

    Perhaps this video helps you:
  17. X

    HELLO GURUS

    Welcome to AWF! Phuduhutswana
  18. X

    Solved DLookUp

    Perhaps this example will help you:
Back
Top Bottom