Recent content by xavier.batlle

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