Search results

No, if you create a calculated field directly in a table (using the "Calculated" data type), Access does not allow you to index it.

Attached a database with an example using @moke123 suggestion:

But if I'm not mistaken with that approach you first have to open the backend databasase where "the linked table if the Yes/No field" is, and it might be corrupted or blocked, etc.

It's also a good idea to prevent users from opening the backend database when there are some maintenance tasks to do. In my case when they open the Application, if there is a file called "EnterDenied.txt" in the same directory where is the backend stored they are unable to open the backend...

Yes, nowadays V-Tools must be reinstalled when Ms Office is updated!☹️

To install V-Tools you must execute MS ACCESS as administrator. How do you open V-Tools in administrative mode but read-only?

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