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!

  • Congratulations strongm 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. Revolution1200

    Time Display on form

    Hi All, Never mind, came up with Dim test As DateTime Dim daysToHours As Long test = DateTime.FromOADate(5.79226851851852) daysToHours = test.Day * 24 daysToHours = daysToHours + test.Hour MsgBox(daysToHours.ToString.PadLeft(2, "0"c) & ":" &...
  2. Revolution1200

    Time Display on form

    Help, I am summing a number of times from an access database to show time utilised over a month. How do I display the time as HH:MM:SS for say 45 hours 15 minutes and 23 seconds I can convert the double to a datetime using FromOADate. Thanks Stuart
  3. Revolution1200

    Scanned image view printing

    Hi, Cant beleive the mess i am getting into with this... I have an app that the user can view scanned images - A4 Application form pages. The user then clicks in the picture box to indicate where reference numbers should appear and prints. When printed though the text is never in the correct...
  4. Revolution1200

    Mail Merge Multiple Word templates into 1

    Thanks Skip and Macropod for your help with this. Probably my fault as I only showed a couple of record examples. The actual record file can have > 4000 records to merge. I have managed to come up with a quicker solution with a variation of the above code by running through the records and...
  5. Revolution1200

    Mail Merge Multiple Word templates into 1

    Thanks Macropod, I will have a look at the IF again, i think the thing that put me off this is that we have around 50 Merge templates that may need to be combined into the final document. Cheers Stuart
  6. Revolution1200

    Word Template Merge

    Hi All, The problem is my current code is very slow. We have multiple word document templates that we use for merging purposes - this is due to people being assigned different letters in the database depending on processing. We need to merge these into one final document for mailing. The...
  7. Revolution1200

    Mail Merge Multiple Word templates into 1

    Hi, The order is important as the final merged document must be made up in the order of Template1 Template2 Template1 This is due to when we print the single final letter it is in the correct mailsort order
  8. Revolution1200

    Mail Merge Multiple Word templates into 1

    Hi Skip, The identifier is the first field in the excel spreadsheet and is basically the name of the word template to use. Example records would be identifier name address details template1 test name some address template2 test name some address 2 template1...
  9. Revolution1200

    Mail Merge Multiple Word templates into 1

    I may not have explained this very well. The records in the excel file are in an order that cannot be changed - for mailsort purposes, they need to be merged to 1 single document which will be a collection of a number of templates depending on the letter identifier. My current code is as...
  10. Revolution1200

    Mail Merge Multiple Word templates into 1

    Hi Skip, A template may only merge to one of the records in the source data depending on the letter the customer is to get. The copy 'n' paste is the method i am currently using - amending the merge fields to my data as I go, trouble is this is very slow. Cheers Stuart
  11. Revolution1200

    Mail Merge Multiple Word templates into 1

    Hi All, We have multiple word document templates that we use for merging purposes - this is due to people being assigned different letters in the database depending on processing. We need to merge these into one final document for mailing. The data for this comes from an excel spreadsheet...
  12. Revolution1200

    Running an Excel Macro from Access

    You could transfer the macro code into access and use the following to open the spreadsheet Dim mainWorkbook As Excel.Workbook Dim currentWorksheet As Excel.Worksheet myFileName = "O:\GTS\TechServices\Telephony\Call Stats\" & "Mailbox List " & runDate & ".xls" Set mainWorkbook =...
  13. Revolution1200

    Password reset

    Hi Firebird, could you give me a clue through Either that or I have one smart heater with lots of LED's! trautskralc~[AT]~hotmail~[DOT]~com Thanks Stuart
  14. Revolution1200

    Password reset

    Thanks Firebird, That is what I feared - Dont even have the 4.5 software on a card or I would have re-installed. Stuart
  15. Revolution1200

    Password reset

    Hi, not sure if this is allowed to be answered... I need to reset the layer 2 password in an Opt 11. I am logged into the switch with layer one, I have the opt 11 in password override mode, and I'm logged into the PDT. when trying to reset the password using the correct command, it is asking...
  16. Revolution1200

    CDR Data Sundenly missing Line numbers

    Any ideas? Our clients are getting flakey for the call stats now. Thanks Stuart
  17. Revolution1200

    CDR Data Sundenly missing Line numbers

    Hi, BCM450, only been setup for 3 weeks. I use the CDR data from the BCM to produce call stats. This has been working great for the last couple of weeks up until yesterday. I used to get the line numbers in the CDR data such as -------- 09/19/09 09:52:35 LINE = 0388 STN = 2193...
  18. Revolution1200

    Name ACD Position ID

    Hi, No the relevent dept is just standard 2616's, they want the Agents on ACD sets to field the calls first and then if required transfer the calls to the various dept's - they dont want direct calls comming into the offices. Cheers Stuart
  19. Revolution1200

    Name ACD Position ID

    Hi, I have had to set up the main office calls to route through a skillset on CC6 to our agents. The problem i have is that when the agent transfers the call to the relevent department using the transfer button, the department see the position id of the phone as the calling number. I though i...
  20. Revolution1200

    Help with agent logged in time

    Hi RyanEK, Thanks for the responses, the data in the table are not segmented into 15 minute intervals, so i could have an entry of 08:46:34. I should also mention that i cannot make any changes in the database, i can only query. Stuart

Part and Inventory Search

Back
Top