Search results

And continue with this other one: https://www.devhut.net/adding-speech-recognition-to-your-application/

I remembar that once I solved the same issue by changing the user monitor to a much larger one that also had the same recommended resolution (1920x1080).

After some tests, it seems that the name that appears in the VBA References "dropdown" is the name of the VBA Project, not the database file name:

When you have changed the textbox control to a combobox, the combobox tab order of the control has changed and now is the last control in the section. You have two options to avoind going to a new record: - Reorder the controls on the tab order option on the form section (surely detail section)...

Yes, like 0.20 is ten times greater than 0.2 🤭

Perhps this approach helps you @riktek: https://nolongerset.com/better-global-constants/

I found it when I converted the Lebans PictureBox to 64 bit. ;)

If I'm not mistaken, I've seen it when you copy memory addresses using Windows APIs. As you know, memory addresses length are different depending on the bitness. This is the code I've used sometimes ' *********************************** ' #If Win64 Then Private Const PTR_SIZE As Long...

Sometimes, converting a database is not as easy as it seems. For example: - You have to change len() to lenB() in some UDT. - When there are copy memory APIs involved, the number of bytes copied must be changed...or not. - Some APIs can be used with different parameters type. - 32 bit OCX...

One of the main purposes of storing the sequence number on a table field is that you can reorder the items the way you want (if needed or wanted).

Look at: https://learn.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-database?view=sql-server-ver17

If you really want to number the items on the subform, I use this approach: I set this function in the BeforeInsert subform event. It numbers the lines form 10 to 10 in case I want to insert any later: Private Sub Form_BeforeInsert(Cancel As Integer) Dim rst As DAO.Recordset Dim...

I don't think it's the problem, but you can try to add the $ to the function assignment or delete it from the function declaration and add "as string"

According to this interesting article by Philipp Stiefel (sonic8) the name of the Office 365 SMTP server is:smtp.office365.com https://codekabinett.com/rdumps.php?Lang=2&targetDoc=send-email-access-vba-cdo

The function original code is from this page: https://learn.microsoft.com/en-us/answers/questions/4768377/convert-pdf-to-image-using-vba-macro

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.