Search results for query: *

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

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

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

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

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

How would I go about geting a macro that will allow me to delete any row in a range that contains a zero value. I have a range "A6:C1003" and there are rows where all three columns contain zeros which I need to delete. For example columns A,B and C row 45, 48, 98 contain zeros. The...

I've been having this application error continuously for the past month and have not been able to figure out what the problem is. I have a couple of excel sheets with multiple charts in them that are getting their info from a data sheet via links. The application error is completely random and...

What is the syntax when trying to use multiple criteria for filtering data in an area. The way I have been doing it is like so...

Is it possible to add multiple (<>) Not equal to Criteria when trying to filter out an access query. For Example returning data that does not equal 50948E and 54806L and 54821. Help Me Obi Wan Kenobi, You're My Only Hope.

Is it possible for me to manipulate this code such that if the filename is OPEX Variance Analysis rev.2.xls it will run the macro, otherwise, nothing will happen. Here is the code that I have so far. Option Explicit Private Sub Workbook_Open() Dim filename As String If filename =...

Is there a way that I can delete a specific range in an excel worksheet when the user either saved the workbook or closed the workbook Help Me Obi Wan Kenobi, You're My Only Hope.

I have a peice of code that allows me to copy a range of A29:T53 from an excel file to a cell A1 of a new excel sheet. It continues to give me an Invalid Qualifier Error at the &quot;copy cell values&quot; action. Here is the code and the error: The invalid qualifier is in red Option Explicit...

One question that I had was in the my case where I am going to now be copying the range K29:t53, how do I get it copy starting at cell A1 in the new sheet? Presently it copies it to cells K29:T53 in the new sheet. Also, is there a way to copy the informatio to one single new sheet rather than...

How would I go about writing a macro that would allow me to to go through 10-12 XL files in a directory and copy the same range,A2-M200 for example, from all of them and to a new workbook or sheet. Help Me Obi Wan Kenobi, You're My Only Hope.