Search results

  1. X

    DoCmd.SendObject and CDO

    Perhaps these functions are useful for someone. I use them for saving and loading *.MSG Files. I don't remember where I found them: 'For Windows 2000 or later. Requires a reference to: ' Microsoft CDO For Windows Library ' Microsoft ActiveX Data Objects 2.5 Library Function...
  2. X

    DoCmd.SendObject and CDO

    Quick answer: Yes! Some information: https://nolongerset.com/outlook-alt/
  3. X

    DoCmd.SendObject and CDO

    I don't use DoCmd.SenbObject but CDO works properly in Access365.
  4. X

    Adapting automatically Access code from 32-bit to 32/64-bit

    This post is 13 years old, so it might be oudated! I've tested (not worked) with 64 bit MSFORMS in MS ACCESS with no issues.
  5. X

    New to Microsoft Access world, should I invest the time learning it from scratch or go for the C#, SQL Server, and ASP path? Please advice

    After two years of the OP, I would like to know what happened with the project!:unsure:
  6. X

    Steaming STT using AI model

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

    Form sizing / scrolling for smaller screens

    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).
  8. X

    Access VBA References

    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:
  9. X

    Autocomplete Combo Enter/Tab behaviour

    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)...
  10. X

    ChatGPT

    Yes, like 0.20 is ten times greater than 0.2 🤭
  11. X

    Programmatically construct a constant's name and return its value

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

    Adapting automatically Access code from 32-bit to 32/64-bit

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

    Adapting automatically Access code from 32-bit to 32/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...
  14. X

    Adapting automatically Access code from 32-bit to 32/64-bit

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

    Solved Form Record Cloning In MS Access

    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).
  16. X

    My Database went from 120 GB to 150 GB after Normalizing? Is there a Compact command for SQL Server?

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

    Solved How to include line sequence in MS Access Line details table

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

    Variable assignment not working.

    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"
  19. X

    Solved Using ACCESS, WORD and OUTLOOK to send bulk E-Mails

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

    Convert acrobat 9.0 PDF to Image .PNG Using VBA Code

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