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 Mike Lewis 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: *

  • Users: Sudashan
  • Order by date
  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