Search results for query: *

I am trying to write code that will check only certain cell dependent on row. In this case certain cells that are below a given number are red and rest are green. How ever I am getting an error: Run-time error '1004': Unable to set the ColorIndex property of the Interior class Here is the...

I am working with data that has to be pulled by way of txt file due to the database is propriatary. The information goes into a excel spreedsheet first from the txt file so that I can cut it up and grap only what I need. The next step is sending it to an access database. The only thing is that...

I am bringing in data that is setup with date and time but once in I need to get rid of the time. I am not sure what vba function I can use to change the format to only have the date and the time be totally erased so that I can line things up by date in a pivot table without the issue of time...

I am working on vba to setup a pivot table but only what values of certain things to show. Currently I have: With ActiveSheet.PivotTables("PivotTable4").PivotFields("Pkg") .PivotItems("AUTO03F").Visible = False .PivotItems("AUTO20F").Visible = False...

I am trying to get it so that if I have multiple entries for products I just want the last time for each of the products. An example of the data is: Date Customer Date/Time 29-Sep-04 1594301 9/29/2004 23:00 29-Sep-04 1100501 9/29/2004 23:00 29-Sep-04 1594201 9/29/2004 23:00 29-Sep-04 919101...

I just want to do something that I would think is easy but it is not not just pasting and I do not have any of my outlook books here. I am wanting to take a graph off a excel spreadsheet and place it on an email in outlook.

I had the IIS 5.1 setup working on an XP earlier with help a few weeks ago. Today I was trying to change the defualt but was not sure at what level to do it and deleted and reput on several defualt types but now no defualt page is coming up just a (You are not authorized to view this page)...

I have a pivot table that has a field that contains sever all things of informatio and am trying to get it to align a certain way. It look like this in the field: 020202 john henry VC 123454534212 fkjdf 040302 max lock MX 342342343444 jdfls 090403 Jennifer Whobio MC...

I have a search function created that will allow people to look for titles but two issues I am coming accross is that if you place a ' in the query it sees it as end of the quary item for that field and will error out. The other is if you put in an extra space at the end it will not locate the...

I am trying to find how in C# I can look at the link between is and a database and the fields it looks like and what they are named for programming or atleast point me to a forum that would know.

I use to be an Oracle programmer/analyst and we had a tool that made it easy to write code all in one application. I believe it was called Notpad Plus. It allowed you to put set up the basic code rules for diffrent languages. So, if I wanted to write a pro*C I would activate the settings...

I use to be an Oracle programmer/analyst and we had a tool that made it easy to write code all in one application. I believe it was called Notpad Plus. It allowed you to put set up the basic code rules for diffrent languages. So, if I wanted to write a pro*C I would activate the settings...

I am working on a report that is being created in Crystal but part of the information comes from our SQL server tables and the other part comes from a table created in dbase IV. The information from the dbase IV is braught into a SQL server table but everthing that is converted comes in as a...

I am trying to locat customers that have one product but not the other. I am sure this is not that hard but just not much time to play. Example: Lets say that a company offers three types of insurance (health, life, and long term). For each product the customer has is another entry on a give...

We got the new virus an it has infected our temp files and wanted to make sure the we can delete the WINNT/temp files if exchange sits on the server. Thanks!!

Okay, I am new dealing with quark and am trying to help a publication company find the quickest and most functional way to turn Quark or PDF files into HTML and the code still needs to be fairly clean so that a text editor could be used for any quick changes and removing and images that we are...

Ok, I know for getting the top 50 files I would do this: Select Top 50 a, b, c from data but how I get the bottom 50?

Okay, I know this one has been asked alot but I can not seem to find one that exactly fits my issue. I am trying to network an XPpro to a 98SE. The two computer are connected to a Hub that is connected to a router that connects to my cable modem. I setup the MACaddress from my XP machine on...

I tried this and got that is wanted the actual names in the group by but then I put the names of the fields in the group by and it still did not like it. error and code fallow Server: Msg 8118, Level 16, State 1, Line 1 Column 'cpn.PMO_DSC' is invalid in the select list because it is not...

Can I do an outer select on a union all. select fields from( select fields from tables where rules union all select fields from tables where rules ) group by fields