Search results

This function uses PPT automation in MS ACCESS to convert A PDF to a PNG file. No Acrobat needed. (Tested) : 'Set a reference to the Microsoft PowerPoint xx.0 Object Library: 'In the VBA editor (press Alt + F11), 'Go to Tools > References..., 'Find and check Microsoft PowerPoint xx.0 Object...

Yes, I found it on my Google search first page. I also read it's possible to achieve it using PPT automation (Not tested): Sub SavePDFAsPng(sPathToPDF As String, sPathToPNG As String) Dim oPres As Presentation Dim oSh As Shape ' Height/Width are hardcoded here ' You could get trickier and...

I totaly agree with you. Sometimes, when I have needed a calculated field that should be indexed, or that it can't be set with the current operators, I use data macros to simulate it. It has been very useful in some projects.

If you are searching only one record and the table is indexed on that field, the method seek in a table recordset is faster. The table must be in an MS Access Database, Seek doesn't work on SQL Server.

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.