Search results for query: *

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) & ":" &...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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