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!

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

Recent content by Sudashan

  1. Sudashan

    Values Passing Between Supreports

    Hi, In the first sub report create an formula WhilePrintingRecords; Shared numberVar num := 0; if somecondition then num := 1 In the main report create a formula WhilePrintingRecords; Shared numberVar num; place this formula below the section where the sub report is placed link the main...
  2. Sudashan

    Only n-Results per ID

    Hi innu, create an view based on u r original query i.e select * from cars, carcolor where cars.id = carcolor.idcars Use the following query to get the desired result select count(*) As rank, v.car, v.carcolour from viewname v, viewname v1 where v.car + v.carcolour >= v1.car +...
  3. Sudashan

    Query Question

    Hi digital_dude, The following query will solve u r problem SELECT tdata.output_id, t_data.output_id FROM t_data AS tdata INNER JOIN t_data ON tdata.input_id = t_data.output_id;
  4. Sudashan

    Disable an option on a Customised Menubar

    Hi roddy, I hope the following code will help u Dim CBarMenu Dim CBarCtl 'Menu Set CBarMenu = CommandBars("MainMenu") 'File Menu Set CBarCtl = CBarMenu.Controls("File") CBarMenu.Controls("File").Visible = True...

Part and Inventory Search

Back
Top