Search results for query: *

I'm trying to write a report that will group the results by information that is only available by a Formula. CR is throwing an error stating "Group specified on a non-recurring field" and references the formula I've created. The formula is correct, but does not appear to be a valid formula for...

Simian, thanks for the reply. Yes, all the backups in question have a .bak extension. Randy Davis Denver, CO

Hey gang. Thanks for all the help you give. I have a SQL Server 2008 R2 database that gets backed up every night. Logs show that these backups are successful, and I can locate all of them in the file system. However, when attempting to do a restore through SSMS, not all files are visible in...

I have Acrobat 9 Pro installed and can "Combine supported files in Acrobat..." through Win Explorer. Is is possible to do this through a command line? Randy Davis Denver, CO

Hey guys, I hope someone can help. I've written a macro that pulls in data from a CSV file in Excel and formats it. Is there a way to capture the file date/time of the csv file? I want to be able to use it to display the age of the data. Randy Davis Denver, CO

Our shop has very recently began to deploy Windows 7 computers to our field staff and we are running into problems remotely supporting them properly. When using GoToAssist (GTA, or any other remote support application), Windows 7 security features get in the way. Our policy is that users are...

I was able to figure out the solution: RowCount = Range("A3").CurrentRegion.Rows.Count Range("C1:G" & RowCount).Select Randy Davis Denver, CO

I have a range of data from a1:g-. The number of rows in this range vary. I need to be able to select only columns c:f and only the rows that are part of the CurrentRange. Put another way, I need to select only certain contiguous columns from the CurrentRange. I'd appreciate anyone pointing...

Thanks, Brad Randy Davis The Technology Firm Denver, CO

Yes, I understand relative addressing. And I've gone ahead and done just that. However, I just trying to better understand the OFFSET function. So my question still stands. Is there a way to reference the current cell from within another function? Randy Davis The Technology Firm Denver, CO

Thanks for the responses. Sorry about not being explicit enough. Sometimes I think I give too much information. Let say: B2 65.75 C2 =INDEX({"F";"D";"C";"B";"A"},MATCH(B2,{0;60;70;80;90})) <Yes, its a grading spreadsheet> This is easy enough and it works. However, there are several...

How do you reference the cell address of the formula you are creating? For instance, I want to make a calculation in a certain cell based on a value in the cell to the left. Both of the following produce an error: =OFFSET(CELL("address"),0,-1) =OFFSET(ADDRESS(ROW(),COLUMN()),0,-1) I think...

Single profile on my home computer cannot access the Web. I have enough experience to rule out several things, but after spending a couple hours on this... Datails: Running XP Pro, IE8, DSL through Secured Access Point. Single profile is affected - a limited account. DNS is not the issue as I...