Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chrisgarvey

    Using SQL hints - Sort merge

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

    Ratio Buttons / Outlook created using MS-word

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

    Ratio Buttons / Outlook created using MS-word

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

    Survey / questionaire using outlook & ratio buttons

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

    including a web page in another page

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

    including a web page in another page

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

    Commenting

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

    Shopping Basket Problems

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

    Problem running macro more than once without re starting program

    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'...
  10. chrisgarvey

    Problem running macro more than once without re starting program

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

    Problem running macro more than once without re starting program

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

    Problem running macro more than once without re starting program

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

    Selecting all cells except one

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

    Selecting all cells except one

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

    User-defined type not defined - trying to export from VB to word

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

    User-defined type not defined - trying to export from VB to word

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

    Bookmarks using word & VB

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

    Updating Data Report

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

    Data Report in VB does`nt Update.

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

    Updating Data Report

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

Part and Inventory Search

Back
Top