Search results for query: *

How make "strsql" string get value of field in the current recordset line. I tryed this: Dim Rst As DAO.Recordset Set Rst = CurrentDb.OpenRecordset("ConsultaIPE") Dim Link As Variant With Rst .MoveFirst While Not .EOF Dim strsql As String ... strsql = "INSERT INTO...

Hi, i need of a method to store the Time() value (like recordset) and get this value in a posterior time without using extra files or table. Thanks

How can i set the right encoding into my post request function? I tried : .setRequestHeader'encoding','ISO-8859-1' But dont work obs: the response xml have this header: <?xml version=""1.0"" encoding=""ISO-8859-1"" ?> The function Function HTTPSessionRequest(method, url, data) Dim poStvars...

Hi, i don`t know how but i need a way to make one code to: * For each line in table name "resposta" get column "link" value and execute this link(all the links contain files like 300kb~400kb) * How make vba wait the download complete to continue the routine? thanks a lot!

Hi friends, i have this: Sub vai() Dim dinicial As Date, dfinal As Date, data As Date Dim hinicial, strhinicial dinicial = DateValue(Form_Atualiza.[date1]) dfinal = DateValue(Form_Atualiza.[date2]) hinicial = Form_Atualiza.[hora] strhinicial = Format(hinicial, "hh:mm") data = dinicial For...

Hi!, i can not insert 3 strings values in 3 table fields! I think the fault is the string "strDOCfile = f.Name" because his value is a file name like "file.DOC" and i have operator error on debugger. Sub EBA() Dim fs, f, s Dim SourceDir As String 'The source directory Dim ArqExiste As Boolean...

Guys, i have two text field in access form.[date1] and [date2]. In field [date1] i put the initial date value and [date2] i put the end date value. like: [01/10/2009] [03/10/2009] Obs:format date(dd/mm/yyyy) I need a code to call one sub for each date between fields [date1] and [date2]...

Hi, i have in my access2007 project one vb module with reference to msxml4.dll(Microsoft xml, v4.0) and scrrun.dll(Microsoft Scripting Rintime). I need a way to make my project run in others pc's without these dll's pre installed. But a way without user interention. Sorry for my english...

Guys, i need a way to make this request(html code(post method)) and get all links from the response page and insert the links in a ms access table. i use Ms access 2007 but i have a lot of results in google finding by "http post method vb" but i cant make the code work please guys help!! The...

Hy, i need a vba code to insert all data from access table into mysql table. I tryed "DoCmd.TransferDatabase acExport" but this send the table object to mysql. Help please.