Search results for query: *

Hello-- I need to start getting data from Google Analytics. The tool is equipped to 1)export data in CSV format as well as 2)email the csv file. However, the format is not useable. The data I want is there, but underneath a few rows of junk (titles, etc.). I know it is possible to pick...

Hi There-- I am wondering how you would assign ranks to records based on their values--i.e. the record with the highest value gets 1, the record with the second highest value gets 2, etc. Ultimately I need a query that will have 5 original fields and 5 calculated fields which contain rankings...

Hello- I am wondering if there is an easy way to build a formula field in one subreport which uses fields from two other subreports. Thanks for the help!

Thank you lbass. Needed to change to left outer joins between tables as not all records matched. Thanks again.

Hello-- I am building a very simple report which pulls a couple of metrics by date from an Access table. The date range in question is basically 09/01/2007 - 02/12/2008. For some reason, the report will not pull anything from 2008. When I specifically state in the select expert that the...

Hey Madawc...that works perfectly! Thanks for the help. (It's version 11 by the way.)

Hi there-- I am building a report that has 8 fields, the first being date (mm/dd/yyyy). The report reflects a month of data and has subtotals grouped on both the weekly and monthly level. I successfully used the WeightedAverage function to calculate subtotals at the weekly level for 3...

Hi JerryKlmns-- Yes, it does query Access for data. I will try looking in the forum you suggested for a solution. Thanks--

Hi There-- I can open the Excel template I want from Access, however, the underlying data query does not run upon opening. The code I am using is as follows: Private Sub cmdProtocol_Click() Dim oXL As Object Dim oExcel As Object Dim sFullPath As String sFullPath = "...template.xlt" Set...

Hi-- When trying to use a loop to import multiple worksheets from a workbook, I get run time error 3051: "MS Jet Engine cannot open (string)...it is already open by another user or you need permission to view its data." The file in question is neither in use by another user or...

All-- The code I had in there works ok as the date entered in the text box has a custom input mask. The problem ended up being changing If BooleanValue IS False to If BooleanValue = False. I changed Resume to GoTo as well. Thank you for the help!

Hi there, I am trying to use a DLookup function to scan an existing table for a specified date value. If the value is found, the procedure will terminate with a message box. If the value is not found, the procedure will continue and import the specified Excel sheet. The code I wrote to do...

Not sure if that was a rhetorical question or not but you're a genius! I had asigned 2 variables to b. Thanks again for the help.

Hi Skip-- I have. In fact I read your article before posting this thread. Stepping through the code is the baffling part. I watch all the variables adjust as they should in the Watch Window as the loops execute and every thing runs normally. However, after the third outer loop (it should...

Hi-- This is another question related to the code posted in the "Error Handler Only Works Once" thread. I implemented the suggestions provided regarding the error handler and made some additional necessary tweaks to the code. The problem I am having now is that the outer loop goes to "exit...

All-- Thanks for the help. I think we may have the answer! I'll let you know if problems remain...

Good point. I did not account for none of the 4 variables being present on the sheet. This will have to be worked into the code as well. However, what I'm dealing with now is that values 3778, 3779, and 3780 are in the first worksheet. When it cannot find 3797 the error handler works...

DNIS1 = "3778" DNIS2 = "3779" DNIS3 = "3780" DNIS4 = "3797" a = Range("c1").Value b = Range("e1").Value On Error GoTo ErrorHandler For k = a To b WorksheetActivate: Worksheets(k).Activate For i = DNIS1 To DNIS4 If i = 3781 Then i = 3797 Cells.Find(i).Activate Set x...

Hi-- I wrote some code the logic of which should do the following: 1) Loops through a column of values (inner loop) 2) Looks for 4 specific values 3) When it finds any of these 4 values, copies the entire row it is in 4) Pastes this row to another worksheet in the same workbook 5) Go back and...