Recent content by chrisgarvey

Hi forum, I'm trying to force oracle to use the sort merge using hints. Can anyone suggest why the below code is working correctly? Please see the explain plan. Regards, Chris. set autotrace on timing start select /*+ use_merge(e) */ e.fk, d.fk FROM girl d, boy e WHERE e.fk = d.fk; timing...

Hi Forum, I'm trying to create a survey/online questionnaire using outlook (also tried word & copy and pasting from word to outlook). I wish to get recipients of the questionnaire to answer questions using ratio buttons. However when the recipient receives the mail the buttons are blocked or...

Hi Forum, I'm trying to create a survey/online questionnaire using outlook (also tried word & copy and pasting from word to outlook). I wish to get recipients of the questionnaire to answer questions using ratio buttons. However when the recipient receives the mail the buttons are blocked or...

Hi Forum, I'm trying to create a survey/online questionnaire using outlook (also tried word & copy and pasting from word to outlook). I wish to get recipients of the questionnaire to answer questions using ratio buttons. However when the recipient receives the mail the buttons are blocked or...

Thanks everyone, I decided in the end to use an i-frame. Very Pleased with the result when viewed in ie!

I have a html page which contains the header for my web site (graphic, buttons etc) I would like to include this banner html document at the top of all the other pages within my web site. Can anyone help me achieve this? I thought it would be something like <include 'banner.html'> But this...

Hi I'm just starting to learn mysql for the first time. I know in Oracle SQL*Plus you add comments to your code using the REM statement. How can you add comments in mysql? Cheers, Chris.

Hi. I'm new to php and trying to create a shopping basket for the first time. Firstly I am trying to create a php script to display the items in my sql database on screen before I move onto creating the actual on-line basket. The script below display's the items as I wish however it produces...

Thanks for your help Johnmw. I think you deserve a star for that! However, I am still having problems, If I try and click the button containing the code that run's the macro for a second time whilst not closing down the program, i get the following message: 'Run-time error'1004': Method 'Run'...

Very Valid Points johnwm, thank you. I am trying to correct them, but struggling..... I now understand I need to destroy the object 'excel.Application.run "sortMembershipNumber" I cannot work out how to do this? I have tried: excel.application=nothing excel.application.hide...

Hopefully my code should appear below, The problem occours when the macro is run for the second time: Dim n As Long 'declare n as a long integer, this will be used to store the number of records in db Dim a, b As String 'declare as string datDiningClub.Recordset.MoveFirst 'move to the first...

Hello. I have a vb program that creates several reports by opening an excel file inserting the contence of a database and then sorting as required using an excel macro. There are three difference macro's depending on the report required. The program works if I only generate 1 report however...

Stupid question really.... But thanks for your help!

Hello. I have been puzzelled by this for several days now... so any help would be much appreciated. I have an excel spreadsheet with data in that I wish to sort. However the top row contains the headings for the cells. I would like to be able to select all the cells with data on the sheet...

Thanks Johnwm. I set a reference to word: 'Microsoft word 10.0 object library' in the project references list, as you suggested. Chris.