Search results

I don't know if this can help. When I import a CSV File to an Excel spreadsheet, I use some code similar to this one generated by ChatGPT where you can specify the type and date format of each column. (Not tested) Sub ImportCSVToExcelWithFormatting() Dim xlApp As Excel.Application Dim...

Instead of using the format property, I'd use the switch command and the format() function in the controlsource property to set the desired numeric format in the query.

Perhaps you can get this information using PowerShell (by ChatGPT): Write-Host "Equipo local: $env:COMPUTERNAME`n" # Obtener adaptadores físicos que estén activos $adapters = Get-NetAdapter -Physical | Where-Object { $_.Status -eq 'Up' } foreach ($adapter in $adapters) { $name =...

I don't think it's a good idea to do this, but it's possible to create a blinking form caption using the form timer event. Tested only for fun! ;-)

I use these utilities: https://www.accessribbon.de/en/?Trust_Center:Trusted_Locations

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.