Search results

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.

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()

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

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

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.

still nothing is working out

its a single factor authentication

Many thanks to all contributors all your answers are valuable to me

Am trying to configure a simple email system in MS Access 2016 so that I can directly send invoices from MS Access 2016 using a form. I have put a button on a form as onclick event, but whenever, I try to send an email I'm getting an error message saying: "Check your internet", transportation...

Okay finally a wrapper has work to remove spaces Function spaceremove(strs) As String Dim str As String Dim nstr As String Dim sstr As String Dim x As Integer str = strs For x = 1 To VBA.Len(str) sstr = Left(Mid(str, x), 1) If sstr = " " Or sstr = " " Then Else nstr = nstr...

its actual leaving spaces on Me.txtlatsouth and Me.txtlongNorth MYURL = "https://api.openweathermap.org/data/2.5/weather?lat=" & Me.txtlatsouth & "&lon= " & Me.txtlongNorth & "&appid=xxxxxxxxxxxxxxxx" No space is allowed the URL should like below then it works ok, the issue is how to remove...

This what I'm doing : MYURL = "https://api.openweathermap.org/data/2.5/weather?lat=" & Me.txtlatsouth & "&lon= " & Me.txtlongNorth & "&appid=xxxxxxxxxxxxxxxx" Its failing it bring type mismatch

I need help to solve the parameters in this URL string below which is working okay as long as the parameters are hard codded , now I want the parameters to be more flexible by providing some kind of input form parameters like below: Here are the parameters: Me.txtlatsouth = -15 (where there is...

My apologies people I forgot the last field required as well, its called humidity Me.txthumitity = Json("main")(1)("humidity") This the last field required for the weather pattern, sorry to trouble you again { "coord": { "lon": 28, "lat": -15 }, "weather": [ { "id"...

Many thanks Cheekybuddha your method has worked very well it's unbelievable. Many thanks to you

Many thanks CJ you were 100% correct on DMax , it did the magic everything is now working okay

Okay thanks CJ let me try it

Okay the problem here is that this field ImportID" is not part of Json I just wanted to link the data to the primary key in the parent table because if I do not do that the same field in the Child will appear quite okay, but the reference remains hidden that is where my problem is. But I can...

I have imported the data from the internet successfully, but surprising I'm failing to save it in the database, below is my code what is the problem here: Private Sub CmdImports_Click() Dim n As Integer Dim Request As Object Dim strData As String Dim stUrl As String Dim Response As String Dim...

@ GPGeorge your response is well respected thank you