Search results for query: *

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

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

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

Hello, I'm trying to update my subform with a recordset. Unfortunately, it is only listing the last record over and over again. I know I need to create a count, but I'm not sure how to accomplish this. Below is my code: Private Sub cboAssetNumber_AfterUpdate() If Not...

Hello, I am working on an access form when the cmdfilter button is clicked and there are no records matching the results I would like an addition form to open. Unfortunately, because there are no records both forms go blank. Below is my code: Private Sub cmdFilter_Click() Dim rst As...

Hello, I have a main form (frmMain) that holds the field (cboAssetNumber) and a subform (fsubbrokers) that holds the field (VendorID). The subform has an "Assign" command button. When this is clicked I want it to update the table tblVendorAssignment. This is the code I have. DoCmd.RunSQL...

Hello, I have a main for that enters an address when the cmdfilter button is clicked the following code is executed: Private Sub FilterBrokers() Dim db As DAO.Database Dim rs20Mile As DAO.Recordset Dim MileCriteria As Long Dim qry As DAO.QueryDef, qry2 As DAO.QueryDef Set...

Hello, I'm new to VB and am trying to accomplish the following logic: When the end user enters an address and hits the filter button it does the following: Filter Button Functionality: Run ActiveAsset_SelQry If [Ruca_Subclass] = "A" or "B" Then Run Get20Mile_SelQry Where Miles <5 Else If...

Hello, I have an access form that runs a query based on an address entered by the end user. The query returns all vendors within 15 miles. I have been successful in mapping the results of the query, but I would also like to map the address that is entered in the form. . . this is where...

Hello, I have an access form that is mapping addresses from a query into Mappoint. Unfortunately, a few of the addresses are mapping incorrectly. Below is my code and an example of what is mapping wrong. Sub MapSelectedProperties() 'Map the selected properties On Error GoTo...

Hello, I'm getting Error 91, (Object Variable or With Block not set) with the following code: Sub MapSelectedProperties() 'Map the selected properties On Error GoTo MapSelectedProperties_Err_Exit Dim db As Database Dim rstProps As DAO.Recordset Dim objLoc As MapPoint.Location...

Hello, I hope this is the right forum. . . I'm using Access 2000 and have MapPoint 2004. What I'm trying to do is build a database which stores companies, by address and zip, on a waiting list. I would like the user to be able to type in a zip code and have a subform pop up which accesses the...

Hello, I'm working in Crystal v8.5. I have a start date and an end date. I would like to increment the date value by month. Here is an example of what I would like: Start Date = 1/1/2005 End Date = 4/1/2005 I would like a variable that returns a value for the following: 1/1/2005 2/1/2005...