Search results

I need to convert json file from web to xml file and i need very simple way... There are several data I need from json response... There are a lot of around but they are not very clear... I found some samples like this: PS c:\0> ConvertTo-Xml -InputObject temp_JSON.json -As String PS c:\0>...

I'd like to generate dynamic expression from string e.g. from string SF = subfolder ' varable "or each" & SF & "in fso.folders.. " to For each subfolder in fso.folders .... where subfolder is variable Actually I need to examine contents in the parent folder which contains n not known...

I'm trying to Copy file (e.g. picture) from android device (e.g. cell phone, tablet...) to PC, but i did stack I did get the path and read and execute shell command to the device folder like device =...

I need to get path string to android device or its sd card as be able to copy or get some files(e.g. pictures) to process further.... As I red around not so menu samples about ... 1. I tried go get the file with file dialog "f = Application.FileDialog..." but the directory has not been showed...

Now I use wininet.dll library to get file and calculate progres of dowloading action .... it is something like this: Do If InternetReadFile(hRequest, VarPtr(Buffer(0)), BUF_SIZE, dwBytesRead) Then If WriteFile(hFile, VarPtr(Buffer(0)), dwBytesRead, dwBytesWritten, 0) Then...

I need to decrease default timeout (which is about 30 sec) in executing the followed code Private Const BUF_SIZE As Long = 4096 ' allocation buffer Private Const INVALID_HANDLE_VALUE As Long = (-1) Private Const CREATE_ALWAYS As Long = &H2&...

Enable and disable usb port .... Is it possible enable and disable a usb port via vba? An example of using this would be if I had a light plugged in a usb port and the code would turn it on and off. Or maybe is there s some...

SQL 2000 database I can't create root element with for xml auto, root "root" with bcp the xml file is created but root is not created.. Is it common with SQL 2000 database This works... but root element is not created exec master..xp_cmdshell 'bcp "select * from mytable" as ROW for xml auto ...

I need to insert(append) first and last line in xml file... So I have xml file and I need to insert one line to the top and at the of the text... Xml file contains Cyrillic characters and method to recreate xml file is going wrong with characters conversions... The last line a can append easy...

I need to retrieve Cyrillic data from MSSQL database with PHP but I get back "??????? I need to retrieve Cyrillic data from MSSQL database with PHP but I get back "???????" <?php $dbconn = new PDO('odbc:Driver=FreeTDS; Server=xxx.xxx.xxx.xx; Port=1433; Database=xxxxxx; UID=xxxx...

I need to Import table to access 2003 database from json file which i have received from public web service... I did before successfully from xml file.. is it possible from json file as well?

Is it possible to create simple web service with vb6/vba access 2003 to access sql database on server... In the biginig i need only to retrieve some data from sql database If it is..then please let some basic advice what to search around... If it is not some idea what free and simple software i...

So I do map drive on this way and it is successful ... Dim FSO As Object Dim objFile As Object Dim objFileS As Object Dim WshNet As Object persistent = false set objNetwork = CreateObject("WScript.Network") objNetwork.MapNetworkDrive "driveletter:", "\\server\sharename", persistent...

I want to set system time with vba code using win apis I use this code: Option Compare Database Option Explicit Private Declare Function SetSystemTime Lib "kernel32" (lpSystemTime As SYSTEMTIME) As Long Private Type SYSTEMTIME wYear As Integer wMonth As Integer wDayOfWeek As...

Is there a way to get all currently connected addresses to SQL server 2000 from vba client app connected to the server

I have MDB database linked to SQL SERVER through VPN connection... I created links to the sql server .. Links are dsnless... Everything works fine but when I lost VPN connection or sql connection has been broken I can't refresh links to the tables. I receive message 3146 sql connection failed...

Refresh linked tables when connection has been lost whit out closing access database I have MDB database linked to SQL SERVER through VPN connection... I create links to the sql server with dao method.. everything works fine but when I lost VPN connection i cant refresh links to the tables with...

I have MDE app in access 2003 ... in two client computers having win7 and msoffice 2007 doesn't work ... problem is progress bar control... error does not recognize object.. I put different versions of mscomctl,ocx file but no success... should i regiter ocx file some how or some other idea...

I need to stop already ran procedure or function with vba code So I use END command ans everything stops.. in some cases that is usefull , but some times need I to do something else after I use END command, but after END everything stops... LIKE THIS : SUB () END ME.CTL.SETFOCUS...

WHEN I USE SENDKEYS in XP i don't have any specific problems... but on win7 they make a lot of confusion with num lock ...when i use sendkeys in win7 num lock sometimes is going off ... so I red around that i could replace them with API but i didn't find any clear example... ANY IDEA TO SOLVE...