Recent content by gareth001

I've a windows batch command that is being generated by an external product which inserts variables which will replace sections within a space delimeted data file. So below I'm searching for the value of "--d--" and replacing it with "email@domain.com" perl -pe "s/--d--/email@domain.com...

Thanks - knew it was something simular to what I had. Now working. A quote is the epiphany of intelligence

Afraid that just leaves me with an empty cell in the table with no boarders where the URL should be. A quote is the epiphany of intelligence

I've got an xml file that I'm placing into a table, one field at a time with Java. I can happily place the values as string, but can't get the syntax correct to place as a URL. Simple string: document.write('<td>' + results[i].getAttribute("age") + '</td>'); Attempt at href...

Hi All, I've got an application which I want to be able to logoff windows with. I currently use the following code: Dim MyProcess As New System.Diagnostics.Process MyProcess.StartInfo.CreateNoWindow = True MyProcess.StartInfo.UseShellExecute = True...

Hi all, I'm wanting to delete all (about 60) the defined names within an excel workbook. I can delete the values of the defined names (end up with "=Sheet1!#REF!") with the below code, but not the name it's self even though I'm displaying it in the message box. For Each n In...

Thanks PH, thats great help. Works a treat.

Hi, I have a working filter which uses the required field [defined as Field] and record(s) [Defined as Node] within which are needed. with the below code: Set tbl = Screen.ActiveDatasheet tbl.Filter = Field & _ "=" & _ Node tbl.FilterOn = True...

Thats a great help, thanks CMP

Hi, I've got a table (tblQuestionnaireComments) which contains fields numbered id_0 to id_50. Within a form (frmCommentReport) there is a text box which generates this number (TxtIDNo) from a list box as the list box only contains 0 to 50. What I can not work out is how to apply a dynamic...

Thank you for both for your help, all working now. Gareth

Hi, I've been trying to set a on Change command for a group of List boxes to enable a button when they contain data, but I can't seem to detect when they contain a null value. The code is as follows: Private Sub cboSchemeID_Change() If cboLevelID.Value = Null Then...

Thanks John, thats exactly what I was after.

Hi, I've got a time stored in seconds (eg 150 seconds), but how can I display the time in minutes and seconds (2:30)? Excel help surgests using: =TEXT(A2/24, "h:mm") but I can't get this to work with mins and secs. Thanks Gareth

Hi, I've tried to send an email which has an attachement of 23mb. BTInternet or Outlook does not wont to send the file which is fine as i've sent it via cd now. But when i go to try and delete the email, it tells me that it can't be deleted as Outlook has started to send it. This has also ment...