Search results

  1. N

    Solved How to remove this error "the execution this software stopped due to run time" error in MS Access VBA

    My apologies people for taking too late to reply to this issue, I have been investing why the CDO does not work well with runtime. I have finally found the truth here: (1) The CDO was created to work with full MS Access not depleted runtime period.
  2. N

    Improve FE - BE performaces on LAN

    This sounds like the index issues here, if the tables are properly indexed and you are using wired local area network access works faster. Never use WIFi in this case. Shifting to SQL Server is like climbing mount Everest, if you really want performance forget about that SQL server its just a...
  3. N

    Solved MS Access Switch Board Menu

    Many thanks to all experts above for providing valuable information this helped a lot.
  4. N

    Solved MS Access Switch Board Menu

    Our department want an MS Access switchboard menu , though I Know we add it manually its not on the menu of MS Access 2016 . The sales switchboard must have the following reports : (1) Sales reports with each button representing a sales area or an outlet (Example, town Centre , first class ...
  5. N

    Solved Converting a longer date string into short date

    Many thanks to all you have helped to solve this issues I real appreciate you all.
  6. N

    Solved Converting a longer date string into short date

    Is possible to convert a longer date received from a website into a short date in MS Access Example longer date : Tue, 24 Dec 2024 12:55:03 GMT) Convert into : 24/12/2024 I have tried this it failed: Format((Tue, 24 Dec 2024 12:55:03 GMT),"DD\/MM\/YYYY") Any idea here We are interested...
  7. N

    Solved How to send multiple attachment with CDO Gmail in MS Access VBA

    Many thanks CJ London you are great! the sky is the limit you have really made my new present 2025. Once again thank you Regards Ch
  8. N

    Solved How to send multiple attachment with CDO Gmail in MS Access VBA

    Its now giving me the sending failure message , unless I have changed a wrong place , see the new code Dim Newmail As Object Dim mailConfig As Object Dim fields As Variant Dim msConfigURL As String Dim a() As String Dim i As Integer On Error GoTo Err1: 'late binding Set Newmail =...
  9. N

    Solved How to send multiple attachment with CDO Gmail in MS Access VBA

    Many thanks CJ but I do not know where I'm going wrong , see the message below
  10. N

    Solved How to send multiple attachment with CDO Gmail in MS Access VBA

    @ Use the split function on your attachment field and then loop through the array I'm a beat lost how do we use this split function
  11. N

    Solved How to send multiple attachment with CDO Gmail in MS Access VBA

    Its giving me type missmatch With Newmail If Not IsNull(Me.Attachment(1)) Then .AddAttachment Me.Attachment(1) End If If Not IsNull(Me.Attachment(2)) Then .AddAttachment Me.Attachment(2) End If End With
  12. N

    Solved How to send multiple attachment with CDO Gmail in MS Access VBA

    The code below is almost complete of course with the help of the members here or on this forum, all is working fine but with one exception it can only send one attachment at a time. I have managed to attach multiple file as you can see below on the screen shoot, so the challenge is how to send...
  13. N

    Solved How to remove this error "the execution this software stopped due to run time" error in MS Access VBA

    Is there any problem if I change the FE from accde to accdr. If leave the FE in this format accde , the above error does not come, but I want to try it again four times. Commenting the error did not show any error in the code at all
  14. N

    Solved How to remove this error "the execution this software stopped due to run time" error in MS Access VBA

    I have configured the Gmail in MS Access 2016 with VBA and everything is work okay: (1) I'm able to select recipients emails from the combo box (2) I'm able to concatenate several emails automatically like we do it in outlook (3) I have made both the attachment and CC as option all is working...
  15. N

    Solved How to add an attachment in Gmail managed in MS Access VBA

    Many thanks June7 it has work very well I have also managed to make CC: and Attachment Optional, I need now to add some tables for host credentials and customer's table.
  16. N

    Solved How to add an attachment in Gmail managed in MS Access VBA

    Thanks isladogs I'm calling the above function as below but it does allow only MS Access Database instead of any document, could it be I'm again making a mistake somewhere: Me.Attachment = GetFile()
  17. N

    Solved How to add an attachment in Gmail managed in MS Access VBA

    I'm getting user un defined Function on fDialog As Office.FileDialog Function GetFile() ' Requires reference to Microsoft Office xx.0 Object Library. Dim fDialog As Office.FileDialog ' Set up the File Dialog. Set fDialog = Application.FileDialog(msoFileDialogFilePicker) With...
  18. N

    Solved How to add an attachment in Gmail managed in MS Access VBA

    After working almost the whole Xmas day 25th December 2024 to make sure that access is able to send an email from its own form. This process is now working okay though very length . Last issue requiring your help is on attachment for an external document, here I'm using the actual path of the...
  19. N

    Solved I want to be able to send a few emails in access 2016 using gmail but am having challenges

    Okay many thanks to all contributors no answer is wrong they are all valuable and I appreciate you all. Finally, Mark above hinted something about dual authentication, and from there I have used the Gmail application password, and it has sorted out the problem.
Back
Top Bottom