Search results for query: *

Hap, I'm not sure where I'd upload these files to. Any suggestions. I don't think I've ever uploaded any files using ftp. All my files reside locally on an intranet for the school. Paul

Sorry Hap. I haven't visited this page since mid May and missed your post completely. Are you still interested in those samples? Paul

You can look at the FileSysObject() Pretty sure you can grab the contents of an XML file and save it to a table to use in your List box. Paul

To interact with a web page, you need to use a server side language. ASP works very well for something like this. If you use ASP then you can use VBScript which is a lot like VBA. It's not hard to do, but it's not something that would be easy to describe to someone who doesn't know anything...

[2thumbsup]

You can look at the FileSystemObject.OpenTextFile(fname,mode,create,format) or some of the other FileSystemObjects. If you open it for appending, you may be able to use the Replace() function to find ">" and "<" and replace them with the "^". FileSystemObjects is usually listed under ASP...

Well you can use ADO to grab the data from the Access database and use the connect string to input your UID PWD etc, but then you will need to use a server side language to post the info into a web page (form). More info would help, or you could post this in the ASP forum. Paul

Thanks, yes, that's where I've remapped her paths to trusted locations. I finally got this just a few minutes ago. I wiped out all her locations, changed her Message bar in the trusted locations to 'Show message bar for all applications where content is blocked'. Then when I went back in I...

I have a db on the network that 2 of us use. On my pc, it runs fine. The AutoExec macro works and all the VBA event procedures work. On our Admin Assistants machine, the AutoExec Macro works but none of the VBA code executes. If I type something in her Immediate Window like ?Asc("m") I get...

Thanks linney. My work involves databases and some Intranet work. I don't know the first thing about OS's but will have someone log me in as admin and take a look at the logs. I've talked with one of these guys when he was doing some updates on my PC but didn't get an answer I thought was...

This seems weird to me, but when I go home at night (or leave my pc for short periods sometimes), my machine will lock itself. When it does that, it dumps my cookies (are they session cookies?). I'm not sure it actually dumps them, but, for example, when I open Tek-Tips I have to log back in...

And don't forget PIN number. Paul

I found another, probably easier way to do the same thing using this type of Outlook MailItem Sub CreateHTMLMail() 'Creates a new e-mail item and modifies its properties. Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem Set olApp = Outlook.Application 'Create...

I found a reasonable work around to this. I created an HTML page that had the <a href tag set up so that it displayed the link the way I want. Then I put that HTML page into my email using a File System Object. Dim filesys, filetxt Const ForReading = 1, ForWriting = 2, ForAppending = 8 Set...

I have to generate bulk emails using VBA. The email includes a link in it to a page on our intranet. I don't want the actual link to show but would rather cover it in a manner similar to TGML or HTML methods. In TGML, you can have something like this: Google and you end up seeing Google Is it...

Your new director seems to wrap up her entire self worth in her degrees. She has all these credentials, you have none, and yet you have earned more than her at times, gotten raises and promotions along with her and have a relationship with the CFO that threatens her. She's laboring under the...

I was just talking with one of the guys here in the office (not an IT guy). He said his son, who is just high school age, is thinking of getting into networking. I told him I thought he should add security to his list of studies because over the next 10 years I expect that jobs for IT security...

Being just a spit up the road from Springfield, it's good to know Merriam Webster is looking out for our linguistic well being. My vote for word of the year would be 'vilified'. Has a real 21st century ring to it. [#-)] Paul

@SQLSister I've fallen off a few of them myself but always got back on. Paul

One I use all the time is "It's like falling off a horse, you never forget how" Paul