Search results for query: *

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

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

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

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

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

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

Hi, I've got a list of pages i want to select using VB, the list of pages is contained within a defined name ("PageSelector"). When i use this defined name to select one sheet - eg. Dim PageSelect As String PageSelect = Evaluate("PageSelector") Sheets(PageSelect).Select The...

Hi, I've got a list of pages i want to select using VB, the list of pages is contained within a defined name ("PageSelector"). When i use this defined name to select one sheet - eg. Dim PageSelect As String PageSelect = Evaluate("PageSelector") Sheets(PageSelect).Select The code...

Hi, I've got a make table query which points to a certain location, but within VBA I want to be able to add a date/time stamp on the table name. How can I change the new table name on the fly (I'm creating a table in a seperate database)? I was origionally going to be using a select query and...

Hi, I'm wanting to search a string and find where the space appears within it, once found I want to take the letters before the space and populate one feild and the letters after it in another. I was hoping I could use the same function as used within Excel (Find(" ",[FeildName],1)) to find the...

Hi, Is there anyway to automatically display the suffix to numbers, like the "th", "rd" and st without using an IF statement? Thanks for your help in advanced Gareth

Hi, I'm trying to work out what page a form currently is on, I have two page breaks, so three pages and I want to be able to turn the Enabled property of a button off and on depending on the page being displayed. Thanks in advance Gareth

Hi, I'm running a macro to transfer out of access into excel spreadsheets. I want to use this macro more than once but each time to make a spreadsheet with a new name. What I don't want to have to do is either change the macro's File Name each time or rename the file once created. Is there...

Hi, I've created 6 variables, TargetNo1 through to TargetNo6. When I run the For loop I need it to use the counter in the loop and concatenate it with "Target" so I can then run an If statement on the values held TargetNo1 to TargetNo6. The VBA I'm using is as follows: For intLabel = 1 To...

Hi, I've got two forms, one for adding data and another to search for a record and allow it to be edited if needed. When a record has been edited, I need a msgbox to appear and confirm i want the changes made. However i can't find a property that works correctly or that i've been using...

Hi when i go to change things in the registry after about 10 seconds it closes by itself. I know the machine i am working on has some spame software installed (hence wanting to get into the registry to remove it). Is there somewhere i can stop this closing from happening? Thanks in advance gareth

Hi, I'm wanting to list out years in table 1 which will contain years from 1901 through to 2050 (future proof). Table 1 will be used as a combo box lookup in table 2, but I'm only wanting the years which are valid to be used, e.g. 2005 and back. Is there a way to not include 2006 onwards in...