Search results

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

@ Check your count of records returned by the source query for your report before trying to print it. If it's zero don't try and print it, and don't call your other routines. How do I do the count, sorry for sounding foolish????? Here is my query SELECT tblPOSStocksSold.ItemSoldID...

Dear all, Is it possible someone can have an idea how to call two functions immediately after successful printing of a receipt, the print function is stated below, and so once its run and the document comes out, I need to call the other two functions which links to two APIs to update inventory...

I want to implement the error handling mechanism in the code below, the objectives of the error handling are to give the error message and once the user click okay the code must exit the processing immediately. This will help to ensure that the stock levels are only updated once there no errors...

Sorry I think people misunderstood my situation here, the form data entry property is set to "YES" meaning once data saved , there will not be any opportunity to correct any errors at all because the data is gone for good unless if someone has an opportunity to correct it directly in the tables...