Search results for query: *

Hi There, I am wondering if the Generic RTA report can be changed from what seems to be a standard output of 82231 20 0 14 95 0 1 0 82731 82233 30 2 9 95 0 1 0 82733 82234 20 0 24 95 0 1 0 82734 to somthing like 17/05/2008 10:01:02 82231 20...

Hi there. I was wondering if someon could help. I have a spread sheet that has multiple rows however the row is not prefixed with the date i.e 12/12/06 Fiona Young Charlie Snedden 13/12/06 Fiona Young Charlie Snedden What I need the macro to do is 12/12/06 12/12/06...

I have been bashing this around for a number of days now. What I have is a database with a content field. The content field has XML in it. I want to display the content in the textarea using the XSL template. Then I want to be able to press a button and see the XML. All this for edditing a...

I have a report with three seperate querys. Each of which has to have the same date varibles. How do I execute one request for inputs to the other querys? Thanks in advance Charlie

Is there a quick way to transfere a Oracle database to sql? Thanks in advance Charlie

Is there a quick way I can extract all the Table in the Oracle database so I can transfere them to a SQL server database.... Thanks Thanks in advance Charlie

I have a database and crystal report which does almost all I need. The last thing I need to do is create a summary of all the calls split by operator. I have fields callop, callid I need to sum the number of callid by the individual callop. Is this possible??? Thanks in advance Thanks in...

I have two tables. Users and names. In users the fields are ID, Fname, Lname, Location, sex in the names table I have Fname, lname and sex. What I want to be able to do is have an insert query that inserts from the names table, however the names are randomly selected and also randomise the...

I know that if you run an agent trace you can see what work codes have been entered by an agent. What I need to know is howlong does it keep agents workcode data and where can I find out more information on workcodes? Unfortunately I am only a technical user and My IT dept will not release the...

How do I write a query that will delete account numbers from table two that are in table one? Thanks in advance Charlie

Hi there I am trying to create a macro that searches a colum and until in finds a cell populated with a number and copies that to the cells below until the cell matches a specific values. To be honest the codeing is beyond me, tips and pointers in the right direction would be a start. The whole...

HI How would you use an erlang table in excel? Thanks in advance Charlie

does anyone have a macro that will delete all empty cells within a range and move the rest to the right or left? Thanks in advance Charlie

Is it possible to write a function that is called when a form is loaded to request a password from the tblpass and only allow the form to be opened if the password matches? If so help to do this would be much appreciated Thanks in advance Charlie

Hi there, how can I pull a report or export of all agents in an agent group with their skills and relative skill levels? Thanks in advance Charlie

I have taken ownership of a data base which all the tool bars ect are visable. I have tried to remove them using the Startup option but to no avail. Am I missing something? Apart form a brain ;-) Thanks in advance Charlie

How can I select two colums from 31 and sum the contents per row between the two selected colums. Charlie Thanks in advance Charlie

I have 31 colums of data, and I want to be able to select to columns. One as a start point and one as an end point. Then I want to sum the contents per row between these two points. is this possible and if so how? Charlie Thanks in advance Charlie

I am trying to created an audit trial. So far things are going well, But what I need to know is. Can you call the form name in an SQL statement which has ran the macro? Regards Charlie Thanks in advance Charlie

Is it possible to have access to run a macro to insert a line of data without the screen message saying you are about to insert a line of data? Thanks in advance Charlie