Search results for query: *

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.

Can anyone tell me why when I run the code below, I get an error message 'compiler Error, user-defined type not defined'? The program exports the contence of text boxes on a form to a MS Word document placing them using bookmarks. I got the adapted code from an earlier post. Many Thanks...

I am working on a program that uses information from an access table to produce a report in word, using a visual basic enviroment. However I am struggling with regard to inserting bookmarks into word using visual basic to place data in word document. Using the code below i am able to create...

Thanks for your input johnwm. I understand your proposed solution of closing the recordset & report and then re-opening to refresh the report. However I am struggling to understand the code; what does '.connection2' & '.connection1' refer to? Is this the data enviroment?? I only currently...

I have the same problem as discussed in previous threads. Can anyone explain to me how to update the data report using a timer? Chris.

I have a form with a data control linked to a Access D.B. This allows users to create/update/delete the DB. From this form I have created a Data Enviroment that generates a data Report. The data report produces the report fine, If add/update/delete a record once and then re-run the report, it...