Search results for query: *

Afternoon everyone. I recently purchased a PHP script from someone and am having difficulty getting it to work. I am not knowledgeable enough in PHP to figure it out and can't get a reply back from the guy I bought it from. I can post the errors here and hopefully someone can tell what I am...

Good Morning everyone. I have a small issue that I'm hoping someone has an easy fix to. I have an Excel spreadsheet that is output from an Access database. I then do a pivot table on this spreadsheet. The problem that I am running into is that the pivot table does not recognize the blank...

I have a little Access issue I'm hoping that someone here could help me with. You guys have helped me out so much in the past and it has been most appreciated. I have two scenarios that are very similar, but one is slightly different. Scenario #1: I have a Table named SO COMBINED DATA that...

Is there a way to have access clear the contents of certain fields based upon a set criteria? I don't want to delete the entire record. I just need to clear the field if it equals "00/00/00" or "EMPTY". Any ideas would be most appreciated. Thanks!

Hey guys and gals, I am trying to run a function that will calulate the number of workdays between 2 dates and take into account holidays as listed in a seperate table. I found the info below in the Tek-Tips archives, but can't seem to get it to work. I have saved the info into a module and...

Hey guys and gals, I am trying to run a function that will calulate the number of workdays between 2 dates and take into account holidays as listed in a seperate table. I found the info below in the Tek-Tips archives, but can't seem to get it to work. I have saved the info into a module and...

OK, guys and gals, I need a little assistance. I have a spreadsheet containing a macro that will merge columns B & C into one column and place an "-" between the data. It is as follows: *************** Sub mergecells() Dim intRow As Integer Dim txt As String intRow = 2...

OK, guys and gals, I need a little assistance. I have a spreadsheet containing a macro that will merge columns B & C into one column and place an "-" between the data. It is as follows: *************** Sub mergecells() Dim intRow As Integer Dim txt As String intRow = 2...

Hi guys, I was wondering if one or more of you might be able to help me. I need a macro that will compare column C in 2 seperate workbooks (workbook A & B) and change the font color of any values in workbook A that are not in workbook B. Basically I have a report that is run daily listing...

OK, so here's my question. I have the javascript below that will ask a person their favorite color upon entering a webpage and automatically display that color and remember it next time they enter that site. What I would like to do is have it ask them their favorite college sports team...

Anyone have a piece of code that will scan column A for any cells with a value of #N/A and change the font color of that entire row to RED? Thanks for your help!

Ok, you brainiacs, is there a macro that can be written that will make Excel automatically email the current spreadsheet or workbook to someone? I have a spreadsheet that I'm running various macros on and in the middle of this process, I have to email it to certain individuals before I make...

OK guys and gals, I have a piece of code for Access that calculates the number of work days between 2 given dates. However, this code does not take into account any Holidays that may exist. Can someone please show me how to modify or write new code that can calculate the number of workdays...

I have a Access table that contains many duplicate records. One of the fields within this table is a date field. I am needing some code (or something) that will delete all the duplicate records except the one with the earliest date. Any ideas? THX! Examples: SO NUMBER LOA LOC SO VERSION...

OK, need a hand here. This should be a simple piece of code, I think. I need a piece of code that will look at the contents of column H, and if it equals "00/00/00", I need it to clear the contents of column M on the same row. Thanks!

I have a column of data that I am trying to clean up. I want to write a macro that will delete the entire row in which this particular column starts with TU. The column is filled with items like TU10, TU15, TU30, etc. I have this so far: Do Until ActiveCell.Value = "" If...