Search results for query: *

Hi, I have the xml below which I am reading using XML Document. My code also below works fine if I take the namespace out of the xml but I cannot seem to get the reader right with the NameSpace. Advice would be appreciated. <?xml version="1.0" encoding="UTF-8" ?> - <iPOSImports...

Hi, PLease help as I've spent two days confused on this! I'm trying the read the xml file below node by node with the code also below this. All the childnodes values seem to be concatinated together on the output, for example: DeliveryAddress : HO/A0221Wyatt HouseThe ButtsSanctuary...

I am using the standard Oracle BULK_EXCEPTIONS to trap any invalid rows. Unfortunately I only can get the index number of the row. How do I obtain more info from the row? My code is: CREATE OR REPLACE PROCEDURE PSADMIN.GLI_EXTRACT_KP AS bulk_errors EXCEPTION; PRAGMA...

thread401-1033316 Hi, I have exactly the same problem as the above thread and have tried the solutions given but with no luck. The only difference is that I am on 7.1 Any Ideas?

I need to disable a menu button once it is clicked. Within the click event of the button I placed: ButtonName.Enabled = False This does not seem to work. Any help would be appreciated. Thanks

Im trying to change a cell value on a insert into a table from a datagrid like below but I cannot seem to get the code right. Please help! If(VARIABLE_INPUTDataGridView1.Item(var_cash_col_no, row_no).Value) = "Adjustment" Then VARIABLE_INPUTDataGridView1.Item(var_cash_col_no, row_no).Value)...

I guess this is really easy if you now how but how do you add a default value to a DataGridView cell. I tried the following off msdn but it dont work: Private Sub VARIABLE_INPUTDataGridView1_DefaultValuesNeeded(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewRowEventArgs)...

Hi, I would be very greatful if someone could me an idea with this one. I'm sending an Outlook email and printing the values to the body: oMsg.Body = "Dear " & Me.PREFERREDLabel1.Text & "," & vbCr & vbCr _ Me.DrivingLicErrLabel.Text & vbCr & _ Me.DrivLicExpErrLabel.Text & vbCr & _...

Im trying to do a mailmerge on a word document and think I need to use NEXTIF. For example (see below) I have two columns on a csv and need Applicant ID's Surname's on one document and 99999 on another. How would I do this as the examples I've seen do not appear to be clear? Applicant ID...

Im trying to do a mailmerge on a word document and think I need to use NEXTIF. For example (see below) I have two columns on a csv and need Applicant ID's Surname's on one document and 99999 on another. How would I do this as the examples I've seen do not appear to be clear? Applicant ID...

I have a table containing column names of other tables. I need to place them into variables & use them to write to UTL_file in a csv. i.e. Table Column ------------------ Table A Column A Table A Column B Output File: Column A, Column B Its probably really easy if you know how but an...

I have the query below what gives me the records I desire. I easily need to delete all of these records. How would I do this with a DELETE FROM clause or a PL/SQL cursor? Any help would be appreciated! SELECT ded.emp_no , re.pay_group , ded.element...

Probably a easy question but I would be greatful for some help. I have the table below and I need to report on just the EMP_NO's that do not have ELEMENT's BUSMILES & PRIVATMIL. Any clues on this? EMP_NO CAR_TYPE PER_NO ELEMENT --------------------------------------------------- 00111...

I have outlook code which forwards mails on. How do I change the color of the subject for the recipient in vba?

I have code that forwards a mail based on an Outlook item subject name in the Subfolder "Percentage Reports" and then moves the item to another directory "Migration Reports". This works fine as long as I have an item in the "Percentage Reports" subfolder. If I dont when a new mail arrives I...

Hi, I have the code to save a filename to a log file as below: FilenameA = "C:\ArchivedMails.log" Open FilenameA For Output As #1 Print #1, FileName Close #1 This works fine but within the file I want to add new filenames each time the code is run. At present it is overwriting the...

I have code that saves outlook attachments to network locations based on the attachment filname. The code for this works fine but I need the delete all the items out of the Subfolder afterwards. The code is below: ' Declare variables Dim ns As NameSpace Dim Inbox As MAPIFolder Dim...

I have the link code: <a href="http://esr.mhapp.nhs.uk:30002/pls/PROD/xx_conv_dashboard" target="_blank"><font size="4" color="#336666">dashboard</font></a></font></b></td> I want to make the linked page to text size smallest.Please bear in mind I hardly know any html.

What I need to do is say "If any cell value on a worksheet = "6.2b" Then set the cell to a hyperlink of www.yahoo.com". Is this possible.

I need to open all the excel files in a directory and apply formating. The files also need to be saved. The directory is c:\TestFolder. The formating recorded from a macro is: Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _...