Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by LeanneGodney

  1. LeanneGodney

    Why would my POP mail refuse to send when Exchange Server is offline?

    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
  2. LeanneGodney

    Why would my POP mail refuse to send when Exchange Server is offline?

    Sorry, in Outlook.
  3. LeanneGodney

    Why would my POP mail refuse to send when Exchange Server is offline?

    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...
  4. LeanneGodney

    Which Cisco Router?

    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...
  5. LeanneGodney

    Business Objects and ADO Recordsets

    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...
  6. LeanneGodney

    FTP Through Proxy

    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
  7. LeanneGodney

    FTP Through Proxy

    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...
  8. LeanneGodney

    Compile Excel through VBA Code

    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...
  9. LeanneGodney

    Compile Excel through VBA Code

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

    Compile Excel through VBA Code

    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...
  11. LeanneGodney

    Disconnected recordset - rs.update makes unstable

    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...
  12. LeanneGodney

    Disconnected Recordset Not Recognising new record added within form

    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...
  13. LeanneGodney

    Disconnected Recordset Not Recognising new record added within form

    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...
  14. LeanneGodney

    Do a select on an adodp recordset into another recordset

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

    Do a select on an adodp recordset into another recordset

    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?
See more

Part and Inventory Search

Back
Top