Recent content by xavier.batlle

Broken link. Missing an "l" at the end of the URL http://allenbrowne.com/AppInventory.html

If no internet browsers or desktop Outlook used! They are resource eaters.😉

If TS stands for Terminal Server, why only 15 users? The number of users depen on the number of licenses you buy.

To fix errors on procedures that have "Error handler", I find the "Extra Resume" technique very useful instead of commenting out the Error handler. https://nolongerset.com/the-extra-resume/

Hi ramendog, After some tests, I noticed that the problem arises when the subreport has more records that fits on a page (I suspect). For example: Kentucky: KY0- Number of 2024: 125 I've changed the main report recordsource to list only the the states where the subreport has 110 or less...

Try using DMax and adding 1 to the value https://learn.microsoft.com/en-us/office/vba/api/access.application.dmax

I've removed all the formats in the currecy columns and it seems to work properly. To be honest I don't understand why!

Try: [NewLineDesc]<>"#1" Or [NewLineDesc]<>"#2"

Simple database with some code that simulates to color the tab control label depending on the page selected. It could be possible with a similar approach to insert icons and change them depending on the page selected.

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