Search results for query: *

Thank you for your response. I will look into both options.

I appreciate the response. Is it possible, if I create a total of 5 metrics in the universe to drill into that grand total in order to see what values the grand total was derived from. I guess my problem is, these are not dimensions they are measures that are being totalled. My client would...

Hello, It has been a while since I have used business objects, and need some help trying to meet a clients needs. The client would like to sum multiple measures and then have the ability to drill into the values that were summed. See example below: Measure 1 = 10 Measure 2 = 20 Measure 3...

I have a text file that I need to import into access, however the file is "stacked". Below is an example of my data |C1.|FW|Ver.|Seg|Seq|Segmentdata |900|2222222222 | |BBB1| 13|111111 111 111 1 |900|2222222222 | |BBB2| 13|5555 6/2/2008 11 1 222 222 Outlook should look like...

Hi, I am trying to add a radius to my mappoint pushpins and have the following code: Option Explicit Dim oMpApp As mappoint.Application Dim oMap As mappoint.Map Private Sub Command1_Click() Dim oDS As mappoint.DataSet Dim oRS As mappoint.Recordset Set oDS =...

Never mind I figured it out!! Thank you again for your help!

That is very close, except it does the following: Sums everything for Column C: C2:E27 Sums Everything for Column D: D2:E27 The code I used was: Dim LastRow As Long LastRow = AppXls.Cells.Find(what:="*", After:=[A1], _ SearchOrder:=xlByRows, _...

This code works: Dim LastRow As Long LastRow = AppXls.Cells.Find(what:="*", After:=[A1], _ SearchOrder:=xlByRows, _ SearchDirection:=xlPrevious).Row AppXls.Rows(LastRow).Select AppXls.ActiveCell.Offset(1, 0).Select AppXls.ActiveCell.FormulaR1C1 =...

It is 28 (Which is my last row)

Hi PH, Thank you for your response. I am still getting the same error message?

Hello, I have the following problematic line of code: AppXls.Selection.Formula = "=Sum(c2:" & Format(ActiveCell.Row - 1, "c#") & ")" It is meant to sum the values in column c. . . but I am getting the following error: Run-Time Error 1004 Application-defined or object-defined Error Can...

Hello, I am trying to trap a SQL Server Unavailable error from a VBA Program. I have tried the SQL Server bad connection string, but that is not what I'm looking for. Thanks in advance!

Hello, I'm not sure if I am in the right forum, but here it goes. . . I am using Access 2000 and am having trouble programatically changing the connection string from sql tables to access tables. I was successful in updating the connection from sql to sql or access to access, but cannot...

Hello, I have the following select statement: SELECT InspectionGraph_GetData_SelQry.month, InspectionGraph_GetData_SelQry.[Inpsection Type], Sum(InspectionGraph_GetData_SelQry.[0-10 Days]) AS [SumOf0-10 Days], Sum(InspectionGraph_GetData_SelQry.[11 - 15 Days]) AS [SumOf11 - 15 Days]...

Thank you for your reply. I have been setting up different queries and recordsets for every set of data. Unfortunately, as you can probably imagine this is a mess and isn't as efficient as I would hope. Can you explain how to dynamically build my sql statement? Again I appreciate your help!

Hello, I have successfully created a dynamic crosstab report in access which uses a crosstab query to populate my report. Problem: I need to add additional queries to this report. Question: Is it possible to create a dynamic crosstab from multiple recordsets? Below is my current code for...

Hello, I have successfully created a dynamic crosstab report in access which uses a crosstab query to populate my report. Problem: I need to add additional queries to this report. Question: Is it possible to create a dynamic crosstab from multiple recordsets? Below is my current code for...

Hi Lars, I basically reran the query, but I had time this morning and put your line of code in and it worked perfectly, so thank you!

Thank you for your reply, I tried that and it didn't work, but I was able to get it working.

Hi, I have a reset button on my main form that when clicked should clear the main and subforms. Unfortunately, it is only clearing my main form. The code I have is: Private Sub cmdReset_Click() 'Clear the criteria Me!txtZipCode = vbNullString Me!cboAssetNumber = vbNullString...