Recent content by sandybam

Works like a charm! Thank you,

Hi All, I would like to figure out how to identify a future date using an identified date and adding only work days in Excel. So for instance, today is 7/15 what date would it be 20 work days from now (M-F)? Thank you for your help. Sandy

Hi All, I have an Excel spreadsheet with the following conditional formatting set in a macro. When this macro runs it highlights fields that are null. How can I only highlight those fields that are populated? Here is what we have: Columns("H:H").Select Selection.FormatConditions.Delete...

Sorry about that. I meant for this to be a new post and not a tag onto where I placed it. Sorry...

Hi All, I have an Excel spreadsheet with the following conditional formatting set in a macro. When this macro runs it highlights fields that are null. How can I only highlight those fields that are populated? Here is what we have: Columns("H:H").Select Selection.FormatConditions.Delete...

Easy as that! You guys are so awesome. Thank you for the speedy reply! Sandy

Hi All, I understand how to highlight every other row in an Excel spreadsheet using conditional formatting and the mod() function. Is there a way to highlight every other data grouping such as by State? My spreadsheet fields are as follows: A: AgencyName B: AgencyAddress C: AgencyCity D...

Thank you for the suggestions! Sandy

Hi All, I am looking for a program comparable to GeoAccess. I need the ability to develop maps using data I currently have housed in Access. Any suggestions?

Bob, Thank you for such a quick response. When I use this code the query returns all records that satisfy the query criteria and has a value in the cbofederalbuilding field. Since this is not a required field some records will have a Null value for this field. I would like to be able to have...

Hi All, I have a search form named SV Search Menu, which includes the following fields: Agency Number Name State Rep cboFederalBuilding All of the fields are required for data entry except the cboFederalBuilding field. What I am trying to do is run a query using the search form criteria...

Thank you! The isnull did the trick! I appreciate your quick response. Sandy

Hi All, I have a form that I use to run roll up reports by Colleague, Team or Auditor. The team and auditor report is the same but the colleague report is different. I would like to use the same form and report button to run either report. Here is the code I am using for my report run...

Hi All, I am trying to append some data from one database to another using an append query. The database I would like to append to has a password and I keep getting a "Not a valid password" error when I run the query. This is what my file name looks like in the append file name box...

I have two sets of dots for each of the ranges, a total of 10 dots. There is one dot represented for each percentile. For instance, there is one dot for 95% instead of 4 dots. When I hold my cursor over the dot it will tell me that that dot represents 4 however this is not useful once the...