Recent content by LeanneGodney

Hello, My exchange email goes to my exchange mailbox. But my POP mail goes to a local PST file... So I can't see any link between them, which is what has me stumped..? Leanne

Sorry, in Outlook.

Hi there, I have exchange 2010 but I also have two or three POP email accounts that I use. The POP mail has it's own SMTP address, and mail is delivered to a different store. However, when it tries to send my pop mail says that the Exchange Server is offline and therefore cannot send... Very...

Hi everyone, I have a small/medium business that specialises in IT Training as well as training room hire. This means that we run our own training courses but we also hire out our facilities to outside clients. Some of these clients run their own online courses, requiring very fast, reliable...

Hi there, I am trying to retrieve information from Business Objects into an Excel spreadsheet, using VBA. I'm aware of (and am currently using) the export option. But ideally I'd like to use an ADODB Recordset, or something similar to grab the results of a report in Business Objects into a...

Hi there, Your sample code doesn't use a proxy server. This is the sum of my problem - need to get it to work through a proxy. Leanne

Hi guys, I'm trying to write code to retrieve a file from my clients ftp server. If I do it manually, I do the following: 1. Open up the command prompt 2. Type FTP proxyserver 3. Enter my username and password 4. Connect to client site by entering "user username@clientFTPSite.com" 5...

Hello, All macros are self contained, and have their own declaratives, etc etc, so putting them into one would not work. For anyone else who may want to do this, I've figured out how to do it: You ahve to create a new instance of Excel, cos you can't compile code while it's running. You...

Yes, I realise that. That isn't an option.

Hi there, I have an application of hundreds of Excel macro files that all reference one central excel file. This central excel file acts like an add-in. If I make changes to this main file it could have knock on effects on the individual macros using it. I would like to be able to run some...

Hi there, I am using Access 2002 ADP and SQL Server 2000. I am using a disconnected recordset which is being used as the recordset of a form. Through code if I write to the RS then on occasion it doesn't display this change unless I use the RS.update feature. Under normal circumstances this...

Yes I have. Often get an error saying that the method failed writing to the textbox. I used to write to the forms control initially, but that started failing, so moved to the disconnected recordset. i've actually sorted this problem out with a hacker fix... Instead of writing to the...

Hi there, I'm having quite a big issue with my ADP at the moment. I have a disconnected recordset that is created when the form opens. The form's recordset is set to the disconnected recordset. The user starts adding a new record. For my date fields I don't allow manual entry because of...

Thanks for letting me know! You're a great help cmmrfrds! :0) Leanne

I would want to do a select distinct to get unique values from a particular field, for example. But I've wanted to do something like this before for other reasons and haven't been able to figure out how. So I guess it's not possible then?