Search results

Hello again, When making an api call to an external website, it returns with the following: (example) {"ip":"XX.XXX.XX.XX","location":{"country":"SK","region":"","city":"Rev\u00faca","lat":48.68346,"lng":20.11734,"postalCode":"","timezone":"+01:00"," etc... I am trying to convert that so that...

Hi all, I am getting a syntax error when I try to execute this piece of code: DoCmd.RunSQL "INSERT INTO tblLogins " _ & "(lkpUser, lstAppName, lstLogType, lkpWorkstation, chrPubIP, chrLocIP, chrLogInLocation, chrLoginRegion, chrLoginCountry, chrTimeZone, chrTimeStampUTC, chrSSID)...

Hi, I found this function to get my public IP: Function GetMyPublicIP() As String Dim HttpRequest As Object On Error Resume Next 'Create the XMLHttpRequest object. Set HttpRequest = CreateObject("MSXML2.XMLHTTP") 'Check if the object was created. If Err.Number <> 0...

Hi all, I am trying to display data from an xml file that I can get from the web. Here's how it works: If I call this URL in a browser...

Hi guys, Creating a query in design view, I want to use the value of a particular text box in an open form. So, I write something like this in the 'Criteria' row of the query design view: [forms]![myForm].[TextBoxName] So be it. It works. Is there any possibility to tell the query to pick up...

Hi all, I am hitting a snag with the display of linked pictures on one of my forms: I create an Image on the form, and use as Control Source an other field on that form that contains the path to the Image I want to display. As long as I use a path on a local hard drive, like...

Hi all, I am trying to achieve this: On a form, I would like to display automatically the status of the current network connection of the computer where the database is running. Additionally, I would also like Access to display whether a VPN connection is active or not on that form. I tried...

Hi all, I would like to display the status of the network connection on a form. Here is what I have done so far: 1. I put this code in the (General) section of my form: Private Sub Connection_Status() Dim Network_Cnx As String If My.Computer.Network.IsAvailable Then Network_Cnx = "UP"...

Hi all, My issue: I have a text box, called CID on a form. With a click of a button I would like to pass the value of that text box to a box where I see a list of values taken from a table (the name of the list box is Customer) I used this in the code for the onclick event of the button...

Helo databaser firends, I am Jeff, Belgian "retired-ish" air traffic controller. I used to be very active in the aeronautical field in the development of Airport Collaborative Decision making (A-CDM) software. That would be how you see when the flight you are awaiting is going to land, at which...