Recent content by lorveney

Further to this, when I use: xxx = Dir("C:\Myfolder\*.xls") I get the name of the first Excel file in the C:\Myfolder directory. What is the equivalent command I should use to get the same from the web folder Myfolder on http://xxx.uk.yyysrv.net/ParentFolder/MyFolder

What I want to be able to do is allow the user to browse through the sharepoint folder structure and select the folder they wish to process. Then using the selected folder, process each of the Excel files it contains one by one. This is what the Getfolder (SHBrowseForFolder function) currently...

Hi All, I currently have an Access VBA module that browses for a folder name using Getfolder (SHBrowseForFolder function), then gets a list of all the Excel files in the chosen folder using Dir(folder & "\*.xls") and opens and processes each file in turn using Excel Automation. Can anyone tell...

Decided to go with adding an AfterUpdate event to all 61 textbox controls. Actually, didn't take too long by cutting and pasting between VBA and Word. Seems to work ok anyway. Thanks for your help

Hi Guys, Has anyone got any experience of using the SHBrowseForFolder function to get a Web Folder path. With what I have got so far, it will sometimes, but not always, show the Web Folder structure in the Get Folder window but even when it does, the return value only gives the folder name, not...

Unfortunately, the Form_Dirty event fires before the new value in the text box is fully input (and therefore before the totals have been recalculated), plus it will only fire the first time a field is changed, not on subsequent changes to that field or any other field on the form.

Hi Rabbie, Won't that vary depending on the text e.g. wont IIIIII take up less space than XXXXXX?

Apologies if this has been asked before …. I have not been able to find an answer for it in the forums. I have a fixed format, single page, report with many fields on it, several of which are Memo fields. On some occasions, the report field is insufficiently sized to take all the text and I...

Yes, I realise that Dennisk, as I said "I realise I could attach an event to each of the fifty or so text boxes to achieve this but was looking for a quicker, more elegant, solution first. "

Hi Guys, Apologies if this has been asked before …. I have not been able to find an answer for it in the forums. I have a form with in excess of fifty text boxes on it (actual & forecast spend by month, subcategorised by operational and capital spend, with totalling to give total forecasted...