Search results

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

Well said the doc man and highly appreciated. Just for curiosity's sake, since I'm able to access the resources on the local network by do the following (1) "http://192.168.xxx.x.xx:8080/XXXXXXXXXXXXXXXXXXXXX" Dim Request As Object Dim stUrl As String Dim Response As String Dim requestBody As...

I'm not sure whether I got a response on this, I have staff who are relatively new and so are not competent to process the landed costing, since we are using the cloud accounting software, I'm able to see their work where we are based. The problem here how to approve their work digitally since...

The printing is called automatically after the last API is complete, the only problem is the last call function is updating the stock twice, but if I use the onclick button all is fine, could it be I'm doing something wrong on the code below? If (DCount("ItemSoldID", "QryPosReceipts"...

Okay thanks Minty the rest I will do it