Search results for query: *

Great Randy, took your route and its working perfectly. Thanks again to both you guys for responding John [smile]

Hmm thanks guys for the two possible methods. Randy, how would that code look roughly? John [smile]

...store the form contents as a new record. Under this text box, I have two other text boxes, one which contains the expression =[SALE_SUBTOTAL]*0.2, which displays the VAT for the transaction, and then a third which has =[SALE_SUBTOTAL]*1.2, which is the total including VAT to charge the...

Hi Phil, Yes we have that enabled and can get sound back from the host, but just cant get any microphone audio. We are testing a sip phone on the remote server and it doesnt recognise any audio devices. John [smile]

Hi all, I have a problem where I need to remotely access a desktop and have the audio / microphone audio passed from the far end machine to my desktop. I thought that perhaps PC Anywhere would have that functionality but it appears not. Does anyone have an idea of software which can do this...

Anyone any help on why I cant export this additional calendar? John [smile]

Cheers that works a treat, but Im having a problem in that the calendar Im trying to export is not my own, but one I have permissions over. When I try to export the cal, it does not appear on the available list. I am working round it at the moment by creating a dummy calendar and then copying...

Hi all, As per the title, Im looking for a way to print off an outlook calendar graphically to display a timeline if you like. Similar to the way the scheduling tab looks when you are scheduling a meeting. Is there any way, or using an additional tool to do this? John [smile]

Hi all, I have QueryA which returns three fields in a List box on a report. I have added the behaviour to open a new query QueryB which runs using a value from column 1 in QueryA, but I cant get this run correctly. How do you tell the new query QueryB to get its criteria for the query from the...

Ahh fantastic, I would never have worked that out myself, at least not this year! Thanks, Ill now go away and research how this does what it does and hopefully not have to pester you pros again! Many thanks John [smile]

Thanks Taupirho, Im struggling to apply the case and decode functions as Im not really familiar with them and googling shows me examples of what they do, Im just not sure how to apply them to my problem? [sadeyes] Ill keep plugging and try to work it out but if you have any other guidance it...

Ha ha! Yes I think taupirho's solution does do what I need. I was also wondering if there was a way to do the same for the HOLD status on the same result line of a query? But for this, I would only need a total duration, not the start and end times as above? Something like this...

Hi all, I have the following Data.... ID START(UTC) END(UTC) DURATION STATE TRANSACTION_ID ------------------------------------------------------ 1 1251384001 1251384102 101 INBOUND 31808563970 2 1251384102 1251384202 100 HOLD 31808563970 3 1251384202 1251384302 100 INBOUND...

Sorry PHV have posted in the oracle forum John [smile]

Hi all, I am running the following sql to convert a decimal string to hex and its fine but I then need to compare that value to a different data source which already has the value in hex.  Trouble is the second source appears to have two have two zeros at the start of each hex string, so I...

Hi all, I am running the following sql to convert a decimal string to hex and its fine but I then need to compare that value to a different data source which already has the value in hex.  Trouble is the second source appears to have two have two zeros at the start of each hex string, so I...

Hi all, Im running IE8 on windows xp and have to view some presentations from a vendor which launch via a play.htm file, which then seems to jump to another page. I believe this is trying to run some javascript, and it runs fine on an old xp machine with ie6. Ive done a clean build of xp, ie8...

Hi It's the rollback that's not happening. After I run the above command, I run the rollback and it doesn't change the data. John [smile]

Hi, I am calling the following sql from within a windows batch file using "sqlplus -s %CONSTR% @merge.sql" where the connection string is passed using a variable. MERGE INTO schema1.routing r USING schema1.batchupdate b ON (r.dnis1=b.dnis1 and r.ivr_reason=b.ivr_reason) WHEN MATCHED THEN...

Hi I've tried the rollback statement and it doesn't work. The changes stay the same. I thought that when doing a merge, similar to an update or insert, a rollback is not possible as those commands are automaticallyfollowed by a sort of system commit which makes the rollback impossible? John [smile]