Search results

Thanks tvanstiphout, I've updated it to VBA7 to use it in 64 bit MS Access..

You can add an Unicode character to the form caption when a form is active. For example: Form1 selected: Form2 Selected

Yes! she is: https://web.archive.org/web/20180313165355/http://thatlldoit.com/Pages/default.aspx look at this link: http://www.youtube.com/user/LearnAccessByCrystal

It seems that it's by Crystal and crew.

Perhaps something like this: Dim strRecordSource As String strRecordSource = Me.RecordSource Me.RecordSource = "Select * From [name of the table] Where 1=2" Me.Recordset.Requery Me.RecordSource = strRecordSource

This is an example of how to use a simple class to color selected labels in checkboxes and optiongroup controls. Example:

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