Recent content by izzyq

I'm running a windows xp operating system and I was wondering if it's possible to password protect my internet explorer browser. I just want it to prompt me for a username and password. I'm connected to the internet via ADSL and I only want to allow certain members of my team access to the...

Would these be the same steps that I would take for Outlook 2000? Help Me Obi Wan Kenobi, You're My Only Hope.

Just had a major catastrophe with my PC and I'm looking for a new backup device that will have an option for me to schedule mu backups daily. I currently have a CD Burner but it's jus not cutting it. I've looked into the new 750MB Iomega ZIP drive that comes with software which will allow me to...

TheOldMan346, Thanks for those links, they're pretty helpful. One problem I've run into after following your instructions is that my MS Outlook can no longer find the email server to send or receive. I can access the internet okay, but the email is out of comission. I'm running Windows XP if...

From what I've read, you can't prevent MS Outlook from blocking an .mdb file...amongst other files but does anyone know an alternative way of transferring these files without having to use another email program. I'm currently using MS Outlook 2002 on an XP operating system Thanks Help Me Obi...

I've set up an FTP server at home(Serv-U) and I'm trying to access files via the internet explorer FTP function. The only thing is that I have a linksys firewall at home and I'm not quite sure how to get around it. I access the internet at school so the IP address is constantly changing so I...

It's a reference package that gets exported to word as RTF and then sent out to multiple users. Unfortunately it is very time consuming as it is print the single package let alone ten single reports. It also get's manipulated in Word to add a table of contents and other items but when we...

If you are conglomerating 10 different reports into one large one, is there a way to set it up so that each of the 10 reports begins on it's own page? Help Me Obi Wan Kenobi, You're My Only Hope.

I have created a macro that will run an access database query and copy the results into Excel. It runs fairly well except on one PC where it gives me a: "Run-time error '3706' Provider cannot be found. It may not be properly installed." The error occurs in this particular line of...

I've recorded a macro to update the Table of contents in my document, but when I run the macro it duplicates the headings. The document is somewhat complicated in that it is an access report that is saved as RIch Text Format and inserted into the word document. There is macro in word that is...

Thanks Geoff and Mike, works like a charm. Although, I had just assumed that this would bring in the titles of the columns from the access database and paste them in the excel sheet. In this case it's not happening. Am I missing something. Help Me Obi Wan Kenobi, You're My Only Hope.

I'm getting a Run-time error '91': Object Variable or with block variable not set. Could anyone give me some insight on why this is occurring. The line that it is occuring on, I've put stars beside. Thank You Option Explicit Sub GetData2() Dim cnt As New ADODB.Connection Dim rst As...

I'm getting a Run-time error '91': Object Variable or with block variable not set. Could anyone give me some insight on why this is occurring. The line that it is occuring on, I've hightlighted in red. Thank You Option Explicit Sub GetData2() Dim cnt As New ADODB.Connection Dim...

What is the syntax to pick a specifcally named sheet to paste to instead of the "active sheet". The sheet name would be "2002". What I have so far will copy info from a database and paste it into the active sheet: Option Explicit Sub GetData2() Dim cnt As New...

I received this peice of code from a friend to bring in an access query into excel but I am having trouble with an error. "Compile Error: User Defined type not defined". I am not quite sure of the syntax to correct this error. This is the code that I have so far: The error seems to be...