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
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.