Search results

Hello all, I managed to find out why it didn't worked...because i needed something that would replicate wget (linux) and download some web filles (http,in my case). Unfortunately i didn't understood or explained very well what i wanted. I'm realy sorry for everyone that lost time with...

Hi, I've tried Private Sub Command0_Click() FileSystemObject.CopyFile "http://wsdfarm-brise-something/ExtractBOXI/Referentiel%20MSP/Tickets_CC_daily.xls", "\\dakar\soemthing\something2\works.xls" End Sub ,but I get the following error - Runtime error 424 - >Object required . I have the...

Hello, In excel the logic is at follows : open the workbook form the link - make it active - save active workbook as - to my local/network location. I want to do something similar but in Access And not in excel because i interrupt errors sometimes at the lines that should make the...

Hello, I've tried to use FSO with the code below : Dim fso As New FileSystemObject fso.CopyFile "http://wsdfarm-brise-something/ExtractBOXI/Referentiel%20MSP/Tickets_CC_daily.xls", "\\dakar\soemthing\something2\works.xls", True But it i get the following error : " Run-time error...

Hello Pat Hartman, Thank you for the reply and sorry for the delay. Here is the code used in excel: Kill "\\dakar\SSPO\L1\Customer Care\Reports\Tickets_CC_daily.xls" Workbooks.Open Filename:= _ "http://something/ExtractBOXI/something2/Tickets_CC_daily.xls"...

Hello all, At work I access my files thou an address in the browser like http://"ip address"/something/something2/ - here are some xls files ( this is a dummy link since i can't say the exact address ). From excel I can access this link and download a certain xls file that is generated...

Hello, Thanks to privateer managed to found the right solution. It looks like : sql2 = "Update T_all Set Used=""*""" sql2 = sql2 & " WHERE ( Email=""" & varwhereClause & """);" Once again thank you Privateer for the good direction. Regards,

Hello all, I have the following problem . I have a command button that inserts and e-mail adress in a table. In the same clikc event i want to update the field in another table that corresponds to the e-mail clicked. Unfortunately,don't know why ( probably because i don't know very well...

Hello, After a good night of sleep and some late night reading. I found something interesting regardinh data ranges and transferSpreadSheet - http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#ExpRange ( fo anyone that wants to read ). So i went in my excel and named the data ranges...

Hi, I've checked the documentation before and did try naming the tables with a shorter name ( even like onlu 1, 2 etc) For example i renamed the table tbl_timeline_towards_the_Country in tbl and worked,tried to do the same to the others..it stopped working.. Honestly don't know what to...

Hello, That's correct regarding the space where should be exported. But don't think is because of the space - since i have more rows and columns in the range specified ,than the data that will be exported ( we are taking about tables very small ). I'll try to see if using DAO for...

Hello, I've already done that and found out that 3 work without any problems and 3 don't/ The ones commented below are the ones that don't work. Yes i export all the data found in each table. Don't understand exact what you mean with the api selection ? DoCmd.TransferSpreadsheet...

Hello all, I have the a form with a button ( at least one of them does what i'll depict:) ) that should export some tables previously created by another command button ,to an existing excel file and each in a specifc cell range. The file is copied form a shared location to the folder...

Thank you very much for the help.

Hi, And it does. Thank you very much works great. I wish you all the best and a Happy new Year . The reason why i used why i used is simple,didn't know other way - i'm kinda a self learner when it comes to VBA/Access. Regards, ==== Small question : If i want to inset a caption changer in...

Hi, Thank you managed to make it work (cmd button) with the following code [Forms]![L2_FtGroup_Contacts]![L2_FtGroup_Contacts_sub].Form.AllowEdits = True So i've added another button to stop the editing with this code [Forms]![L2_FtGroup_Contacts]![L2_FtGroup_Contacts_sub].Form.AllowEdits...

Hello, As i Stated is a continuous form ( only made to loo like a dataheet) - so the form is continuous. Hopethis clears things a little. Regards,

Hello, Any ideas why is not working?

Hello all, And Merry Christmas . I have the folowing situation : - main form L2_FtGroup_Contacts - subform (continous,made to look like a datasheet) ,with AllowEdits NO by default - L2_FtGroup_Contacts_sub -in the Detail section of the subform (continuous) i have a button that...

Hello, I've managed to put up a solution for what i wanted. I post the code below for people that might want the same thing . So, i first filter the subform with a textbox ( has a on change event) - while the box is not empty the option group will get visible for more detail filtering...