Recent content by xavier.batlle

Is MS your Access Updated? Do all the computters have the same MS Access version? This behaviour you have explained was an ACCESS bug that happened 1 or 2 years ago!

This video can help you to avoid records locked in editing mode:

I've tested your code and it works fine. The database names are added to the combobox and displayed

The API is similar to this other one: Public Declare PtrSafe Function GetFileInformationByHandle Lib "kernel32" Alias "GetFileInformationByHandle" (ByVal hFile As LongPtr, lpFileInformation As BY_HANDLE_FILE_INFORMATION) As Long so I guess the VBA7 version would be: Public Declare PtrSafe...

If you use CDO, you can archive the full message as an *.eml file after sending it.

For example, if you want to send two attachments you can have two TextBoxes: Attachment1 and Attachment2, and for sendirng both files, you have to change the code: With Newmail If Not isNull(Me.Attachment1) Then .AddAttachment Me.Attachment1 Endif If Not...

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...

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.

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

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

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

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

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"""

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...

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.