Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TaylorTot

    Create Sum in Business Objects and Drill Into that Sum

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

    Create Sum in Business Objects and Drill Into that Sum

    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...
  3. TaylorTot

    Create Sum in Business Objects and Drill Into that Sum

    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...
  4. TaylorTot

    Import Text file into multiple tables based on key

    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...
  5. TaylorTot

    Access VB Mapping to Mappoint Error 91

    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 =...
  6. TaylorTot

    Error Run-Time Error 1004

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

    Error Run-Time Error 1004

    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, _...
  8. TaylorTot

    Error Run-Time Error 1004

    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 =...
  9. TaylorTot

    Error Run-Time Error 1004

    It is 28 (Which is my last row)
  10. TaylorTot

    Error Run-Time Error 1004

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

    Error Run-Time Error 1004

    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...
  12. TaylorTot

    Trap a SQL Server Unavailable Error from a VBA Program

    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!
  13. TaylorTot

    Change Connection from Sql to Access

    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...
  14. TaylorTot

    Two Values on X Axis

    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]...
  15. TaylorTot

    Dynamic Crosstab

    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!
  16. TaylorTot

    Dynamic Crosstab

    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...
  17. TaylorTot

    Dynamic Crosstab Report with Multiple Queries

    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...
  18. TaylorTot

    Subform is not clearing!

    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!
  19. TaylorTot

    Subform is not clearing!

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

    Subform is not clearing!

    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...

Part and Inventory Search

Back
Top