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

    Creating an Outbound report

    I've been asked to create an Outbound reports with the following metrics: Number of Outbound Calls Talk Time Work Time Hold Time Outbound Time Average Handle Time Occupancy I'm used to doing Inbound calls using the ACD split/skill reports. I'm unsure what CMS reports I can use to track these...
  2. ltworf

    queryTable

    no problem. I'm using excel. The data I want is on the same workbook as the report itself.
  3. ltworf

    queryTable

    not sure I understand. could you please give me an example. I'm seeing allot of example on the net but i don't get it. see exampl bit below: Set QT = WSW.QueryTables.Add(Connection:=ConnectString, Destination:=WSW.Range("A1")) With QT .Name = "portfolio" .FieldNames =...
  4. ltworf

    queryTable

    Never used QueryTables before need help. I have 1 workbook with to sheets. A datasheet and a reportsheet. the datasheet has field names: Dept, Location, Skill, Calls Offered, & BAHT. So lets say in the reportsheet on Cell A1 I need a specific Dept,Location summary from teh datasheet. How do I...
  5. ltworf

    avaya cms 13 vb code

    does anyknwo know how to get cms data via the scripting through access vba
  6. ltworf

    using vb code with CMS 13 ,11 & 9

    Still having problems. Does anyone have an help they can offered , Please:)
  7. ltworf

    using vb code with CMS 13 ,11 & 9

    my company uses all 3 cms verion. My code work great for 9 & 11. However 13 will not export. there are no error msg. the loop just keeps going as there seems to be no data coming from the application. this is where it keeps looping: freetmpnum = FreeFile() For i = 1 To 9 Line Input #1...
  8. ltworf

    CMS 13 automatic scripts with this CMS server have not been specified

    I use CMS 9 11 & 13 script's the 13 will not run the report engine. I check the log and it shows: User ID and password for automatic scripts with this CMS server have not been specified how do i fix this
  9. ltworf

    using existing msaccess form within Excel

    Thx that helped me on my way. So now I have it opening the AccessDB then a macro runs to open the form. Is there no way to just open the form without having to open the AccessDB.Here si what I have in my script: Sub controlAccess() Dim objAccess As Object Set objAccess =...
  10. ltworf

    using existing msaccess form within Excel

    I'm using office xp. I have a form in my accessDB that changes the dates in my queries. I would like to access this form via Excel. Does any one have any code they can share with me that would help.

Part and Inventory Search

Back
Top